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