public GrnMM DeleteStockDespatch(string stockreceivedid) { GrnMM grnMM = new GrnMM(); try { grnMM = _db.QueryFirstOrDefault <GrnMM>("USP_STOCK_RECEIVED_DELETE_V2", new { p_RECEIVEDID = stockreceivedid, }, commandType: CommandType.StoredProcedure); } catch (Exception ex) { } return(grnMM); }
public List <MessageModel> GrnMMInsertUpdate(GrnMM grnMM, DataTable dtTaxDetails, DataTable dtTaxRejection, DataTable dtRejTax, DataTable dtSample, DataTable dtSampleQty) { DataTable dtDetails; dtDetails = Grnformdtl(grnMM.grnOrderdetails); GrnMM grnmodel = new GrnMM(); List <MessageModel> response = new List <MessageModel>(); try { response = _db.Query <MessageModel>("SP_GRN_INSERT_UPDATE_MMPP_V2", new { p_RECEIVEDID = grnMM.RECEIVEDID, p_DESPATCHID = grnMM.DESPATCHID, p_FLAG = "A", p_RECEIVEDDATE = grnMM.DESPATCHDATE, p_TPUID = grnMM.VENDORID, p_TPUNAME = grnMM.VENDORNAME, p_WAYBILLNO = grnMM.WAYBILLKEY, p_INVOICENO = grnMM.INVOICENO, p_INVOICEDATE = grnMM.INVOICEDATE, p_TRANSPORTERID = grnMM.TRANSPORTERID, p_VEHICLENO = grnMM.VEHICLENO, p_MOTHERDEPOTID = grnMM.DEPOTID, p_MOTHERDEPOTNAME = grnMM.DEPOTNAME, p_LRGRNO = grnMM.LRGRNO, p_LRGRDATE = grnMM.LRGRDATE, p_MODEOFTRANSPORT = grnMM.MODEOFTRANSPORT, p_CFORMNO = "", p_CFORMDATE = "", p_GATEPASSNO = grnMM.GATEPASSNO, p_GATEPASSDATE = grnMM.GATEPASSDATE, p_FORMFLAG = "N", p_CREATEDBY = grnMM.Createdby, p_FINYEAR = grnMM.FINYEAR, p_REMARKS = grnMM.REMARKS, p_TOTALDESPATCHVALUE = grnMM.DESPATCHQTY, p_OTHERCHARGESVALUE = grnMM.OTHCHARGEAMT, p_ADJUSTMENTVALUE = grnMM.ADDITIONALCOST, p_ROUNDOFFVALUE = grnMM.ROUNDOFF, p_TERMSID = "", P_DespatchDetails = dtDetails.AsTableValuedParameter("TYPEGrnformdtl"), P_ItemWiseTaxDetails = dtTaxDetails.AsTableValuedParameter("TAXDETAILS_GRN_MM"), P_RejectionDetails = dtTaxRejection.AsTableValuedParameter("REJECTIONDETAILS__MM"), p_ADDNAMOUNT = grnMM.ADDITIONALCOST, p_INSURANCECOMPID = "", p_INSURANCECOMPNAME = "", p_INSURANCENUMBER = "", P_MODULEID = grnMM.MODULEID, P_INVOICETYPE = grnMM.INVOICETYPE, P_ISVERIFIEDCHECKER1 = grnMM.ISVERIFIEDCHECKER1, P_ISVERIFIEDSTOCKIN = grnMM.ISVERIFIEDSTOCKIN, p_RejectionTaxDetails = dtRejTax.AsTableValuedParameter("REJTAXDETAILS_GRN_MM"), P_TOTALITEMWISEFREIGHT = grnMM.TOTALITEMWISEFREIGHT, P_TOTALITEMWISEADDCOST = grnMM.TOTALITEMWISEADDCOST, P_TOTALITEMWISEDISCOUNT = grnMM.TOTALITEMWISEDISCOUNT, P_LEDGERID = grnMM.LEDGERID, p_WAYBILLDT = grnMM.WAYBILLDT, P_CAPACITYUPLOAD = grnMM.CAPACITYUPLOAD, P_VENDORFROM = grnMM.VENDORFROM, P_GRN = "Y", @P_SampleQty = dtSample.AsTableValuedParameter("STOCKRECEIVED_SAMPLEQTY"), @P_SampleQtyFileUpload = dtSampleQty.AsTableValuedParameter("UPLOADCAPACITYFILE") }, commandType: CommandType.StoredProcedure).ToList(); } catch (Exception ex) { throw ex; } return(response); }