public ActionResult _FilterPostOrders(PurchaseInvoiceLineFilterViewModel vm)
{
List <PurchaseInvoiceLineViewModel> temp = _PurchaseInvoiceLineService.GetPurchaseOrderForFilters(vm).ToList();
PurchaseInvoiceMasterDetailModel svm = new PurchaseInvoiceMasterDetailModel();
svm.PurchaseInvoiceLineViewModel = temp;
return(PartialView("_Results", svm));
}
public ActionResult _ResultsPost(PurchaseInvoiceMasterDetailModel vm)
{
List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
List <LineChargeViewModel> LineCharges = new List <LineChargeViewModel>();
int pk = 0;
int Serial = _PurchaseInvoiceLineService.GetMaxSr(vm.PurchaseInvoiceLineViewModel.FirstOrDefault().PurchaseInvoiceHeaderId);
bool HeaderChargeEdit = false;
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
List <LineReferenceIds> RefIds = new List <LineReferenceIds>();
PurchaseInvoiceHeader Header = new PurchaseInvoiceHeaderService(_unitOfWork).Find(vm.PurchaseInvoiceLineViewModel.FirstOrDefault().PurchaseInvoiceHeaderId);
PurchaseInvoiceSetting Settings = new PurchaseInvoiceSettingService(_unitOfWork).GetPurchaseInvoiceSettingForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);
int?MaxLineId = new PurchaseInvoiceLineChargeService(_unitOfWork).GetMaxProductCharge(Header.PurchaseInvoiceHeaderId, "Web.PurchaseInvoiceLines", "PurchaseInvoiceHeaderId", "PurchaseInvoiceLineId");
int PersonCount = 0;
int CalculationId = Settings.CalculationId;
List <LineDetailListViewModel> LineList = new List <LineDetailListViewModel>();
var RecptLineIds = vm.PurchaseInvoiceLineViewModel.Select(m => m.PurchaseGoodsReceiptLineId).ToArray();
var RecptRecords = (from p in db.ViewPurchaseGoodsReceiptBalance
where RecptLineIds.Contains(p.PurchaseGoodsReceiptLineId)
select new
{
LineId = p.PurchaseGoodsReceiptLineId,
BalQty = p.BalanceQty,
}).ToList();
bool BeforeSave = true;
try
{
BeforeSave = PurchaseInvoiceDocEvents.beforeLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseInvoiceLineViewModel.FirstOrDefault().PurchaseInvoiceHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
if (!BeforeSave)
{
ModelState.AddModelError("", "Validation failed before save");
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
foreach (var item in vm.PurchaseInvoiceLineViewModel)
{
decimal balqty = RecptRecords.Where(m => m.LineId == item.PurchaseGoodsReceiptLineId).FirstOrDefault().BalQty;
if (item.DealQty > 0 && (Settings.isMandatoryRate == true ? item.Rate > 0 : 1 == 1) && item.Qty <= balqty)
{
PurchaseInvoiceLine line = new PurchaseInvoiceLine();
line.PurchaseInvoiceHeaderId = item.PurchaseInvoiceHeaderId;
line.PurchaseGoodsReceiptLineId = item.PurchaseGoodsReceiptLineId;
line.UnitConversionMultiplier = item.UnitConversionMultiplier;
line.Rate = item.Rate;
line.DealUnitId = item.DealUnitId;
line.DocQty = item.DocQty;
line.DealQty = item.DealQty;
line.DiscountPer = item.DiscountPer;
//line.Amount = (item.DealQty * item.RateAfterDiscount);
if (Settings.CalculateDiscountOnRate)
{
var temprate = item.Rate - (item.Rate * item.DiscountPer / 100);
line.Amount = line.DealQty * temprate ?? 0;
}
else
{
var DiscountAmt = (item.Rate * line.DealQty) * item.DiscountPer / 100;
line.Amount = (item.Rate * line.DealQty) - (DiscountAmt ?? 0);
}
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.Sr = Serial++;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
line.PurchaseInvoiceLineId = pk;
line.ObjectState = Model.ObjectState.Added;
db.PurchaseInvoiceLine.Add(line);
//_PurchaseInvoiceLineService.Create(line);
LineStatus.Add(line.PurchaseGoodsReceiptLineId, line.DocQty);
LineList.Add(new LineDetailListViewModel {
Amount = line.Amount, Rate = line.Rate, LineTableId = line.PurchaseInvoiceLineId, HeaderTableId = item.PurchaseInvoiceHeaderId, PersonID = Header.SupplierId, DealQty = line.DealQty
});
RefIds.Add(new LineReferenceIds {
LineId = line.PurchaseInvoiceLineId, RefLineId = line.PurchaseGoodsReceiptLineId
});
pk++;
}
}
int[] RecLineIds = null;
RecLineIds = RefIds.Select(m => m.RefLineId).ToArray();
var temp = (from p in db.PurchaseGoodsReceiptLine
where RecLineIds.Contains(p.PurchaseGoodsReceiptLineId)
join t in db.PurchaseOrderLine on p.PurchaseOrderLineId equals t.PurchaseOrderLineId
join LineCharge in db.PurchaseOrderLineCharge on p.PurchaseOrderLineId equals LineCharge.LineTableId
join HeaderCharge in db.PurchaseOrderHeaderCharges on t.PurchaseOrderHeaderId equals HeaderCharge.HeaderTableId
group new { p, LineCharge, HeaderCharge } by new { p.PurchaseGoodsReceiptLineId } into g
select new
{
LineId = g.Key.PurchaseGoodsReceiptLineId,
HeaderCharges = g.Select(m => m.HeaderCharge).ToList(),
Linecharges = g.Select(m => m.LineCharge).ToList(),
}).ToList();
var temp2 = (from p in LineList
join t in RefIds on p.LineTableId equals t.LineId
join t2 in temp on t.RefLineId equals t2.LineId into table
from LineLis in table.DefaultIfEmpty()
orderby p.LineTableId
select new LineDetailListViewModel
{
Amount = p.Amount,
DealQty = p.DealQty,
HeaderTableId = p.HeaderTableId,
LineTableId = p.LineTableId,
PersonID = p.PersonID,
Rate = p.Rate,
RLineCharges = (LineLis == null ? null : Mapper.Map <List <LineChargeViewModel> >(LineLis.Linecharges)),
}).ToList();
new ChargesCalculationService(_unitOfWork).CalculateCharges(temp2, vm.PurchaseInvoiceLineViewModel.FirstOrDefault().PurchaseInvoiceHeaderId, CalculationId, MaxLineId, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.PurchaseInvoiceHeaderCharges", "Web.PurchaseInvoiceLineCharges", out PersonCount, Header.DocTypeId, Header.SiteId, Header.DivisionId);
//Saving Charges
foreach (var item in LineCharges)
{
PurchaseInvoiceLineCharge PoLineCharge = Mapper.Map <LineChargeViewModel, PurchaseInvoiceLineCharge>(item);
PoLineCharge.ObjectState = Model.ObjectState.Added;
db.PurchaseInvoiceLineCharge.Add(PoLineCharge);
//new PurchaseInvoiceLineChargeService(_unitOfWork).Create(PoLineCharge);
}
//Saving Header charges
for (int i = 0; i < HeaderCharges.Count(); i++)
{
if (!HeaderChargeEdit)
{
PurchaseInvoiceHeaderCharge POHeaderCharge = Mapper.Map <HeaderChargeViewModel, PurchaseInvoiceHeaderCharge>(HeaderCharges[i]);
POHeaderCharge.HeaderTableId = vm.PurchaseInvoiceLineViewModel.FirstOrDefault().PurchaseInvoiceHeaderId;
POHeaderCharge.PersonID = Header.SupplierId;
POHeaderCharge.ObjectState = Model.ObjectState.Added;
//new PurchaseInvoiceHeaderChargeService(_unitOfWork).Create(POHeaderCharge);
db.PurchaseInvoiceHeaderCharge.Add(POHeaderCharge);
}
else
{
var footercharge = new PurchaseInvoiceHeaderChargeService(_unitOfWork).Find(HeaderCharges[i].Id);
footercharge.Rate = HeaderCharges[i].Rate;
footercharge.Amount = HeaderCharges[i].Amount;
footercharge.ObjectState = Model.ObjectState.Modified;
db.PurchaseInvoiceHeaderCharge.Add(footercharge);
//new PurchaseInvoiceHeaderChargeService(_unitOfWork).Update(footercharge);
}
}
new PurchaseOrderLineStatusService(_unitOfWork).UpdatePurchaseQtyInvoiceMultiple(LineStatus, Header.DocDate, ref db);
if (Header.Status != (int)StatusConstants.Drafted)
{
Header.Status = (int)StatusConstants.Modified;
Header.ModifiedBy = User.Identity.Name;
Header.ModifiedDate = DateTime.Now;
Header.ObjectState = Model.ObjectState.Modified;
db.PurchaseInvoiceHeader.Add(Header);
}
try
{
PurchaseInvoiceDocEvents.onLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseInvoiceLineViewModel.FirstOrDefault().PurchaseInvoiceHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
EventException = true;
}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
//_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Results", vm));
}
try
{
PurchaseInvoiceDocEvents.afterLineSaveBulkEvent(this, new PurchaseEventArgs(vm.PurchaseInvoiceLineViewModel.FirstOrDefault().PurchaseInvoiceHeaderId), ref db);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.PurchaseInvoiceHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
