private int SQLUpdate(EntityClass.Orders ord)
{
SqlCommand cmd;
try
{
con = AppConfig.GetConnection();
con.Open();
cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "[UpdateOrder]";
cmd.CommandType = CommandType.StoredProcedure;
if (ckCus.Checked)
{
cmd.Parameters.Add("custid", SqlDbType.Int).Value = (object)DBNull.Value;
}
else
{
cmd.Parameters.Add("custid", SqlDbType.Int).Value = int.Parse(ord.CusID);
}
cmd.Parameters.Add("empid", SqlDbType.Int).Value = ord.EmpID;
cmd.Parameters.Add("orderdate", SqlDbType.DateTime).Value = Convert.ToDateTime(ord.OrderDate);
cmd.Parameters.Add("requireddate", SqlDbType.DateTime).Value = Convert.ToDateTime(ord.RequiredDate);
if (ckShipped.Checked)
{
cmd.Parameters.Add("shippeddate", SqlDbType.DateTime).Value = (object)DBNull.Value;
}
else
{
cmd.Parameters.Add("shippeddate", SqlDbType.DateTime).Value = Convert.ToDateTime(ord.ShippedDate);
}
cmd.Parameters.Add("shipperid", SqlDbType.Int).Value = ord.ShipperID;
cmd.Parameters.Add("freight", SqlDbType.Money).Value = Convert.ToDecimal(ord.Freight);
cmd.Parameters.Add("shipname", SqlDbType.NVarChar).Value = ord.ShipName;
cmd.Parameters.Add("shipaddress", SqlDbType.NVarChar).Value = ord.ShipAddress;
cmd.Parameters.Add("shipcity", SqlDbType.NVarChar).Value = ord.ShipCity;
cmd.Parameters.Add("shipregion", SqlDbType.NVarChar).Value = ord.ShipRegion != null ? ord.ShipRegion : (object)DBNull.Value;
cmd.Parameters.Add("shippostalcode", SqlDbType.NVarChar).Value = ord.ShipPostalCode != null ? ord.ShipPostalCode : (object)DBNull.Value;
cmd.Parameters.Add("shipcountry", SqlDbType.NVarChar).Value = ord.ShipCountry;
cmd.Parameters.Add("orderid", SqlDbType.NVarChar).Value = ord.ID;
int rs = cmd.ExecuteNonQuery();
if (rs > 0)
{
return(rs);
}
else
{
return(0);
}
}
catch (SqlException)
{
return(-1);
}
catch (Exception)
{
return(-1);
}
finally
{
con.Close();
}
}
