public List <CustOrderDetail> GetCustOrderDetail(int orderId)
{
string spName = "dbo.CustOrdersDetail";
var custOrderDetailList = new List <CustOrderDetail>();
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
using (var command = new SqlCommand(spName, connection))
{
command.CommandType = CommandType.StoredProcedure;
var customerIdParam = new SqlParameter("@OrderID", orderId);
command.Parameters.Add(customerIdParam);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var custOrderDetail = new CustOrderDetail();
custOrderDetail.ProductName = reader.GetSafe <string>("ProductName");
custOrderDetail.UnitPrice = reader.GetSafe <decimal>("UnitPrice");
custOrderDetail.Quantity = reader.GetSafe <short>("Quantity");
custOrderDetail.Discount = reader.GetSafe <int>("Discount");
custOrderDetail.ExtendedPrice = reader.GetSafe <decimal>("ExtendedPrice");
custOrderDetailList.Add(custOrderDetail);
}
return(custOrderDetailList);
}
}
}
}
public int Compare(object x, object y)
{
CustOrderDetail custOrderDetail1 = (CustOrderDetail)x;
CustOrderDetail custOrderDetail2 = (CustOrderDetail)y;
return(custOrderDetail1.Discount == custOrderDetail2.Discount &&
custOrderDetail1.ExtendedPrice == custOrderDetail2.ExtendedPrice &&
custOrderDetail1.ProductName == custOrderDetail2.ProductName &&
custOrderDetail1.Quantity == custOrderDetail2.Quantity ? 0 : 1);
}
public ActionResult ShippingDetails(RdplForm.Models.CustDetail result)
{
RahmanDbEntities db = new RahmanDbEntities();
{
tblCustDetail objcustdt = new tblCustDetail();
objcustdt.CustName = result.CustName;
objcustdt.Address = result.Address;
objcustdt.MobileNo = result.MobileNO;
// For total Amount Calculation
List <CartItems> cartId = (List <CartItems>)Session["cart"];
var total_Amount = 0;
foreach (var item in cartId)
{
//tblProductDetail prodDetail = new tblProductDetail();
var Amount = db.tblProductDetails.Where(c => c.ProductId == item.ProductId).FirstOrDefault();
total_Amount = total_Amount + (Amount.Price) * (item.Quantity);
}
objcustdt.Total_Amount = total_Amount;
db.tblCustDetails.Add(objcustdt);
db.SaveChanges();
ViewBag.Success = " Order placed Successfully ";
tblProductDetail prodDetails = new tblProductDetail();
List <CartItems> cartIds = (List <CartItems>)Session["cart"];
foreach (var item in cartIds)
{
CustOrderDetail orddt = new CustOrderDetail();
orddt.Order_Id = objcustdt.CustId;
orddt.Quntity = item.Quantity;
orddt.Product_Id = item.ProductId;
db.CustOrderDetails.Add(orddt);
}
db.SaveChanges();
ModelState.Clear();
}
return(View());
}
