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