Nested foreach in C# MVC?

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

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 < dtEmpCdExpSubmit.Count; i++)
{
string type = string.Empty;
int headerId = dtEmpCdExpSubmit[i].EH_SYS_ID;
var dtSubType = dbEClaim.Rpt_GetSubTpe_Tele().ToList();
for (int j = 0; j < dtSubType.Count; 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 < DtType.Count; 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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar8y ago
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 < dtEmpCdExpSubmit.Count; i++)
{
string type = string.Empty;
int headerId = dtEmpCdExpSubmit[i].EH_SYS_ID;
var dtSubType = dbEClaim.Rpt_GetSubTpe_Tele().ToList();
for (int j = 0; j < dtSubType.Count; 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 < DtType.Count; 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