public static void AddToCustomerOrder(CustomerOrderDomain mCustomerOrder) { string mainconn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); sqlconn.Open(); SqlCommand cmd = new SqlCommand("sp_CustomerOrder", sqlconn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mode", "PostCustomerOrder"); cmd.Parameters.AddWithValue("@CustomerId", mCustomerOrder.CustomerId); cmd.Parameters.AddWithValue("@FirstName", mCustomerOrder.FirstName); cmd.Parameters.AddWithValue("@LastName", mCustomerOrder.LastName); cmd.Parameters.AddWithValue("@OrderEmail", mCustomerOrder.OrderEmail); cmd.Parameters.AddWithValue("@OrderPhone", mCustomerOrder.OrderPhone); cmd.Parameters.AddWithValue("@OrderCounty", mCustomerOrder.OrderCounty); cmd.Parameters.AddWithValue("@OrderState", mCustomerOrder.OrderState); cmd.Parameters.AddWithValue("@OrderCity", mCustomerOrder.OrderCity); cmd.Parameters.AddWithValue("@OrderPostCode", mCustomerOrder.OrderPostCode); cmd.Parameters.AddWithValue("@ShippingAddress", mCustomerOrder.ShippingAddress); cmd.Parameters.AddWithValue("@OrderDate", mCustomerOrder.OrderDate); cmd.Parameters.AddWithValue("@PaymentType", mCustomerOrder.PaymentType); cmd.Parameters.AddWithValue("@TransactionId", mCustomerOrder.TransactionId); cmd.Parameters.AddWithValue("@OrderAmount", mCustomerOrder.OrderAmount); cmd.ExecuteNonQuery(); sqlconn.Close(); }
public ActionResult PlaceOrder(CustomerOrderDomain model) { try { var orders = CustomerOrderCRUD.GetCustomerOrderByCustomerId(0); int lastOrder = 0; if (orders.Count > 1) { lastOrder = orders[0].Id; } model.OrderDate = DateTime.Now; model.PaymentType = "COD"; model.TransactionId = "Trans00" + lastOrder + 1; CustomerOrderCRUD.AddToCustomerOrder(model); List <CustomerCartDomain> sessionCustomerCartOrders = (List <CustomerCartDomain>)Session["customerCartOrders"]; if (sessionCustomerCartOrders != null) { foreach (var item in sessionCustomerCartOrders) { bool res = CustomerCartCRUD.UpdateDetails(item.Id, true); } } else { var customerCartOrders = CustomerCartCRUD.GetCartByALLCustomerId(Convert.ToInt32(Session["idUser"])); foreach (var item in customerCartOrders) { bool res = CustomerCartCRUD.UpdateDetails(item.Id, true); } } return(Json("True", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ExceptionLogDomain obj = new ExceptionLogDomain(); obj.MethodName = "PlaceOrder"; obj.ControllerName = "Checkout"; obj.ErrorText = ex.Message; obj.StackTrace = ex.StackTrace; obj.Datetime = DateTime.Now; ExceptionLogCRUD.AddToExceptionLog(obj); return(Json("False", JsonRequestBehavior.AllowGet)); } }