public Prq_SupplierBillItem ConvertItem(PrqSupplierBillItem model, long billId, int userId)
{
var entity = model.BillItemID == 0
? new Prq_SupplierBillItem()
: (from b in _context.Prq_SupplierBillItem.AsEnumerable()
where b.BillItemID == model.BillItemID
select b).FirstOrDefault();
entity.SupplierBillID = billId;
entity.BillItemID = model.BillItemID;
entity.ItemType = model.ItemTypeID;
entity.ItemSize = model.ItemSizeID;
entity.ItemQty = model.ItemQty;
entity.RejectQty = model.RejectQty ?? 0;
entity.ItemRate = model.ItemRate;
entity.ApproveRate = model.ApproveRate;
entity.Amount = model.Amount;
entity.AmtUnit = model.AmtUnit;
entity.AvgArea = model.AvgArea;
entity.AreaUnit = model.AreaUnit;
entity.Remarks = model.Remarks;
entity.SetOn = model.BillItemID == 0
? DateTime.Now
: _unit.SupplierBillItemRepository.GetByID(model.BillItemID).SetOn;
entity.SetBy = model.BillItemID == 0
? userId
: _unit.SupplierBillItemRepository.GetByID(model.BillItemID).SetBy;
entity.RecordStatus = "NCF";
entity.IsDelete = false;
return(entity);
}
public PrqSupplierBillItem SetToBussinessObject(Prq_SupplierBillItem entity)
{
var model = new PrqSupplierBillItem();
model.SupplierBillID = entity.SupplierBillID;
model.BillItemID = entity.BillItemID;
model.ItemTypeID = entity.ItemType;
model.ItemTypeName =
_context.Sys_ItemType.Where(w => w.ItemTypeID == entity.ItemType).FirstOrDefault().ItemTypeName;
model.ItemSizeID = entity.ItemSize;
model.ItemSizeName = _context.Sys_Size.Where(w => w.SizeID == entity.ItemSize).FirstOrDefault().SizeName;
model.ItemQty = entity.ItemQty;
model.RejectQty = entity.RejectQty;
model.ItemRate = entity.ItemRate;
model.ApproveRate = entity.ApproveRate;
model.Amount = entity.Amount;
model.AmtUnit = entity.AmtUnit ?? 0;
if (entity.AmtUnit != 0)
{
model.AmtUnitName = _context.Sys_Currency.Where(w => w.CurrencyID == entity.AmtUnit).FirstOrDefault().CurrencyName;
}
model.AvgArea = entity.AvgArea;
model.AreaUnit = entity.AreaUnit ?? 0;
if (entity.AreaUnit != 0)
{
model.AreaUnitName = _context.Sys_Unit.Where(w => w.UnitID == entity.AreaUnit).FirstOrDefault().UnitName;
}
model.Remarks = entity.Remarks;
return(model);
}
public ActionResult GetBillById(long billId)
{
var bill = new PrqSupplierBill();
var ritems = new List <PrqSupplierBillItem>();
var rchallans = new List <PrqSupplierBillChallan>();
var supplierBill = _unit.SupplierBillRepository.GetByID(billId);
if (supplierBill != null)
{
bill.SupplierBillID = supplierBill.SupplierBillID;
bill.SupplierBillNo = supplierBill.SupplierBillNo;
bill.SupplierBillRefNo = supplierBill.SupplierBillRefNo;
bill.SupplierID = supplierBill.SupplierID;
bill.SupplierCode = _unit.SysSupplierRepository.GetByID(supplierBill.SupplierID).SupplierCode;
bill.SupplierName = _unit.SysSupplierRepository.GetByID(supplierBill.SupplierID).SupplierName;
bill.SupplierAddressID = supplierBill.SupplierAddressID;
bill.SupplierAddress = _unit.SupplierAddressRepository.GetByID(supplierBill.SupplierAddressID).Address;
bill.PurchaseID = supplierBill.PurchaseID;
bill.PurchaseNo = supplierBill.PurchaseID == null
? ""
: _unit.PrqPurchaseRepository.GetByID(supplierBill.PurchaseID).PurchaseNo;
bill.BillCategory = supplierBill.BillCategory;
bill.BillType = supplierBill.BillType;
bill.BillDate = string.Format("{0:dd/MM/yyyy}", supplierBill.BillDate);
bill.PurchaseYear = supplierBill.PurchaseYear;
bill.Remarks = supplierBill.Remarks;
bill.TotalQty = supplierBill.TotalQty;
bill.TotalRejectQty = supplierBill.TotalRejectQty;
bill.AvgPrice = supplierBill.ApprovedPrice;
bill.ApprovedPrice = supplierBill.ApprovedPrice;
bill.OtherCost = supplierBill.OtherCost;
bill.DiscountAmt = supplierBill.DiscountAmt;
bill.DiscountPercent = supplierBill.DiscountPercent;
bill.ApprovedAmt = supplierBill.ApprovedAmt;
bill.TotalAmt = supplierBill.TotalAmt;
bill.PayableAmt = supplierBill.PayableAmt;
bill.CheckComment = supplierBill.CheckComment;
bill.ApproveComment = supplierBill.ApproveComment;
bill.RecordStatus = supplierBill.RecordStatus;
var challans =
_unit.SupplierBillChallanRepository.Get()
.Where(ob => ob.SupplierBillID == supplierBill.SupplierBillID && ob.IsDelete == false)
.ToList();
if (challans.Count > 0)
{
foreach (var c in challans)
{
var rchallan = new PrqSupplierBillChallan();
rchallan.ChallanID = c.ChallanID;
rchallan.ChallanNo = c.S_ChallanRef;
rchallan.ChallanDate = string.Format("{0:dd/MM/yyyy}",
_unit.PrqPurchaseChallanRepo.GetByID(c.ChallanID).ChallanDate);
rchallan.Quantity =
_unit.PurchaseChallanItemRepository.Get()
.Where(ob => ob.ChallanID == c.ChallanID)
.Sum(ob => ob.ChallanQty);
rchallans.Add(rchallan);
}
}
var items =
_unit.SupplierBillItemRepository.Get()
.Where(ob => ob.SupplierBillID == supplierBill.SupplierBillID && ob.IsDelete == false)
.ToList();
if (items.Count > 0)
{
foreach (var item in items)
{
var ritem = new PrqSupplierBillItem();
ritem.BillItemID = item.BillItemID;
ritem.ItemTypeID = item.ItemType;
ritem.ItemTypeName = _unit.SysItemTypeRepository.GetByID(item.ItemType).ItemTypeName;
ritem.ItemSizeID = item.ItemSize;
ritem.ItemSizeName = _unit.SysSizeRepository.GetByID(item.ItemSize).SizeName;
ritem.ItemQty = item.ItemQty;
ritem.RejectQty = item.RejectQty;
ritem.ItemRate = item.ItemRate;
ritem.ApproveRate = item.ApproveRate;
ritem.Amount = item.Amount;
ritem.AmtUnit = item.AmtUnit ?? 0;
ritem.AvgArea = item.AvgArea;
ritem.AreaUnit = item.AreaUnit;
ritem.AreaUnitName = item.AreaUnit == null ? "" : _unit.SysUnitRepository.GetByID(item.AreaUnit).UnitName;
ritem.Remarks = item.Remarks;
ritems.Add(ritem);
}
}
}
return(Json(new { bill, rchallans, ritems }, JsonRequestBehavior.AllowGet));
}