public int CheckData(Ecommers.Entity.Ditales Ditales) { if (Ditales.ProductID.ToString().Length == 0) { return(0); } else if (Ditales.ProductPrice.ToString().Length == 0) { return(0); } else if (Ditales.ProductQunity.ToString().Length == 0) { return(0); } else if (Ditales.SupplierID == 0) { return(0); } else if (Ditales.CustomerID == 0) { return(0); } else { return(1); } }
public int Remove(Ecommers.Entity.Ditales Ditales) { if (CheckData(Ditales) == 0) { return(0); } else { return(DAL.Remove(Ditales)); } }
public int Edit(Ecommers.Entity.Ditales Ditales) { if (CheckData(Ditales) == 0) { return(0); } else { return(DAL.Edit(Ditales)); } }
public int Remove(Ecommers.Entity.Ditales Ditales) { int result = 0; string sql = "delete * form Ditales where OrderID=@OrderID"; SqlCommand cmd = new SqlCommand(sql, DBC.conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@OrderID", Ditales.OrderID); DBC.conn.Open(); result = cmd.ExecuteNonQuery(); DBC.conn.Close(); return(result); }
public int Edit(Ecommers.Entity.Ditales Ditales) { int result = 0; string sql = "update Ditales set ProductQunity=@ProductQunity,ProductPrice=@ProductPrice where OrderID=@OrderID "; SqlCommand cmd = new SqlCommand(sql, DBC.conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@OrderID", Ditales.OrderID); DBC.conn.Open(); result = cmd.ExecuteNonQuery(); DBC.conn.Close(); return(result); }
public int Add(Ecommers.Entity.Ditales Ditales) { int result = 0; string sql = "insert into Ditales (ProductID,ProductPrice,ProductQuantity,SupplierID,CustomerID) values (@ProductID,@ProductPrice,@ProductQunity,@SupplierID,@CustomerID)"; SqlCommand cmd = new SqlCommand(sql, DBC.conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@ProductID", Ditales.ProductID); cmd.Parameters.AddWithValue("@ProductPrice", Ditales.ProductPrice); cmd.Parameters.AddWithValue("@ProductQunity", Ditales.ProductQunity); cmd.Parameters.AddWithValue("@SupplierID", Ditales.SupplierID); cmd.Parameters.AddWithValue("@CustomerID", Ditales.CustomerID); DBC.conn.Open(); result = cmd.ExecuteNonQuery(); DBC.conn.Close(); return(result); }