public ActionResult JardeSenef(string StartDate, string EndDate, string SenefId, int? page, int? Quantiyid)
{
string Name = User.Identity.GetUserName();
if (Name == "*****@*****.**" || Name == "*****@*****.**" || Name == "*****@*****.**")
{
return RedirectToAction("Forbidden", "Error");
}
ViewBag.SenefId = new SelectList(db.Senef.Where(o=>o.FirstName!="ايصال"), "SenefId", "FirstName");
int pageSize = (Quantiyid ?? 24); ;
int pageNumber = (page ?? 1);
DateTime firstdate = Convert.ToDateTime("1/1/0001");
DateTime enddate = Convert.ToDateTime("1/1/0001");
if (StartDate != String.Empty & EndDate != String.Empty)
{
firstdate = Convert.ToDateTime(StartDate).Date;
enddate = Convert.ToDateTime(EndDate).Date;
ViewBag.StartDate = firstdate;
ViewBag.EndDate = enddate;
}
var Jarde = from s in db.OrderDetails.OrderByDescending(o => o.OrderDate)
select s;
if (firstdate.Year != 0001 && enddate.Year != 0001)
{
Jarde = Jarde.Where(s => s.OrderDate >= firstdate && s.OrderDate <= enddate);
}
if (SenefId == null)
{
Jarde = null;
return PartialView("JardeSenef", Jarde.ToPagedList(pageNumber, pageSize));
}
ViewBag.SSenefId = SenefId;
int productId = Convert.ToInt16(SenefId);
decimal outcome = 0;
decimal income = 0;
if (firstdate.Year == 0001 && enddate.Year == 0001)
{
ViewBag.FirstTime = "1/7/2015";
ViewBag.EndTime = DateTime.Now.AddDays(1).ToShortDateString();
List<OrderDetails> SenefJarde = Jarde.Where(o => o.ProductId == productId).Where(o => o.OrderDate >= firstdate && o.OrderDate <= enddate).ToList();
foreach (OrderDetails bl in SenefJarde)
{
outcome += bl.Total;
}
List<OrderDetailsCompany> senefJarde1 = db.OrderDetailsCompany.Where(o => o.ProductId == productId).Where(o => o.OrderDate >= firstdate && o.OrderDate <= enddate).ToList();
foreach (OrderDetailsCompany bl in senefJarde1)
{
OrderDetails temp = new OrderDetails();
outcome += bl.Total;
temp.Total = bl.Total;
temp.OrderDetailId = bl.OrderDetailsCompanyId;
temp.ProductId = bl.ProductId;
temp.productName = bl.productName;
temp.Quantity = bl.Quantity;
temp.UnitPrice = bl.UnitPrice;
temp.OrderDate = bl.OrderDate;
temp.BillClientId = bl.BillCompanyId;
SenefJarde.Add(temp);
}
ViewBag.outcome = outcome;
return PartialView("JardeSenef", SenefJarde.ToPagedList(pageNumber, pageSize));
}
else
{
ViewBag.FirstTime = firstdate.ToShortDateString();
ViewBag.EndTime = enddate.ToShortDateString();
List<OrderDetails> SenefJarde = Jarde.Where(o => o.ProductId == productId).Where(o => o.OrderDate >= firstdate && o.OrderDate <= enddate).ToList();
foreach (OrderDetails bl in SenefJarde)
{
outcome += bl.Total;
}
List<OrderDetailsCompany> senefJarde1 = db.OrderDetailsCompany.Where(o => o.ProductId == productId).Where(o => o.OrderDate >= firstdate && o.OrderDate <= enddate).ToList();
foreach (OrderDetailsCompany bl in senefJarde1)
{
OrderDetails temp = new OrderDetails();
outcome += bl.Total;
temp.Total = bl.Total;
temp.OrderDetailId = bl.OrderDetailsCompanyId;
temp.ProductId=bl.ProductId;
temp.productName=bl.productName;
temp.Quantity=bl.Quantity;
temp.UnitPrice=bl.UnitPrice;
temp.OrderDate=bl.OrderDate;
temp.BillClientId=bl.BillCompanyId;
SenefJarde.Add(temp);
}
ViewBag.outcome = outcome;
return PartialView("JardeSenef", SenefJarde.ToPagedList(pageNumber, pageSize));
}
}
private int CreateOrder(List<Senef> Temp, BillClient order)
{
ApplicationDbContext storeDB = new ApplicationDbContext();
decimal orderTotal = 0;
// var cartItems = GetCartItems();
// Iterate over the items in the cart,
// adding the order details for each
foreach (var item in Temp)
{
var orderDetail = new OrderDetails
{
ProductId = item.SenefId,
productName = item.FirstName,
BillClientId = order.BillClientId,
UnitPrice = item.Price,
Quantity = item.Quantity,
Total = item.Quantity * item.Price,
OrderDate = DateTime.Now.AddHours(10)
};
// Set the order total of the shopping cart
orderTotal += (item.Quantity * item.Price);
storeDB.OrderDetails.Add(orderDetail);
}
// Set the order's total to the orderTotal count
order.Total = orderTotal;
// Save the order
storeDB.SaveChanges();
// Return the OrderId as the confirmation number
return order.BillClientId;
}
