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); }