public async Task <IActionResult> Edit(long id, [Bind("order_id,cust_id,pickup_dri_id,sp_id,status_id,order_weight,order_pickup_add,order_deliver_add,deliver_dri_id,request_time,awaiting_pickup_time,pickup_time,washing_time,washing_completed_time,delivering_time,delivered_time,order_amount,payment_method")] Order_Header order_Header)
{
if (id != order_Header.order_id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(order_Header);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Order_HeaderExists(order_Header.order_id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(order_Header));
}
public Boolean SaveLog(Order_Header record)
{
try
{
var log = new Order_Header_Log
{
OrderNumber = record.OrderNumber,
FacilityCode = record.FacilityCode,
OrderStatusId = System.Convert.ToInt32(record.OrderStatusId),
OrderStatusChangedBy = new UserManagement().getCurrentuser(),
OrderStatusDateChanged = DateTime.Now,
StartDate = record.StartDate,
EndDate = record.EndDate,
DatePrepared = record.DatePrepared,
OrderTypeId = record.OrderTypeId,
ProductCategoryId = 2
};
context.Order_Header_Log.Add(log);
context.SaveChanges();
return(true);
}
catch (Exception e)
{
throw (e);
}
}
public async Task <IActionResult> Create([Bind("order_id,cust_id,pickup_dri_id,sp_id,status_id,order_weight,order_pickup_add,order_deliver_add,deliver_dri_id,request_time,awaiting_pickup_time,pickup_time,washing_time,washing_completed_time,delivering_time,delivered_time,order_amount,payment_method")] Order_Header order_Header)
{
if (ModelState.IsValid)
{
_context.Add(order_Header);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(order_Header));
}
public Boolean Save()
{
try
{
if (GetRecordByKey(mOrderNumber) == null)
{
var x = new Order_Header
{
OrderNumber = mOrderNumber,
FacilityCode = mFacilityCode,
StartDate = mStartDate,
EndDate = mEndDate,
DatePrepared = mDatePrepared,
EditedBy = new UserManagement().getCurrentuser(),
EditedDate = mEditedDate,
//EmergencyOrder = mEmergencyOrder,
FinalSubmission = mFinalSubmission,
OrderTypeId = mOrderTypeId,
OrderStatusId = mOrderStatusId,
OrderStatusIdChangedBy = mOrderStatusIdChangedBy,
OrderStatusIdDateChanged = mOrderStatusIdDateChanged,
DateExpected = mDateExpected,
RFSO_SentBackTofacility = mRFSO_SentBackTofacility
};
context.Order_Header.Add(x);
//////SaveLog(x);
context.SaveChanges();
////SaveLog(x);
return(true);
}
else
{
return(false);
}
}
catch (Exception x)
{
throw (x);
}
}
public IActionResult Index(SelectedItemsViewModel model)
{
if (model.SelecedIds != null)
{
string[] ItemsIDs = model.SelecedIds.Split(',');
int[] myInts = Array.ConvertAll(ItemsIDs, int.Parse);
var selected = model.Items.Where(t => myInts.Contains(t.ItemD)).ToList();
if (selected != null && selected.Count > 0)
{
List <Order_Details> order_DetailsList = new List <Order_Details>();
var userId = _userManager.GetUserId(User);
var CheckUserHasOrder = _appDbContext.order_Header.FirstOrDefault(i => i.CustomerID == userId && i.Status == "Pending");
if (CheckUserHasOrder != null)
{
foreach (var item in selected)
{
Order_Details order_Details = new Order_Details();
order_Details.ItemName = item.Name;
order_Details.ItemID = item.ItemD;
order_Details.ItemPrice = item.Price;
order_Details.Quantity = item.Quantity;
order_Details.TotalPrice = (item.Price - item.Discount) * item.Quantity;
order_Details.Uom = item.Uom;
order_Details.Discount = item.Discount;
order_Details.Order_Header = CheckUserHasOrder;
order_DetailsList.Add(order_Details);
}
_appDbContext.order_Details.AddRange(order_DetailsList);
_appDbContext.SaveChanges();
return(RedirectToAction("GetCardItems", "Home", new { @OrderID = CheckUserHasOrder.Order_Header_ID }));
}
else
{
Order_Header order_Header = new Order_Header();
order_Header.OrderDate = DateTime.Now;
order_Header.CustomerID = userId;
order_Header.Status = "Pending";
order_Header.Tax = 14;
foreach (var item in selected)
{
Order_Details order_Details = new Order_Details();
order_Details.ItemName = item.Name;
order_Details.ItemID = item.ItemD;
order_Details.ItemPrice = item.Price;
order_Details.Quantity = item.Quantity;
order_Details.TotalPrice = (item.Price - item.Discount) * item.Quantity;
order_Details.Uom = item.Uom;
order_Details.Discount = item.Discount;
order_DetailsList.Add(order_Details);
}
order_Header.Order_Details = order_DetailsList;
_appDbContext.order_Header.Add(order_Header);
_appDbContext.SaveChanges();
return(RedirectToAction("GetCardItems", "Home", new { @OrderID = order_Header.Order_Header_ID }));
}
}
}
return(View());
}
public Boolean SaveART(string OrderNo)
{
try
{
var allocated = context.Order_DrugDetails.Where(o => o.OrderNumber == OrderNo && o.Quantity_Allocated > 0).ToList().Count;
if (allocated > 0)
{
if (GetRecordByKey(OrderNo) != null)
{
Order_Header t = new Order_Header();
t = GetRecordByKey(OrderNo);
//DateTime eDate = t.EndDate;
DateTime pDate = System.Convert.ToDateTime(t.DatePrepared);
int facility = t.FacilityCode;
var sapcode = context.A_Facilities.FirstOrDefault(a => a.FacilityCode == facility).SAP_Code;
var x = new SAP_ExportHeader
{
OrderNumber = t.OrderNumber,
AddedDate = System.DateTime.Now,
AddedBy = new UserManagement().getCurrentuser(),
CurrentReccord = true,
RecordReadBySAP = false,
DocNum = System.Convert.ToString(System.Convert.ToDateTime(pDate).Day + "" + System.Convert.ToDateTime(pDate).Month + "" + System.Convert.ToDateTime(pDate).Year + "" + facility),
DocDate = System.Convert.ToDateTime(pDate),
DocDueDate = System.Convert.ToDateTime(pDate),
CardCode = sapcode,// t.A_Facilities.SAP_Code,
DocEntry = mDocEntry,
ProductCategory = 2,
};
var order = context.SAP_ExportHeader.FirstOrDefault(o => o.OrderNumber == OrderNo);
if (order == null)
{
context.SAP_ExportHeader.Add(x);
context.SaveChanges();
}
SAPExportDetails details = new SAPExportDetails();
details.SaveART(OrderNo);
//var update = t;
//update.OrderStatusId = 4;
//context.Entry(t).CurrentValues.SetValues(update);
//context.Entry(t).State = EntityState.Modified;
//context.SaveChanges();
return(true);
}
else
{
// existing_records = true;
return(false);
}
}
else
{
// existing_records = true;
return(false);
}
}
catch (Exception x)
{
throw (x);
}
}
