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);
}
