private void btnAdd_Click(object sender, EventArgs e) { Mapper.CreateMap <DealCustomerDTO, DealCustomer>(); DealCustomerDTO dealer = new DealCustomerDTO(); try { dealer.Name = namebox.Text; dealer.Email = boxEmail.Text; dealer.Contact = boxContact.Text; dealer.Address = boxAddress.Text; dealer.AddedDate = DateTime.Now; dealer.AddedBy = UserID; dealer.Type = comboboxUserType.SelectedItem.ToString(); if (string.IsNullOrWhiteSpace(dealer.Name) || string.IsNullOrWhiteSpace(dealer.Email) || string.IsNullOrWhiteSpace(dealer.Contact) || string.IsNullOrWhiteSpace(dealer.Address) || string.IsNullOrWhiteSpace(dealer.Type) ) { MessageBox.Show("One or more inputs is incorrect"); return; } } catch (Exception exception) { //log the exception later MessageBox.Show("An error occured please try again"); return; } using (var db = new Model1()) { var dealed = Mapper.Map <DealCustomerDTO, DealCustomer>(dealer); var val = db.DealCustomers.FirstOrDefault(c => c.Name.ToLower() == dealed.Name.ToLower() && c.Email == dealed.Email); if (val != null) { MessageBox.Show("User already exist"); return; } db.DealCustomers.Add(dealed); var result = db.SaveChanges() > 0; if (result) { MessageBox.Show("Input added successfully"); dataUser.DataSource = db.DealCustomers.ToList().ToDataTable(); boxEmail.Clear(); boxAddress.Clear(); boxContact.Clear(); namebox.Clear(); boxUserID.Clear(); } } }
private void btnUpdate_Click(object sender, EventArgs e) { Mapper.CreateMap <DealCustomerDTO, DealCustomer>(); DealCustomerDTO dealer = new DealCustomerDTO(); try { dealer.Name = namebox.Text; dealer.Email = boxEmail.Text; dealer.Contact = boxContact.Text; dealer.Address = boxAddress.Text; dealer.AddedDate = DateTime.Now; dealer.AddedBy = UserID; dealer.Type = comboboxUserType.SelectedItem.ToString(); if (string.IsNullOrWhiteSpace(dealer.Name) || string.IsNullOrWhiteSpace(dealer.Email) || string.IsNullOrWhiteSpace(dealer.Contact) || string.IsNullOrWhiteSpace(dealer.Address) || string.IsNullOrWhiteSpace(dealer.Type) ) { MessageBox.Show("One or more inputs is incorrect"); return; } } catch (Exception exception) { //log the exception later MessageBox.Show("An error occured please try again"); return; } using (var db = new Model1()) { var dealed = Mapper.Map <DealCustomerDTO, DealCustomer>(dealer); var id = boxUserID.Text; if (string.IsNullOrWhiteSpace(id)) { MessageBox.Show("ID cannot be null or empty"); return; } var ids = 0; int.TryParse(id, out ids); dealed.id = ids; db.DealCustomers.AddOrUpdate(dealed); var result = db.SaveChanges() > 0; if (result) { MessageBox.Show("Input added successfully"); dataUser.DataSource = db.DealCustomers.ToList().ToDataTable(); boxEmail.Clear(); boxAddress.Clear(); boxContact.Clear(); namebox.Clear(); boxUserID.Clear(); } } }