public async Task <ActionResult> DonatorsList() { 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.DonatorsListData(); foreach (DataRow dr in ds.Tables[0].Rows) { lmd.Add(new PeriodicPaymentModel { Dr_Reg_Date = Convert.ToDateTime(dr["Dr_Reg_Date"]), Dr_Amount = Convert.ToInt32(dr["Dr_Amount"]), Dr_Month_Duration = Convert.ToInt16(dr["Dr_Month_Duration"]), Us_Name = dr["Us_Name"].ToString(), Us_LName = dr["Us_LName"].ToString(), IsUser = Convert.ToBoolean(dr["IsUser"]), Us_Email = dr["Us_Email"].ToString(), Us_Mob = dr["Us_Mob"].ToString(), Us_Phone = dr["Us_Phone"].ToString(), Us_Unic_Number = Convert.ToInt32(dr["Us_Unic_Number"]), Dr_CT_Code = Convert.ToInt16(dr["Dr_CT_Code"]) }); } } return(View(lmd)); }