Nested foreach in C# MVC?

Question

I'm New to C# MVC and I'm failed to implement following situation, I have a database and it's table Data like below Company Branch Section Employee_ID abc ltd. branch11 section1 111001 abc ltd. branch11 section2 221001 xyz ltd. branch11 section1 551001 xyz ltd. branch22 section1 551001 Each Company has separate Branch, Each Branch has Separate Section Each Section has Separate Employee_ID I need a Model Class and A Razor View to represent the Data with a nested foreach loop like below. foreach(var company in model.Company) { foreach ( var branch in company) { foreach (var section in branch) { foreach ( var empid in section) } } } Is it possible? How I write the model class? Data needs to be looked like abc ltd. branch11 section1 111001 section2 221001 xyz ltd. branch11 section1 551001 branch22 section1 661001

Suraj Kumar · Answer

Hello Sumon, Here is an examples below public DataTable LINQToDataTable(IEnumerable varlist) { DataTable dtReturn = new DataTable(); // column names PropertyInfo[] oProps = null ; if (varlist == null ) return dtReturn; foreach (T rec in varlist) { // Use reflection to get property names, to create table, Only first time, others will follow if (oProps == null ) { oProps = ((Type)rec.GetType()).GetProperties(); foreach (PropertyInfo pi in oProps) { Type colType = pi.PropertyType; if ((colType.IsGenericType) && (colType.GetGenericTypeDefinition() == typeof (Nullable ))) { colType = colType.GetGenericArguments()[0]; } dtReturn.Columns.Add( new DataColumn(pi.Name, colType)); } } DataRow dr = dtReturn.NewRow(); foreach (PropertyInfo pi in oProps) { dr[pi.Name] = pi.GetValue(rec, null ) == null ? DBNull.Value : pi.GetValue (rec, null ); } dtReturn.Rows.Add(dr); } return dtReturn; } Another example is as below var dtEmpCdExpSubmit = dbEClaim.EP_EmpCdExpSubmit_New1_Tele(empCd, dtFromDate, dtToDate).ToList(); //dbEClaim.UspACCommExpList(compCd, empCd, dtFromDate, dtToDate).ToList(); for ( int i = 0; i { string type = string .Empty; int headerId = dtEmpCdExpSubmit[i].EH_SYS_ID; var dtSubType = dbEClaim.Rpt_GetSubTpe_Tele().ToList(); for ( int j = 0; j { type = dtSubType[j].EST_EXP_SUB_TYPE_NAME; dbEClaim.Rpt_GetTypeExpByMonthType_New_Tele(dtEmpCdExpSubmit[i].EH_EMP_CODE, dtFromDate, dtToDate, dtEmpCdExpSubmit[i].EH_MONTH, dtEmpCdExpSubmit[i].EH_YEAR, type, headerId); } var DtType = dbEClaim.Rpt_GetType_Tele().ToList(); for ( int k = 0; k { string etExpenseType = DtType[0].ET_EXPENSE_TYPE_NAME; dbEClaim.Rpt_GetTypeExpByMonthType_New_Tele(dtEmpCdExpSubmit[i].EH_EMP_CODE, dtFromDate, dtToDate, dtEmpCdExpSubmit[i].EH_MONTH, dtEmpCdExpSubmit[i].EH_YEAR, etExpenseType, headerId); } dbEClaim.Rpt_GetTypeExpByMonthType_2New_Tele(dtEmpCdExpSubmit[i].EH_EMP_CODE, dtFromDate, dtToDate, dtEmpCdExpSubmit[i].EH_MONTH, dtEmpCdExpSubmit[i].EH_YEAR, headerId); } Regard Suraj

Company	Branch	Section	Employee_ID
abc ltd.	branch11	section1	111001
abc ltd.	branch11	section2	221001
xyz ltd.	branch11	section1	551001
xyz ltd.	branch22	section1	551001