public IEnumerable <ModelGrant> GetListGrant()
{
DataSet ds = new SelectToData("ConnectListSocDB").GetDatasetToBase(new ModelGrant());
List <ModelGrant> listGrant = new List <ModelGrant>();
foreach (var it in ds.Tables[0].AsEnumerable())
{
listGrant.Add(
new ModelGrant()
{
LastName = it.ItemArray[0].ToString(),
FirstName = it.ItemArray[1].ToString(),
MiddleName = it.ItemArray[2].ToString(),
DateOfBirth = (DateTime)it.ItemArray[3],
PeriodFrom = (DateTime)it.ItemArray[4],
PeriodTo = (DateTime)it.ItemArray[5],
ReasonForTheSuspension = it.ItemArray[6].ToString(),
Adress =
it.ItemArray[7].ToString() //Населенный пункт
+ " " + it.ItemArray[8].ToString() //Улица
+ " д." + it.ItemArray[9].ToString() //Дом
+ ((it.ItemArray[10].ToString() != "") ? ("/" + it.ItemArray[10].ToString()) : "") //Корпус
+ ((it.ItemArray[11].ToString() != "") ? (" кв. " + it.ItemArray[11].ToString()) : "") //Квартира
+ ((it.ItemArray[12].ToString() != "") ? String.Format(" ком. {0}", it.ItemArray[12].ToString()) : "") //Комната
});
}
return(listGrant);
}
public static IEnumerable <ItemOldLive> GetListOldLive()
{
DataSet ds = new SelectToData("ConnectListSocDB").GetDatasetToBase(new ItemOldLive());
List <ItemOldLive> list = new List <ItemOldLive>();
foreach (var it in ds.Tables[0].AsEnumerable())
{
list.Add(
new ItemOldLive()
{
LastName = it.ItemArray[0].ToString(),
FirstName = it.ItemArray[1].ToString(),
MiddleName = it.ItemArray[2].ToString(),
BrDate = (DateTime)it.ItemArray[3],
Category = it.ItemArray[4].ToString()
});
}
return(list);
}
static IEnumerable <ItemEDV> GetListEDV()
{
List <ItemEDV> list = new List <ItemEDV>();
DataSet ds = new SelectToData("ConnectListSocDB").GetDatasetToBase(new ItemEDV());
DataTable table = ds.Tables[0];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
//[fm],[im],[ot], dtr,[cat_name]
list.Add(
new ItemEDV()
{
LastName = table.Rows[i].ItemArray[0].ToString(),
FirstName = table.Rows[i].ItemArray[1].ToString(),
MiddleName = table.Rows[i].ItemArray[2].ToString(),
BrDate = (DateTime)table.Rows[i].ItemArray[3],
Category = table.Rows[i].ItemArray[4].ToString()
});
}
return(list);
}
public static IEnumerable <ItemPayKinder> GetListPayKinder()
{
DataSet ds = new SelectToData("ConnectListSocDB").GetDatasetToBase(new ItemPayKinder());
List <ItemPayKinder> list = new List <ItemPayKinder>();
foreach (var item in ds.Tables[0].AsEnumerable())
{
list.Add(
new ItemPayKinder()
{
LastName = item.ItemArray[0].ToString(),
FirstName = item.ItemArray[1].ToString(),
MiddleName = item.ItemArray[2].ToString(),
BrDate = (DateTime)item.ItemArray[3],
EffictiveDate = (DateTime)item.ItemArray[4],
DateOfApplication = item.ItemArray[5].ToString(),
NamePay = item.ItemArray[6].ToString(),
Base = item.ItemArray[7].ToString()
});
}
return(list);
}
