public override string IsValidated() { var b = true; string validationResult = ""; //Installation Address var msc = new MySalesJobMasterListCustomer(BaseValue.JobID); msc.SetInstallTo(); if (msc.CustomerID == 0) { validationResult += "No Installation Company Selected " + System.Environment.NewLine; b = false; } else { var mc = new MyCustomer(msc.CustomerID); if (MyConvert.ConvertToString(mc.Value.ADDR_1).Length < 5) { validationResult += "No Installation Address " + System.Environment.NewLine; b = false; } } //Document Attached var requiredDocuemntTypes = new int[] { 200 }; for (int i = 0; i < requiredDocuemntTypes.Length; i++) { var docTypeID = requiredDocuemntTypes[i]; var docAttached = _db.PermitDocuments.Where(x => x.BaseAppID == BaseValue.BaseAppID & x.DocType == docTypeID).ToList(); if (!docAttached.Any()) { var docType = _db.PermitDocumentTypes.Find(docTypeID); validationResult += "Document Required: " + docType.TypeName + System.Environment.NewLine; b = false; } } //Leadtime if (BaseValue.Deadline <= DateTime.Today) { validationResult += "Lead time is 5 business days " + System.Environment.NewLine; b = false; } else { var endDate = Convert.ToDateTime(BaseValue.Deadline); if (MyDateTime.GetDiffHoursOfWeekday(DateTime.Today, endDate) < 24 * NLeadTime) { validationResult += "Lead time is 5 business days " + System.Environment.NewLine; b = false; } } return(b ? "ok" : validationResult); }
public virtual void CreateBaseApplication() { var ab = new PermitBase() { JobID = _jobID, RequirementID = _requirementID, RequestNumber = RequestNumber, RequestBy = _printingEmployeeID, RequestDate = DateTime.Now, StatusID = (int)NPermitStatus.New, Deadline = DateTime.Now, Version = 1, }; var mp = new MyProjectDetail(_jobID); ab.JobTitle = mp.JobTitle; ab.JobNumber = mp.JobNumber; ab.Description = mp.Description; var msc = new MySalesJobMasterListCustomer(_jobID); msc.SetInstallTo(); ab.InstallToCustomerID = msc.CustomerID; Db.PermitBases.Add(ab); Db.SaveChanges(); NewlyInsertedBaseAppID = ab.BaseAppID; }
private void SetInstallToCustomerID() { var mjc = new MySalesJobMasterListCustomer(_projectID); // Install To mjc.SetInstallTo(); InstallToCustomerID = mjc.CustomerID; }
public void ImportAddressFromCustomer() { //Subcontract-->Project-->IsInstallTo->Contact and Customer var subcontract = new MySubContract(Value.SubContractID); var msc = new MySalesJobMasterListCustomer(subcontract.Value.JobID); msc.SetInstallTo(); if (msc.CustomerID < 1000) { Result = "Request Failed, No Install to Customer Selected."; } else { var myCustomer = new MyCustomer(msc.CustomerID); var myContact = new MyCustomerContact(msc.ContactID); string addr = myCustomer.Value.ADDR_1; if (!Convert.IsDBNull(myCustomer.Value.ADDR_2)) { addr = addr + " " + myCustomer.Value.ADDR_2; } Value.Address = addr; Value.City = myCustomer.Value.CITY; Value.Postcode = myCustomer.Value.ZIPCODE; Value.Province = myCustomer.Value.STATE; Value.ShipToName = myCustomer.Value.NAME; string attenName = MyConvert.ConvertToString(myContact.Value.CONTACT_HONORIFIC) + " "; attenName += MyConvert.ConvertToString(myContact.Value.CONTACT_FIRST_NAME) + " "; attenName += MyConvert.ConvertToString(myContact.Value.CONTACT_LAST_NAME); Value.AttnName = attenName.Trim(); Value.AttnPhone = MyConvert.ConvertToString(myContact.Value.CONTACT_PHONE); _db.Entry(Value).State = EntityState.Modified; _db.SaveChanges(); Result = "ok"; } }
public override string IsValidated() { var b = true; string validationResult = ""; var isCityOfToronto = false; //Leadtime if (BaseValue.Deadline <= DateTime.Today) { validationResult += "Lead time is 5 business days " + System.Environment.NewLine; b = false; } else { var endDate = Convert.ToDateTime(BaseValue.Deadline); if (MyDateTime.GetDiffHoursOfWeekday(DateTime.Today, endDate) < 24 * NLeadTime) { validationResult += "Lead time is 5 business days " + System.Environment.NewLine; b = false; } } if (MyConvert.ConvertToString(Value.OccupationTimeStart).Length < 3) { validationResult += "Occupation Start Time Required" + System.Environment.NewLine; b = false; } if (MyConvert.ConvertToString(Value.OccupationTimeEnd).Length < 3) { validationResult += "Occupation End Time Required" + System.Environment.NewLine; b = false; } // if (Value.TypeOfTruck == 0) { validationResult += "Please Fill out Type of Truck " + System.Environment.NewLine; b = false; } //Installation Address var msc = new MySalesJobMasterListCustomer(BaseValue.JobID); msc.SetInstallTo(); if (msc.CustomerID == 0) { validationResult += "No Installation Company Selected " + System.Environment.NewLine; b = false; } else { var mc = new MyCustomer(msc.CustomerID); var customer = mc.Value; if (MyConvert.ConvertToString(customer.ADDR_1).Length < 5) { validationResult += "No Installation Address " + System.Environment.NewLine; b = false; } if (MyConvert.ConvertToString(customer.CITY).Length < 3) { validationResult += "Landlord City Required " + System.Environment.NewLine; b = false; } else { isCityOfToronto = GetIsCityOfToronto(customer.CITY); } if (MyConvert.ConvertToString(customer.ZIPCODE).Length < 4) { validationResult += "Landlord Postcode Required " + System.Environment.NewLine; b = false; } } if (MyConvert.ConvertToString(Value.ForemanName).Length < 2) { validationResult += "Foreman Name Required" + System.Environment.NewLine; b = false; } if (MyConvert.ConvertToString(Value.ForemanPhone).Length < 9) { validationResult += "Foreman Name Required" + System.Environment.NewLine; b = false; } //301 Insurance 2 30 //302 Additional Insurance for City of Toronto 2 30 //Document Attached int docTypeID = 301; var docAttached = _db.PermitDocuments.Where(x => x.BaseAppID == BaseValue.BaseAppID & x.DocType == docTypeID).ToList(); if (!docAttached.Any( )) { var docType = _db.PermitDocumentTypes.Find(docTypeID); validationResult += "Document Required: " + docType.TypeName + System.Environment.NewLine; b = false; } //302 Additional Insurance for City of Toronto 2 30 if (isCityOfToronto) { docTypeID = 302; docAttached = _db.PermitDocuments.Where(x => x.BaseAppID == BaseValue.BaseAppID & x.DocType == docTypeID).ToList(); if (!docAttached.Any()) { var docType = _db.PermitDocumentTypes.Find(docTypeID); validationResult += "Document Required: " + docType.TypeName + System.Environment.NewLine; b = false; } } return(b ? "ok" : validationResult); }
public void ImportAddressFromCustomer(string importCustomerType) { //Subcontract-->Project-->IsInstallTo->Contact and Customer var workorder = new MyWorkorder(Value.WoID); var msc = new MySalesJobMasterListCustomer(workorder.Value.jobID); if (importCustomerType == "InstallTo") { msc.SetInstallTo(); } if (importCustomerType == "QuoteTo") { msc.SetQuoteTo(); } if (importCustomerType == "BillTo") { msc.SetBillTo(); } var mc = new MyCustomer(msc.CustomerID); _customer = mc.Value; var mcc = new MyCustomerContact(msc.ContactID); _contact = mcc.Value; if (_customer != null) { string addr = _customer.ADDR_1; if (!Convert.IsDBNull(_customer.ADDR_2)) { addr = addr + " " + _customer.ADDR_2; } Value.Address = addr; Value.City = _customer.CITY; Value.Postcode = _customer.ZIPCODE; Value.Province = _customer.STATE; Value.ShipToName = _customer.NAME; string attenName = MyConvert.ConvertToString(_contact.CONTACT_HONORIFIC) + " "; attenName += MyConvert.ConvertToString(_contact.CONTACT_FIRST_NAME) + " "; attenName += MyConvert.ConvertToString(_contact.CONTACT_LAST_NAME); Value.AttnName = attenName.Trim(); Value.AttnPhone = MyConvert.ConvertToString(_contact.CONTACT_PHONE); //For Delivery Note Value.DeliveryDate = DateTime.Today; Value.WorkorderNumber = workorder.Value.WorkorderNumber; var emp = new FsEmployee(Convert.ToInt32(workorder.Value.Sales)); Value.AeName = emp.NickName; Value.AePhone = emp.GetCompanyPhoneExtension(); Value.InvoiceNumber = workorder.GetInvoices(); Value.NoteTypeID = 0; _db.Entry(Value).State = EntityState.Modified; _db.SaveChanges(); Result = "ok"; } else { Result = "Could not find the specified Customer."; } }
public override string IsValidated() { var b = true; string validationResult = ""; //Number of Sign if (MyConvert.ConvertToDouble(Value.NumberOfSigns) == 0) { validationResult += "Number of Signs required." + System.Environment.NewLine; b = false; } //Estimated Value if (MyConvert.ConvertToDouble(Value.ProjectValueEstimated) == 0) { validationResult += "Estimated Project Valued required." + System.Environment.NewLine; b = false; } //Installation Address var msc = new MySalesJobMasterListCustomer(BaseValue.JobID); msc.SetInstallTo(); if (msc.CustomerID == 0) { validationResult += "No Installation Company Selected " + System.Environment.NewLine; b = false; } else { var mc = new MyCustomer(msc.CustomerID); if (MyConvert.ConvertToString(mc.Value.ADDR_1).Length < 5) { validationResult += "No Installation Address " + System.Environment.NewLine; b = false; } } //Landlord if (Value.LandlordID < 1000) { validationResult += "Enter a Landlord Please " + System.Environment.NewLine; b = false; } else { var landlord = _db.PermitLandlords.Find(Value.LandlordID); //Company Name if (MyConvert.ConvertToString(landlord.NAME).Length < 5) { validationResult += "Landlord Name Required" + System.Environment.NewLine; b = false; } //Address if (MyConvert.ConvertToString(landlord.ADDR_1).Length < 5) { validationResult += "Landlord Address Required " + System.Environment.NewLine; b = false; } if (MyConvert.ConvertToString(landlord.CITY).Length < 3) { validationResult += "Landlord City Required " + System.Environment.NewLine; b = false; } if (MyConvert.ConvertToString(landlord.ZIPCODE).Length < 4) { validationResult += "Landlord Postcode Required " + System.Environment.NewLine; b = false; } } //Landlord Contact if (Value.LandlordContactID < 1000) { validationResult += "Enter a Landlord Contact " + System.Environment.NewLine; b = false; } else { var contact = _db.PermitLandlordContacts.Find(Value.LandlordContactID); var l1 = MyConvert.ConvertToString(contact.CONTACT_FIRST_NAME).Length; var l2 = MyConvert.ConvertToString(contact.CONTACT_LAST_NAME).Length; if (l1 + l2 < 2) { validationResult += "Landlord Contact Name Required" + System.Environment.NewLine; b = false; } if (MyConvert.ConvertToString(contact.CONTACT_PHONE).Length < 9) { validationResult += "Landlord Contact Phone Required" + System.Environment.NewLine; b = false; } } //Document Attached var requiredDocuemntTypes = new int[] { 10, 12, 14, 16 }; for (int i = 0; i < requiredDocuemntTypes.Length; i++) { var docTypeID = requiredDocuemntTypes[i]; var docAttached = _db.PermitDocuments.Where(x => x.BaseAppID == BaseValue.BaseAppID & x.DocType == docTypeID).ToList(); if (!docAttached.Any( )) { var docType = _db.PermitDocumentTypes.Find(docTypeID); validationResult += "Document Required: " + docType.TypeName + System.Environment.NewLine; b = false; } } return(b ? "ok" : validationResult); }
private string IsValidated() { var b = true; string validationResult = ""; var msc = new MySalesJobMasterListCustomer(Value.JobID); msc.SetInstallTo(); if (msc.CustomerID < 1000) { validationResult += "No Installation Company Selected " + System.Environment.NewLine; b = false; } else { var myCustomer = new MyCustomer(msc.CustomerID); if (MyConvert.ConvertToString(myCustomer.Value.ADDR_1).Length < 5) { b = false; validationResult += "No Installation Address " + System.Environment.NewLine; } } if (Value.ContactPerson1 == 0) { validationResult += "Contact person required." + System.Environment.NewLine; b = false; } if (MyConvert.IsDate(Value.TargetDate)) { if (Value.TargetDate <= DateTime.Today) { validationResult += "Target Date should not be early than today. " + System.Environment.NewLine; b = false; } } else { validationResult += "Invalid Target Date format. " + System.Environment.NewLine; b = false; } if (!MyString.IsStringLengthLongerThan(3, Value.BudgetProvideBy)) { validationResult += "Budget Provide By Whom Required." + System.Environment.NewLine; b = false; } if (!MyString.IsStringLengthLongerThan(3, Value.Requirement)) { validationResult += "Please Enter Requirement." + System.Environment.NewLine; b = false; } var budgetAmount = 100; if (Value.RequirementID >= 6530) { budgetAmount = 100; //1 } if (Value.Budget < budgetAmount) { validationResult += "Normal Job Budget should >=$100, other Job Budget >=$100 " + System.Environment.NewLine; b = false; } return(b ? "ok" : validationResult); }