public ActionResult AssignInspector(int id, int sender) { //var lor = db.loan_officer_assign.Add(AI) // OfficerAssign OA = new OfficerAssign(); //var AI = AI1.Find(p => p.officer_id == id); loan_officer_assign oa = new loan_officer_assign(); oa.application_id = sender; oa.officer_id = id; db.loan_officer_assign.Add(oa); db.SaveChanges(); loan_application la = new loan_application(); la = db.loan_application.Find(sender); //if(la == null) //{ // return HttpNotFound(); //} la.status = "Assigned"; db.SaveChanges(); officer O1 = db.officers.Find(id); string EID = O1.email_id; string OfficerName = O1.name; string AppID = oa.application_id.ToString(); SendVerificationLinkEmail(EID, OfficerName, AppID); return(RedirectToAction("ApplicationList", "View_Loan_Applications")); }
// GET: /officer/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } officer officer = db.officers.Find(id); var jobsType = new List <SelectListItem> { new SelectListItem { Text = "--छान्नुहोस्--", Value = "" }, new SelectListItem { Text = "करार", Value = "करार" }, new SelectListItem { Text = "स्थाई", Value = "स्थाई" } }; ViewBag.jobType = new SelectList(jobsType.ToList(), "Text", "Value", officer.jobType); if (officer == null) { return(HttpNotFound()); } ViewBag.officeId = new SelectList(db.offices, "officeId", "karyalaye", officer.officeId); return(View(officer)); }
public ActionResult GetOfficerDetails(int id) { officer officer = (from item in db.officers where item.officerID == id select item).FirstOrDefault(); officerStayIn room = (from item in db.officerStayIns where item.officerid == id select item).FirstOrDefault(); OfficerWorkA work = (from item in db.OfficerWorkAs where item.officerid == id select item).FirstOrDefault(); OfficerDetails officerDetails = new OfficerDetails(); officerDetails.officer = officer; if (room != null) { officerDetails.room = room.officerRoom; } if (work != null) { officerDetails.job = work.Job; } return(View(officerDetails)); }
public ActionResult DeleteConfirmed(int id) { officer officer = db.officers.Find(id); db.officers.Remove(officer); db.SaveChanges(); return(RedirectToAction("Index")); }
private void AddOfficer(officer zOfficer) { //move officer from available list to unavailable list officer removed = zOfficer; removed.Reset(); m_officers.Add(removed); SetOfficerStatus(); }
public ActionResult Create([Bind(Include = "officerId,fullName,pisNo,jobType,email,officePhone,extenNo,mobileNo,status,officeId,darja,bankAccNo,sthaiLekhaNo,bima,bimaPariNo,bimaCode,bimaSheetRollNo,suruScale,gradeSankhya,mahangiBhatta,jokhimBhatta,gradeDar,bankShakha,jobType,naLaKos,kaSaKos,naLaKosNo,kaSaKosNo,saSuKar,paKar,serialNo,sapati")] officer officer, FormCollection col) { if (ModelState.IsValid) { int intstatus = Convert.ToInt32(officer.status); string getStatus = ((status)intstatus).ToString(); officer objOfficer = new officer(); objOfficer.fullName = TrimText(officer.fullName); objOfficer.pisNo = TrimText(officer.pisNo); objOfficer.email = officer.email; objOfficer.officePhone = TrimText(officer.officePhone); objOfficer.officeId = officer.officeId; objOfficer.mobileNo = TrimText(officer.mobileNo); objOfficer.sapati = officer.sapati; objOfficer.jokhimBhatta = officer.jokhimBhatta; objOfficer.mahangiBhatta = officer.mahangiBhatta; objOfficer.status = getStatus; objOfficer.jobType = officer.jobType; objOfficer.darja = TrimText(officer.darja); objOfficer.bankAccNo = TrimText(officer.bankAccNo); objOfficer.sthaiLekhaNo = TrimText(officer.sthaiLekhaNo); objOfficer.bima = officer.bima; objOfficer.bimaCode = TrimText(officer.bimaCode); objOfficer.bimaPariNo = TrimText(officer.bimaPariNo); objOfficer.bimaSheetRollNo = TrimText(officer.bimaSheetRollNo); objOfficer.suruScale = officer.suruScale; objOfficer.gradeSankhya = officer.gradeSankhya; objOfficer.gradeDar = officer.gradeDar; objOfficer.bankShakha = TrimText(officer.bankShakha); objOfficer.extenNo = TrimText(officer.extenNo); objOfficer.naLaKos = officer.naLaKos; objOfficer.kaSaKos = officer.kaSaKos; objOfficer.naLaKosNo = officer.naLaKosNo; objOfficer.kaSaKosNo = officer.kaSaKosNo; objOfficer.saSukar = officer.saSukar; objOfficer.paKar = officer.paKar; objOfficer.serialNo = officer.serialNo; //TempData["pisNo"] = StringToUnicode(officer.pisNo); db.officers.Add(objOfficer); db.SaveChanges(); int officerId = db.officers.OrderByDescending(m => m.officerId).ToList()[0].officerId; bool result = serializeOfficer(officer.serialNo, officerId, "Up"); if (result) { return(RedirectToAction("Index")); } } ViewBag.serialNo = officer.serialNo; ViewBag.officeId = new SelectList(db.offices, "officeId", "karyalaya", officer.officeId); return(View(officer)); }
public void RemoveOfficer(int num, int turnsAway) { //before calling this we must check if we have enough officers available for (int i = 0; i < num; i++) { //move officer from available list to unavailable list officer removed = m_officers[0]; m_officers.RemoveAt(0); removed.Use(turnsAway); m_officersInUse.Add(removed); } SetOfficerStatus(); }
// GET: /officer/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } officer officer = db.officers.Find(id); if (officer == null) { return(HttpNotFound()); } return(View(officer)); }
public ActionResult Delete(int id, FormCollection collection) { try { officer of = oc.officers.Find(id); or.Delete(of); //oc.officers.Remove(of); //oc.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult ApprovedOrRejected(int id) { if (ModelState.IsValid) { loan_officer_assign loa = new loan_officer_assign(); loa = db.loan_officer_assign.SingleOrDefault(p => p.application_id == id); //var Applicant = db.loan_application.Find(id); //string strDDLValue = Request.Form["ddldtatus"].ToString(); //Applicant.status = strDDLValue; //db.SaveChanges(); //loan_app_or_rej lp = new loan_app_or_rej(); //lp.date_of_approval = (DateTime)DateTime.Now; //lp.application_id = Applicant.application_id; //lp.amount_sanctioned = Applicant.loan_amount; //lp.status = strDDLValue; //lp.interest_rate = 7.50; //lp.reasons = "Wont tell you"; //db.loan_app_or_rej.Add(lp); //db.SaveChanges(); var Applicant = db.loan_application.Find(id); string strDDLValue = Request.Form["ddldtatus"].ToString(); Applicant.status = strDDLValue; db.SaveChanges(); loan_app_or_rej lp = new loan_app_or_rej(); lp.date_of_approval = (DateTime)DateTime.Now; lp.application_id = Applicant.application_id; lp.amount_sanctioned = Applicant.loan_amount; lp.status = strDDLValue; lp.interest_rate = 7.50; lp.reasons = "Wont tell you"; db.loan_app_or_rej.Add(lp); db.SaveChanges(); officer O1 = db.officers.Find(loa.officer_id); string EID = O1.email_id; string OfficerName = O1.name; string AppID = Applicant.application_id.ToString(); SendVerificationLinkEmailToOfficer(EID, OfficerName, AppID, lp.status); return(RedirectToAction("ApplicationList", "View_Loan_Applications")); } return(RedirectToAction("ApplicationList", "View_Loan_Applications")); // return View(); }
public ActionResult Create(FormCollection collection) { if (ModelState.IsValid) { officer o = new officer(); o.name = collection["name"]; //oc.officers.Add(o); //oc.SaveChanges(); // or.Add(o); _offser.CreateOfficer(o); return(RedirectToAction("Index")); } else { return(View(oc.officers.ToList())); } }
public ActionResult Edit(int id, FormCollection collection) { try { officer k = oc.officers.Find(id); UpdateModel(k); oc.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
// Use this for initialization void Awake() { for (int i = 0; i < officerIndicators.Length; i++) { officerIndicators[i].gameObject.SetActive(true); officerIndicators[i].UpdateText(); var rectTransform = officerIndicators[i].GetComponent <RectTransform>(); rectTransform.anchoredPosition3D = new Vector3(_offset, 0f, 0f); _offset += rectTransform.rect.width; } for (int i = 0; i < TotalOfficers; i++) { officer temp = new officer(); m_officers.Add(temp); } m_officersInUse = new List <officer>(); SetOfficerStatus(); }
public ActionResult updateOfficer(officer officer, HttpPostedFileBase postedFile) { if (postedFile != null) { string path = Server.MapPath("~/Uploads/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } postedFile.SaveAs(path + officer.citizinID.ToString() + ".jpg"); officer.imageURL = officer.citizinID.ToString() + ".jpg"; ViewBag.Message = "File uploaded successfully."; } db.Entry(officer).State = EntityState.Modified; db.SaveChanges(); return(Redirect("~/Admin/GetOfficersData")); }
//assign aroom randomly for a specific officer private void AssignARoom(officer officer) { var maxRoomID = (from item in db.officerRooms where item.isActive == true orderby item.officerRoomID descending select item.officerRoomID).FirstOrDefault(); var minRoomID = (from item in db.officerRooms where item.isActive == true orderby item.officerRoomID ascending select item.officerRoomID).FirstOrDefault(); Random rnd = new Random(); int selectedRoomID = rnd.Next(minRoomID, maxRoomID); var selectedRoom = (from item in db.officerRooms where item.officerRoomID == selectedRoomID select item).FirstOrDefault(); if (selectedRoom != null) { officerStayIn relation = new officerStayIn(); relation.officer = officer; relation.officerid = officer.officerID; relation.officerRoom = selectedRoom; relation.officerRoomid = selectedRoom.officerRoomID; relation.since = DateTime.Now; db.Entry(relation).State = EntityState.Added; db.SaveChanges(); selectedRoom.isActive = false; db.Entry(selectedRoom).State = EntityState.Modified; db.SaveChanges(); } }
// GET: /officer/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } officer officer = db.officers.Find(id); if (officer == null) { return(HttpNotFound()); } else { try { db.officers.Remove(officer); db.SaveChanges(); var ListOfficer = db.officers.ToList().OrderBy(o => o.serialNo); int i = 1; foreach (var item in ListOfficer) { item.serialNo = i; i++; } db.SaveChanges(); } catch { TempData["ErrorMessage"] = "Record not Deleted"; return(RedirectToAction("Index", "Officer")); } } TempData["Message"] = "Record Deleted Successfully"; return(RedirectToAction("Index", "Officer")); }
public void CreateOfficer(officer off) { _IRepository.Add(off); }
public ActionResult Edit([Bind(Include = "officerId,fullName,pisNo,email,jobType,officePhone,extenNo,mobileNo,status,officeId,darja,bankAccNo,sthaiLekhaNo,bima,bimaPariNo,bimaCode,bimaSheetRollNo,suruScale,gradeSankhya,mahangiBhatta,jokhimBhatta,gradeDar,bankShakha,jobType,naLaKos,kaSaKos,naLaKosNo,kaSaKosNo,saSuKar,paKar,serialNo,sapati")] officer officer) { if (ModelState.IsValid) { string serializeString = "Up"; var objOfficer = db.officers.Find(officer.officerId); if (objOfficer.serialNo > officer.serialNo) { serializeString = "Up"; } else if (objOfficer.serialNo < officer.serialNo) { serializeString = "Down"; } else if (objOfficer.serialNo == officer.serialNo) { serializeString = "Equal"; } int intstatus = Convert.ToInt32(officer.status); string getStatus = ((status)intstatus).ToString(); if (officer.serialNo <= 0) { officer.serialNo = 1; } else if (officer.serialNo > db.officers.ToList().Count) { officer.serialNo = db.officers.ToList().Count; } objOfficer.fullName = TrimText(officer.fullName); objOfficer.pisNo = TrimText(officer.pisNo); objOfficer.email = officer.email; objOfficer.officePhone = TrimText(officer.officePhone); objOfficer.officeId = officer.officeId; objOfficer.mobileNo = TrimText(officer.mobileNo); objOfficer.jokhimBhatta = officer.jokhimBhatta; objOfficer.mahangiBhatta = officer.mahangiBhatta; objOfficer.status = getStatus; objOfficer.jobType = officer.jobType; objOfficer.darja = TrimText(officer.darja); objOfficer.bankAccNo = TrimText(officer.bankAccNo); objOfficer.sthaiLekhaNo = TrimText(officer.sthaiLekhaNo); objOfficer.bima = officer.bima; objOfficer.bimaCode = TrimText(officer.bimaCode); objOfficer.bimaPariNo = TrimText(officer.bimaPariNo); objOfficer.bimaSheetRollNo = TrimText(officer.bimaSheetRollNo); objOfficer.suruScale = officer.suruScale; objOfficer.gradeSankhya = officer.gradeSankhya; objOfficer.gradeDar = officer.gradeDar; objOfficer.bankShakha = TrimText(officer.bankShakha); objOfficer.extenNo = TrimText(officer.extenNo); objOfficer.kaSaKos = officer.kaSaKos; objOfficer.naLaKos = officer.naLaKos; objOfficer.naLaKosNo = officer.naLaKosNo; objOfficer.kaSaKosNo = officer.kaSaKosNo; objOfficer.saSukar = officer.saSukar; objOfficer.paKar = officer.paKar; objOfficer.serialNo = officer.serialNo; objOfficer.sapati = officer.sapati; db.SaveChanges(); bool result = serializeOfficer(officer.serialNo, officer.officerId, serializeString); if (result) { return(RedirectToAction("Index")); } } ViewBag.serialNo = officer.serialNo; ViewBag.officeId = new SelectList(db.offices, "officeId", "mantralaye", officer.officeId); return(View(officer)); }