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); }