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