예제 #1
0
파일: CallerId.cs 프로젝트: sezertt/ROPv1
        public void FillInfo()
        {
            Customer customer = new Customer();
            cDal = new CallerIDDAL();
            try
            {
                customer = cDal.selectCustomer(info.phoneNumber);
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
            }

            if (info != null)
            {
                txtPhoneLine1.Text = info.phoneNumber;
                if (customer != null)
                {
                    txtNameLine1.Text = customer.Name;
                    txtLastNameLine1.Text = customer.LastName;
                    addressLine1.Text = customer.Address;
                    if (!string.IsNullOrEmpty(customer.Region))
                        txtRegionLine1.Text = customer.Region;
                    if (string.IsNullOrEmpty(customer.CustomerNote))
                        txtNoteLine1.Text = customer.CustomerNote;
                }
            }
        }
예제 #2
0
파일: CallerId.cs 프로젝트: sezertt/ROPv1
        public void insertCustomer()
        {
            cDal = new CallerIDDAL();
            Customer customer = new Customer();
            bool inserted = false;
            customer.Name = txtNameLine1.Text;
            customer.LastName = txtLastNameLine1.Text;
            customer.Address = addressLine1.Text;
            customer.Phone = txtPhoneLine1.Text;
            customer.Region = txtRegionLine1.Text;
            customer.CustomerNote = txtNoteLine1.Text;
            if (customer != null)
            {
                inserted = cDal.insertNewCustomer(customer);
            }

            if (!inserted)
                MessageBox.Show("Müşteri ad, soyad ve adres bilgilerini lütfen eksiksiz bir şekilde doldurunuz.");
        }
예제 #3
0
 public List<int> sonSiparisler(string phone)
 {
     try
     {
         List<int> orders = new List<int>();
         Customer customer = new Customer();
         SqlCommand cmd = SQLBaglantisi.getCommand("Select OrderId from CustomerOrders Where Phone=@phone");
         cmd.Parameters.AddWithValue("@phone", phone);
         SqlDataReader dr = cmd.ExecuteReader();
         while (dr.Read())
         {
             orders.Add(dr.GetInt32(0));
         }
         return orders;
     }
     catch (Exception)
     {
         return null;
     }
 }
예제 #4
0
 /// <summary>
 /// Gets the customer information from the database by phone number.
 /// </summary>
 /// <param name="phone">Phone is the unique key for each customer.</param>
 /// <returns></returns>
 public Customer selectCustomer(string phone)
 {
     try
     {
         Customer customer = new Customer();
         SqlCommand cmd = SQLBaglantisi.getCommand("Select Phone, Name, LastName, Address, Region, CustomerNote from Customers Where Phone=@phone");
         cmd.Parameters.AddWithValue("@phone", phone);
         SqlDataReader dr = cmd.ExecuteReader();
         dr.Read();
         customer.Phone = dr.GetString(0);
         customer.Name = dr.GetString(1);
         customer.LastName = dr.GetString(2);
         customer.Address = dr.GetString(3);
         customer.Region = dr.GetString(4);
         customer.CustomerNote = dr.GetString(5);
         return customer;
     }
     catch (Exception)
     {
         return null;
     }
 }
예제 #5
0
        public bool insertNewCustomer(Customer customer)
        {
            try
            {
                SqlCommand cmd = SQLBaglantisi.getCommand("Insert into Customers Values(@phone,@name,@lastName,@address,@region,@customerNote)");
                cmd.Parameters.AddWithValue("@phone", customer.Phone);
                cmd.Parameters.AddWithValue("@name", customer.Name);
                cmd.Parameters.AddWithValue("@lastName", customer.LastName);
                cmd.Parameters.AddWithValue("@address", customer.Address);
                cmd.Parameters.AddWithValue("@region", customer.Region);
                cmd.Parameters.AddWithValue("@customerNote", customer.CustomerNote);
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();
                cmd.Connection.Dispose();

                return true;
            }
            catch (Exception e)
            {
                return false;
            }
        }