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