public ActionResult Form(long?id) { try { if (id == null) { user = (OCCUSER)Session["User"]; ViewBag.BRANCHCODE = new SelectList(db.BRANCHINFO, "ID", "BRANCHNAME"); CARDCHEREUISITION ccreq = new CARDCHEREUISITION(); //if (user.BRANCH != null) //{ // ccreq.BRANCHCODE = (long)user.BRANCH; //} long status = db.OCCENUMERATION.Where(x => x.Name == "applied").Select(x => x.ID).FirstOrDefault(); ViewBag.STATUSID = new SelectList(db.OCCENUMERATION.Where(x => x.Type == "chequereq"), "ID", "Name", status); ViewBag.STATUS = status; ccreq.CREATEDON = DateTime.Now; return(View(ccreq)); } CARDCHEREUISITION cardchereuisition = db.CARDCHEREUISITION.Find(id); if (cardchereuisition == null) { return(HttpNotFound()); } ViewBag.BRANCHCODE = new SelectList(db.BRANCHINFO, "ID", "BRANCHNAME", cardchereuisition.BRANCHCODE); ViewBag.STATUSID = new SelectList(db.OCCENUMERATION.Where(x => x.Type == "chequereq"), "ID", "Name", cardchereuisition.STATUS); return(View(cardchereuisition)); } catch (Exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult DelivaryPost(IEnumerable <long> idList) { OCCUSER user = (OCCUSER)Session["User"]; try { foreach (var id in idList) { var chequereq = db.CARDCHEREUISITION.Find(id); var statusId = db.OCCENUMERATION.Where(x => x.Type == "chequereq") .Where(x => x.Name == "delivered") .Select(x => x.ID) .FirstOrDefault(); chequereq.DELIVEREDBY = user.ID; chequereq.DELIVEREDON = DateTime.Now; chequereq.STATUS = statusId; db.Entry(chequereq).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult PostAuthList(IEnumerable <long> idList) { List <CARDCHEREUISITION> UpdatedList = new List <CARDCHEREUISITION>(); long count = 1; try { OCCUSER user = (OCCUSER)Session["User"]; foreach (var id in idList) { var cheueReq = db.CARDCHEREUISITION.FirstOrDefault(x => x.ID == id); cheueReq.STATUS = db.OCCENUMERATION.Where(x => x.Type == "chequereq").Where(x => x.Name == "authorized").Select(x => x.ID).FirstOrDefault(); cheueReq.AUTHORIZEDBY = user.ID; cheueReq.AUTHORIZEDON = DateTime.Now; UpdatedList.Add(cheueReq); } foreach (var editedChqRq in UpdatedList) { db.Entry(editedChqRq).State = EntityState.Modified; db.SaveChanges(); } // var authorizedList = db.CARDCHEREUISITION.Where(x => x.STATUS == 4).ToList(); return(RedirectToAction("RequisitionRequest")); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult UserCreation(OCCUSER occuser, int?BranchId) { try { if (!UserAlreadyExist(occuser.EMPLOYEEID)) { OCCUSER user = (OCCUSER)Session["User"]; occuser.CREATEDBY = user.ID; occuser.CREATEDON = DateTime.Now; occuser.ISACTIVE = true; occuser.BRANCH = BranchId; if (ModelState.IsValid) { db.OCCUSER.Add(occuser); db.SaveChanges(); var msg = "Data saved successfully. "; return(Json(msg, JsonRequestBehavior.AllowGet)); } ViewBag.BRANCH = new SelectList(db.BRANCHINFO.ToList(), "ID", "BRANCHNAME", BranchId); ViewBag.TYPE = new SelectList(db.OCCENUMERATION.Where(x => x.Type == "user").ToList(), "ID", "Name", occuser.TYPE); return(View()); } var mymsg = "User Already Exists"; return(Json(mymsg, JsonRequestBehavior.AllowGet)); } catch (Exception exception) { return(Json(exception.Message, JsonRequestBehavior.AllowGet)); } }
public ActionResult UserDetail(OCCUSER aUser, string btnName) { try { OCCUSER user = (OCCUSER)Session["User"]; if (String.Equals(btnName, "update")) { aUser.MODIFIEDBY = user.ID; aUser.MODIFIEDON = DateTime.Now; db.Entry(aUser).State = EntityState.Modified; db.SaveChanges(); var msg = "Successfully Updated"; return(Json(msg, JsonRequestBehavior.AllowGet)); } if (String.Equals(btnName, "delete")) { aUser.MODIFIEDBY = user.ID; aUser.MODIFIEDON = DateTime.Now; aUser.ISACTIVE = false; db.Entry(aUser).State = EntityState.Modified; db.SaveChanges(); var msg = "Successfully Removed"; return(Json(msg, JsonRequestBehavior.DenyGet)); } return(RedirectToAction("Error", "Home", new { Area = "" })); } catch (Exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult Form(DEPOSIT deposit) { try { OCCUSER user = (OCCUSER)Session["User"]; int adminFlag = 0; if (deposit.ID == 0) { deposit.CREATEDBY = user.ID; deposit.ISACTIVE = true; deposit.ISDELETE = false; deposit.ISDOWNLOAD = false; var refNo = DateTime.Now.ToString("ddMMyyHHmmssfff"); //refNo += deposit.CARDNUMBER.Substring(deposit.CARDNUMBER.Length - 4); deposit.REFERENCENUMBER = refNo; db.DEPOSIT.Add(deposit); db.SaveChanges(); // Session["DepositSaveMsg"] = "Data saved successfully.\nReferance Number is: "+deposit.REFERENCENUMBER; var msg = @"Data saved successfully.<br/>Referance Number is: " + deposit.REFERENCENUMBER; if (user.TYPE == 1) { adminFlag = 1; } // return RedirectToAction("Index", "List"); return(Json(new { msg, adminFlag }, JsonRequestBehavior.AllowGet)); } else { if (ModelState.IsValid) { deposit.CREATEDBY = user.ID; deposit.ISACTIVE = true; deposit.ISDELETE = false; deposit.ISDOWNLOAD = false; db.Entry(deposit).State = EntityState.Modified; if (user.TYPE == 1) { adminFlag = 1; } //db.DEPOSIT.AddOrUpdate(x=>x.ID==deposit.ID); db.SaveChanges(); var msg = "Successfully Updated"; return(Json(new { msg, adminFlag }, JsonRequestBehavior.AllowGet)); } List <string> currencyList = new List <string>() { "USD", "BDT" }; ViewBag.BRANCH = new SelectList(db.BRANCHINFO.ToList(), "ID", "BRANCHNAME", db.DEPOSIT.Select(x => x.BRANCH)); ViewBag.CURRENCY = new SelectList(currencyList, null, null, db.DEPOSIT.Select(x => x.CURRENCY)); return(View(deposit)); } } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
//[ValidateAntiForgeryToken] public ActionResult Form(CARDCHEREUISITION cardchereuisition) { try { user = (OCCUSER)Session["User"]; int adminFlag = 0; if (cardchereuisition.ID == 0) { cardchereuisition.LEAFNO = 10; cardchereuisition.ISACTIVE = false; cardchereuisition.ISDELETE = false; cardchereuisition.CREATEDBY = user.ID; if (ModelState.IsValid) { db.CARDCHEREUISITION.Add(cardchereuisition); db.SaveChanges(); if (user.TYPE == 1) { adminFlag = 1; } string msg = "Successfully Saved"; return(Json(new { msg, adminFlag }, JsonRequestBehavior.AllowGet)); } ViewBag.BRANCH = new SelectList(db.BRANCHINFO, "ID", "BRANCHNAME", user.BRANCH); CARDCHEREUISITION ccreq = new CARDCHEREUISITION(); if (user.BRANCH != null) { ccreq.BRANCHCODE = (long)user.BRANCH; } long status = db.OCCENUMERATION.Where(x => x.Name == "applied").Select(x => x.ID).FirstOrDefault(); ViewBag.STATUSID = new SelectList(db.OCCENUMERATION.Where(x => x.Type == "chequereq"), "ID", "Name", status); cardchereuisition.STATUS = status; return(View(cardchereuisition)); } else { var modifiedcardCheque = db.CARDCHEREUISITION.Find(cardchereuisition.ID); modifiedcardCheque.REMARKS = cardchereuisition.REMARKS; modifiedcardCheque.REFERENCENO = cardchereuisition.REFERENCENO; modifiedcardCheque.MODIFIEDBY = user.ID; modifiedcardCheque.MODIFIEDON = DateTime.Now; db.Entry(modifiedcardCheque).State = EntityState.Modified; db.SaveChanges(); string msg = "Successfully Updated"; return(Json(new { msg, adminFlag }, JsonRequestBehavior.AllowGet)); } } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult Index(int?STATUS, string CARDNO, DateTime?CREATEDON, int?page) { try { var checkSts = db.OCCENUMERATION.Where(x => x.Name == "delivered" && x.Type == "chequereq") .Select(x => x.ID) .FirstOrDefault(); OCCUSER user = (OCCUSER)Session["User"]; var cardchereuisition = db.CARDCHEREUISITION.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Include(c => c.OCCUSER1).Where(x => x.STATUS == checkSts && x.ISACTIVE == false).Where(x => x.ISDELETE == false).ToList(); //var status = db.OCCENUMERATION.Where(x => x.Type == "chequereq").Where(x => x.IsActive == true).ToList(); var status = new Dictionary <int, string>() { { 16, "delivered" }, { 0, "Active" } }; ViewBag.STATUS = new SelectList(status, "Key", "Value"); if (STATUS != null) { if (STATUS == 0) { cardchereuisition = db.CARDCHEREUISITION.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Include(c => c.OCCUSER1).Where(x => x.ISACTIVE).ToList(); } else { cardchereuisition = db.CARDCHEREUISITION.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Include(c => c.OCCUSER1).Where(x => x.STATUS == STATUS && x.ISACTIVE == false).ToList(); } ViewBag.STATUS = new SelectList(status, "Key", "Value", STATUS); ViewBag.currsts = STATUS; // ViewBag.STATUS = new SelectList(statusID, "Key", "Value", statusID.Where(x => x.Key == STATUS)); } if (!String.IsNullOrEmpty(CARDNO)) { CARDNO = CARDNO.Trim(); cardchereuisition = cardchereuisition.Where(x => x.CARDNO.Contains(CARDNO)).ToList(); ViewBag.CARDNO = CARDNO; } if (CREATEDON != null) { cardchereuisition = cardchereuisition.Where(x => x.CREATEDON == CREATEDON).ToList(); ViewBag.CREATEDON = CREATEDON; } int pageSize = ConstantConfig.PageSizes; int pageNumber = ((page ?? 1)); return(View(cardchereuisition.ToPagedList(pageNumber, pageSize))); } catch (Exception ex) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult Create(CARDCHTRAN cardchtran) { List <string> currencyList; try { int adminFlag = 0; OCCUSER user = (OCCUSER)Session["User"]; cardchtran.CREATEDBY = user.ID; cardchtran.CREATEDON = DateTime.Now.Date; cardchtran.STATUS = 13; cardchtran.ISACTIVE = true; cardchtran.ISDELETE = false; var leaf = db.CARDCHLEAF.FirstOrDefault(x => x.ID == cardchtran.CHEQUELEAFID); leaf.LEAFSTATUS = db.OCCENUMERATION.Where(x => x.Name == "used").Select(x => x.ID).FirstOrDefault(); db.Entry(leaf).State = EntityState.Modified; if (ModelState.IsValid) { db.CARDCHTRAN.Add(cardchtran); db.SaveChanges(); if (user.TYPE == 1) { adminFlag = 1; } var msg = "Data saved successfully. "; return(Json(new { msg, adminFlag }, JsonRequestBehavior.AllowGet)); } currencyList = new List <string>() { "BDT" }; ViewBag.BRANCHCODE = new SelectList(db.BRANCHINFO.ToList(), "ID", "BRANCHNAME"); ViewBag.CURRENCY = new SelectList(currencyList); return(View("Index")); } catch (DbEntityValidationException dbEntityValidationException) { return(RedirectToAction("Error", "Home", new { Area = "" })); } catch (InvalidOperationException invalidOperationException) { return(RedirectToAction("Error", "Home", new { Area = "" })); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
//public ActionResult Index() //{ // return View(); //} public ActionResult Index(int?STATUS, string CARDNO, DateTime?CREATEDON, int?page) { Dictionary <int, string> statusID; OCCUSER user = (OCCUSER)Session["User"]; if (user.TYPE == 1) { statusID = new Dictionary <int, string>() { { 4, "applied" }, { 5, "authorized" }, { 7, "received" }, { 8, "deny" }, { 16, "delivered" } }; } else { statusID = new Dictionary <int, string>() { { 4, "applied" }, { 5, "authorized" }, { 7, "received" }, { 16, "delivered" } }; } ViewBag.STATUS = new SelectList(statusID, "Key", "Value"); var statusId = db.OCCENUMERATION.Where(x => x.Type == "chequereq") .Where(x => x.Name == "received") .Select(x => x.ID) .FirstOrDefault(); var List = db.CARDCHEREUISITION.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Where(x => x.ISDELETE != true).Where(x => x.STATUS == statusId).OrderByDescending(x => x.ID).ToList(); if (STATUS != null) { List = db.CARDCHEREUISITION.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Where(x => x.ISDELETE != true).Where(x => x.STATUS == STATUS).OrderByDescending(x => x.ID).ToList(); ViewBag.STATUS = new SelectList(statusID, "Key", "Value", statusID.Where(x => x.Key == STATUS)); ViewBag.currsts = STATUS; // ViewBag.STATUS = new SelectList(statusID, "Key", "Value", statusID.Where(x => x.Key == STATUS)); } if (!String.IsNullOrEmpty(CARDNO)) { CARDNO = CARDNO.Trim(); List = List.Where(x => x.CARDNO.Contains(CARDNO)).Where(x => x.ISDELETE != true).ToList(); ViewBag.CARDNO = CARDNO; } if (CREATEDON != null) { List = List.Where(x => x.ESTABLISHMENTON.Value.Date == CREATEDON).Where(x => x.ISDELETE != true).ToList(); ViewBag.CREATEDON = CREATEDON; } int pageSize = ConstantConfig.PageSizes; int pageNumber = ((page ?? 1)); return(View(List.ToPagedList(pageNumber, pageSize))); }
public ActionResult Index() { try { OCCUSER user = (OCCUSER)Session["User"]; AuthorizerDashboardVM aVm = new AuthorizerDashboardVM(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList(); var pendingReqListCount = pendingReqList.Count; aVm.PendingRequisitionCount = pendingReqListCount; aVm.PendingRequisitionList = pendingReqList.Take(5).ToList(); var pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); var pendingChequeListCount = pendingChequeList.Count; aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT); aVm.PendingCardChequeCount = pendingChequeListCount; aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList(); var authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).OrderByDescending(x => x.ID).ToList(); var authReqListCount = authReqList.Count; aVm.AuthRequisitionCount = authReqListCount; aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList(); var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); var authChequeListCount = authChequeList.Count; aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT); aVm.AuthCardCHequeCount = authChequeListCount; aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList(); return(View(aVm)); } catch (Exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } // return View(); }
public ActionResult CardChequePendingRequest(string CARDNO, DateTime?CREATEDON, int?page, int?STATUS) { var statusID = db.OCCENUMERATION.Where(x => x.Type == "cardcheque"); List <CARDCHTRAN> List = new List <CARDCHTRAN>(); ViewBag.STATUS = new SelectList(statusID, "ID", "Name"); OCCUSER user = (OCCUSER)Session["User"]; // db.CARDCHTRAN.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Where(x=>x.) if (STATUS != null) { // List = List.Where(x => x.STATUS == STATUS).ToList(); //if (STATUS == 13) //{ // List = db.CARDCHTRAN.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Where(x => x.STATUS == 13).Where(x => x.ISDELETE != true).ToList(); //} //else //{ // List = db.CARDCHTRAN.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Where(x => x.STATUS == 14).Where(x => x.ISDELETE != true).ToList(); //} List = db.CARDCHTRAN.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Where(x => x.STATUS == STATUS).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); ViewBag.currentStatus = STATUS; ViewBag.STATUS = new SelectList(statusID, "ID", "Name", STATUS); } else { List = db.CARDCHTRAN.Include(c => c.BRANCHINFO).Include(c => c.OCCENUMERATION).Include(c => c.OCCUSER).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); } if (!String.IsNullOrEmpty(CARDNO)) { List = List.Where(x => x.CARDNO == CARDNO).Where(x => x.ISDELETE != true).ToList(); ViewBag.currentCardNo = CARDNO; } if (CREATEDON != null) { List = List.Where(x => x.CREATEDON == CREATEDON).Where(x => x.ISDELETE != true).ToList(); ViewBag.currentDate = CREATEDON; } // int pageSize = 3; int pageSize = ConstantConfig.PageSizes; int pageNumber = ((page ?? 1)); //var chqSts = db.OCCENUMERATION.Where(x => x.Type == "cardcheque" && x.Name != "pending").ToList(); //ViewBag.CHQSTATUS = new SelectList (chqSts, "Id", "Name"); return(View(List.ToPagedList(pageNumber, pageSize))); }
// GET: Admin/Payment public ActionResult Index(int?BRANCH, string CARDNO, DateTime?CREATEDON, int?page, int?serial) { // var dEPOSIT = db.DEPOSIT.Include(d => d.BRANCHINFO).Include(d => d.OCCUSER); // return View(dEPOSIT.ToList()); int pageSize = 10; int pageNumber = (page ?? 1); OCCUSER user = (OCCUSER)Session["User"]; try { var list = db.DEPOSIT.Where(x => x.ISDELETE == false).OrderByDescending(x => x.ID).ToList(); var branch = db.BRANCHINFO.Select(x => new { x.BRANCHNAME, x.ID }).OrderBy(x => x.BRANCHNAME); ViewBag.BRANCH = new SelectList(branch, "ID", "BRANCHNAME"); if (serial != null) { @ViewBag.Sln = (pageNumber * pageSize) - 9; } else { @ViewBag.Sln = 1; } if (BRANCH != null) { list = list.Where(x => x.BRANCH == BRANCH).ToList(); ViewBag.BRANCH = new SelectList(branch, "ID", "BRANCHNAME", BRANCH); ViewBag.currentBranch = BRANCH; } if (!String.IsNullOrEmpty(CARDNO)) { CARDNO = CARDNO.Trim(); list = list.Where(x => x.CARDNUMBER.Contains(CARDNO)).ToList(); ViewBag.CARDNO = CARDNO; } if (CREATEDON != null) { list = list.Where(x => x.CREATEDON == CREATEDON).ToList(); ViewBag.CREATEDON = CREATEDON; } return(View(list.ToPagedList(pageNumber, pageSize))); // return View(list); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult Index() { try { OCCUSER user = (OCCUSER)Session["User"]; TellerDashBoardVM aVm = new TellerDashBoardVM(); var visaList = db.DEPOSIT.Where(x => x.ISDELETE == false).Where(x => x.CREATEDBY == user.ID).OrderByDescending(x => x.ID).ToList(); aVm.TotalVisaPayment = visaList.Count; aVm.TotalVisaPaymentCollection = (decimal)visaList.Sum(x => x.AMOUNT); visaList = visaList.Take(5).ToList(); var requisitionList = db.CARDCHEREUISITION.Where(x => x.CREATEDBY == user.ID).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); aVm.TotalReqisitionRequest = requisitionList.Count; requisitionList = requisitionList.Take(5).ToList(); var cardchtanList = db.CARDCHTRAN.Where(x => x.CREATEDBY == user.ID).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); aVm.TotalCardPayment = cardchtanList.Sum(x => x.AMOUNT); aVm.TotalChequePaymentNumber = cardchtanList.Count; cardchtanList = cardchtanList.Take(5).ToList(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } //var visaPaymentList = db.DEPOSIT.Where(x => x.CREATEDBY == user.ID).ToList(); aVm.Deposits = visaList; aVm.Requisitions = requisitionList; aVm.ChequeTrans = cardchtanList; // aVm.TotalVisaPayment = visaPaymentList.Count; // aVm.TotalVisaPaymentCollection = (decimal)visaPaymentList.Sum(x => x.AMOUNT); return(View(aVm)); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult SearchReasult(DateTime startDate, DateTime endDate, string btnName) { try { if (btnName == "visa") { OCCUSER user = (OCCUSER)Session["User"]; var List = db.DEPOSIT.Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x => x.CREATEDBY == user.ID).ToList(); } return(View()); } catch (Exception) { return(Json("Error")); } }
public ActionResult Details(CARDCHTRAN tran, string btnName) { try { OCCUSER user = (OCCUSER)Session["User"]; if (String.Equals(btnName, "update")) { var updatedTrn = db.CARDCHTRAN.Find(tran.ID); updatedTrn.CHEQUELEAFID = tran.CHEQUELEAFID; updatedTrn.CARDNO = tran.CARDNO; updatedTrn.BENEFICIARINFO = tran.BENEFICIARINFO; updatedTrn.AMOUNT = tran.AMOUNT; updatedTrn.BRANCHCODE = tran.BRANCHCODE; updatedTrn.REQUESTDATE = tran.REQUESTDATE; updatedTrn.MODIFIEDBY = user.ID; updatedTrn.MODIFIEDON = DateTime.Now; // updatedTrn.ISACTIVE = true; db.Entry(updatedTrn).State = EntityState.Modified; db.SaveChanges(); var msg = "Successfully Updated"; return(Json(msg, JsonRequestBehavior.AllowGet)); } if (String.Equals(btnName, "delete")) { //aUser.MODIFIEDBY = user.ID; //aUser.MODIFIEDON = DateTime.Now; //aUser.ISACTIVE = false; //db.Entry(aUser).State = EntityState.Modified; //db.SaveChanges(); var updatedTrn = db.CARDCHTRAN.Find(tran.ID); updatedTrn.ISDELETE = true; db.Entry(updatedTrn).State = EntityState.Modified; db.SaveChanges(); var msg = "Successfully Removed"; return(Json(msg, JsonRequestBehavior.AllowGet)); } var msg1 = "Error in operation"; return(Json(msg1, JsonRequestBehavior.DenyGet)); // return View(tran); } catch (Exception exception) { return(Json(exception.Message, JsonRequestBehavior.AllowGet)); //return RedirectToAction("Error", "Home", new { Area = "" }); } }
public ActionResult Details(CARDCHEREUISITION cardchereuisition, string btnName) { try { OCCUSER user = (OCCUSER)Session["User"]; if (String.Equals(btnName, "delete")) { CARDCHEREUISITION ccr = db.CARDCHEREUISITION.Find(cardchereuisition.ID); ccr.ISDELETE = true; //db.Entry(ccr).State = EntityState.Modified; db.SaveChanges(); var msg = "Successfully Removed"; return(Json(msg, JsonRequestBehavior.AllowGet)); } if (String.Equals(btnName, "update")) { var updatedModel = db.CARDCHEREUISITION.Find(cardchereuisition.ID); updatedModel.CARDNO = cardchereuisition.CARDNO; updatedModel.CREATEDON = cardchereuisition.CREATEDON; updatedModel.BRANCHCODE = cardchereuisition.BRANCHCODE; updatedModel.STATUS = cardchereuisition.STATUS; updatedModel.REFERENCENO = cardchereuisition.REFERENCENO; updatedModel.REMARKS = cardchereuisition.REMARKS; //if (cardchereuisition.ISACTIVE) //{ // updatedModel.ISACTIVE = cardchereuisition.ISACTIVE; //} //if (ModelState.IsValid) //{ //db.Entry(cardchereuisition).State = EntityState.Modified; db.SaveChanges(); //} var msg = "Successfully Updated"; return(Json(msg, JsonRequestBehavior.AllowGet)); } return(Json("Error", JsonRequestBehavior.AllowGet)); } catch (Exception exception) { return(Json(exception.Message, JsonRequestBehavior.AllowGet)); } }
// GET: /ChequeRequisition/Home/ public ActionResult Index(int?STATUS, string CARDNO, DateTime?CREATEDON, int?page) { try { user = (OCCUSER)Session["User"]; Dictionary <int, string> statusID = new Dictionary <int, string>() { { 4, "applied" }, { 5, "authorized" } }; ViewBag.STATUS = new SelectList(statusID, "Key", "Value"); var List = db.CARDCHEREUISITION.Include(c => c.BRANCHINFO).Where(x => x.ISDELETE == false).Where(x => x.CREATEDBY == user.ID).OrderByDescending(x => x.ID).ToList(); if (STATUS != null) { List = List.Where(x => x.STATUS == STATUS).ToList(); ViewBag.STATUS = new SelectList(statusID, "Key", "Value", statusID.Where(x => x.Key == STATUS)); ViewBag.currsts = STATUS; // ViewBag.STATUS = new SelectList(statusID, "Key", "Value", statusID.Where(x => x.Key == STATUS)); } if (!String.IsNullOrEmpty(CARDNO)) { CARDNO = CARDNO.Trim(); List = List.Where(x => x.CARDNO.Contains(CARDNO)).ToList(); ViewBag.CARDNO = CARDNO; } if (CREATEDON != null) { List = List.Where(x => x.CREATEDON == CREATEDON).ToList(); ViewBag.CREATEDON = CREATEDON; } int pageSize = ConstantConfig.PageSizes; int pageNumber = ((page ?? 1)); return(View(List.ToPagedList(pageNumber, pageSize))); } catch (Exception ex) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult Post(IEnumerable <long> idList) { OCCUSER user = (OCCUSER)Session["User"]; try { foreach (var id in idList) { var cheqreq = db.CARDCHEREUISITION.FirstOrDefault(x => x.ID == id); cheqreq.CALLCENTERBY = user.ID; cheqreq.CALLCENTERON = DateTime.Now; cheqreq.ISACTIVE = true; db.Entry(cheqreq).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult Details(DEPOSIT deposit, string btnName) { try { OCCUSER user = (OCCUSER)Session["User"]; if (String.Equals(btnName, "update")) { DEPOSIT deposits = db.DEPOSIT.Find(deposit.ID); deposit.CREATEDBY = deposits.CREATEDBY; deposit.CREATEDON = deposits.CREATEDON; deposit.MODIFIEDBY = user.ID; deposit.MODIFIEDON = DateTime.Now; deposit.ISACTIVE = true; deposit.ISDELETE = false; //db.Entry(deposit).State = EntityState.Modified; db.DEPOSIT.AddOrUpdate(deposit); db.SaveChanges(); var msg = "Successfully Updated"; return(Json(msg, JsonRequestBehavior.AllowGet)); } if (String.Equals(btnName, "delete")) { DEPOSIT depostis = db.DEPOSIT.Find(deposit.ID); depostis.ISDELETE = true; db.Entry(depostis).State = EntityState.Modified; db.SaveChanges(); var msg = "Successfully Removed"; return(Json(msg, JsonRequestBehavior.AllowGet)); } return(RedirectToAction("Error", "Home", new { Area = "" })); } catch (Exception exception) { var msg = exception.Message; return(Json(msg, JsonRequestBehavior.AllowGet)); } }
// GET: Admin/CardCheque public ActionResult Index(int?STATUS, string CARDNO, DateTime?CREATEDON, int?page) { try { OCCUSER user = (OCCUSER)Session["User"]; var List = db.CARDCHTRAN.Include(c => c.CARDCHLEAF).Include(c => c.OCCUSER).Include(c => c.OCCUSER1).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); var status = db.OCCENUMERATION.Where(x => x.Type == "cardcheque"); ViewBag.STATUS = new SelectList(status, "ID", "Name"); if (STATUS != null) { List = List.Where(x => x.STATUS == STATUS).ToList(); ViewBag.STATUS = new SelectList(status, "ID", "Name", STATUS); ViewBag.currsts = STATUS; } if (!String.IsNullOrEmpty(CARDNO)) { CARDNO = CARDNO.Trim(); List = List.Where(x => x.CARDNO.Contains(CARDNO)).ToList(); ViewBag.CARDNO = CARDNO; } if (CREATEDON != null) { List = List.Where(x => x.CREATEDON == CREATEDON).ToList(); ViewBag.CREATEDON = CREATEDON; } // int pageSize = ConstantConfig.PageSizes; int pageSize = ConstantConfig.PageSizes; int pageNumber = ((page ?? 1)); return(View(List.ToPagedList(pageNumber, pageSize))); } catch (Exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult Index(DateTime?startDate, DateTime?endDate, string btnName) { try { if (startDate != null || endDate != null) { OCCUSER user = (OCCUSER)Session["User"]; AdminDashboardVM aVm = new AdminDashboardVM(); var visaList = db.DEPOSIT.Where(x => x.ISDELETE == false).OrderByDescending(x => x.ID).ToList(); aVm.TotalVisaPayment = visaList.Count; aVm.TotalVisaPaymentCollection = (decimal)visaList.Sum(x => x.AMOUNT); visaList = visaList.Take(5).ToList(); var requisitionList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); aVm.TotalReqisitionRequest = requisitionList.Count; requisitionList = requisitionList.Take(5).ToList(); var cardchtanList = db.CARDCHTRAN.Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); aVm.TotalCardPayment = cardchtanList.Sum(x => x.AMOUNT); aVm.TotalChequePaymentNumber = cardchtanList.Count; cardchtanList = cardchtanList.Take(5).ToList(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } if (btnName == "visa") { visaList = db.DEPOSIT.Where(x => x.ISDELETE == false).Where(x => x.CREATEDON.Value.Date >= startDate.Value.Date).Where(x => x.CREATEDON.Value.Date <= endDate.Value.Date).ToList(); aVm.TotalVisaPayment = visaList.Count; aVm.TotalVisaPaymentCollection = (decimal)visaList.Sum(x => x.AMOUNT); //aVm.Deposits = List; } else if (btnName == "requisition") { requisitionList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.CREATEDON.Date >= startDate.Value.Date).Where(x => x.CREATEDON.Date <= endDate.Value.Date).ToList(); aVm.TotalReqisitionRequest = requisitionList.Count; } else if (btnName == "cardcheque") { cardchtanList = db.CARDCHTRAN.Where(x => x.ISDELETE != true).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList(); aVm.TotalCardPayment = cardchtanList.Sum(x => x.AMOUNT); aVm.TotalChequePaymentNumber = cardchtanList.Count; } aVm.Deposits = visaList; aVm.Requisitions = requisitionList; aVm.ChequeTrans = cardchtanList; return(View(aVm)); } return(RedirectToAction("Index")); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } // return View(); }
public ActionResult CardChAuthPost(FormCollection formCollection) { List <long> ID = new List <long>(); List <string> APPROVALNO = new List <string>(); List <int> CHQSTATUS = new List <int>(); List <string> REMARKSLIST = new List <string>(); try { OCCUSER user = (OCCUSER)Session["User"]; List <CardChequeAuthorizrVM> vm = new List <CardChequeAuthorizrVM>(); foreach (var key in formCollection.AllKeys) { if (key.Contains("ID")) { long id = Convert.ToInt64(formCollection[key]); ID.Add(id); } if (key.Contains("APPROVAL")) { string approval = formCollection[key]; APPROVALNO.Add(approval); } if (key.Contains("CHQSTATUS")) { int chqStatus = Convert.ToInt32(formCollection[key]); CHQSTATUS.Add(chqStatus); } if (key.Contains("REMARKS")) { string remarks = formCollection[key]; REMARKSLIST.Add(remarks); } var value = formCollection[key]; } for (int i = 0; i < ID.Count; i++) { var aVm = new CardChequeAuthorizrVM() { APPROVALNO = APPROVALNO[i], ID = ID[i], ChqStatus = CHQSTATUS[i], REMARKS = REMARKSLIST[i] }; vm.Add(aVm); } // var a = formCollection["CHQSTATUS"]; foreach (var aViewModel in vm) { var cardChq = db.CARDCHTRAN.FirstOrDefault(x => x.ID == aViewModel.ID); cardChq.APPROVALNO = aViewModel.APPROVALNO; cardChq.STATUS = aViewModel.ChqStatus; cardChq.REMARKS = aViewModel.REMARKS; cardChq.AUTHORIZEDBY = user.ID; cardChq.AUTHORIZEDON = DateTime.Now; db.Entry(cardChq).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("CardChequePendingRequest")); } catch (Exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult Index(DateTime?startDate, DateTime?endDate, string btnName) { try { if (startDate != null || endDate != null) { OCCUSER user = (OCCUSER)Session["User"]; AuthorizerDashboardVM aVm = new AuthorizerDashboardVM(); WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID); foreach (DataRow dataRow in dt.Rows) { aVm.EmployeeInfoVm.BranchName = (string)dataRow[21]; aVm.EmployeeInfoVm.Email = (string)dataRow[9]; aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2]; aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7]; aVm.EmployeeInfoVm.Name = (string)dataRow[3]; aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17]; } var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE == false).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList(); var pendingReqListCount = pendingReqList.Count; aVm.PendingRequisitionCount = pendingReqListCount; aVm.PendingRequisitionList = pendingReqList.Take(5).ToList(); var pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); var pendingChequeListCount = pendingChequeList.Count; aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT); aVm.PendingCardChequeCount = pendingChequeListCount; aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList(); var authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).OrderByDescending(x => x.ID).ToList(); var authReqListCount = authReqList.Count; aVm.AuthRequisitionCount = authReqListCount; aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList(); var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList(); var authChequeListCount = authChequeList.Count; aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT); aVm.AuthCardCHequeCount = authChequeListCount; aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList(); if (btnName == "pendingreq") { pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList(); pendingReqListCount = pendingReqList.Count; aVm.PendingRequisitionCount = pendingReqListCount; aVm.PendingRequisitionList = pendingReqList.ToList(); //aVm.Deposits = List; } else if (btnName == "pendingcc") { pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x => x.ISDELETE != true).ToList(); pendingChequeListCount = pendingChequeList.Count; aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT); aVm.PendingCardChequeCount = pendingChequeListCount; aVm.PendingCardChequeList = pendingChequeList.ToList(); } else if (btnName == "authreq") { authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList(); authReqListCount = authReqList.Count; aVm.AuthRequisitionCount = authReqListCount; aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList(); } else if (btnName == "authcc") { authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x => x.ISDELETE != true).ToList(); authChequeListCount = authChequeList.Count; aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT); aVm.AuthCardCHequeCount = authChequeListCount; aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList(); } return(View(aVm)); } return(RedirectToAction("Index")); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }
public ActionResult LogIn(OCCUSER aUser, string PASSWORD) { WebRef.OBLAPP oblApp = new WebRef.OBLAPP(); try { var isValid = oblApp.GetByUserIDCheck(aUser.EMPLOYEEID, PASSWORD); if (isValid == "Valid") { ViewBag.flag = ""; if (IsUserInSystem(aUser.EMPLOYEEID)) { var user = GetByEmpId(aUser.EMPLOYEEID); if (user != null) { FormsAuthentication.SetAuthCookie(Convert.ToString(user.ID), false); Session["User"] = user; if (user.TYPE == 1) { return(RedirectToAction("Index", "Home", new { Area = "Admin" })); } if (user.TYPE == 3) { return(RedirectToAction("Index", "Home", new { Area = "Authorizer" })); } if (user.TYPE == 2) { return(RedirectToAction("Index", "Home", new { Area = "Teller" })); } if (user.TYPE == 9) { return(RedirectToAction("Index", "Home", new { Area = "Establishment" })); } if (user.TYPE == 15) { return(RedirectToAction("Index", "Home", new { Area = "CallCenter" })); } if (user.TYPE == 17) { return(RedirectToAction("Index", "Home", new { Area = "Dispatcher" })); } } } else { ViewBag.flag = "User is not in the system"; } } else if (isValid == "Invalid") { ViewBag.flag = "Invalid User"; return(View()); } else if (isValid == "NotFound") { ViewBag.flag = "User Not Found"; return(View()); } return(View()); } catch (Exception exception) { ViewBag.flag = "Something is wrong " + exception.Message; return(View()); } }
public ActionResult Post(IEnumerable <long> idList) { OCCUSER user = (OCCUSER)Session["User"]; var aList = idList.OrderBy(x => x); try { foreach (var id in aList) { var cheque = db.CARDCHEREUISITION.FirstOrDefault(x => x.ID == id); var statusId = db.OCCENUMERATION.Where(x => x.Type == "chequereq") .Where(x => x.Name == "received") .Select(x => x.ID) .FirstOrDefault(); cheque.STATUS = statusId; if (IsLeafNoStartsWithZero()) { cheque.LEAFFROM = "0000001"; cheque.LEAFTO = "0000010"; cheque.LEAFNEXT = 11; } else { var lastSavedchq = db.CARDCHEREUISITION.Where(x => x.ESTABLISHMENTBY != null).OrderByDescending(x => x.LEAFNEXT).OrderByDescending(x => x.ESTABLISHMENTON).FirstOrDefault(); var leafnext = (int)lastSavedchq.LEAFNEXT; if (leafnext + 10 > 9999999) { cheque.LEAFFROM = "0000001"; cheque.LEAFTO = "0000010"; cheque.LEAFNEXT = 11; } else { string leafnum = leafnext.ToString(CultureInfo.InvariantCulture); cheque.LEAFFROM = leafnum.PadLeft(7, '0'); leafnext += 9; leafnum = leafnext.ToString(CultureInfo.InvariantCulture); cheque.LEAFTO = leafnum.PadLeft(7, '0'); leafnext++; cheque.LEAFNEXT = leafnext; } } cheque.ESTABLISHMENTBY = user.ID; cheque.ESTABLISHMENTON = DateTime.Now; db.Entry(cheque).State = EntityState.Modified; db.SaveChanges(); } DownloadFile(idList); return(RedirectToAction("Index")); } catch (Exception exception) { return(RedirectToAction("Error", "Home", new { Area = "" })); } }