public string InsertBillTagingJournalVoucherDetails(Accountsmodel accmodel, string finyr, string userid, string xml, string costcenter, string gstdetail)
{
string flag = string.Empty;
string VoucherNo = string.Empty;
string Voucherdetails = string.Empty;
string sql = "EXEC [SP_ACC_VOUCHER] '" + accmodel.vouchertypeid + "','" + accmodel.vouchertypename + "','" + accmodel.BRID + "','" + accmodel.BRNAME + "','" + accmodel.paymentmode + "','" + accmodel.voucherdate + "','" + finyr + "','" + accmodel.narration + "','" + userid + "','" + accmodel.mode + "','" + accmodel.accid + "','" + xml + "','" + accmodel.isvoucherappliocable + "','" + "" + "','" + costcenter + "','" + accmodel.isfrompage + "','" + gstdetail + "','" + accmodel.billno + "','" + accmodel.billdate + "','" + accmodel.grnno + "','" + accmodel.grdate + "','" + accmodel.vehicleno + "','" + accmodel.transport + "','" + accmodel.waybillno + "','" + accmodel.waybilldate + "', @p_OnlyBillTagFromPage='" + accmodel.billtargetfrompage + "', @p_DrCr= '" + accmodel.drcrtds + "',@p_GSTVoucherType='" + accmodel.gstvpuchertypeid + "'";
Voucherdetails = (string)db.GetSingleValue(sql);
return(Voucherdetails);
}
public List <messageresponse> vouchersave(Accountsmodel accmodel, string finyr, string userid, string xml, string costcenter, string gstdetail)
{
List <messageresponse> response = new List <messageresponse>();
response = _db.Query <messageresponse>("SP_ACC_VOUCHERV2",
new
{
p_VoucherTypeId = accmodel.vouchertypeid,
p_VoucherTypeName = accmodel.vouchertypename,
p_BranchId = accmodel.BRID,
p_BranchName = accmodel.BRNAME,
p_PayementMode = accmodel.paymentmode,
p_VoucherDate = accmodel.voucherdate,
p_Finyear = finyr,
p_Narration = accmodel.narration,
p_CREATEDBY = userid,
p_FLAG = accmodel.mode,
p_AccEntryID = accmodel.accid,
p_VoucherDetails = xml,
p_ISVOUCHERAPPROVED = accmodel.isvoucherappliocable,
p_InvoiceVoucherDetails = "",
p_CostCenterDetails = costcenter,
p_ISFROMPAGE = accmodel.isfrompage,
p_InvoiceDebitInvoice = gstdetail,
p_BILLNO = accmodel.billno,
p_BILLDATE = accmodel.billdate,
p_GRNO = accmodel.grnno,
p_GRDATE = accmodel.grdate,
p_VECHILENO = accmodel.vehicleno,
p_TRANSPORT = accmodel.transport,
p_WAYBILLNO = accmodel.waybillno,
p_WAYBILLDATE = accmodel.waybilldate,
p_OnlyBillTagFromPage = accmodel.billtargetfrompage,
p_DrCr = accmodel.drcrtds,
p_GSTVoucherType = accmodel.gstvpuchertypeid,
p_Ismtclaim = accmodel.mtclaim
}, commandType: CommandType.StoredProcedure).ToList();
return(response);
}
