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