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();
}
}
}
