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