public int GetId()
{
var lastrow = service.LastRow().OrderByDescending(a => a.PartyBalanceId).FirstOrDefault();
if (lastrow == null)
{
return(1);
}
else
{
return(lastrow.PartyBalanceId + 1);
}
}
public LedgerPosting Save(LedgerPosting ledger)
{
var ledgerDetails = ledgerService.GetById(ledger.LedgerId);
// var isExists = service.GetAll().Where(a => a.InvoiceNo == ledger.InvoiceNo && a.LedgerId == ledger.LedgerId).FirstOrDefault();
var max = service.LastRow().OrderByDescending(a => a.Id).FirstOrDefault();
if (max == null)
{
ledger.Id = 1;
}
else
{
ledger.Id = max.Id + 1;
}
if (ledger.VoucherNo == null)
{
ledger.VoucherNo = max.VoucherNo + 1;
}
ledger.YearId = CurrentSession.GetCurrentSession().FinancialYear;
ledger.IsActive = true;
var result = service.Save(ledger);
return(result);
}
public AccountGroup Save(AccountGroup cus)
{
var isExists = service.GetAll().Where(a => a.AccountGroupName == cus.AccountGroupName).FirstOrDefault();
var max = service.LastRow().OrderByDescending(a => a.Id).FirstOrDefault().Id;
cus.Id = max + 1;
if (isExists != null)
{
return(null);
}
service.Save(cus);
return(cus);
}
public LedgerPosting Save(LedgerPosting cus)
{
var isExists = service.GetAll().Where(a => a.LedgerId == cus.LedgerId && a.YearId == cus.YearId).FirstOrDefault();
var max = service.LastRow().OrderByDescending(a => a.Id).FirstOrDefault().Id;
cus.Id = max + 1;
if (isExists != null)
{
return(null);
}
cus.YearId = CurrentSession.GetCurrentSession().FinancialYear;
service.Save(cus);
return(cus);
}
public Supplier Save(Supplier cus)
{
var max = service.LastRow().OrderByDescending(a => a.Id).FirstOrDefault();
if (max == null)
{
cus.Id = 1;
}
else
{
cus.Id = max.Id + 1;
}
return(service.Save(cus));
}
public JournalMaster Save(JournalMaster JMaster)
{
// var ledgerDetails = ledgerService.GetById(ledger.LedgerId);
// var isExists = service.GetAll().Where(a => a.InvoiceNo == ledger.InvoiceNo && a.LedgerId == ledger.LedgerId).FirstOrDefault();
var max = journalMaster.LastRow().OrderByDescending(a => a.Id).FirstOrDefault();
if (max == null)
{
JMaster.Id = 1;
}
else
{
JMaster.Id = max.Id + 1;
}
var financialYear = CurrentSession.GetCurrentSession().FinancialYear;
JMaster.YearId = CurrentSession.GetCurrentSession().FinancialYear;
JMaster.VoucherTypeId = 6;
JMaster.UserId = CurrentSession.GetCurrentSession().UserId;
var result = journalMaster.Save(JMaster);
return(result);
}
public AdditionalCost AddCostSave(AdditionalCost addCost)
{
var isExists = addCostService.GetAll().Where(a => a.VoucherNo == addCost.VoucherNo && a.LedgerId == addCost.LedgerId).FirstOrDefault();
var max = addCostService.LastRow().OrderByDescending(a => a.Id).FirstOrDefault();
if (max == null)
{
addCost.Id = 1;
}
else
{
addCost.Id = max.Id + 1;
}
var result = addCostService.Save(addCost);
return(result);
}
public SalaryPayment Save(SalaryPayment SP)
{
var max = service.LastRow().OrderByDescending(a => a.Id).FirstOrDefault();
SP.VoucherNo = max.VoucherNo;
SP.LedgerId = max.LedgerId;
var Max = salaryPayment.LastRow().OrderByDescending(a => a.Id).FirstOrDefault();
if (Max == null)
{
SP.Id = 1;
}
else
{
SP.Id = max.Id + 1;
}
var result = salaryPayment.Save(SP);
return(result);
}
public JournalDetail Save(JournalDetail JDetails)
{
var max = journalDetails.LastRow().OrderByDescending(a => a.Id).FirstOrDefault();
if (max == null)
{
JDetails.Id = 1;
}
else
{
JDetails.Id = max.Id + 1;
}
int value = int.Parse(journalMaster.LastRow().OrderByDescending(p => p.Id).Select(r => r.Id).First().ToString());
JDetails.JournalMasterId = value;
var result = journalDetails.Save(JDetails);
return(result);
}