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