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