} // public void insertDelivery(Models.DeliveryModels.Delivery delivery)
// Inserts a new delivery item into db.deliveries
public void InsertDelivery(DeliveryModels.SaveDelivery delivery)
{
try
{
using (SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["DeliverySystem"].ToString()))
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.insertnewdelivery";
cmd.Parameters.Add("@deliveryid", SqlDbType.Int, -1).Value = delivery.deliveryId;
cmd.Parameters.Add("@from", SqlDbType.VarChar, 50).Value = delivery.from;
cmd.Parameters.Add("@to", SqlDbType.VarChar, 50).Value = delivery.to;
cmd.Parameters.Add("@message", SqlDbType.VarChar, 8000).Value = delivery.message;
cmd.Parameters.Add("active", SqlDbType.Bit, -1).Value = delivery.active;
cmd.ExecuteNonQuery();
} // using (SqlCommand cmd = new SqlCommand())
} // using(SqlConnection cnn = new SqlConnection
} // try
catch (SqlException sqlex)
{
throw sqlex;
}
catch (Exception ex)
{
throw ex;
}
} // public void insertDelivery(Models.DeliveryModels.Delivery delivery)
public void SaveDelivery(DeliveryModels.SaveDelivery Delivery)
{
//var httpContext = (System.Web.HttpContextWrapper)Request.Properties["MS_HttpContext"];
//var foo = httpContext.Request.Form["jsonRequest"];
using (DeliveryHelper SaveDel = new DeliveryHelper())
{
SaveDel.InsertDelivery(Delivery);
}
}
