Exemple #1
0
 public static void DeleteEntity(Vendors vendor)
 {
     using (SqlConnection cn = new SqlConnection(Common.ConnectionString))
     {
         string proc = "pr_Vendor_Delete";
         using (SqlCommand cmd = new SqlCommand(proc, cn))
         {
             cmd.CommandType = CommandType.StoredProcedure;
             cmd.Parameters.AddWithValue("@vendor_ID", vendor.vendor_ID);
             cn.Open();
             cmd.ExecuteNonQuery();
         }
     }
 }
Exemple #2
0
        private void Delete()
        {
            Vendors vendor = vendorBindingSource.Current as Vendors;
            // (BindingList<Vendors>)userBindingSource.DataSource;
            //Vendors vendor = OrderList[userBindingSource.Position];

            decimal      vendor_ID = vendor.vendor_ID;
            DialogResult dlg       = MessageBox.Show(string.Format("Are you sure you want to delete Vendor # {0}?", vendor_ID.ToString()));

            if (dlg == System.Windows.Forms.DialogResult.OK)
            {
                Vendors.DeleteEntity(vendor);
                vendorBindingSource.RemoveCurrent();
                MessageBox.Show(string.Format("Vendor # {0} was deleted.", vendor_ID.ToString()));
            }
        }
Exemple #3
0
        private void Save()
        {
            vendorBindingSource.EndEdit();
            Vendors vendor = vendorBindingSource.Current as Vendors;

            //BindingList<Vendors> OrderList = (BindingList<Vendors>)userBindingSource.DataSource;
            //Vendors Vendors = OrderList[userBindingSource.Position];

            Vendors.SaveEntity(vendor);

            BindingList <Vendors> vendorList = new BindingList <Vendors>(Vendors.GetEntityList());

            vendorBindingSource.DataSource = vendorList;

            MessageBox.Show("Vendor was saved.");
        }
Exemple #4
0
        private void toolBtnFindOrderNumber_Click(object sender, EventArgs e)
        {
            List <Vendors> vendorList   = new List <Vendors>(vendorBindingSource.DataSource as BindingList <Vendors>);
            VendorFilter   vendorFilter = new VendorFilter(Convert.ToInt32(toolTxtFindOrderNumber.Text));
            //Predicate<Vendors> filterByOrderID = new Predicate<Vendors>(orderFilter.MatchesOrderID);
            Predicate <Vendors> filterByOrderID = new Predicate <Vendors>(vendorFilter.BeginsWithOrderID);
            Vendors             vendor          = vendorList.Find(filterByOrderID);

            if (vendor == null)
            {
                MessageBox.Show("No matching Vendor found", "Not Found", MessageBoxButtons.OK);
            }
            else
            {
                int index = vendorBindingSource.IndexOf(vendor);
                vendorBindingSource.Position = index;
            }
        }
Exemple #5
0
        private static Vendors AddEntity(Vendors vendor)
        {
            int vendor_ID = 0;

            using (SqlConnection cn = new SqlConnection(Common.ConnectionString))
            {
                string proc = "pr_Vendor_Add";
                using (SqlCommand cmd = new SqlCommand(proc, cn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@v_name", vendor.v_name);
                    cmd.Parameters.AddWithValue("@v_contactperson", vendor.v_contactperson);
                    cmd.Parameters.AddWithValue("@v_address", vendor.v_address);
                    cmd.Parameters.AddWithValue("@v_phone", vendor.v_phone);
                    cmd.Parameters.AddWithValue("@v_mobile", vendor.v_mobile);
                    cmd.Parameters.AddWithValue("@v_zip", vendor.v_zip);
                    cmd.Parameters.AddWithValue("@v_fax", vendor.v_fax);
                    cmd.Parameters.AddWithValue("@v_email", vendor.v_email);
                    cmd.Parameters.AddWithValue("@v_status", vendor.v_status);
                    cmd.Parameters.AddWithValue("@v_city", vendor.v_city);
                    cmd.Parameters.AddWithValue("@v_state", vendor.v_state);
                    cmd.Parameters.AddWithValue("@v_country", vendor.v_country);
                    cmd.Parameters.AddWithValue("@v_regno", vendor.v_regno);
                    cmd.Parameters.AddWithValue("@rEGdATE", vendor.rEGdATE);
                    cmd.Parameters.AddWithValue("@VendorCode", vendor.VendorCode);
                    cmd.Parameters.AddWithValue("@AVL", vendor.AVL);
                    cmd.Parameters.AddWithValue("@paymentTerms", vendor.paymentTerms);
                    cmd.Parameters.Add(new SqlParameter("@vendor_ID", SqlDbType.Decimal));
                    cmd.Parameters["@vendor_ID"].Direction = ParameterDirection.Output;
                    cn.Open();
                    cmd.ExecuteNonQuery();
                    vendor_ID = Convert.ToInt32(cmd.Parameters["@vendor_ID"].Value);
                }
                vendor = GetEntity(vendor_ID);
            }
            return(vendor);
        }
Exemple #6
0
        private void SetupBindings()
        {
            BindingList <Vendors> vendorList = new BindingList <Vendors>(Vendors.GetEntityList());

            vendorBindingSource.DataSource = vendorList;
        }
Exemple #7
0
 public bool BeginsWithOrderID(Vendors vendor)
 {
     return(vendor.vendor_ID.ToString().StartsWith(vendor_ID.ToString()));
 }
Exemple #8
0
 public bool MatchesOrderID(Vendors vendor)
 {
     return(vendor.vendor_ID == vendor_ID);
 }