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