public ActionResult Add(int masterRecordID, ECallMasterRecordType masterRecordType) { //# validation if (masterRecordID < 0) throw new SystemException("Invalid Entity ID"); if (masterRecordType == ECallMasterRecordType.quotation) return this.Add_FromQuotation(masterRecordID); else if (masterRecordType == ECallMasterRecordType.maintenance) return this.Add_FromMaintenance(masterRecordID); else return this.Add_FromCustomer(masterRecordID); }
public ActionResult Edit(int id, ECallMasterRecordType masterRecordType) { ECallRecord model; //# validation if (id < 0) throw new SystemException("Invalid Entity ID"); //# get old record var records = from e in this._db.recsys_order join cd in this._db.recsys_relate_customers on e.customer_id equals cd.id into cds from cd in cds.DefaultIfEmpty() join c in this._db.recsys_customers on cd.customer_id equals c.id into cs from c in cs.DefaultIfEmpty() join u in this._db.recsys_users on e.update_user_id equals u.id into uss from u in uss.DefaultIfEmpty() join d1 in this._db.recsys_district on cd.district1 equals d1.id into d1s from d1 in d1s.DefaultIfEmpty() join d2 in this._db.recsys_district on cd.district2 equals d2.id into d2s from d2 in d2s.DefaultIfEmpty() join t1 in this._db.recsys_users on e.engineer_id_1 equals t1.id into t1s from t1 in t1s.DefaultIfEmpty() join t2 in this._db.recsys_users on e.engineer_id_2 equals t2.id into t2s from t2 in t2s.DefaultIfEmpty() join t3 in this._db.recsys_users on e.engineer_id_3 equals t3.id into t3s from t3 in t3s.DefaultIfEmpty() join t4 in this._db.recsys_users on e.engineer_id_4 equals t4.id into t4s from t4 in t4s.DefaultIfEmpty() join cu in this._db.recsys_users on e.call_pickup_user_id equals cu.id into cus from cu in cus.DefaultIfEmpty() where e.id == id select new { ECall = e, CustomerData = cd, masterCustomer = c, UpdateUserName = u.name, WorkingDistrictName = d2.name, MailingDistrictName = d1.name, Technician1Name = t1.name, Technician2Name = t2.name, Technician3Name = t3.name, Technician4Name = t4.name, CallPickerName = cu.name }; var record = records.FirstOrDefault(); //# validation if (record == null) throw new RecordNotFoundException(); model = new ECallRecord() { //# field mapping CompleteDate = record.ECall.completion_date.HasValue ? record.ECall.completion_date.Value.ToString("dd-MM-yyyy") : string.Empty, EndTimeHour = record.ECall.end_time.HasValue ? Convert.ToString(record.ECall.end_time.Value.Hours) : string.Empty, EndTimeMinute = record.ECall.end_time.HasValue ? Convert.ToString(record.ECall.end_time.Value.Minutes) : string.Empty, ActualStartTimeHour = record.ECall.actual_start_time.HasValue ? Convert.ToString(record.ECall.actual_start_time.Value.Hours) : string.Empty,///Peter ActualStartTimeMinute = record.ECall.actual_start_time.HasValue ? Convert.ToString(record.ECall.actual_start_time.Value.Minutes) : string.Empty, ActualEndTimeHour = record.ECall.actual_end_time.HasValue ? Convert.ToString(record.ECall.actual_end_time.Value.Hours) : string.Empty,///Peter ActualEndTimeMinute = record.ECall.actual_end_time.HasValue ? Convert.ToString(record.ECall.actual_end_time.Value.Minutes) : string.Empty, engineer_id_1 = record.ECall.engineer_id_1, engineer_id_2 = record.ECall.engineer_id_2, engineer_id_3 = record.ECall.engineer_id_3, engineer_id_4 = record.ECall.engineer_id_4, fault = record.ECall.fault, model = record.ECall.model, repair = record.ECall.repair, repair_date = record.ECall.repair_date.HasValue ? record.ECall.repair_date.Value.ToString("dd-MM-yyyy") : string.Empty, report = record.ECall.report, reviewer = record.ECall.reviewer, StartTimeHour = record.ECall.start_time.HasValue ? Convert.ToString(record.ECall.start_time.Value.Hours) : string.Empty, StartTimeMinute = record.ECall.start_time.HasValue ? Convert.ToString(record.ECall.start_time.Value.Minutes) : string.Empty, tc = record.ECall.tc.ToString() == "1", address1 = record.CustomerData.address1, address2 = record.CustomerData.address2, call_pickup_user_id = record.ECall.call_pickup_user_id, CallPickerName = record.CallPickerName, center = record.CustomerData.center, code = record.CustomerData.code, contact = record.CustomerData.contact, customer_code = record.CustomerData.customer_code, district1 = record.CustomerData.district1, district2 = record.CustomerData.district2, email = record.CustomerData.email, fax1 = record.CustomerData.fax1, fax2 = record.CustomerData.fax2, group_id = record.CustomerData.group_id, id = record.ECall.id, last_update = record.ECall.last_update, last_update_user_name = record.UpdateUserName, MailingDistrictName = record.MailingDistrictName, name = record.CustomerData.name, chi_name = record.CustomerData.chi_name, prefix = record.CustomerData.prefix, remark = record.CustomerData.remark, remark2 = record.ECall.remark, status = record.ECall.status, tel1 = record.CustomerData.tel1, tel2 = record.CustomerData.tel2, title = record.CustomerData.title.HasValue ? record.CustomerData.title.Value : 0, type = record.CustomerData.type.HasValue ? record.CustomerData.type.Value : 0, WorkingDistrictName = record.WorkingDistrictName, create_date = record.ECall.create_date, Technician1Name = record.Technician1Name, Technician2Name = record.Technician2Name, Technician3Name = record.Technician3Name, Technician4Name = record.Technician4Name, //customer_reference_number = record.CustomerData.reference_number, //customer_reference_number = record.CustomerData.reference_number, //get the newset number customer_reference_number = record.masterCustomer.reference_number, JobNumber = record.ECall.job_number, order_status = (int)record.ECall.order_status, //# settings SaveResult = null, Mode = PageMode.Edit, FetchRecordTime = DateTime.Now, MasterRecordType = masterRecordType, //# masters Districts = this._db.recsys_district .Where(theDistrict => theDistrict.status == 1) .OrderBy(theDistrict => theDistrict.name), Groups = this._db.recsys_group .Where(theGroup => theGroup.status == 1) .OrderBy(theGroup => theGroup.name), Titles = this._title, Statuses = this._status, Reviewers = this._db.recsys_users .Where(theUser => theUser.status == 1) .OrderBy(theUser => theUser.name) .Select(theUser => new Reviewer() { ID = theUser.id, Name = theUser.name }), OrderStatuses = this._orderStatuses }; return PartialView("AddEdit", model); }
public ActionResult DetailsEdit(int id, ECallMasterRecordType masterRecordType, string appFrameSelector = "", //# for used in Order-> index page to pass app frame Selector of the iframe string menuButtonSelector = "" //# for used in Order-> index page to pass menu buttonSelector of the iframe ) { ECallDetailsViewModel model; //# validation if (id < 0) throw new SystemException("Invalid Entity ID"); model = new ECallDetailsViewModel() { id = id, Mode = PageMode.Edit, MasterRecordType = masterRecordType, CustomAppFrameSelector = appFrameSelector, CustomMenuButtonSelector = menuButtonSelector }; return View("Details", model); }