public string SaveTransporterbillV2(Transporterbillfac tran, string xml)
{
string transporterbillno = string.Empty;
string sql = string.Empty;
sql = "EXEC SP_TRANSPORTERBILL_INSERT_UPDATE_GST_V2_FAC '" + tran.ID + "','" + tran.Mode + "','" + tran.TransporterID + "','" + tran.TransporterName + "','" + tran.billdate + "','" + tran.billtype + "' ," +
" '" + tran.Remarks + "','" + tran.UserID + "','" + tran.finyear + "','" + xml + "','" + tran.MenuId + "'," + tran.TOTALNETAMOUNT + "," +
" " + tran.TOTALTDS + "," + tran.TOTALGROSSWEIGHT + ",'" + tran.depotid + "','" + tran.depotname + "'," + tran.IsTransferToHO + "," +
" " + tran.TOTALBILLAMOUNT + "," + tran.TOTALTDSDEDUCTABLE + "," + tran.sumcgst + "," + tran.sumsgst + "," + tran.sumigst + "," +
" " + tran.sumugst + ",'" + tran.BILLINGFROMSTATEID + "','" + tran.Reversecharge + "','" + tran.GNGNO + "','" + tran.TDSAPPLICABLE + "', " +
" " + tran.TDSPECENTAGE + ",'" + tran.TDSID + "','" + tran.VIRTUALdepotid + "','" + tran.EXPORTTAG + "','" + tran.ReasonID + "','" + tran.GSTReasonID + "'";
transporterbillno = (string)db.GetSingleValue(sql);
return(transporterbillno);
}
public List <messageresponse> SaveTransporterbillV2(Transporterbillfac trans, string xml)
{
List <messageresponse> response = new List <messageresponse>();
try
{
response = _db.Query <messageresponse>("SP_TRANSPORTERBILL_INSERT_UPDATE_GST_V3",
new
{
p_TRANSPORTERBILLID = trans.ID,
p_FLAG = trans.Mode,
p_TRANSPORTERID = trans.TransporterID,
p_TRANSPORTERNAME = trans.TransporterName,
p_BILLDATE = trans.billdate,
p_BILLTYPEID = trans.billtype,
p_REMARKS = trans.Remarks,
p_CREATEDBY = trans.UserID,
p_FINYEAR = trans.finyear,
p_TransporterBillDetails = xml,
p_MODULEID = trans.MenuId,
p_TOTALNETAMOUNT = trans.TOTALNETAMOUNT,
p_TOTALTDS = trans.TOTALTDS,
p_TOTALGROSSWEIGHT = trans.TOTALGROSSWEIGHT,
p_DEPOTID = trans.depotid,
p_DEPOTNAME = trans.depotname,
p_ISTRANSFERTOHO = trans.IsTransferToHO,
p_TOTALBILLAMOUNT = trans.TOTALBILLAMOUNT,
p_TOTALTDSDEDUCTABLEAMOUNT = trans.TOTALTDSDEDUCTABLE,
p_TOTALCGST = trans.sumcgst,
p_TOTALSGST = trans.sumsgst,
p_TOTALIGST = trans.sumigst,
p_TOTALUGST = trans.sumugst,
p_BILLINGFROMSTATEID = trans.BILLINGFROMSTATEID,
p_REVERSECHARGE = trans.Reversecharge,
p_GNGNO = trans.GNGNO,
p_TDSAPPLICABLE = trans.TDSAPPLICABLE,
p_TDSPECENTAGE = trans.TDSPECENTAGE,
p_TDSID = trans.TDSID,
p_virtualdepotid = trans.VIRTUALdepotid,
p_EXPORTTAG = trans.EXPORTTAG,
p_reasonid = trans.ReasonID,
p_GSTREASONID = trans.GSTReasonID,
}, commandType: CommandType.StoredProcedure).ToList();
}
catch (Exception ex)
{
}
return(response);
}
