public ActionResult Edit([Bind(Include = "ID,Short_Name,Name,Description")] HRMS_Travel_type hRMS_Travel_type) { if (ModelState.IsValid) { HRMS_Travel_type short_typealready = db.HRMS_Travel_type.Where(rec => rec.Short_Name == hRMS_Travel_type.Short_Name && rec.ID != hRMS_Travel_type.ID).FirstOrDefault(); if (short_typealready == null) { HRMS_Travel_type type_name_already = db.HRMS_Travel_type.Where(rec => rec.Name == hRMS_Travel_type.Name && rec.ID != hRMS_Travel_type.ID).FirstOrDefault(); if (type_name_already == null) { db.Entry(hRMS_Travel_type).State = EntityState.Modified; db.SaveChanges(); ModelState.Clear(); return(RedirectToAction("Index")); } else { ViewBag.TypeStatus = "The name is already exist in another travel type!"; return(View()); } } else { ViewBag.TypeStatus = "The short name is already exist in another travel type!"; return(View()); } } return(View(hRMS_Travel_type)); }
public ActionResult Create([Bind(Include = "ID,Short_Name,Name,Description")] HRMS_Travel_type hRMS_Travel_type) { if (ModelState.IsValid) { HRMS_Travel_type short_typealready = db.HRMS_Travel_type.Where(rec => rec.Short_Name == hRMS_Travel_type.Short_Name).FirstOrDefault(); if (short_typealready == null) { HRMS_Travel_type type_name_already = db.HRMS_Travel_type.Where(rec => rec.Name == hRMS_Travel_type.Name).FirstOrDefault(); if (type_name_already == null) { db.HRMS_Travel_type.Add(hRMS_Travel_type); db.SaveChanges(); ModelState.Clear(); ViewBag.TypeStatus = "New Travel Type is added successfully."; return(View()); } else { ViewBag.TypeStatus = "The name is already exist in another travel type!"; return(View()); } } else { ViewBag.TypeStatus = "The short name is already exist in another travel type!"; return(View()); } } return(View(hRMS_Travel_type)); }
// GET: TravelApplication/Create public ActionResult Create() { var user = Convert.ToInt64(Session["id"]); HRMS_Travel_Application hRMS_Travel_Application = new HRMS_Travel_Application(); hRMS_Travel_Application.emp_id = user; //HRMS_TravelMode_MS hRMS_TravelMode_MS = db.HRMS_TravelMode_MS.Where(rec => rec.Mode_Type == "Local Coveyance").FirstOrDefault(); //HRMS_Travel_type hRMS_Travel_Type = db.HRMS_Travel_type.Where(rec => rec.Name == "Domestic").FirstOrDefault(); //hRMS_Travel_Application.Travel_Type = hRMS_Travel_Type.ID; //hRMS_Travel_Application.Travel_App_Type = hRMS_TravelMode_MS.Mode_ID; //ViewBag.emp_id = new SelectList(db.Accounts, "ID", "UserName"); //hRMS_Travel_Application.Grade = db.EMP_Grade_Assignment.Where(rec => rec.EMP_ID == user).Select(rec => rec.Grade_ID); //ViewBag.Approved_by = new SelectList(db.Accounts, "ID", "UserName"); // ViewBag.Grade = new SelectList(db.HRMS_CATEGORY_GRADE, "Category_ID", "Category_Name"); //ViewBag.Designation = new SelectList(db.HRMS_DESG_MS, "Desg_Id", "Desg_Name"); // ViewBag.Travel_Purpose = db.HRMS_Travel_Purpose; //ViewBag.Travel_Type = db.HRMS_Travel_type; //ViewBag.Travel_App_Type = db.HRMS_TravelMode_MS; ViewBag.dataTravelPurpose = new SelectList(db.HRMS_Travel_Purpose, "ID", "Name"); HRMS_TravelMode_MS hRMS_TravelMode_MS = db.HRMS_TravelMode_MS.Where(rec => rec.Mode_Type == "Local Coveyance").FirstOrDefault(); HRMS_Travel_type hRMS_Travel_Type = db.HRMS_Travel_type.Where(rec => rec.Name == "Domestic").FirstOrDefault(); //hRMS_Travel_Application.Travel_Type = hRMS_Travel_Type.ID; //hRMS_Travel_Application.Travel_App_Type = hRMS_TravelMode_MS.Mode_ID; ////hRMS_Travel_Application.Travel_Type = hRMS_Travel_Type.ID; ViewBag.dataTravelType = new SelectList(db.HRMS_Travel_type, "ID", "Short_Name", hRMS_Travel_Type.ID); ViewBag.EntidadList = new SelectList(db.HRMS_TravelMode_MS, "Mode_ID", "Mode_Type", hRMS_TravelMode_MS.Mode_ID); return(View(hRMS_Travel_Application)); }
public bool Delete(long id) { HRMS_Travel_type hRMS_Travel_type = db.HRMS_Travel_type.Find(id); db.HRMS_Travel_type.Remove(hRMS_Travel_type); db.SaveChanges(); ModelState.Clear(); return(true); }
// GET: TravelType/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HRMS_Travel_type hRMS_Travel_type = db.HRMS_Travel_type.Find(id); if (hRMS_Travel_type == null) { return(HttpNotFound()); } return(View(hRMS_Travel_type)); }
public ActionResult Create(HRMS_Travel_Application hRMS_Travel_Application) { HRMS_TravelMode_MS hRMS_TravelMode_MS = db.HRMS_TravelMode_MS.Where(rec => rec.Mode_Type == "Local Coveyance").FirstOrDefault(); HRMS_Travel_type hRMS_Travel_Type = db.HRMS_Travel_type.Where(rec => rec.Name == "Domestic").FirstOrDefault(); ModelState.Remove("Travel_Type"); hRMS_Travel_Application.Travel_Type = hRMS_Travel_Type.ID; ModelState.Remove("Travel_App_Type"); hRMS_Travel_Application.Travel_App_Type = hRMS_TravelMode_MS.Mode_ID; ModelState.Remove("Travel_Application_Date"); hRMS_Travel_Application.Travel_Application_Date = DateTime.Now; ModelState.Remove("Designation"); var designation = db.HRMS_Emp_Details.Where(rec => rec.EMP_ID == hRMS_Travel_Application.emp_id).SingleOrDefault(); hRMS_Travel_Application.Designation = designation.Designation; ModelState.Remove("Grade"); var grade = db.HRMS_EMP_GRA_POL.Where(r => r.Emp_ID == hRMS_Travel_Application.emp_id).SingleOrDefault(); hRMS_Travel_Application.Grade = grade.Gra_ID; hRMS_Travel_Application.Status = 0; if (ModelState.IsValid) { var fromdate = Convert.ToDateTime(hRMS_Travel_Application.From_Date); var todate = Convert.ToDateTime(hRMS_Travel_Application.To_Date); int result = DateTime.Compare(fromdate, todate); if (result < 0) { var samedate = db.HRMS_Travel_Application.Where(rec => rec.emp_id == hRMS_Travel_Application.emp_id && rec.From_Date == hRMS_Travel_Application.From_Date && rec.To_Date == hRMS_Travel_Application.To_Date).FirstOrDefault(); if (samedate == null) { db.HRMS_Travel_Application.Add(hRMS_Travel_Application); db.SaveChanges(); ModelState.Clear(); ViewBag.ApplicationStatus = "Application generated successfully."; ViewBag.dataTravelPurpose = new SelectList(db.HRMS_Travel_Purpose, "ID", "Name"); ViewBag.dataTravelType = new SelectList(db.HRMS_Travel_type, "ID", "Short_Name", hRMS_Travel_Type.ID); ViewBag.EntidadList = new SelectList(db.HRMS_TravelMode_MS, "Mode_ID", "Mode_Type", hRMS_TravelMode_MS.Mode_ID); return(RedirectToAction("Index")); } else { ViewBag.ApplicationStatus = "You have a trip with same From date and To date"; ViewBag.dataTravelPurpose = new SelectList(db.HRMS_Travel_Purpose, "ID", "Name"); ViewBag.dataTravelType = new SelectList(db.HRMS_Travel_type, "ID", "Short_Name"); ViewBag.EntidadList = new SelectList(db.HRMS_TravelMode_MS, "Mode_ID", "Mode_Type"); return(View(hRMS_Travel_Application)); } } else if (result > 0) { ViewBag.ApplicationStatus = "from date is greater then two date!!!"; ViewBag.dataTravelPurpose = new SelectList(db.HRMS_Travel_Purpose, "ID", "Name"); ViewBag.dataTravelType = new SelectList(db.HRMS_Travel_type, "ID", "Short_Name"); ViewBag.EntidadList = new SelectList(db.HRMS_TravelMode_MS, "Mode_ID", "Mode_Type"); return(View(hRMS_Travel_Application)); } } ViewBag.ApplicationStatus = "model is in invalid state."; ViewBag.dataTravelPurpose = new SelectList(db.HRMS_Travel_Purpose, "ID", "Name"); ViewBag.dataTravelType = new SelectList(db.HRMS_Travel_type, "ID", "Short_Name"); ViewBag.EntidadList = new SelectList(db.HRMS_TravelMode_MS, "Mode_ID", "Mode_Type"); return(View(hRMS_Travel_Application)); }