public ActionResult GetMember() { List <Member> ret = new List <Member>(); ret = MemberControllerSql.GetAll(); return(Json(new { data = ret }, JsonRequestBehavior.AllowGet)); }
// GET: Loan public ActionResult Loan() { List <Savings> save = new List <Savings>(); save = SavingsCotrollerSql.GetAll(); if (save.Count != 0) { decimal total = 0; for (int i = 0; i <= save.Count - 1; i++) { total += save[i].SavingsAmt; } if (total >= 15000) { string memberid = Convert.ToString(Session["MemberId"]); List <Loan> loanlist = new List <Loan>(); loanlist = LoanControllerSql.GetAll(memberid); if (loanlist.Count == 0) { List <Member> mem = new List <Member>(); mem = MemberControllerSql.GetAll(Convert.ToInt32(Session["MemberId"])); ViewBag.Id = Convert.ToInt32(Session["MemberId"]); ViewBag.Fullname = Convert.ToString(Session["Fullname"]); ViewBag.Members = mem; return(View()); } else { Session["alert"] = "1"; return(RedirectToAction("Home", "Member")); } } else { Session["alert1"] = "1"; return(RedirectToAction("Home", "Member")); } } else { Session["alert1"] = "1"; return(RedirectToAction("Home", "Member")); } }
public ActionResult MemberAdd(Member me) { bool status = false; DateTime day = DateTime.Now; Session["status"] = null; List <Login> loglist = new List <Login>(); loglist = LoginControllerSql.GetAll(me.EmailAddress); List <Member> mem = new List <Member>(); mem = MemberControllerSql.GetAll(); int iid = mem.Count + 1; string memid = "M" + (iid).ToString(); string salut = ""; if (loglist.Count == 0) { string pass = Hash((me.Birthdate.ToShortDateString())); Login log = new Login { Username = me.EmailAddress, Hash = pass, CreatedBy = "none", ModifyBy = "none", Level = 4, CreatedDate = day, ModifiedDate = day, Locked = 0, LastLogin = day }; status = LoginControllerSql.Insert(log); if (status == true) { if (me.Gender == "Male") { salut = "Mr"; } else if (me.Gender == "Female") { if (me.MaritalStatus == "Married") { salut = "Mrs"; } else { salut = "Ms"; } } List <Login> ul = LoginControllerSql.GetAll(me.EmailAddress); Member ret = new Member { Fname = me.Fname, Mname = me.Mname, Lname = me.Lname, Birthdate = me.Birthdate, Position = me.Position, EmailAddress = me.EmailAddress, Deleted = 0, Url = "---", LoginId = ul[0].Id, ResidentialAddress = me.ResidentialAddress, Gender = me.Gender, ContactNo = me.ContactNo, MaritalStatus = me.MaritalStatus, EmployeeId = memid, EmergencyContactNo = me.EmergencyContactNo, SalaryAmt = me.SalaryAmt, Salutation = salut }; status = MemberControllerSql.Insert(ret); Session["status"] = 1; } } else { Session["status"] = 2; Response.Write("<script type='text/javascript'>alert('Email is already exist');</script>"); } Session["AddMessage"] = status; return(RedirectToAction("MemberView", "Member", new { id = "" })); }