public ActionResult create() { try { var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Personnel).Structure_Code; var req = dbcontext.business_trip_request.ToList(); string number; if (req.Count > 0) { number = stru + (req.LastOrDefault().ID + 1).ToString(); } else { number = stru + 1; } ViewBag.emp = dbcontext.Employee_Profile.Where(m => m.Active == true).ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.busi = dbcontext.Business_Trip.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.trans = dbcontext.TransportationMethod.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); var model = new business_trip_request(); model.request_date = DateTime.Now.Date; model.go_date = DateTime.Now.Date; model.return_date = DateTime.Now.Date; model.number = number; return(View(model)); } catch (Exception) { return(RedirectToAction("index")); } }
public ActionResult edit(business_trip_request model, FormCollection record1) { try { ViewBag.emp = dbcontext.Employee_Profile.Where(m => m.Active == true).ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.busi = dbcontext.Business_Trip.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.trans = dbcontext.TransportationMethod.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); var recod = dbcontext.business_trip_request.FirstOrDefault(m => m.ID == model.ID); recod.Employee_ProfileID = model.Employee_ProfileID; recod.request_date = model.request_date; recod.location_of_duty = model.location_of_duty; recod.purpose_of_duty = model.purpose_of_duty; recod.Remarks_of_duty = model.Remarks_of_duty; recod.go_date = model.go_date; recod.return_date = model.return_date; recod.months = model.months; recod.years = model.years; recod.carry_important_documents = model.carry_important_documents; recod.days = model.days; var s = record1["go_time"].Split(','); var e = record1["return_time"].Split(','); recod.Total_rate = double.Parse(record1["rate"].Split(',')[0]); recod.go_time = Convert.ToDateTime(s[0]).TimeOfDay; recod.return_time = Convert.ToDateTime(e[0]).TimeOfDay; recod.Business_TripID = model.Business_TripID; recod.TransportationMethodID = model.TransportationMethodID; if (model.tionMethodID_return == 0) { var trsn = dbcontext.TransportationMethod.FirstOrDefault(m => m.ID == model.tionMethodID_return); if (trsn == null) { return(View(model)); } else { recod.tionMethodID_return = model.tionMethodID_return; } } dbcontext.SaveChanges(); return(RedirectToAction("index")); } catch (Exception) { return(View(model)); } }
public ActionResult create(business_trip_request model, FormCollection record) { try { ViewBag.emp = dbcontext.Employee_Profile.Where(m => m.Active == true).ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.busi = dbcontext.Business_Trip.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.trans = dbcontext.TransportationMethod.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); var s = record["go_time"].Split(','); var e = record["return_time"].Split(','); model.go_time = Convert.ToDateTime(s[0]).TimeOfDay; model.return_time = Convert.ToDateTime(e[0]).TimeOfDay; model.Total_rate = double.Parse(record["rate"].Split(',')[0]); if (model.tionMethodID_return == 0) { var trsn = dbcontext.TransportationMethod.FirstOrDefault(m => m.ID == model.tionMethodID_return); if (trsn == null) { return(View(model)); } } var Date = Convert.ToDateTime("1/1/1900"); var state = new status { statu = check_status.created, approved_bydate = Date, cancaled_bydate = Date, created_bydate = DateTime.Now.Date, Rejected_bydate = Date, return_to_reviewdate = Date }; state.created_by = User.Identity.GetUserName(); var st = dbcontext.status.Add(state); dbcontext.SaveChanges(); model.statusID = st.ID; model.check_status = check_status.created; dbcontext.business_trip_request.Add(model); dbcontext.SaveChanges(); return(RedirectToAction("index")); } catch (Exception e) { return(View(model)); } }