public ActionResult Book_App_Customer(AppointmentModel Model) { Boolean New = (Request.Form).AllKeys[(Request.Form).AllKeys.GetUpperBound(0)].Trim() == "savenew" ? true : false; try { if (Model.CUSTOMER_SEQ_ID > 0) { CustomerModel subModel = new CustomerModel(); subModel.SEQ_ID = Model.CUSTOMER_SEQ_ID; subModel = new Brill.Helper().SelectModelFromDatabase(subModel); Model.FIRST_NAME = subModel.FIRST_NAME; Model.LAST_NAME = subModel.LAST_NAME; Model.MOBILE_NO = subModel.MOBILE_NO; Model.PAYMENT_MODE_SEQ_ID = subModel.PAYMENT_MODE_SEQ_ID; Model.CUSTOMER_TYPE_SEQ_ID = subModel.CUSTOMER_TYPE_SEQ_ID; } else { CustomerModel subModel = new CustomerModel(); subModel.FIRST_NAME = Model.FIRST_NAME; subModel.LAST_NAME = Model.LAST_NAME; subModel.MOBILE_NO = Model.MOBILE_NO; subModel.PAYMENT_MODE_SEQ_ID = Model.PAYMENT_MODE_SEQ_ID; subModel.CUSTOMER_TYPE_SEQ_ID = Model.CUSTOMER_TYPE_SEQ_ID; subModel.CREATED_BY = Convert.ToInt32(Session["USERID"]); subModel.CREATED_ON = DateTime.Now; Model.CUSTOMER_SEQ_ID = new Brill.Helper().InsertModelInDatabase(subModel); } if (Model.SEQ_ID > 0) { Model.MODIFIED_BY = Convert.ToInt32(Session["USERID"]); Model.MODIFIED_ON = DateTime.Now; new Brill.Helper().UpdateModelInDatabase(Model); } else { Model.CREATED_BY = Convert.ToInt32(Session["USERID"]); Model.CREATED_ON = DateTime.Now; Model.SEQ_ID = new Brill.Helper().InsertModelInDatabase(Model); } if (New) { return(RedirectToAction("Book_App_Location", "Appointment", new { ID = Model.SEQ_ID })); } else { return(RedirectToAction("Dashboard", "Admin")); } } catch (Exception ex) { Helper(); ViewBag.Message = ex.InnerException; return(View(Model)); } }
public static int GetValue(string LookUpName) { LookupModel Model = new LookupModel(); Model.ATTR_NAME = LookUpName; Model = new Brill.Helper().SelectModelFromDatabase(Model); return(Model.SEQ_ID); }
public ActionResult Index() { CustomerModel Model = new CustomerModel(); List <CustomerModel> ModelList = new Brill.Helper().SelectModelListFromDatabase(Model); Helper(); return(View(ModelList)); }
public static List <DropDownModel> GetDropDownValues(int LOOKUP_ID) { DropDownModel Model = new DropDownModel(); Model.LOOKUP_SEQ_ID = LOOKUP_ID; List <DropDownModel> ModelList = new Brill.Helper().SelectModelListFromDatabase(Model); return(ModelList); }
public ActionResult Index() { DriverModel Model = new DriverModel(); Model.ACTIVE = true; List <DriverModel> ModelList = new Brill.Helper().SelectModelListFromDatabase(Model); Helper(); return(View(ModelList)); }
public ActionResult COMPLETED(string ID) { AppointmentModel Model = new AppointmentModel(); Model.SEQ_ID = Convert.ToInt32(ID); Model = new Brill.Helper().SelectModelFromDatabase(Model); Model.STATUS_SEQ_ID = 21; new Brill.Helper().UpdateModelInDatabase(Model); return(Redirect(Request.UrlReferrer.AbsoluteUri.ToString())); }
public ActionResult WebPage(string ID = null) { DriverModel Model = new DriverModel(); if (!string.IsNullOrEmpty(ID)) { Model.SEQ_ID = Convert.ToInt32(ID); Model = new Brill.Helper().SelectModelFromDatabase(Model); } Helper(); return(View(Model)); }
public ActionResult Book_App_Customer(string ID = null) { AppointmentModel Model = new AppointmentModel(); if (!string.IsNullOrEmpty(ID)) { Model.SEQ_ID = Convert.ToInt32(ID); Model = new Brill.Helper().SelectModelFromDatabase(Model); } Helper(); return(View(Model)); }
void GetCustomers() { Dictionary <string, string> List = new Dictionary <string, string>(); CustomerModel Model = new CustomerModel(); List <CustomerModel> ModelList = new Brill.Helper().SelectModelListFromDatabase(Model); foreach (CustomerModel m in ModelList) { List.Add(m.SEQ_ID.ToString(), m.CODE + " | " + m.FIRST_NAME + " " + m.LAST_NAME); } ViewData["CustomerList"] = new SelectList(List, "Key", "Value"); }
void GetCars() { Dictionary <string, string> List = new Dictionary <string, string>(); VehicleModel Model = new VehicleModel(); Model.ACTIVE = true; List <VehicleModel> ModelList = new Brill.Helper().SelectModelListFromDatabase(Model); foreach (VehicleModel m in ModelList) { List.Add(m.SEQ_ID.ToString(), m.DESCRIPTION); } ViewData["CarList"] = new SelectList(List, "Key", "Value"); }
void GetDrivers() { Dictionary <string, string> List = new Dictionary <string, string>(); DriverModel Model = new DriverModel(); Model.ACTIVE = true; List <DriverModel> ModelList = new Brill.Helper().SelectModelListFromDatabase(Model); foreach (DriverModel m in ModelList) { List.Add(m.SEQ_ID.ToString(), m.FIRST_NAME + " " + m.LAST_NAME); } ViewData["DriverList"] = new SelectList(List, "Key", "Value"); }
public JsonResult FetchCustomerData(string sID = null, string sMobile = null, string sFirstName = null, string sLastName = null) { CustomerModel Model = new CustomerModel(); if (!string.IsNullOrEmpty(sID)) { Model.SEQ_ID = Convert.ToInt32(sID); Model = new Brill.Helper().SelectModelFromDatabase(Model); } else if (!string.IsNullOrEmpty(sMobile)) { Model.MOBILE_NO = sMobile.Trim(); Model = new Brill.Helper().SelectModelFromDatabase(Model); } else if (!string.IsNullOrEmpty(sFirstName) && !string.IsNullOrEmpty(sLastName)) { Model.FIRST_NAME = sFirstName.Trim(); Model.LAST_NAME = sLastName.Trim(); Model = new Brill.Helper().SelectModelFromDatabase(Model); } else if (!string.IsNullOrEmpty(sFirstName)) { Model.FIRST_NAME = sFirstName.Trim(); Model = new Brill.Helper().SelectModelFromDatabase(Model); } else if (!string.IsNullOrEmpty(sLastName)) { Model.LAST_NAME = sLastName.Trim(); Model = new Brill.Helper().SelectModelFromDatabase(Model); } else { return(Json(null, JsonRequestBehavior.AllowGet)); } //Session["FIRST_NAME"] = Model.FIRST_NAME; //Session["LAST_NAME"] = Model.LAST_NAME; //Session["MOBILE_NO"] = Model.MOBILE_NO; //Session["CUSTOMER_TYPE_SEQ_ID"] = Model.CUSTOMER_TYPE_SEQ_ID; //Session["PAYMENT_MODE_SEQ_ID"] = Model.PAYMENT_MODE_SEQ_ID; return(Json(Model, JsonRequestBehavior.AllowGet)); }
public ActionResult Book_App_Fare(string ID) { AppointmentModel Model = new AppointmentModel(); if (!string.IsNullOrEmpty(ID)) { Model.SEQ_ID = Convert.ToInt32(ID); Model = new Brill.Helper().SelectModelFromDatabase(Model); VehicleModel VehicleModel = new VehicleModel(); VehicleModel.SEQ_ID = Model.CAR_SEQ_ID; VehicleModel = new Brill.Helper().SelectModelFromDatabase(VehicleModel); Model.FARE = CalculateFare(Model.DISTANCE, VehicleModel.BASICFARE, VehicleModel.ADDITIONALKMFARE); Model.OTHER_CHARGES = string.IsNullOrEmpty(Model.OTHER_CHARGES) ? "0.0" : Model.OTHER_CHARGES; Model.TOTAL_AMOUNT = Convert.ToString(Convert.ToDouble(Model.FARE) + Convert.ToDouble(Model.OTHER_CHARGES)); } Helper(); return(View(Model)); }
public ActionResult Dashboard(string Filter = null, int D = 0) { AppointmentModel Model = new AppointmentModel(); List <AppointmentModel> ModelList = new List <AppointmentModel>(); if (Filter == null) { ModelList.AddRange(new Brill.Helper().SelectModelListFromDatabase(Model)); Model.LUGGAGE = true; Model.WAIT_AND_RETURN = true; ModelList.AddRange(new Brill.Helper().SelectModelListFromDatabase(Model)); ModelList = ModelList.OrderByDescending(s => s.DATE).ToList(); Helper(); return(View(ModelList)); } else if (Filter == "Unassigned") { ModelList = new Brill.Helper().SelectModelListFromDatabase(Model); if (D == 1) { ModelList = ModelList.Where(s => s.DRIVER_SEQ_ID == 0 && s.DATE == DateTime.Now.Date).ToList(); } else { ModelList = ModelList.Where(s => s.DRIVER_SEQ_ID == 0).ToList(); } Helper(); return(View(ModelList)); } switch (Filter) { case "TodaysAppointments": Model.DATE = DateTime.Now.Date; break; case "ReadyforDispatch": Model.STATUS_SEQ_ID = 23; if (D == 1) { Model.DATE = DateTime.Now.Date; } break; case "Dispatched": Model.STATUS_SEQ_ID = 22; if (D == 1) { Model.DATE = DateTime.Now.Date; } break; case "Completed": Model.STATUS_SEQ_ID = 21; if (D == 1) { Model.DATE = DateTime.Now.Date; } break; case "Cancelled": Model.STATUS_SEQ_ID = 20; if (D == 1) { Model.DATE = DateTime.Now.Date; } break; default: break; } ModelList = new Brill.Helper().SelectModelListFromDatabase(Model); Helper(); return(View(ModelList)); }