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