public CustomerViewModel() { CustomerServiceAdapter = new ServiceAdapter <ICustomerService>(); Refresh(); View = new CustomerView { DataContext = this }; View.ShowDialog(); }
public void InsirtCustomer(CustomerView newCustomer) { Validator <CustomerView> .ValidateNull(newCustomer, Convertors.FirstLetterToUpper(nameof(newCustomer))); var customer = ConvertToCustomer(newCustomer); this.context.Customers.Add(customer); this.context.SaveChanges(); }
public CustomerViewModel(CustomerView owner) { this.owner = owner; Customers = new ObservableCollection <Customer>(); UpdateCommand = DelegateCommand.Create(Update); ResetCommand = DelegateCommand.Create(o => InitAsync()); DeleteCommand = DelegateCommand.Create(Delete); ToDealCommand = DelegateCommand.Create(owner.ToDeal); }
/// Task 2 public static void InsirtCustomer(CustomerView newCustomer) { if (newCustomer == null) { throw new NullReferenceException("Customer can not be null"); } customerRepository.InsirtCustomer(newCustomer); }
public async Task <IActionResult> DeleteCustomer([FromBody] CustomerView view) { CustomerModule invMod = new CustomerModule(); Customer customer = await invMod.Customer.Query().MapToEntity(view); invMod.Customer.DeleteCustomer(customer).Apply(); return(Ok(view)); }
public ActionResult CreateBooking(CustomerView cv) { HttpResponseMessage resCus = GlobalVariables.client.PostAsJsonAsync("Customer", cv).Result; int idCus = resCus.Content.ReadAsAsync <int>().Result; string tokenBooking = LibraryHelper.Tokenizer.Generate(5); BookingView book = new BookingView(); book = (BookingView)Session["book"]; book.IDCus = idCus; book.TokenBooking = tokenBooking; HttpResponseMessage resBook = GlobalVariables.client.PostAsJsonAsync("Booking", book).Result; if (resBook.IsSuccessStatusCode) { try { if (ModelState.IsValid) { MailAddress senderEmail = new MailAddress("*****@*****.**", "ABCXYZ Hotel"); MailAddress receiverEmail = new MailAddress(cv.EmailCus, cv.NameCus); string password = "******"; string sub = "Booking Successfully"; string body = "Hello, " + cv.NameCus + "!\n" + "Thank you for your reservation to stay at the ABCXYZ hotel.\n" + "Your booking code: " + tokenBooking + " .\n" + "Link leading to your booking information: http://localhost:53561/Booking/InformationBooking?token=" + tokenBooking; SmtpClient smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 25, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(senderEmail.Address, password) }; using (MailMessage mess = new MailMessage(senderEmail, receiverEmail) { Subject = sub, Body = body }) { smtp.Send(mess); } TempData["success"] = "Booking Successfully! Check your mail"; return(RedirectToAction("InformationBooking", new { token = tokenBooking })); } } catch (Exception e) { ViewBag.Error = "Some Error"; Console.WriteLine(e.Message); } } TempData["error"] = "Booking error!"; return(RedirectToAction("RegisterCustomer")); }
public async Task <CustomerView> Delete(int id) { var reg = await Context.Customers.FirstOrDefaultAsync(p => p.Id == id); reg.Inactive(); await Context.SaveChangesAsync(); return(CustomerView.New(reg)); }
public void Private_Method() { var attrappe = Mock.Create<ICustomerController>(); var sut = new CustomerView(attrappe); Mock.NonPublic.Arrange(sut, "Validate").CallOriginal().MustBeCalled(); sut.Save(); Mock.Assert(sut); }
public void Attrappe() { var attrappe = Mock.Create<ICustomerController>(); var sut = new CustomerView(attrappe); Mock.Arrange(() => attrappe.Save()).Occurs(1); sut.Save(); Mock.Assert(attrappe); }
private void CustomerButton_Click(object sender, EventArgs e) { CustomerView customerView = new CustomerView(); CustomerService customerService = new CustomerService(); IList customerList = customerService.getAllCustomers(); CustomerController customerController = new CustomerController(customerView, customerList); customerController.LoadView(); customerView.ShowDialog(); }
public void Raise_Event() { var sut = new CustomerView(); bool wasCalled = false; sut.WasUpdated += () => wasCalled = true; Mock.Intercept<CustomerView>(); Mock.Raise(() => sut.WasUpdated += null); Assert.That(wasCalled, Is.True); }
public void ModifyCustomer(CustomerView modifiedCustomer) { Validator <CustomerView> .ValidateNull(modifiedCustomer, Convertors.FirstLetterToUpper(nameof(modifiedCustomer))); var customer = this.GetCustomerById(modifiedCustomer.CustomerID); var values = context.Entry(customer).CurrentValues; values.SetValues(modifiedCustomer); context.SaveChanges(); }
public ActionResult Show() { CustomerView customerView = new CustomerView { Customers = _customerManager.GetAll() }; ViewBag.Show = "Show"; ViewBag.ActionName = "Add"; return(View(customerView)); }
public void DeleteCustomer(CustomerView customer) { using (DigiFusionEntities db = new DigiFusionEntities()) { Customer customerDb = db.Customers.Single(x => x.CustomerID == customer.CustomerID);; customerDb.IsDeleted = true; db.SaveChanges(); } }
public ActionResult Create([Bind(Include = "CustomerID,FirstName,LastName")] CustomerView customerView) { if (ModelState.IsValid) { serviceCustomers.AddCustomer(customerView.ToCustomer()); return(RedirectToAction("Index")); } return(View(customerView)); }
public IActionResult Login(LoginViewModel loginViewModel) { if (!ModelState.IsValid) { return(View(loginViewModel)); } IList <string> errors = new List <string>(); CustomerView customer = loginPersistence.PersistLogin(); if (customer == null) { if (EmailValidationService.IsValidEmail(loginViewModel.LoginInformation.Username)) { customer = eCommerce.GetCustomerBy(loginViewModel.LoginInformation.Username); if (customer != null) { if (customer.Active) { string encryptedPassword = eCommerce.GetCustomerEncryptedPassword(int.Parse(customer.Id)); if (EncryptionService.Encrypt(loginViewModel.LoginInformation.Password) == encryptedPassword) { loginPersistence.LoginThrough(loginViewModel.LoginInformation.Username, loginViewModel.LoginInformation.Remember); } else { errors.Add("Wrong password"); } } else { errors.Add("Account was locked"); } } else { errors.Add("Email not found"); } } else { errors.Add("Invalid email address"); } } else { return(Redirect(loginViewModel.ReturnUrl)); } if (errors.Any()) { ViewData[GlobalViewBagKeys.Errors] = errors; return(View(loginViewModel)); } return(Redirect(loginViewModel.ReturnUrl)); }
public ActionResult Edit([Bind(Include = "CustomerId,CustId,CustNum,Company,ResaleId,TerritoryId,ShipViaCode,CountryId,State,City,Address,PhoneNum,Names,LastNames,CreditHold,TermsCode,Terms,VendorId")] CustomerView customer) { if (ModelState.IsValid) { db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.VendorId = new SelectList(db.Vendors, "VendorId", "VendorEpicorId", customer.VendorId); return(View(customer)); }
public async Task Cancel() { if (CustomerView.CustomerId > 0) { await Load(CustomerView.CustomerId); } else { CustomerView = new CustomerView(); } }
public async Task <CustomerView> Update(int id, CustomerDto dto) { var reg = await Context.Customers.FindAsync(id); _customerMapper.Map(reg, dto); _customerValidator.Validate(reg); await Context.SaveChangesAsync(); return(CustomerView.New(reg)); }
// GET: Customer/Details/5 public ActionResult Details(string id) { try { string userName = Session["userName"].ToString(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Customer customer = db.customers.Find(id); CustomerView cv = new CustomerView(); cv.birthday = customer.profile.birthday; cv.countryUser = customer.countryUser; cv.descriptionUser = customer.profile.descriptionUser; cv.eMail = customer.profile.eMail; cv.firstName = customer.profile.firstName; cv.surname = customer.profile.surname; cv.selectedPictureCustomer = customer.selectedPictureCustomer; cv.userName = customer.userName; cv.password = customer.profile.password; try { List <CustomerRating> customerRatings = new List <CustomerRating>(); customerRatings = customer.customerRatings.ToList(); foreach (CustomerRating cr in customerRatings) { cv.rating += cr.rating.ratingValue; } cv.ratingCount = customerRatings.Count; cv.rating /= cv.ratingCount; cv.rating = Math.Round(cv.rating, 1); int ratingRounded = (int)cv.rating; cv.ratingDescription = db.ratings.Find(ratingRounded).ratingValueDescription; } catch (Exception) { cv.ratingCount = 0; cv.rating = 0; cv.ratingDescription = "no Ratings"; } if (customer == null || customer.userName != userName) { return(HttpNotFound()); } return(View(cv)); } catch (Exception) { return(RedirectToAction("Login", "Customer")); } }
public void ToCustomer(object parameter) { if (parameter == null) { var win = new CustomerView(); win.Show(); } else if (parameter.ToString() == "Customer") { selectedViewModel = new CustomerViewModel(); } }
//END PRODUCTS TAB //START CUSTOMERS TAB private void AddCustomer_Click(object sender, EventArgs e) { CustomerDetails cd = new CustomerDetails(this); if (cd.ShowDialog() == DialogResult.OK) { Account ac = new Account(cd.Cust_ID, cd.Cust_Name, cd.Address, cd.State, cd.Date, cd.Type); customers.Add(ac); loadcustomerdata(); CustomerView.Update(); CustomerView.Refresh(); } }
private CustomerView GetViewModel(Customer customer) { CustomerView result = new CustomerView { ContactNumber = customer.ContactNumber, CustomerID = customer.CustomerID, Description = customer.Description, IsDeleted = customer.IsDeleted, Name = customer.Name }; return(result); }
public HttpResponseMessage postUpdate(CustomerView model) { try { customerService.Update(model); return(Request.CreateResponse(HttpStatusCode.OK, "บันทึกข้อมูลสำเร็จ")); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString())); } }
public void UpdateCustomer(CustomerView customer) { using (DigiFusionEntities db = new DigiFusionEntities()) { Customer customerDb = db.Customers.Single(x => x.CustomerID == customer.CustomerID); customerDb.ContactNumber = customer.ContactNumber; customerDb.Description = customer.Description; customerDb.IsDeleted = customer.IsDeleted; customerDb.Name = customer.Name; db.SaveChanges(); } }
public void TestCreateCustomerAccount() { try { string json = ""; json = @"{ ""CustomerName"":""David Poston"" ,""FirstName"":""David"", ""LastName"":""Poston"", ""CompanyName"":""DC Tech"", ""LocationAddress"":[{ ""Address_Line1"" : ""2420 12th Ave"", ""City"" : ""Nampa"", ""State"" : ""ID"", ""Zipcode"" : ""83686"", ""Country"" : ""USA"", ""Type"" : ""Primary"" }], ""AccountEmail"":{ ""EmailText"" : ""*****@*****.**"", ""LoginEmail"" : true, ""Password"" : ""12345"" } }"; CustomerView customerView = JsonConvert.DeserializeObject <CustomerView>(json); CustomerModule custMod = new CustomerModule(); custMod .Customer .CreateAddressBook(customerView) .Apply() .CreateCustomerEmail(customerView) .Apply() .CreateCustomer(customerView) .Apply() .CreateCustomerLocationAddress(customerView) .Apply() ; Assert.True(true); } catch (Exception ex) { throw new Exception("TestCreateCustomerAccount", ex); } }
public async Task <IActionResult> UpdateCustomer([FromBody] CustomerView view) { CustomerModule invMod = new CustomerModule(); Customer customer = await invMod.Customer.Query().MapToEntity(view); invMod.Customer.UpdateCustomer(customer).Apply(); CustomerView retView = await invMod.Customer.Query().GetViewById(customer.CustomerId); return(Ok(retView)); }
// GET: CustomerViews/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CustomerView customerView = new CustomerView(serviceCustomers.GetCustomer(Convert.ToInt32(id))); if (customerView == null) { return(HttpNotFound()); } return(View(customerView)); }
public async Task <AddressBook> GetAddressBookByCustomerView(CustomerView customerView) { try { var query = await(from e in _dbContext.AddressBook join f in _dbContext.EmailEntity on e.AddressId equals f.AddressId where e.Name == customerView.CustomerName && f.Email == customerView.AccountEmail && f.LoginEmail == true select e).FirstOrDefaultAsync <AddressBook>(); return(query); } catch (Exception ex) { throw new Exception(GetMyMethodName(), ex); } }
public void SaveChanges() { if (!ValidateForm()) { return; } ContractBindingSource.EndEdit(); RenewalBindingSource.EndEdit(); _contract = (Contract)ContractBindingSource.DataSource; var renewal = (ContractRenewal)RenewalBindingSource.DataSource; int month = 0; month = Convert.ToInt32(CmboDuration.SelectedValue) == 1 ? (renewal.Duration ?? 0) : (renewal.Duration * 12 ?? 0); renewal.Duration = month; renewal.Status = 1; _contract.Status = 1; try { InsertRenewal(renewal); _context.Contracts.AddObject(_contract); _context.SaveChanges(); if (CustomerView == null) { if (_saveAndNew) { ContractBindingSource.DataSource = new Contract(); RenewalBindingSource.DataSource = new ContractRenewal(); } else { this.Close(); var ct = new ContractDetailView(); var contractDetailView = new ContractDetailView(); contractDetailView.ShowObject(_contract); contractDetailView.MdiParent = this.MainParent; contractDetailView.Show(); } } else { this.Close(); CustomerView.ReloadContracts(); } } catch (Exception e) { ViewHelper.ShowSaveError(); ErrorLogger.LogError(this, e); } }
public HttpResponseMessage GetLogin(string email, string password) { var model = repo.getCustomer(email, password); if (model == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } else { var view = new CustomerView(model); return(Request.CreateResponse(HttpStatusCode.OK, view)); } }
public ICustomer CreateCustomerLocationAddress(CustomerView customerView) { Task <AddressBook> lookupAddressBookTask = Task.Run(() => unitOfWork.addressBookRepository.GetAddressBookByCustomerView(customerView)); Task.WaitAll(lookupAddressBookTask); customerView.AddressId = lookupAddressBookTask.Result.AddressId; Task <CreateProcessStatus> resultTask = Task.Run(() => unitOfWork.locationAddressRepository.CreateLocationUsingCustomer(customerView)); Task.WaitAll(resultTask); return(this as ICustomer); }
private static void ShowAllCustomers() { ICollection <Customer> customers = customerManager.ReadAll(); int customerCounter = 1; foreach (var customer in customers) { CustomerView.SetHeader(string.Format("#{0} Info:", customerCounter)); CustomerView.ShowCustomer(customer.id, customer.name, customer.address, customer.email); CustomerView.SetFooter("######################" + Environment.NewLine); customerCounter++; } }
protected override void Start () { customerView = GetComponent<CustomerView>(); base.Start(); }
public void CustomerlistPartial_List() { // Arrange var Controller = new CustomerController(new CustomerBLL(new CustomerRepoStub())); var customerView = new CustomerView() { CustomerId = 1, Email = "*****@*****.**", Firstname = "Ole", Lastname = "Olsen", Address = "Persveien 5", Zipcode = "0123", City = "Oslo" }; var expectedResult = new List<CustomerView>(); expectedResult.Add(customerView); expectedResult.Add(customerView); expectedResult.Add(customerView); // Act var result = (PartialViewResult)Controller.CustomerlistPartial(); var modelresult = (List<CustomerView>)result.Model; // Assert Assert.AreEqual("", result.ViewName); for (var i = 0; i < modelresult.Count; i++) { Assert.AreEqual(expectedResult[i].CustomerId, modelresult[i].CustomerId); Assert.AreEqual(expectedResult[i].Email, modelresult[i].Email); Assert.AreEqual(expectedResult[i].Firstname, modelresult[i].Firstname); Assert.AreEqual(expectedResult[i].Lastname, modelresult[i].Lastname); Assert.AreEqual(expectedResult[i].Address, modelresult[i].Address); Assert.AreEqual(expectedResult[i].Zipcode, modelresult[i].Zipcode); Assert.AreEqual(expectedResult[i].City, modelresult[i].City); } }
private void AddCustomer() { CustomerViewModel cvm = new CustomerViewModel(); CustomerView dv = new CustomerView(); dv.DataContext = cvm; dv.ShowDialog(); GetCustomers(); }
private void EditCustomer() { CustomerViewModel cvm = new CustomerViewModel(this.SelectedCustomer.CustomerId); CustomerView cv = new CustomerView(); cv.DataContext = cvm; cv.ShowDialog(); GetCustomers(); }
public ActionResult UpdateCustomerHistory(CustomerView cusview) { CustomersHistory customeraddress = null; if (cusview.customerhistory != null) { if (cusview.customerhistory.Id == 0) { customeraddress = new CustomersHistory(); } else { customeraddress = db.CustomersHistories.Find(cusview.customerhistory.Id); } if (customeraddress != null) { customeraddress.OpenPurchaseOrder = cusview.customerhistory.OpenPurchaseOrder; customeraddress.OutstandingBalance = cusview.customerhistory.OutstandingBalance; customeraddress.CustomerId = cusview.customerhistory.CustomerId; db.Entry(customeraddress).State = EntityState.Modified; db.SaveChanges(); } } TempData["ActiveTab"] = "5"; //return RedirectToAction("Index"); return RedirectToAction("Edit", new { id = Convert.ToInt32(customeraddress.CustomerId) }); }
public ActionResult UpdateCustomer(CustomerView cusview) { Customers customers = null; //Update Customer General Information if (Convert.ToInt32(cusview.customer.Id) != null) { customers = db.Customers.Find(cusview.customer.Id); if (customers != null) { customers.ASINo = cusview.customer.ASINo; customers.BussinesType = cusview.customer.BussinesType; customers.CreditLimit = cusview.customer.CreditLimit; //customers.CustomerNo = cusview.customer.CustomerNo; customers.DeptoNo = cusview.customer.DeptoNo; customers.Origin = cusview.customer.Origin; customers.PaymentTerms = cusview.customer.PaymentTerms; customers.PPAINo = cusview.customer.PPAINo; customers.SageNo = cusview.customer.SageNo; customers.SalesPerson = cusview.customer.SalesPerson; customers.SellerPermintNo = cusview.customer.SellerPermintNo; customers.Status = cusview.customer.Status; db.Entry(customers).State = EntityState.Modified; db.SaveChanges(); } } return RedirectToAction("Index"); }
public ActionResult UpdateCustomerAddress(CustomerView cusview) { CustomersContactAddress customeraddress = null; if (cusview.customeraddress != null) { if (cusview.customeraddress.Id == 0) { customeraddress = new CustomersContactAddress(); } else { customeraddress = db.CustomersContactAddresses.Find(cusview.customeraddress.Id); } if (customeraddress != null) { customeraddress.Address = cusview.customeraddress.Address; customeraddress.City = cusview.customeraddress.City; customeraddress.CompanyName = cusview.customeraddress.CompanyName; customeraddress.Country = cusview.customeraddress.Country; customeraddress.CustomerId = cusview.customeraddress.CustomerId; customeraddress.Email = cusview.customeraddress.Email; customeraddress.Fax = cusview.customeraddress.Fax; customeraddress.FirstName = cusview.customeraddress.FirstName; customeraddress.LastName = cusview.customeraddress.LastName; customeraddress.Note = cusview.customeraddress.Note; customeraddress.State = cusview.customeraddress.State; customeraddress.Tel = cusview.customeraddress.Tel; customeraddress.Title = cusview.customeraddress.Title; customeraddress.Website = cusview.customeraddress.Website; customeraddress.Zip = cusview.customeraddress.Zip; db.Entry(customeraddress).State = EntityState.Modified; db.SaveChanges(); } } return RedirectToAction("Index"); }
public ActionResult UpdateCustomerandAddress(CustomerView cusview) { string szError = string.Empty; string szMsg = string.Empty; Customers customers = null; Customers customersDup = null; CustomersContactAddress customeraddress = null; IQueryable<Customers> qryCust = null; //Update Customer General Information if (Convert.ToInt32(cusview.customer.Id) != 0) { customers = db.Customers.Find(cusview.customer.Id); if (customers != null) { customers.ASINo = cusview.customer.ASINo; customers.BussinesType = cusview.customer.BussinesType; customers.CreditLimit = cusview.customer.CreditLimit; customers.DeptoNo = cusview.customer.DeptoNo; customers.Origin = cusview.customer.Origin; customers.PaymentTerms = cusview.customer.PaymentTerms; customers.PPAINo = cusview.customer.PPAINo; customers.SageNo = cusview.customer.SageNo; customers.SalesPerson = cusview.customer.SalesPerson; customers.SellerPermintNo = cusview.customer.SellerPermintNo; customers.Status = cusview.customer.Status; //Find duplicates for CustomerNo customers.CustomerNo = cusview.customer.CustomerNo; qryCust = db.Customers.Where(cut => cut.CustomerNo == customers.CustomerNo); if (qryCust.Count() > 0) { customersDup = qryCust.FirstOrDefault<Customers>(); if (customersDup != null) { customeraddress = db.CustomersContactAddresses.Where(ctad => ctad.CustomerId == customersDup.Id).FirstOrDefault<CustomersContactAddress>(); if (customeraddress != null) { szMsg = customeraddress.CompanyName; } } if (customers.Id != customeraddress.CustomerId) { szError = string.Format("Customer No. {0} already exist for {1}", customers.CustomerNo, szMsg); TempData["Error"] = szError; return RedirectToAction("Edit", new { id = Convert.ToInt32(cusview.customer.Id) }); } } db.Entry(customers).State = EntityState.Modified; //db.SaveChanges(); } } if (cusview.customeraddress != null) { if (cusview.customeraddress.Id == 0) { customeraddress = new CustomersContactAddress(); } else { customeraddress = db.CustomersContactAddresses.Find(cusview.customeraddress.Id); } if (customeraddress != null) { if (string.IsNullOrEmpty(cusview.customeraddress.Fax)) { cusview.customeraddress.Fax = "0"; } if (string.IsNullOrEmpty(cusview.customeraddress.Tel)) { cusview.customeraddress.Tel = "0"; } customeraddress.Address = cusview.customeraddress.Address; customeraddress.City = cusview.customeraddress.City; customeraddress.CompanyName = cusview.customeraddress.CompanyName; customeraddress.Country = cusview.customeraddress.Country; customeraddress.CustomerId = cusview.customeraddress.CustomerId; customeraddress.Email = cusview.customeraddress.Email; customeraddress.FirstName = cusview.customeraddress.FirstName; customeraddress.LastName = cusview.customeraddress.LastName; customeraddress.Note = cusview.customeraddress.Note; customeraddress.State = cusview.customeraddress.State; customeraddress.Fax = cusview.customeraddress.Fax.Replace("-", string.Empty); customeraddress.Tel = cusview.customeraddress.Tel.Replace("-", string.Empty); customeraddress.Title = cusview.customeraddress.Title; customeraddress.Website = cusview.customeraddress.Website; customeraddress.Zip = cusview.customeraddress.Zip; db.Entry(customeraddress).State = EntityState.Modified; //db.SaveChanges(); } } db.SaveChanges(); return RedirectToAction("Edit", new { id = Convert.ToInt32(cusview.customer.Id) }); }
public ActionResult UpdateCustomerBilling(CustomerView cusview) { CustomersBillingDept customeraddress = null; if (cusview.customerbilling != null) { if (cusview.customerbilling.Id == 0) { customeraddress = new CustomersBillingDept(); } else { customeraddress = db.CustomersBillingDepts.Find(cusview.customerbilling.Id); } if (customeraddress != null) { if (string.IsNullOrEmpty(cusview.customerbilling.Tel)) { cusview.customerbilling.Tel = "0"; } if (string.IsNullOrEmpty(cusview.customerbilling.Fax)) { cusview.customerbilling.Fax = "0"; } customeraddress.Address1 = cusview.customerbilling.Address1; customeraddress.Address2 = cusview.customerbilling.Address2; customeraddress.City = cusview.customerbilling.City; customeraddress.Country = cusview.customerbilling.Country; customeraddress.CustomerId = cusview.customerbilling.CustomerId; customeraddress.Email = cusview.customerbilling.Email; customeraddress.Fax = cusview.customerbilling.Fax.Replace("-", string.Empty); customeraddress.FirstName = cusview.customerbilling.FirstName; customeraddress.LastName = cusview.customerbilling.LastName; customeraddress.State = cusview.customerbilling.State; customeraddress.Tel = cusview.customerbilling.Tel.Replace("-", string.Empty); customeraddress.Title = cusview.customerbilling.Title; customeraddress.Zip = cusview.customerbilling.Zip; db.Entry(customeraddress).State = EntityState.Modified; db.SaveChanges(); } } TempData["ActiveTab"] = "3"; //return RedirectToAction("Index"); return RedirectToAction("Edit", new { id = Convert.ToInt32(customeraddress.CustomerId) }); }
// // GET: /Customers/Edit public ActionResult Edit(string modomultiple, int? page, int id = 0) { int nHas = 0; int nPos = -1; string szError = string.Empty; string szDecriptedData = string.Empty; string szDecriptedCode = string.Empty; //int? page = null; int pageNote = 0; int pageSubsidiary = 0; int pageSales = 0; int pageShipp = 0; int pageIndex = 0; int pageSize = 10; string szCustomerInfo = string.Empty; string szCustomerId = string.Empty; string szMsg = string.Empty; List<KeyValuePair<string, string>> listSelector = new List<KeyValuePair<string, string>>(); IQueryable<CustomersContactAddress> qryCusAdd = null; IQueryable<CustomersSubsidiaryAddress> qryCusSub = null; IQueryable<CustomersBillingDept> qryCusBil = null; IQueryable<CustomersSalesContact> qryCusSal = null; IQueryable<CustomersHistory> qryCusHty = null; IQueryable<CustomersCreditCardShipping> qryCusCre = null; IQueryable<CustomersSpecialNotes> qryCusNote = null; IQueryable<CustomersShipAddress> qryCusShip = null; IQueryable<Deptos> qryDepto = null; IQueryable<Bussines> qryBussines = null; IQueryable<Origin> qryOrigin = null; IQueryable<Terms> qryTerms = null; IQueryable<CustomerDefaults> qryCusDefault = null; CustomersContactAddress custMainContact = null; CustomersBillingDept custBilling = null; CustomersSalesContact custSalesContact = null; CustomersHistory custHistory = null; CustomersCreditCardShipping CustCredit = null; CustomersSubsidiaryAddress custSubsidiary = null; CustomersShipAddress CusShip = null; CustomersSpecialNotes CustNotes = null; CustomerDefaults customerdefaults = null; List<CustomersSpecialNotes> notesList = new List<CustomersSpecialNotes>(); List<CustomersSubsidiaryAddress> subsidiaryList = new List<CustomersSubsidiaryAddress>(); List<CustomersSalesContact> salesList = new List<CustomersSalesContact>(); List<CustomersShipAddress> shipList = new List<CustomersShipAddress>(); //Get the customer's data Customers customers = db.Customers.Find(id); if (customers != null) { //Use the customer defaults customerdefaults = db.CustomerDefaults.Where(cudf => cudf.CustomerId == id).FirstOrDefault<CustomerDefaults>(); if (customerdefaults == null) { customerdefaults = new CustomerDefaults(); customerdefaults.CustomerId = id; db.CustomerDefaults.Add(customerdefaults); db.SaveChanges(); } szCustomerInfo = customers.CustomerNo; qryCusAdd = db.CustomersContactAddresses.Where(cutadd => cutadd.CustomerId == customers.Id); if (qryCusAdd.Count() > 0) { custMainContact = qryCusAdd.FirstOrDefault<CustomersContactAddress>(); szCustomerInfo = string.Format("{0} {1}", szCustomerInfo, custMainContact.CompanyName); szCustomerId = customers.Id.ToString(); } else { custMainContact = new CustomersContactAddress(); custMainContact.CustomerId = customers.Id; db.CustomersContactAddresses.Add(custMainContact); szCustomerId = customers.Id.ToString(); } qryCusBil = db.CustomersBillingDepts.Where(cutadd => cutadd.CustomerId == customers.Id); if (qryCusBil.Count() > 0) { custBilling = qryCusBil.FirstOrDefault<CustomersBillingDept>(); } else { custBilling = new CustomersBillingDept(); custBilling.CustomerId = customers.Id; db.CustomersBillingDepts.Add(custBilling); } qryCusHty = db.CustomersHistories.Where(cutadd => cutadd.CustomerId == customers.Id); if (qryCusHty.Count() > 0) { custHistory = qryCusHty.FirstOrDefault<CustomersHistory>(); } else { custHistory = new CustomersHistory(); custHistory.CustomerId = customers.Id; db.CustomersHistories.Add(custHistory); } qryCusCre = db.CustomersCreditCardShippings.Where(cutadd => cutadd.CustomerId == customers.Id); if (qryCusCre.Count() > 0) { CustCredit = qryCusCre.FirstOrDefault<CustomersCreditCardShipping>(); if (customerdefaults.NoteId == null) { customerdefaults.NoteId = CustCredit.Id; customerdefaults.NoteName = string.Format("{0}", CustCredit.CreditNumber); } } else { CustCredit = new CustomersCreditCardShipping(); CustCredit.CustomerId = customers.Id; db.CustomersCreditCardShippings.Add(CustCredit); if (customerdefaults.NoteId == null) { customerdefaults.NoteId = CustCredit.Id; customerdefaults.NoteName = string.Format("{0}", CustCredit.Name); } } qryCusShip = db.CustomersShipAddresses.Where(cutadd => cutadd.CustomerId == customers.Id).OrderBy(cutadd => cutadd.FirstName).ThenBy(cutadd => cutadd.LastName); if (qryCusShip.Count() > 0) { //CusShip = qryCusShip.FirstOrDefault<CustomersShipAddress>(); foreach (var item in qryCusShip) { shipList.Add(item); if (customerdefaults.ShiptoAddressId == null) { customerdefaults.ShiptoAddressId = item.Id; customerdefaults.ShiptoName = item.Address1; } } } else { CusShip = new CustomersShipAddress(); CusShip.CustomerId = customers.Id; db.CustomersShipAddresses.Add(CusShip); db.SaveChanges(); shipList.Add(CusShip); if (customerdefaults.ShiptoAddressId == null) { customerdefaults.ShiptoAddressId = CusShip.Id; customerdefaults.ShiptoName = CusShip.Address1; } } qryCusSal = db.CustomersSalesContacts.Where(cutadd => cutadd.CustomerId == customers.Id).OrderBy(cutadd => cutadd.FirstName).ThenBy(cutadd => cutadd.LastName); if (qryCusSal.Count() > 0) { //custSalesContact = qryCusSal.FirstOrDefault<CustomersSalesContact>(); foreach (var item in qryCusSal) { salesList.Add(item); if (customerdefaults.SalesContactId == null) { customerdefaults.SalesContactId = item.Id; customerdefaults.SalesName = string.Format("{0} {1}", item.FirstName, item.LastName); custSalesContact = db.CustomersSalesContacts.Find(item.Id); } } } else { custSalesContact = new CustomersSalesContact(); custSalesContact.CustomerId = customers.Id; db.CustomersSalesContacts.Add(custSalesContact); db.SaveChanges(); salesList.Add(custSalesContact); if (customerdefaults.SalesContactId == null) { customerdefaults.SalesContactId = custSalesContact.Id; customerdefaults.SalesName = string.Format("{0} {1}", custSalesContact.FirstName, custSalesContact.LastName); } } qryCusSub = db.CustomersSubsidiaryAddresses.Where(cutadd => cutadd.CustomerId == customers.Id).OrderBy(cutadd => cutadd.CompanyName); if (qryCusSub.Count() > 0) { //custSubsidiary = qryCusSub.FirstOrDefault<CustomersSubsidiaryAddress>(); foreach (var item in qryCusSub) { subsidiaryList.Add(item); if (customerdefaults.SubsidiaryId == null) { customerdefaults.SubsidiaryId = item.Id; customerdefaults.SubsidiaryName = string.Format("{0}", item.CompanyName); } if (custSubsidiary == null) { custSubsidiary = item; customerdefaults.SubsidiaryId = item.Id; customerdefaults.SubsidiaryName = string.Format("{0}", item.CompanyName); } } } else { custSubsidiary = new CustomersSubsidiaryAddress(); custSubsidiary.CustomerId = customers.Id; db.CustomersSubsidiaryAddresses.Add(custSubsidiary); db.SaveChanges(); subsidiaryList.Add(custSubsidiary); if (customerdefaults.SubsidiaryId == null) { customerdefaults.SubsidiaryId = custSubsidiary.Id; customerdefaults.SubsidiaryName = string.Format("{0}", custSubsidiary.CompanyName); } } qryCusNote = db.CustomersSpecialNotes.Where(cutadd => cutadd.CustomerId == customers.Id).OrderByDescending(cutadd => cutadd.Id); if (qryCusNote.Count() > 0) { //CustNotes = qryCusNote.FirstOrDefault<CustomersSpecialNotes>(); foreach (var item in qryCusNote) { notesList.Add(item); //if (customerdefaults.NoteId == null) //{ // customerdefaults.NoteId = item.Id; // customerdefaults.NoteName = string.Format("{0}", item.SpecialNote); //} if (CustNotes == null) { CustNotes = item; } } } else { CustNotes = new CustomersSpecialNotes(); CustNotes.CustomerId = customers.Id; db.CustomersSpecialNotes.Add(CustNotes); notesList.Add(CustNotes); if (customerdefaults.NoteId == null) { customerdefaults.NoteId = CustNotes.Id; customerdefaults.NoteName = string.Format("{0}", CustNotes.SpecialNote); } } } db.SaveChanges(); ViewBag.CustomerInfo = szCustomerInfo; ViewBag.CustomerId = szCustomerId; //Get the dropdown data qryDepto = db.Deptos.OrderBy(dpt => dpt.Name); if (qryDepto.Count() > 0) { foreach (var item in qryDepto) { listSelector.Add(new KeyValuePair<string, string>(item.DeptoNo, item.Name)); } } SelectList deptoslist = new SelectList(listSelector, "Key", "Value"); ViewBag.DeptosList = deptoslist; listSelector = new List<KeyValuePair<string, string>>(); qryBussines = db.Bussines.OrderBy(bss => bss.BussinesType); if (qryBussines.Count() > 0) { foreach (var item in qryBussines) { listSelector.Add(new KeyValuePair<string, string>(item.BussinesType, item.BussinesType)); } } SelectList bussineslist = new SelectList(listSelector, "Key", "Value"); ViewBag.BussinesList = bussineslist; listSelector = new List<KeyValuePair<string, string>>(); qryOrigin = db.Origins.OrderBy(org => org.Name); if (qryOrigin.Count() > 0) { foreach (var item in qryOrigin) { listSelector.Add(new KeyValuePair<string, string>(item.Name, item.Name)); } } SelectList Originlist = new SelectList(listSelector, "Key", "Value"); ViewBag.OriginList = Originlist; listSelector = new List<KeyValuePair<string, string>>(); qryTerms = db.Terms.OrderBy(trm => trm.Term); if (qryTerms.Count() > 0) { foreach (var item in qryTerms) { listSelector.Add(new KeyValuePair<string, string>(item.Term, item.Term)); } } SelectList Termslist = new SelectList(listSelector, "Key", "Value"); ViewBag.TermsList = Termslist; listSelector = new List<KeyValuePair<string, string>>(); qryCusSal = db.CustomersSalesContacts.Where(csp => csp.CustomerId == customers.Id).OrderBy(csp => csp.FirstName).ThenBy(csp => csp.LastName); if (qryCusSal.Count() > 0) { foreach (var item in qryCusSal) { szMsg = string.Format("{0} {1}", item.FirstName, item.LastName); listSelector.Add(new KeyValuePair<string, string>(szMsg, szMsg)); } } SelectList SalesPersonslist = new SelectList(listSelector, "Key", "Value"); ViewBag.SalesPersonsList = SalesPersonslist; listSelector = new List<KeyValuePair<string, string>>(); qryCusSal = db.CustomersSalesContacts.Where(csp => csp.CustomerId == customers.Id).OrderBy(csp => csp.FirstName).ThenBy(csp => csp.LastName); if (qryCusSal.Count() > 0) { foreach (var item in qryCusSal) { szMsg = string.Format("{0} {1}", item.FirstName, item.LastName); listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), szMsg)); } } SelectList cusdefaultlist = new SelectList(listSelector, "Key", "Value"); ViewBag.SalesContactList = cusdefaultlist; listSelector = new List<KeyValuePair<string, string>>(); qryCusSub = db.CustomersSubsidiaryAddresses.Where(cusb => cusb.CustomerId == customers.Id).OrderBy(cusb => cusb.CompanyName); if (qryCusSub.Count() > 0) { foreach (var item in qryCusSub) { listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), item.CompanyName)); } } SelectList cussublist = new SelectList(listSelector, "Key", "Value"); ViewBag.SubsidiaryList = cussublist; listSelector = new List<KeyValuePair<string, string>>(); qryCusShip = db.CustomersShipAddresses.Where(cusb => cusb.CustomerId == customers.Id).OrderBy(cusb => cusb.FirstName).ThenBy(cusb => cusb.LastName); if (qryCusShip.Count() > 0) { foreach (var item in qryCusShip) { szMsg = string.Format("{0} {1}", item.FirstName, item.LastName); listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), szMsg)); } } SelectList cusshiplist = new SelectList(listSelector, "Key", "Value"); ViewBag.ShipList = cusshiplist; listSelector = new List<KeyValuePair<string, string>>(); qryCusCre = db.CustomersCreditCardShippings.Where(cucr => cucr.CustomerId == customers.Id).OrderBy(cucr => cucr.CreditNumber); if (qryCusCre.Count() > 0) { foreach (var item in qryCusCre) { szError = string.Empty; szDecriptedData = TimelyDepotMVC.Controllers.PaymentController.DecodeInfo02(item.CreditNumber, ref szError); if (!string.IsNullOrEmpty(szError)) { nPos = szError.IndexOf("data to decode"); if (nPos != -1) { szDecriptedData = string.Empty; } else { szDecriptedData = string.Format("******"); } } else { //Mask the card number nHas = szDecriptedData.Length; if (nHas > 4) { szMsg = szDecriptedData.Substring(nHas - 4, 4); szDecriptedData = string.Format("******{0}", szMsg); } else { szDecriptedData = string.Format("******"); } } //listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), item.CreditNumber)); listSelector.Add(new KeyValuePair<string, string>(item.Id.ToString(), szDecriptedData)); } } SelectList cuscreditlist = new SelectList(listSelector, "Key", "Value"); ViewBag.CreditCardList = cuscreditlist; //Get the missing (null) objects if (custSalesContact == null) { custSalesContact = db.CustomersSalesContacts.Find(customerdefaults.SalesContactId); if (custSalesContact == null) { custSalesContact = new CustomersSalesContact(); } } if (custSubsidiary == null) { custSubsidiary = db.CustomersSubsidiaryAddresses.Find(customerdefaults.SubsidiaryId); if (custSubsidiary == null) { custSubsidiary = new CustomersSubsidiaryAddress(); } } if (CusShip == null) { CusShip = db.CustomersShipAddresses.Find(customerdefaults.ShiptoAddressId); if (CusShip == null) { CusShip = new CustomersShipAddress(); } } //Get theActive/Inactive list listSelector = new List<KeyValuePair<string, string>>(); listSelector.Add(new KeyValuePair<string, string>("Y", "Active")); listSelector.Add(new KeyValuePair<string, string>("N", "Inactive")); SelectList activeinactivelist = new SelectList(listSelector, "Key", "Value"); ViewBag.ActiveInactivelist = activeinactivelist; CustomerView cusview = new CustomerView(); cusview.customer = customers; cusview.customeraddress = custMainContact; cusview.customerbilling = custBilling; cusview.customerhistory = custHistory; cusview.customercredit = CustCredit; cusview.customerdefaults = customerdefaults; cusview.customersalescontact = custSalesContact; cusview.custmersubsidiary = custSubsidiary; cusview.customershipaddress = CusShip; cusview.customernote = CustNotes; if (TempData["AddCustomer"] != null) { ViewBag.AddCustomerHlp = TempData["AddCustomer"].ToString(); } //Set the page if (page == null) { pageIndex = 1; } else { pageIndex = Convert.ToInt32(page); } if (string.IsNullOrEmpty(modomultiple)) { pageNote = pageIndex; pageSubsidiary = pageIndex; pageSales = pageIndex; pageShipp = pageIndex; } else { switch (modomultiple) { case "SpecialNote": pageNote = pageIndex; break; case "Subsidiary": pageSubsidiary = pageIndex; break; case "Sales": pageSales = pageIndex; PageSize = 1; break; case "Shipp": pageShipp = pageIndex; break; default: break; } } //Verify page numbre if (pageNote == 0) { pageNote = 1; } var noteListHlp = notesList.ToPagedList(1, 1); ViewBag.OnePageOfNotesData = noteListHlp; cusview.customernotesList = noteListHlp; var subsidiaryListHlp = subsidiaryList.ToPagedList(1, 1); ViewBag.OnePageOfsubsidiarysData = subsidiaryListHlp; cusview.customersubsidiaryList = subsidiaryListHlp; //var salesListHlp = salesList.ToPagedList(pageSales, pageSize); var salesListHlp = salesList.ToPagedList(1, 1); ViewBag.OnePageOfsalesData = salesListHlp; cusview.customersalesList = salesListHlp; var shippListHlp = shipList.ToPagedList(1, 1); ViewBag.OnePageOfshipsData = shippListHlp; cusview.customershipList = shippListHlp; //Set the error, if any if (TempData["Error"] != null) { ViewBag.Error = TempData["Error"].ToString(); } //Set the active tab if (TempData["ActiveTab"] != null) { ViewBag.ActiveTab = TempData["ActiveTab"].ToString(); } return View(cusview); }
private void MergeSelectedCustomer() { CustomerView cv = new CustomerView(); cv.DataContext = new CustomerViewModel(SelectedCustomer.CustomerId, CustomerTemp); cv.Show(); using (dbContext db = new dbContext()) { var temp = db.CustomerTemp.SingleOrDefault(item => item.CustomerTempId == CustomerTemp.CustomerTempId); db.CustomerTemp.Remove(temp); db.SaveChanges(); } Messenger.Default.Send(new NotificationMessage("CloseSimilarCustomerListViewWindow")); }
public void UpdateCustomerCreditCard(CustomerView cusview) { CustomersCreditCardShipping customeraddress = null; if (cusview.customercredit != null) { if (cusview.customercredit.Id == 0) { customeraddress = new CustomersCreditCardShipping(); } else { customeraddress = db.CustomersCreditCardShippings.Find(cusview.customercredit.Id); } if (customeraddress != null) { customeraddress.Name = cusview.customercredit.Name; customeraddress.CreditNumber = cusview.customercredit.CreditNumber; customeraddress.ExpirationDate = cusview.customercredit.ExpirationDate; customeraddress.SecureCode = cusview.customercredit.SecureCode; customeraddress.Address1 = cusview.customercredit.Address1; customeraddress.Address2 = cusview.customercredit.Address2; customeraddress.Country = cusview.customercredit.Country; customeraddress.State = cusview.customercredit.State; customeraddress.Tel = cusview.customercredit.Tel.Replace("-", string.Empty); customeraddress.Zip = cusview.customercredit.Zip; customeraddress.CustomerId = cusview.customercredit.CustomerId; db.Entry(customeraddress).State = EntityState.Modified; db.SaveChanges(); } } }