public ActionResult Create([Bind(Include = "Mode_ID,Mode_Type,Mode_Name,Mode_Short_Name")] HRMS_TravelMode_MS hRMS_TravelMode_MS)
{
if (ModelState.IsValid)
{
bool isValid = db.HRMS_TravelMode_MS.Any(x => (x.Mode_Name == hRMS_TravelMode_MS.Mode_Name || x.Mode_Short_Name == hRMS_TravelMode_MS.Mode_Short_Name));
if (!isValid)
{
db.HRMS_TravelMode_MS.Add(hRMS_TravelMode_MS);
db.SaveChanges();
ViewBag.success = "Travel Mode is Successfully Added!";
ModelState.Clear();
return(View());
}
else
{
if (db.HRMS_TravelMode_MS.Any(x => x.Mode_Name == hRMS_TravelMode_MS.Mode_Name))
{
ViewBag.error = "Sorry! Mode Name is already exist!";
return(View(hRMS_TravelMode_MS));
}
else
{
ViewBag.error = "Sorry! Mode Short Name is already exist!";
return(View(hRMS_TravelMode_MS));
}
}
}
return(View(hRMS_TravelMode_MS));
}
public ActionResult Edit([Bind(Include = "Mode_ID,Mode_Type,Mode_Name,Mode_Short_Name")] HRMS_TravelMode_MS hRMS_TravelMode_MS)
{
if (ModelState.IsValid)
{
bool isValid = db.HRMS_TravelMode_MS.Any(x => (x.Mode_ID != hRMS_TravelMode_MS.Mode_ID) && ((x.Mode_Name == hRMS_TravelMode_MS.Mode_Name || x.Mode_Short_Name == hRMS_TravelMode_MS.Mode_Short_Name)));
if (!isValid)
{
db.Entry(hRMS_TravelMode_MS).State = EntityState.Modified;
db.SaveChanges();
ViewBag.success = "Your Record Successfully Updated!";
return(View());
}
else
{
if (db.HRMS_TravelMode_MS.Any(x => (x.Mode_ID != hRMS_TravelMode_MS.Mode_ID) && ((x.Mode_Name == hRMS_TravelMode_MS.Mode_Name))))
{
ViewBag.error = "Model Name is Already exist!";
return(View());
}
else
{
ViewBag.error = "Model Short Name is Already exist!";
return(View());
}
}
}
return(View(hRMS_TravelMode_MS));
}
// 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));
}
// GET: TravelModeMaster/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_TravelMode_MS hRMS_TravelMode_MS = db.HRMS_TravelMode_MS.Find(id);
if (hRMS_TravelMode_MS == null)
{
return(HttpNotFound());
}
return(View(hRMS_TravelMode_MS));
}
public bool delete(long id)
{
HRMS_TravelMode_MS hRMS_TravelMode_MS = db.HRMS_TravelMode_MS.Find(id);
if (hRMS_TravelMode_MS != null)
{
db.HRMS_TravelMode_MS.Remove(hRMS_TravelMode_MS);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
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));
}
