public static string ManageLabelPrinting(LabelPrinting o)
{
o = o ?? new LabelPrinting();
string Res = "Error";
try
{
Dictionary <string, string> input = new Dictionary <string, string>()
{
{ "InScanID", o.InScanID ?? "" },
{ "AWBNo", o.AWBNo ?? "" },
{ "InScanDate", o.InScanDate ?? "" },
{ "DepartmentID", o.DepartmentID ?? "" },
{ "ConsigneeID", o.ConsigneeID ?? "" },
{ "ConsignorID", o.ConsignorID ?? "" },
{ "OriginID", o.OriginID ?? "" },
{ "DestinationID", o.DestinationID ?? "" },
{ "CustomerRateTypeID", o.CustomerRateTypeID ?? "" },
{ "Pieces", o.Pieces ?? "" },
{ "StatedWeight", o.StatedWeight ?? "" },
{ "CourierServiceID", o.CourierServiceID ?? "" },
{ "CollectedBy", o.CollectedBy ?? "" },
{ "ReceivedBy", o.ReceivedBy ?? "" },
{ "Remarks", o.Remarks ?? "" },
{ "CourierStatusID", o.CourierStatusID ?? "" },
{ "StatusPaymentMode", o.StatusPaymentMode ?? "" },
{ "StatusClose", o.StatusClose ?? "" },
{ "StatusInScan", o.StatusInScan ?? "" },
{ "StatusReconciled", o.StatusReconciled ?? "" },
{ "InscanSheetNo", o.InscanSheetNo ?? "" },
{ "Volume", o.Volume ?? "" },
{ "VolumeWeight", o.VolumeWeight ?? "" },
{ "StatusOutbound", o.StatusOutbound ?? "" },
{ "ItemID", o.ItemID ?? "" },
{ "StatusTransit", o.StatusTransit ?? "" },
{ "StatusCustomsDocument", o.StatusCustomsDocument ?? "" },
{ "DespatchDate", o.DespatchDate ?? "" },
{ "TDID", o.TDID ?? "" },
{ "Description", o.Description ?? "" },
{ "OriginBranchID", o.OriginBranchID ?? "" },
{ "DestinationBranchID", o.DestinationBranchID ?? "" },
{ "TransitMasterID", o.TransitMasterID ?? "" },
{ "UserID", o.UserID ?? "" },
{ "shipperContactPerson", o.shipperContactPerson ?? "" },
{ "ConsigneeContactPerson", o.ConsigneeContactPerson ?? "" },
{ "AcJournalID", o.AcJournalID ?? "" },
{ "FyearID", o.FyearID ?? "" },
{ "OtherChargeDescription", o.OtherChargeDescription ?? "" },
{ "DeliveryDate", o.DeliveryDate ?? "" },
{ "DeliveredBy", o.DeliveredBy ?? "" },
{ "PODRemarks", o.PODRemarks ?? "" },
{ "DeliveredByID", o.DeliveredByID ?? "" },
{ "AcJournalID2", o.AcJournalID2 ?? "" },
{ "StatusTS", o.StatusTS ?? "" },
{ "EnquiryID", o.EnquiryID ?? "" },
{ "OutScanDate", o.OutScanDate ?? "" },
{ "TakenByID", o.TakenByID ?? "" },
{ "TransitID", o.TransitID ?? "" },
{ "RouteID", o.RouteID ?? "" },
{ "DocumentID", o.DocumentID ?? "" },
{ "ConsigneeDepotID", o.ConsigneeDepotID ?? "" },
{ "CustInvValue", o.CustInvValue ?? "" },
{ "Freight", o.Freight ?? "" },
{ "IsNCND", o.IsNCND ?? "" },
{ "MaterialCost", o.MaterialCost ?? "" },
{ "MaterialCostInvoiceNo", o.MaterialCostInvoiceNo ?? "" },
{ "NCNDRemark", o.NCNDRemark ?? "" },
{ "PackageID", o.PackageID ?? "" },
{ "TransitDepotID", o.TransitDepotID ?? "" },
{ "BranchId", o.BranchId ?? "" },
{ "CustomerID", o.CustomerID ?? "" },
{ "PaymentType", o.PaymentType ?? "" },
{ "IsLocalTD", o.IsLocalTD ?? "" },
{ "SalesManID", o.SalesManID ?? "" },
{ "ModifyBy", o.ModifyBy ?? "" },
{ "DRSID", o.DRSID ?? "" },
{ "DRSNo", o.DRSNo ?? "" },
{ "DRSDate", o.DRSDate ?? "" },
{ "VehicleID", o.VehicleID ?? "" },
{ "Details", o.Details ?? "" },
{ "DriverID", o.DriverID ?? "" },
{ "EmployeeID", o.EmployeeID ?? "" },
{ "DriverFlag", o.DriverFlag ?? "" },
{ "VehicleType", o.VehicleType ?? "" },
{ "RegNo", o.RegNo ?? "" },
{ "TransferDate", o.TransferDate ?? "" },
{ "DriverName", o.DriverName ?? "" },
{ "Mode", o.Mode ?? "" },
};
Dictionary <string, string> output = new Dictionary <string, string>()
{
{ "Result", "" }
};
Dictionary <string, string> res = pgFun.ExecuteSQL("[dbo].[usp_LabelPrinting_Manage]", input, output, true);
int LastID = 0;
bool isdone = int.TryParse(res["Result"], out LastID);
if (isdone)
{
Res = res["Result"];
}
else
{
Res = res["Result"];
}
return(Res);
}
catch (Exception p)
{
return(p.Message);
}
}
public static List <LabelPrinting> GetLabelPrinting(LabelPrinting o)
{
o = o ?? new LabelPrinting();
Dictionary <string, string> input = new Dictionary <string, string>()
{
{ "InScanID", o.InScanID ?? "" },
{ "AWBNo", o.AWBNo ?? "" },
{ "InScanDate", o.InScanDate ?? "" },
{ "DepartmentID", o.DepartmentID ?? "" },
{ "ConsigneeID", o.ConsigneeID ?? "" },
{ "ConsignorID", o.ConsignorID ?? "" },
{ "OriginID", o.OriginID ?? "" },
{ "DestinationID", o.DestinationID ?? "" },
{ "CustomerRateTypeID", o.CustomerRateTypeID ?? "" },
{ "Pieces", o.Pieces ?? "" },
{ "StatedWeight", o.StatedWeight ?? "" },
{ "CourierServiceID", o.CourierServiceID ?? "" },
{ "CollectedBy", o.CollectedBy ?? "" },
{ "ReceivedBy", o.ReceivedBy ?? "" },
{ "Remarks", o.Remarks ?? "" },
{ "CourierStatusID", o.CourierStatusID ?? "" },
{ "StatusPaymentMode", o.StatusPaymentMode ?? "" },
{ "StatusClose", o.StatusClose ?? "" },
{ "StatusInScan", o.StatusInScan ?? "" },
{ "StatusReconciled", o.StatusReconciled ?? "" },
{ "InscanSheetNo", o.InscanSheetNo ?? "" },
{ "Volume", o.Volume ?? "" },
{ "VolumeWeight", o.VolumeWeight ?? "" },
{ "StatusOutbound", o.StatusOutbound ?? "" },
{ "ItemID", o.ItemID ?? "" },
{ "StatusTransit", o.StatusTransit ?? "" },
{ "StatusCustomsDocument", o.StatusCustomsDocument ?? "" },
{ "DespatchDate", o.DespatchDate ?? "" },
{ "TDID", o.TDID ?? "" },
{ "Description", o.Description ?? "" },
{ "OriginBranchID", o.OriginBranchID ?? "" },
{ "DestinationBranchID", o.DestinationBranchID ?? "" },
{ "TransitMasterID", o.TransitMasterID ?? "" },
{ "UserID", o.UserID ?? "" },
{ "shipperContactPerson", o.shipperContactPerson ?? "" },
{ "ConsigneeContactPerson", o.ConsigneeContactPerson ?? "" },
{ "AcJournalID", o.AcJournalID ?? "" },
{ "FyearID", o.FyearID ?? "" },
{ "OtherChargeDescription", o.OtherChargeDescription ?? "" },
{ "DeliveryDate", o.DeliveryDate ?? "" },
{ "DeliveredBy", o.DeliveredBy ?? "" },
{ "PODRemarks", o.PODRemarks ?? "" },
{ "DeliveredByID", o.DeliveredByID ?? "" },
{ "AcJournalID2", o.AcJournalID2 ?? "" },
{ "StatusTS", o.StatusTS ?? "" },
{ "EnquiryID", o.EnquiryID ?? "" },
{ "OutScanDate", o.OutScanDate ?? "" },
{ "TakenByID", o.TakenByID ?? "" },
{ "TransitID", o.TransitID ?? "" },
{ "RouteID", o.RouteID ?? "" },
{ "DocumentID", o.DocumentID ?? "" },
{ "ConsigneeDepotID", o.ConsigneeDepotID ?? "" },
{ "CustInvValue", o.CustInvValue ?? "" },
{ "Freight", o.Freight ?? "" },
{ "IsNCND", o.IsNCND ?? "" },
{ "MaterialCost", o.MaterialCost ?? "" },
{ "MaterialCostInvoiceNo", o.MaterialCostInvoiceNo ?? "" },
{ "NCNDRemark", o.NCNDRemark ?? "" },
{ "PackageID", o.PackageID ?? "" },
{ "TransitDepotID", o.TransitDepotID ?? "" },
{ "BranchId", o.BranchId ?? "" },
{ "CustomerID", o.CustomerID ?? "" },
{ "PaymentType", o.PaymentType ?? "" },
{ "IsLocalTD", o.IsLocalTD ?? "" },
{ "SalesManID", o.SalesManID ?? "" },
{ "DRSID", o.DRSID ?? "" },
{ "DRSNo", o.DRSNo ?? "" },
{ "Mode", o.Mode ?? "" },
{ "LastTop", o.LastTop ?? "" },
};
return(pgFun.GetData <LabelPrinting>("[dbo].[usp_LabelPrinting_Get]", input));
}