public static SerialDto NextSerialDto(int vid, KontoContext db)
{
int bid = 0;
if (SysParameter.Branch_Wise_Voucher)
{
bid = KontoGlobals.BranchId;
}
SerialDto serialno = null;
serialno = db.Database.SqlQuery <SerialDto>(
"dbo.GenerateSerialNumberSp @voucherid={0},@Companyid={1},@FiscalYearId={2},@BranchId={3}",
vid, KontoGlobals.CompanyId, KontoGlobals.YearId, bid).FirstOrDefault();
return(serialno);
}
public static string NextSerialNo(int vid, int isNew = 0)
{
int bid = 0;
if (SysParameter.Branch_Wise_Voucher)
{
bid = KontoGlobals.BranchId;
}
SerialDto serialno = null;
using (var db = new KontoContext())
{
serialno = db.Database.SqlQuery <SerialDto>(
"dbo.GenerateSerialNumberSp @voucherid={0},@Companyid={1},@FiscalYearId={2},@BranchId={3},@IsNew={4}",
vid, KontoGlobals.CompanyId, KontoGlobals.YearId, bid, isNew).FirstOrDefault();
}
return(serialno.SerialNumber);
}
