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