Example #1
0
        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();
                }
            }
        }
Example #2
0
        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();
                }
            }
        }