public List <Product> GetAll(int type)
{
if (type == 0)
{
return(service.GetAll(a => a.IsActive == true).ToList());
}
//return service.GetAll();
return(service.GetAll(a => a.IsActive == true && a.ProductTypeId == type).ToList());
}
public List <TempSalesMaster> GetUnAurhorizedSales()
{
try
{
return(serviceTempSalesMaster.GetAll(a => a.IsActive == true).ToList());
}
catch (Exception)
{
return(new List <TempSalesMaster>());
}
}
public bool Save(List <StockOutRequest> stockOuts, string invoiceNo, string Notes)
{
var balance = 0.0m;
var inventoryLists = stockOuts.Select(a => a.InventoryId).ToList();
var existingItem = inventory.GetAll(a => inventoryLists.Contains(a.Id) && a.IsActive == true).ToList();
if (existingItem.Count > 0)
{
var stocks = new List <StockOut>();
foreach (var inv in existingItem)
{
var qty = stockOuts.Where(a => a.InventoryId == inv.Id).Sum(a => a.Qty);
var stock = new StockOut()
{
AlreadyProcessed = false,
BaleQty = qty,
ProductId = inv.ProductId,
IsActive = true,
InvoiceNo = invoiceNo,
Notes = Notes,
SupplierId = inv.SupplierId,
WarehouseId = inv.WarehouseId,
CreatedBy = CurrentSession.GetCurrentSession().UserName,
CreatedDate = DateTime.Now,
SizeId = inv.SizeId,
SizeName = inv.Size.Name,
BrandId = inv.BrandId,
BrandName = inv.Brand.BrandName,
APIId = inv.APIId,
InventoryId = inv.Id,
Rate = inv.PurchasePrice,
StockOutPrice = inv.PurchasePrice * qty,
ProductionDate = DateTime.Now
};
inv.UpdatedDate = DateTime.Now;
inv.UpdatedBy = CurrentSession.GetCurrentSession().UserName;
inv.ProductionOut += qty;
inv.BalanceQty = inv.BalanceQty - qty;
balance = inv.BalanceQty;
inventory.Update(inv, inv.Id);
stocks.Add(stock);
var invTransaction = new InventoryTransaction()
{
APIId = stock.APIId,
BalanceQty = balance,
BrandId = stock.BrandId,
CreatedBy = CurrentSession.GetCurrentSession().UserName,
CreatedDate = DateTime.Now,
GoodsType = "Finished Goods",
InventoryGuid = Guid.NewGuid().ToString(),
InvoiceNo = "",
IsActive = true,
ProductId = stock.ProductId ?? 0,
PurchasePrice = 0,
Qty = stock.BaleQty,
SalesPrice = 0,
SizeId = stock.SizeId,
SupplierId = stock.SupplierId ?? 0,
TransactionType = (int)Util.TransactionType.ProductionOut,
WarehouseId = stock.WarehouseId ?? 0
};
_invTransactionService.Save(invTransaction);
}
service.Save(stocks);
return(true);
}
else
{
return(false);
}
}
public List <Employee> GetAll()
{
return(service.GetAll(a => a.IsActive == true).ToList());
}
public List <Brand> GetAll()
{
return(service.GetAll());
}
public List <SalesDelivery> GetAll()
{
return(service.GetAll());
}
public List <PartyAgeingReportResponse> AgeingReportSummary(DateTime fromDate, DateTime toDate)
{
List <PartyAgeingReportResponse> ageingReport = new List <PartyAgeingReportResponse>();
var customers = _customerService.GetAll().ToList();
var ids = customers.Select(a => a.LedgerId);
var list = service.GetAll(a => ids.Contains(a.LedgerId) && a.FinancialYearId == yearId).ToList();
//firstSlab
int i = 0;
foreach (var item in customers)
{
i++;
DateTime fDate = fromDate;
DateTime tDate = toDate;
PartyAgeingReportResponse customerWiseAgeing = new PartyAgeingReportResponse();
customerWiseAgeing.SI = i;
customerWiseAgeing.PartyName = item.Name;
//total Receivable
var transactions = list.Where(a => a.LedgerId == item.LedgerId).ToList();
if (transactions != null)
{
var credit = transactions.Sum(a => a.Credit ?? 0);
var debit = transactions.Sum(a => a.Debit ?? 0);
customerWiseAgeing.Receivable = Math.Abs(credit - debit);
customerWiseAgeing.ReceivableWithType = credit > debit ? customerWiseAgeing.Receivable + "Cr" : customerWiseAgeing.Receivable + "Dr";
}
//upto 0-30 Receivable
tDate = fDate.AddDays(-30);
var uppTo30Days = transactions.Where(a => a.PostingDate.Value.Date <fDate.Date && a.PostingDate.Value.Date> tDate.Date).ToList();
if (uppTo30Days != null)
{
var credit = uppTo30Days.Sum(a => a.Credit ?? 0);
var debit = uppTo30Days.Sum(a => a.Debit ?? 0);
customerWiseAgeing.FirstSlab = Math.Abs(credit - debit);
customerWiseAgeing.FirstSlabWithType = credit > debit ? customerWiseAgeing.Receivable + "Cr" : customerWiseAgeing.Receivable + "Dr";
}
//upto 30-60 Receivable
fDate = tDate;
tDate = fDate.AddDays(-30);
var uppTo60Days = transactions.Where(a => a.PostingDate.Value.Date <fDate.Date && a.PostingDate.Value.Date> tDate.Date).ToList();
if (uppTo60Days != null)
{
var credit = uppTo60Days.Sum(a => a.Credit ?? 0);
var debit = uppTo60Days.Sum(a => a.Debit ?? 0);
customerWiseAgeing.SecondSlab = Math.Abs(credit - debit);
customerWiseAgeing.SecondSlabWithType = credit > debit ? customerWiseAgeing.Receivable + "Cr" : customerWiseAgeing.Receivable + "Dr";
}
//upto 61-90 Receivable
fDate = tDate;
tDate = fDate.AddDays(-30);
var uppTo90Days = transactions.Where(a => a.PostingDate.Value.Date <fDate.Date && a.PostingDate.Value.Date> tDate.Date).ToList();
if (uppTo90Days != null)
{
var credit = uppTo90Days.Sum(a => a.Credit ?? 0);
var debit = uppTo90Days.Sum(a => a.Debit ?? 0);
customerWiseAgeing.ThirdSlab = Math.Abs(credit - debit);
customerWiseAgeing.ThirdSlabWithType = credit > debit ? customerWiseAgeing.Receivable + "Cr" : customerWiseAgeing.Receivable + "Dr";
}
//upto 90-180 Receivable
fDate = tDate;
tDate = fDate.AddDays(-90);
var uppTo180Days = transactions.Where(a => a.PostingDate.Value.Date <fDate.Date && a.PostingDate.Value.Date> tDate.Date).ToList();
if (uppTo180Days != null)
{
var credit = uppTo180Days.Sum(a => a.Credit ?? 0);
var debit = uppTo180Days.Sum(a => a.Debit ?? 0);
customerWiseAgeing.FourthSlab = Math.Abs(credit - debit);
customerWiseAgeing.FourthSlabWithType = credit > debit ? customerWiseAgeing.Receivable + "Cr" : customerWiseAgeing.Receivable + "Dr";
}
//upto 180 and above Receivable
fDate = tDate;
var restOf = transactions.Where(a => a.PostingDate.Value.Date < fDate.Date).ToList();
if (restOf != null)
{
var credit = restOf.Sum(a => a.Credit ?? 0);
var debit = restOf.Sum(a => a.Debit ?? 0);
customerWiseAgeing.FourthSlab = Math.Abs(credit - debit);
customerWiseAgeing.FourthSlabWithType = credit > debit ? customerWiseAgeing.Receivable + "Cr" : customerWiseAgeing.Receivable + "Dr";
}
ageingReport.Add(customerWiseAgeing);
}
return(ageingReport);
}
public List <Size> GetAll()
{
return(service.GetAll());
}
public ReceiveMaster Save(ReceiveMaster cus, List <AdditionalCost> additionalCosts, int wareHouseId, int goodsType)
{
var avgAdditionalCost = cus.AdditionalCost / cus.ReceiveDetails.Select(a => a.Qty).Sum();
var avgCostPrice = 0.0m;
var supplier = supplierService.GetById(cus.SupplierID);
cus.YearId = financialYearId;
var result = service.Save(cus);
if (result != null || result.Id > 0)
{
foreach (var item in cus.ReceiveDetails)
{
var balance = 0.0m;
var existingItem = _inventoryService.GetAll(a => a.ProductId == item.ProductId && a.IsActive == true && a.WarehouseId == wareHouseId && a.SizeId == item.SizeId && a.BrandId == item.BrandId && a.APIId == item.APIId).ToList();
if (existingItem.Count > 0)
{
foreach (var inv in existingItem)
{
var existingCosting = inv.BalanceQty * inv.Costprice ?? 0;
var totalAmount = item.Amount + avgAdditionalCost * item.Qty + existingCosting;
avgCostPrice = totalAmount / (item.Qty + inv.BalanceQty);
inv.Costprice = avgCostPrice;
inv.PurchasePrice = item.Rate;
inv.UpdatedDate = DateTime.Now;
inv.UpdatedBy = "";
inv.BalanceQty = inv.BalanceQty + item.Qty;
inv.ReceiveQty = inv.ReceiveQty ?? 0 + item.Qty;
_inventoryService.Update(inv, inv.Id);
balance = inv.BalanceQty;
}
}
else
{
Inventory inv = new Inventory();
inv.IsActive = true;
inv.CreatedDate = DateTime.Now;
inv.CreatedBy = "";
inv.ProductId = item.ProductId;
inv.ReceiveQty = item.Qty;
inv.SupplierId = cus.SupplierID;
inv.WarehouseId = wareHouseId;
inv.BrandId = item.BrandId;
inv.SizeId = item.SizeId;
inv.APIId = item.APIId;
inv.Faulty = 0;
inv.OpeningQty = 0;
inv.BalanceQty = item.Qty;
inv.PurchasePrice = item.Rate;
inv.Costprice = avgCostPrice;
inv.SalesPrice = 0;
inv.GoodsType = goodsType.ToString();
_inventoryService.Save(inv);
balance = item.Qty;
}
var invTransaction = new InventoryTransaction()
{
APIId = item.APIId,
BalanceQty = balance,
BrandId = item.BrandId,
CreatedBy = CurrentSession.GetCurrentSession().UserName,
CreatedDate = DateTime.Now,
GoodsType = goodsType.ToString(),
InventoryGuid = Guid.NewGuid().ToString(),
InvoiceNo = cus.InvoiceNo,
IsActive = true,
ProductId = item.ProductId,
PurchasePrice = item.Rate,
CostPrice = avgCostPrice,
Qty = item.Qty,
SalesPrice = 0,
SizeId = item.SizeId,
SupplierId = cus.SupplierID,
TransactionType = (int)Util.TransactionType.ReceiveQty,
WarehouseId = item.WarehouseId ?? 0
};
_invTransactionService.Save(invTransaction);
}
// Ledger posting debit to purchase account
var ledgerObj = new LedgerPosting();
ledgerObj.VoucherTypeId = (int)VoucherTypeEnum.PurchaseInvoice;
ledgerObj.VoucherNo = result.InvoiceNoPaper;
ledgerObj.PostingDate = cus.InvoiceDate;
ledgerObj.LedgerId = (int)DefaultLedger.PurchaseAccount;
ledgerObj.InvoiceNo = cus.InvoiceNo;
ledgerObj.Credit = 0;
ledgerObj.Debit = cus.GrandTotal;
ledgerObj.MasterId = result.Id;
var save = ledgerService.Save(ledgerObj);
//Ledger posting to customer ledger credit
var detailsLedger = new LedgerPosting();
detailsLedger.VoucherTypeId = (int)VoucherTypeEnum.PurchaseInvoice;
detailsLedger.VoucherNo = result.InvoiceNoPaper;
detailsLedger.PostingDate = cus.InvoiceDate;
detailsLedger.LedgerId = supplier.LedgerId;
detailsLedger.InvoiceNo = cus.InvoiceNo;
detailsLedger.Credit = cus.TotalAmount - cus.BillDiscount;
detailsLedger.Debit = 0;
detailsLedger.MasterId = result.Id;
var detailsLedgerResult = ledgerService.Save(detailsLedger);
//save addisitonalCost
if (additionalCosts != null && additionalCosts.Count > 0)
{
foreach (var item in additionalCosts)
{
item.CreatedBy = CurrentSession.GetCurrentSession().UserId;
item.CreatedDate = DateTime.Now;
item.LedgerId = supplier.LedgerId;
item.VoucherNo = cus.InvoiceNo;
item.Extra1 = cus.AdditionalCostPurpose;
item.VoucherTypeId = (int)VoucherTypeEnum.PurchaseInvoice;
var isSaved = _addCostService.Save(item);
}
//
var additionalCost = new LedgerPosting();
additionalCost.VoucherTypeId = (int)VoucherTypeEnum.AdditionalCost;
additionalCost.VoucherNo = result.InvoiceNoPaper;
additionalCost.PostingDate = cus.InvoiceDate;
additionalCost.LedgerId = (int)DefaultLedger.AdditionalCost;
additionalCost.InvoiceNo = cus.InvoiceNo;
additionalCost.Credit = cus.AdditionalCost;
additionalCost.Debit = 0;
additionalCost.MasterId = result.Id;
var _ = ledgerService.Save(additionalCost);
}
var party = new PartyBalance();
party.InvoiceNo = result.InvoiceNo;
party.LedgerId = supplier.LedgerId ?? 0;
party.Credit = cus.TotalAmount - cus.BillDiscount;
party.CreditPeriod = 60;
party.Debit = 0;
party.MasterId = result.Id;
party.FinancialYearId = CurrentSession.GetCurrentSession().FinancialYear;
party.PostingDate = cus.InvoiceDate;
party.VoucherTypeId = (int)VoucherTypeEnum.PurchaseInvoice;
party.VoucherNo = result.InvoiceNo;
party.extra1 = "Purchase Invoice: " + cus.InvoiceNo + " Paper Invoice No:" + cus.InvoiceNoPaper;
party.extra2 = result.Id.ToString();
partyBalanceService.Save(party);
}
return(cus);
}
public List <ReceiveMaster> GetAll()
{
return(service.GetAll());
}
public int Delete(ReceiveMaster master)
{
try
{
var salesdetails = serviceDetails.GetAll(a => a.ReceiveMasterId == master.Id).ToList();
foreach (var item in salesdetails)
{
try
{
var isdetails = new DBService <ReceiveDetail>().Delete(item.Id);
}
catch (Exception ex)
{
}
}
var isDeleted = service.Delete(master.Id);
foreach (var item in master.ReceiveDetails)
{
var existingItem = _inventoryService.GetAll(a => a.ProductId == item.ProductId && a.IsActive == true && a.WarehouseId == item.WarehouseId).ToList();
if (existingItem.Count > 0)
{
foreach (var inv in existingItem)
{
inv.UpdatedDate = DateTime.Now;
inv.UpdatedBy = "";
inv.BalanceQty = inv.BalanceQty - item.Qty;
inv.ReceiveQty = inv.ReceiveQty ?? 0 - item.Qty;
_inventoryService.Update(inv, inv.Id);
}
}
}
var supplier = supplierService.GetById(master.SupplierID);
foreach (LedgerPosting item in this.ledgerService.GetAllByInvoice(master.InvoiceNo, true))
{
item.IsActive = false;
this.ledgerService.Update(item, item.Id);
}
PartyBalanceService partyBalanceService = this.partyBalanceService;
int? ledgerId = supplier.LedgerId;
PartyBalance paymentObj = partyBalanceService.GetByInvoiceNo(supplier.LedgerId ?? 0, master.InvoiceNo);
this.partyBalanceService.Delete(paymentObj.PartyBalanceId);
// Ledger Saves credit
//var ledgerObj = new LedgerPosting();
//ledgerObj.VoucherTypeId = (int)VoucherType.PurchaseInvoice;
//ledgerObj.VoucherNo = master.InvoiceNoPaper;
//ledgerObj.PostingDate = master.InvoiceDate;
//ledgerObj.LedgerId = (int)DefaultLedger.PurchaseAccount;
//ledgerObj.InvoiceNo = master.InvoiceNo;
//ledgerObj.Debit = 0;
//ledgerObj.Credit = master.GrandTotal;
//ledgerObj.Extra1 = "Purchase Invoice Deleted: " + master.InvoiceNo;
//var save = ledgerService.Save(ledgerObj);
//Ledger posting to customer ledger credit
//var detailsLedger = new LedgerPosting();
//detailsLedger.VoucherTypeId = (int)VoucherType.PurchaseInvoice;
//detailsLedger.VoucherNo = master.InvoiceNoPaper;
//detailsLedger.PostingDate = master.InvoiceDate;
//detailsLedger.LedgerId = supplier.LedgerId;
//detailsLedger.InvoiceNo = master.InvoiceNo;
//detailsLedger.Debit = master.GrandTotal;
//detailsLedger.Credit = 0;
//detailsLedger.Extra1 = "Purchase Invoice Deleted: " + master.InvoiceNo;
//var detailsLedgerResult = ledgerService.Save(detailsLedger);
//var party = new PartyBalance();
//party.InvoiceNo = master.InvoiceNo;
//party.LedgerId = supplier.LedgerId ?? 0;
//party.Debit = master.GrandTotal;
//party.CreditPeriod = 60;
//party.Credit = 0;
//party.FinancialYearId =CurrentSession.GetCurrentSession().FinancialYear;
//party.PostingDate = master.InvoiceDate;
//party.VoucherTypeId = (int)VoucherType.PurchaseInvoice;
//party.extra1 = "Purchase Invoice Deleted: " + master.InvoiceNo;
//partyBalanceService.Save(party);
return(1);
}
catch (Exception ex)
{
return(0);
}
}
public List <SalaryPackageResponse> GetAllPackage()
{
var payHeads = _salaryPackageservice.GetAll();
return(AutoMapper.Mapper.Map <List <SalaryPackageResponse> >(payHeads));
}
public List <PayHeadViewModel> GetAll()
{
var payHeads = service.GetAll();
return(AutoMapper.Mapper.Map <List <PayHeadViewModel> >(payHeads));
}
public List <Department> GetAll()
{
return(service.GetAll().ToList());
}
public List <Picture> GetAll()
{
return(service.GetAll());
}
public List <RoleWiseScreenPermission> GetRoleWiseService()
{
return(roleService.GetAll());
}
public List <AccountLedger> GetAll()
{
return(service.GetAll().ToList());
}
public List <Tax> GetAll()
{
return(service.GetAll());
}
public StockIn Save(StockIn stockIn)
{
var balance = 0.0m;
var existingItem = inventory.GetAll(a => a.ProductId == stockIn.ProductId && a.BrandId == stockIn.BrandId && a.SizeId == stockIn.SizeId && a.APIId == stockIn.APIId && a.IsActive == true && a.WarehouseId == stockIn.WarehouseId).ToList();
if (existingItem.Count > 0)
{
foreach (var inv in existingItem)
{
inv.UpdatedDate = DateTime.Now;
inv.UpdatedBy = "";
inv.BalanceQty = inv.BalanceQty + stockIn.BaleQty ?? 0;
inv.ProductionIn = inv.ProductionIn ?? 0 + stockIn.BaleQty ?? 0;
inventory.Update(inv, inv.Id);
balance = inv.BalanceQty;
}
}
else
{
Inventory result = new Inventory();
Inventory FinalResult = new Inventory();
result.ProductId = (int)stockIn.ProductId;
result.SupplierId = stockIn.SupplierId ?? 0;
result.WarehouseId = (int)stockIn.WarehouseId;
result.ProductionIn = stockIn.BaleQty;
result.PurchasePrice = stockIn.Rate;
result.BrandId = stockIn.BrandId;
result.SizeId = stockIn.SizeId;
result.BalanceQty = stockIn.BaleQty ?? 0;
result.Notes = stockIn.Notes;
result.GoodsType = "2";
result.CreatedBy = CurrentSession.GetCurrentSession().UserName;
result.CreatedDate = DateTime.Now;
result.IsActive = true;
FinalResult = inventory.Save(result);
balance = result.BalanceQty;
}
var invTransaction = new InventoryTransaction()
{
APIId = stockIn.APIId,
BalanceQty = balance,
BrandId = stockIn.BrandId,
CreatedBy = CurrentSession.GetCurrentSession().UserName,
CreatedDate = DateTime.Now,
GoodsType = "Finished Goods",
InventoryGuid = Guid.NewGuid().ToString(),
InvoiceNo = "",
IsActive = true,
ProductId = stockIn.ProductId ?? 0,
PurchasePrice = stockIn.Rate,
Qty = stockIn.BaleQty,
SalesPrice = 0,
SizeId = stockIn.SizeId,
SupplierId = stockIn.SupplierId ?? 0,
TransactionType = (int)Util.TransactionType.ProductionIn,
WarehouseId = stockIn.WarehouseId ?? 0
};
_invTransactionService.Save(invTransaction);
return(service.Save(stockIn));
}
public List <LedgerPosting> GetAll()
{
return(service.GetAll().ToList());
}
public List <PartyBalance> GetAll()
{
return(service.GetAll(a => a.FinancialYearId == yearId).ToList());
}
public List <PaymentMaster> GetAllPendingPayment()
{
return(_paymentMaster.GetAll(a => a.IsApproved == false).ToList());
}
public List <Supplier> GetAll()
{
//return service.GetAll();
return(service.GetAll(a => a.IsActive == true).ToList());
}
public List <BonusDeduction> GetAll(int year, int month)
{
return(service.GetAll(a => a.Year == year && a.Month == month).ToList());
}
public List <AccountGroup> GetAll()
{
return(service.GetAll().ToList());
}
public List <Category> GetAll()
{
return(service.GetAll(a => a.IsActive == true).ToList());
}
public List <StockOut> GetAll()
{
return(service.GetAll());
}
public List <Company> GetAll()
{
return(service.GetAll());
}
public List <WareHouse> GetAll()
{
//return service.GetAll();
return(service.GetAll(a => a.IsActive == true).ToList());
}
public List <User> GetAll()
{
return(service.GetAll());
}