public bool PostCheckout(TR_Checkout_Request param) { bool RetVal = false; try { DataTable CartID = new DataTable(); using (CartID) { CartID.Columns.Add("CartID", typeof(int)); foreach (var i in param.Cart) { int item = Convert.ToInt32(i.CartID_PK); CartID.Rows.Add(item); } } using (TransactionScope transactionScope = new TransactionScope()) { List <SqlParameter> Parameter = new List <SqlParameter>(); Parameter.Add(new SqlParameter() { ParameterName = "@pListCartID", SqlDbType = SqlDbType.Structured }); Parameter[0].TypeName = "[dbo].[CARTLIST]"; Parameter[0].Value = CartID; Parameter.Add(new SqlParameter() { ParameterName = "@pShippingAddress", SqlDbType = SqlDbType.VarChar, Value = param.ShippingAddress ?? "" }); Parameter.Add(new SqlParameter() { ParameterName = "@pPaymentTypeID", SqlDbType = SqlDbType.Int, Value = param.PaymentTypeID.HasValue ? param.PaymentTypeID :0 }); Parameter.Add(new SqlParameter() { ParameterName = "@pCreatedBy", SqlDbType = SqlDbType.VarChar, Value = param.CreatedBy ?? "" }); Parameter.Add(new SqlParameter() { ParameterName = "@pCreatedDate", SqlDbType = SqlDbType.DateTime, Value = param.CreatedDate.HasValue ? param.CreatedDate : DateTime.Now }); DBtran.DbExecute("USP_POST_CHECKOUT", Parameter, true, out SqlParameterCollection outParameter); transactionScope.Complete(); RetVal = true; } } catch (Exception ex) { } return(RetVal); }
public string ValidationRequest(TR_Checkout_Request req) { string RetVal = ""; if (req.UserName != Session["UserName"].ToString()) { RetVal = "UserName Not Match"; } return(RetVal); }
public bool PostCheckout(TR_Checkout_Request req) { bool RetVal = false; try { RetVal = DALCheckout.PostCheckout(req); } catch (Exception ex) { } return(RetVal); }
public ActionResult Checkout(TR_Checkout_Request req) { try { if (ModelState.IsValid) { string Valid = ValidationRequest(req); if (Valid == "") { string Address = req.ShippingAddress + " " + req.City + " " + req.Districs; List <TR_Cart_Item> Items = Session["TesData"] as List <TR_Cart_Item>; List <TR_Cart_Response> CartItem = GetCartItems(Items); req.Cart = CartItem; req.CreatedBy = Session["UserName"].ToString(); bool PostCheckout = BLCheckout.PostCheckout(req); } } } catch (Exception ex) { } return(RedirectToAction("Index", "Home")); }