Exemplo n.º 1
0
 public static bool Create(Customer u)
 {
     DBUtilities.Connection();
     try
     {
         string sql = "Insert into Customers (CustomerEmail,CustomerName,CustomerAddress,CustomerGender,CustomerBirthday,CustomerPhone)";
         sql += " values (@1,@2,@3,@4,@5,@6)";
         SqlCommand cmd = new SqlCommand(sql, DBUtilities.objConnection);
         cmd.Parameters.AddWithValue("@1", u.CustomerEmail);
         cmd.Parameters.AddWithValue("@2", u.CustomerName);
         cmd.Parameters.AddWithValue("@3", u.CustomerAddress);
         cmd.Parameters.AddWithValue("@4", u.CustomerGender);
         cmd.Parameters.AddWithValue("@5", u.CustomerBirthday);
         cmd.Parameters.AddWithValue("@6", u.CustomerPhone);
         cmd.ExecuteNonQuery();
         cmd.Dispose();
         return true;
     }
     catch (Exception)
     {
         return false;
     }
     finally
     {
         DBUtilities.Close_Connection();
     }
 }
Exemplo n.º 2
0
        protected void btnAccept_Click(object sender, EventArgs e)
        {
            int Id = (Request.QueryString["ID"] != null) ? Convert.ToInt32(Request.QueryString["ID"]) : 1;
            string format = "yyyy-MM-dd HH:mm:ss";
            if (Validate_Control())
            {
                Customer c = new Customer();
                c.CustomerName = txtFullname.Text;
                c.CustomerEmail = txtEmail.Text;
                if (rdbMale.Checked)
                    c.CustomerGender = false;
                else
                    c.CustomerGender = true;

                c.CustomerBirthday = Convert.ToDateTime(txtBirthday.Text); ;
                c.CustomerAddress = txtAddress.Text;
                c.CustomerPhone = txtPhone.Text;

                if (CustomerDAO.Create(c))
                {
                    DataTable dtCus = CustomerDAO.All();
                    Painting paint = PaintingDAO.Find(Convert.ToInt32(PaintingId.Value));
                    paint.IsPaid = true;
                    paint.LastModify = DateTime.Now;
                    paint.CustomerId = Convert.ToInt32(dtCus.Rows[0][0]);
                    if (PaintingDAO.Update(paint))
                    {
                        Flash.dictFlash.Add("success", String.Format("Order successful, Wait for call"));
                        Response.Redirect("Show.aspx?ID=" + Id);
                    }
                    else {
                        Flash.dictFlash.Add("danger", "Have error in order process, Pless call");
                        Response.Redirect("Show.aspx?ID=" + Id);
                    }
                }
                else
                {
                    Flash.dictFlash.Add("danger", "You can't order with this picture");
                    Response.Redirect("Show.aspx?ID=" + Id);
                }
            }
        }
Exemplo n.º 3
0
 public static bool Destroy(Customer c)
 {
     DBUtilities.Connection();
     try
     {
         string sql = "Delete from Customers where Id = @1";
         SqlCommand cmd = new SqlCommand(sql, DBUtilities.objConnection);
         cmd.Parameters.AddWithValue("@1", c.Id);
         cmd.ExecuteNonQuery();
         cmd.Dispose();
         return true;
     }
     catch (Exception)
     {
         return false;
     }
     finally
     {
         DBUtilities.Close_Connection();
     }
 }
Exemplo n.º 4
0
 public static Customer Find(int Id)
 {
     DBUtilities.objConnection = new SqlConnection(DBUtilities.connStr);
     DataTable dt = new DataTable();
     string sql = "Select * from Customers where Id = @Id";
     SqlDataAdapter adap = new SqlDataAdapter(sql, DBUtilities.objConnection);
     adap.SelectCommand.Parameters.AddWithValue("@Id", Id);
     adap.Fill(dt);
     if (dt.Rows.Count > 0)
     {
         Customer c = new Customer();
         c.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
         c.CustomerName = dt.Rows[0]["CustomerName"].ToString();
         c.CustomerEmail = dt.Rows[0]["CustomerEmail"].ToString();
         c.CustomerGender = bool.Parse(dt.Rows[0]["CustomerGender"].ToString());
         c.CustomerBirthday = DateTime.Parse(dt.Rows[0]["CustomerBirthday"].ToString());
         c.CustomerAddress = dt.Rows[0]["CustomerAddress"].ToString();
         c.CustomerPhone = dt.Rows[0]["CustomerPhone"].ToString();
         return c;
     }
     return null;
 }
Exemplo n.º 5
0
 public static bool Update(Customer u)
 {
     DBUtilities.Connection();
     try
     {
         string sql = "Update Customers set ";
         Type myType = u.GetType();
         IList<PropertyInfo> props = new List<PropertyInfo>(myType.GetProperties());
         int i = 1;
         int j = 1;
         foreach (PropertyInfo prop in props)
         {
             object propValue = prop.GetValue(u, null);
             if (propValue != null && prop.Name != "Id")
             {
                 if (j < props.Count)
                     sql += String.Format("{0} = @{1} ,", prop.Name, i);
                 else
                     sql += String.Format("{0} = @{1} where ID= @{2}", prop.Name, i, i + 1);
                 i++;
             }
             j++;
         }
         i = 1;
         j = 1;
         SqlCommand cmd = new SqlCommand(sql, DBUtilities.objConnection);
         foreach (PropertyInfo prop in props)
         {
             object propValue = prop.GetValue(u, null);
             if (propValue != null && prop.Name != "Id")
             {
                 if (j < props.Count)
                     cmd.Parameters.AddWithValue(String.Format("@{0}", i), propValue);
                 else
                 {
                     cmd.Parameters.AddWithValue(String.Format("@{0}", i), propValue);
                     cmd.Parameters.AddWithValue(String.Format("@{0}", i + 1), u.Id);
                 }
                 i++;
             }
             j++;
         }
         cmd.ExecuteNonQuery();
         cmd.Dispose();
         return true;
     }
     catch (Exception)
     {
         return false;
     }
     finally
     {
         DBUtilities.Close_Connection();
     }
 }