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 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."; } }