public async Task <ActionResult> MyPeriodicPayments() { List <PeriodicPaymentModel> lmd = new List <PeriodicPaymentModel>(); var user = await UserManager.FindByIdAsync(User.Identity.GetUserId()); if (user != null) { Connection.Connection con = new Connection.Connection(); DataSet ds = new DataSet(); ds = con.MyPeriodicPaymentData(User.Identity.GetUserId()); foreach (DataRow dr in ds.Tables[0].Rows) { lmd.Add(new PeriodicPaymentModel { Dr_Reg_Date = Convert.ToDateTime(dr["Dr_Reg_Date"]), Us_Name = dr["Us_Name"].ToString(), Us_LName = dr["Us_LName"].ToString(), Dr_AccTransaction = Convert.ToBoolean(dr["Dr_AccTransaction"]), Dr_Amount = Convert.ToInt32(dr["Dr_Amount"]), Dr_CardTranscation = Convert.ToBoolean(dr["Dr_CardTranscation"]), Dr_Cleaner = Convert.ToBoolean(dr["Dr_Cleaner"]), Dr_Clothes = Convert.ToBoolean(dr["Dr_Clothes"]), Dr_Endowment = Convert.ToBoolean(dr["Dr_Endowment"]), Dr_Food = Convert.ToBoolean(dr["Dr_Food"]), Dr_HelpDay = Convert.ToInt16(dr["Dr_HelpDay"]), Dr_Id = Convert.ToInt32(dr["Dr_Id"]), Dr_Inperson = Convert.ToBoolean(dr["Dr_Inperson"]), Dr_Medical = Convert.ToBoolean(dr["Dr_Medical"]), Dr_Month_Duration = Convert.ToInt16(dr["Dr_Month_Duration"]), Dr_Representative = Convert.ToBoolean(dr["Dr_Representative"]), Dr_Stationery = Convert.ToBoolean(dr["Dr_Stationery"]) }); } } return(View(lmd)); }