public ActionResult GetMember()
{
List <Member> ret = new List <Member>();
ret = MemberControllerSql.GetAll();
return(Json(new { data = ret }, JsonRequestBehavior.AllowGet));
}
public ActionResult MemberView(Member me)
{
Session["status"] = null;
Member ret = new Member
{
Id = me.Id,
Fname = me.Fname,
Mname = me.Mname,
Lname = me.Lname,
Birthdate = me.Birthdate,
Position = me.Position,
EmailAddress = me.EmailAddress,
ResidentialAddress = me.ResidentialAddress,
Gender = me.Gender,
ContactNo = me.ContactNo,
MaritalStatus = me.MaritalStatus,
EmergencyContactNo = me.EmergencyContactNo,
SalaryAmt = me.SalaryAmt,
};
bool status = false;
status = MemberControllerSql.Update(ret);
if (status == true)
{
Session["status"] = 1;
//Response.Write("<script>alert('You have successfully updated the Admin');</script>");
}
Session["UpdateMess"] = status;
return(RedirectToAction("MemberView", "Member", new { id = "" }));
}
public JsonResult ListMember(Member data)
{
Member data1 = new Member();
data1 = MemberControllerSql.GetEmpId(data.EmployeeId);
return(new JsonResult {
Data = data1, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Deleted(int Id)
{
Member ret = new Member
{
Id = Id
};
bool status = false;
status = MemberControllerSql.Delete(ret);
Session["DeleteStatus"] = status;
return(RedirectToAction("MemberView", "Member", new { id = "" }));
}
// 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 MemberView(int?Id)
{
if (Id == null)
{
if (Session["status"] == null)
{
Session["status"] = 0;
}
ViewBag.ModalView = 0;
return(View());
}
else
{
Member a = new Member();
a = MemberControllerSql.GetById((int)Id);
ViewBag.ModalView = 1;
return(View(a));
}
}
public ActionResult Index(FormCollection fc)
{
try
{
string username = (fc["username"]).ToString();
string pass = (fc["password"].ToString());
string hash = Hash(pass);
Login log = new Login();
log = LoginControllerSql.Get(username, hash);
if (username == "")
{
return(RedirectToAction("Home", "Admin"));
}
if (log.Level == 4)
{
Member mem = new Member();
mem = MemberControllerSql.GetByLoginId(log.Id);
Session["Fullname"] = mem.Fname + " " + mem.Mname + " " + mem.Lname;
Session["MemberId"] = mem.Id;
Session["MemberId1"] = mem.EmployeeId;
return(RedirectToAction("Home", "Member"));
}
else if (log.Level == 3)
{
Admin a = new Admin();
a = AdminControllerSql.GetById(log.Id);
Session["Fullname"] = a.Fname + " " + a.Mname + " " + a.Lname;
Session["MemberId"] = a.Id;
Session["MemberId1"] = a.AdminId;
return(RedirectToAction("Home", "Admin"));
}
else
{
Response.Write("<script type = 'text/javascript'>alert('Wrong Username or Password');</script>");
}
}
catch (Exception)
{
Response.Write("<script type = 'text/javascript'>alert('Wrong Username or Password');</script>");
}
return(View());
}
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 = "" }));
}
public ActionResult Loan(FormCollection fc)
{
bool status = false;
decimal loanamt = Convert.ToDecimal(fc["amt"]);
int terms = Convert.ToInt32(fc["mtp"]);
decimal totalwinterest = Convert.ToDecimal(fc["totalwinterest"]);
int mid = Convert.ToInt32(Session["MemberId"]);
string w1 = Convert.ToString(fc["witness1"]);
string w2 = Convert.ToString(fc["witness2"]);
string w3 = Convert.ToString(fc["witness3"]);
int no = Convert.ToInt32(fc["no"]);
List <Loan> listloan = new List <Loan>();
listloan = LoanControllerSql.GetAll();
int cid = listloan.Count + 1;
string lid = "L" + cid.ToString();
DateTime d = DateTime.Now;
Loan loan = new Loan
{
LoanId = lid,
MemberId = mid,
Status = "Pending",
CreatedDate = d,
ApprovalDate = d,
LoanAmt = loanamt,
Terms = terms,
InterestRate = 1,
TotalPaymentwInterest = totalwinterest,
ApprovedBy = "none"
};
status = LoanControllerSql.Insert(loan);
if (status == true)
{
Witness w = new Witness
{
LoanId = lid,
WitnessName = w1,
};
status = WitnessControllerSql.Insert(w);
Witness wm1 = new Witness
{
LoanId = lid,
WitnessName = w2,
};
status = WitnessControllerSql.Insert(wm1);
Witness wm2 = new Witness
{
LoanId = lid,
WitnessName = w3,
};
status = WitnessControllerSql.Insert(wm2);
Response.Write("<script>alert('Success');</script>");
for (int i = 0; i <= no - 1; i++)
{
string name = Convert.ToString(fc["co" + i]);
string contact = Convert.ToString(fc["cno" + i]);
string MID = Convert.ToString(fc["CMID" + i]);
if (MID == "")
{
MID = "0";
}
List <Member> m = new List <Member>();
m = MemberControllerSql.Get(MID);
if (m.Count > 0)
{
Comaker co = new Comaker
{
LoanId = lid,
Name = name,
ContactNo = contact,
MemberId = MID
};
status = ComakerControllerSql.Insert(co);
}
else
{
Response.Write("<script type='text/javascript'>alert(Member Id: " + MID + "' doesn't exist');</script>");
return(View());
}
}
if (status == true)
{
Session["Success"] = "1";
return(RedirectToAction("Home", "Member"));
}
}
return(View());
}
