public int Remove(Ecommers.Entity.Order order)
{
if (CheckData(order) == 0)
{
return(0);
}
else
{
return(DAL.Remove(order));
}
}
public int Edit(Ecommers.Entity.Order order)
{
if (CheckData(order) == 0)
{
return(0);
}
else
{
return(DAL.Edit(order));
}
}
public int Remove(Ecommers.Entity.Order Order)
{
int result = 0;
string sql = "delete from Order where OrderID=@OrderID ";
SqlCommand cmd = new SqlCommand(sql, DBC.conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@OrderID", Order.OrderID);
DBC.conn.Open();
result = cmd.ExecuteNonQuery();
DBC.conn.Close();
return(result);
}
public int Edit(Ecommers.Entity.Order Order)
{
int result = 0;
string sql = "update Order set SupplierID=@SupplierID,CustomerID=@CustomerID where OrderID=@OrderID ";
SqlCommand cmd = new SqlCommand(sql, DBC.conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@OrderID", Order.OrderID);
cmd.Parameters.AddWithValue("@SupplierID", Order.SupplierID);
cmd.Parameters.AddWithValue("@CustomerID", Order.CustomerID);
DBC.conn.Open();
result = cmd.ExecuteNonQuery();
DBC.conn.Close();
return(result);
}
public int Add(Ecommers.Entity.Order Order)
{
int result = 0;
string sql = "insert into [Order] ( OrderTotal ,SupplierID,CustomerID) values ( @OrderTotal ,@SupplierID,@CustomerID);";
SqlCommand cmd = new SqlCommand(sql, DBC.conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@SupplierID", Order.SupplierID);
cmd.Parameters.AddWithValue("@CustomerID", Order.CustomerID);
cmd.Parameters.AddWithValue("@OrderTotal", Order.OrderTotal);
DBC.conn.Open();
result = cmd.ExecuteNonQuery();
DBC.conn.Close();
return(result);
}
private int CheckData(Ecommers.Entity.Order order)
{
if (order.OrderTotal == 0)
{
return(0);
}
else if (order.CustomerID == 0)
{
return(0);
}
else if (order.SupplierID == 0)
{
return(0);
}
else
{
return(1);
}
}
