示例#1
0
        private static void MeasureHardCoded()
        {
            CustomerDataMapper customer = new CustomerDataMapper(typeof(Customer), connStr, true);

            customer.GetAll();
            customer.GetById("ALFKI");
        }
示例#2
0
        private void FillCustomerComboBox()
        {
            var customerMapper = new CustomerDataMapper();

            cmbCustomer.DataSource    = customerMapper.GetAll();
            cmbCustomer.DisplayMember = "CompanyName";
            cmbCustomer.ValueMember   = "Id";
        }
示例#3
0
 private void CustomerEditForm_Load(object sender, EventArgs e)
 {
     if (!string.IsNullOrEmpty(_customerId))
     {
         var customerMapper = new CustomerDataMapper();
         var customer       = customerMapper.Get(_customerId);
         FillFormByCustomer(customer);
     }
 }
示例#4
0
        public static void CustomerDynamic()
        {
            IDataMapper test   = new CustomerDataMapper(typeof(Customer), connStr, true);
            object      id     = test.Insert(insertTestC);
            IEnumerable res    = test.GetAll();
            Customer    actual = (Customer)test.GetById(id);

            test.Delete(actual);
            Customer original = (Customer)test.GetById("ALFKI");

            test.Update(updateTestC);
            test.Update(original);
        }
示例#5
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            var customerMapper = new CustomerDataMapper();
            var customer       = CreateCustomertByForm();

            if (string.IsNullOrWhiteSpace(_customerId))
            {
                customerMapper.Insert(customer);
            }
            else
            {
                customerMapper.Update(customer);
            }
            RefreshListForm();
            Dispose();
        }
        static void Main(string[] args)
        {
            Customer cust = new Customer();
            cust.Id = 1;
            cust.FirstName = "Ahmet";
            cust.LastName = "Mehmet";
            cust.DateOfBorn = Convert.ToDateTime("1990-01-01");
            cust.Country = "Türkiye";

            CustomerDataMapper dataMapper = new CustomerDataMapper();
            dataMapper.Insert(cust);

            cust.Country = "Türkiye 2";
            dataMapper.Update(cust);

        }