Exemplo n.º 1
0
        public Dictionary <string, object> Post(BookingDetail objbookingDetail)
        {
            Dictionary <string, object>  OrderDetails                 = new Dictionary <string, object>();
            List <OpenOrder>             objListOpenOrder             = new List <OpenOrder>();
            List <CompositeReceiptOrder> objListCompositeReceiptOrder = new List <CompositeReceiptOrder>();
            List <CompositeReceiptROID>  objListCompositeReceiptROID  = new List <CompositeReceiptROID>();
            OpenOrder objOpenOder;

            try
            {
                HomeDAL objHomeDAL = new HomeDAL();
                string  strXml     = string.Empty;
                strXml += "<ebooking><actionname>opencompositereceipt</actionname><receiptid>" + objbookingDetail.ReceiptID + "</receiptid></ebooking>";
                DataSet objds = objHomeDAL.eBookingActions(strXml);

                if (objds.Tables.Count == 1)
                {
                    objOpenOder         = new OpenOrder();
                    objOpenOder.IsValid = Convert.ToInt16(objds.Tables[0].Rows[0]["ErrorFlag"]);
                    if (objOpenOder.IsValid == 1)
                    {
                        objOpenOder.ErrorMessage = Convert.ToString(objds.Tables[0].Rows[0]["ErrorMessage"]);
                        objOpenOder.IsValid      = Convert.ToInt16(objds.Tables[0].Rows[0]["ErrorFlag"]);
                        objListOpenOrder.Add(objOpenOder);
                        OrderDetails.Add("OpenOrder", objListOpenOrder);
                    }
                }

                else
                {
                    DataTable             objdt  = objds.Tables[0];
                    DataTable             objdt1 = objds.Tables[1];
                    CompositeReceiptOrder objCompositeReceiptOder;

                    if (objdt.Rows.Count > 0)
                    {
                        foreach (DataRow dr in objdt.Rows)
                        {
                            objCompositeReceiptOder                     = new CompositeReceiptOrder();
                            objCompositeReceiptOder.ReceiptID           = Convert.ToInt64(dr["ReceiptID"]);
                            objCompositeReceiptOder.TotalPayableAmount  = Convert.ToDouble(dr["TotalPayableAmount"]);
                            objCompositeReceiptOder.TotalAmountPaid     = Convert.ToDouble(dr["TotalAmountPaid"]);
                            objCompositeReceiptOder.WriteOffAmount      = Convert.ToDouble(dr["WriteOffAmount"]);
                            objCompositeReceiptOder.LogUserID           = Convert.ToInt64(dr["LogUserID"]);
                            objCompositeReceiptOder.ReceiptStatus       = Convert.ToInt16(dr["ReceiptStatus"]);
                            objCompositeReceiptOder.ReceiptRemarks      = Convert.ToString(dr["ReceiptRemarks"]);
                            objCompositeReceiptOder.CancelDate          = Convert.ToString(dr["CancelDate"]);
                            objCompositeReceiptOder.BillingRemarks      = Convert.ToString(dr["BillingRemarks"]);
                            objCompositeReceiptOder.CancellationRemarks = Convert.ToString(dr["CancellationRemarks"]);
                            objCompositeReceiptOder.ReceiptDate         = Convert.ToString(dr["ReceiptDate"]);
                            objCompositeReceiptOder.AdvancedUsed        = Convert.ToDouble(dr["AdvancedUsed"]);
                            objCompositeReceiptOder.AdvancedRecieved    = Convert.ToDouble(dr["AdvancedRecieved"]);
                            objCompositeReceiptOder.ReceiptCentreID     = Convert.ToInt16(dr["ReceiptCentreID"]);
                            objCompositeReceiptOder.ReceiptNumber       = Convert.ToInt64(dr["ReceiptNumber"]);
                            objCompositeReceiptOder.IsClassified        = Convert.ToInt16(dr["IsClassified"]);
                            objCompositeReceiptOder.CancelledUserId     = Convert.ToInt16(dr["CancelledUserId"]);
                            objCompositeReceiptOder.AgencyID            = Convert.ToInt16(dr["AgencyID"]);
                            objCompositeReceiptOder.ClientID            = Convert.ToInt16(dr["ClientID"]);
                            objCompositeReceiptOder.CasualClient        = Convert.ToString(dr["CasualClient"]);
                            objCompositeReceiptOder.AgencyName          = Convert.ToString(dr["AgencyName"]);
                            objCompositeReceiptOder.BillTo              = Convert.ToInt16(dr["BillTo"]);
                            objCompositeReceiptOder.RevenueCentreid     = Convert.ToInt16(dr["RevenueCentreid"]);
                            objCompositeReceiptOder.MachineName         = Convert.ToString(dr["MachineName"]);
                            objCompositeReceiptOder.CasualAddress       = Convert.ToString(dr["CasualAddress"]);
                            objCompositeReceiptOder.City                = Convert.ToString(dr["City"]);
                            objCompositeReceiptOder.Phone               = Convert.ToString(dr["Phone"]);
                            objCompositeReceiptOder.Zip                 = Convert.ToString(dr["Zip"]);
                            objCompositeReceiptOder.ReceiptPaymentMode  = Convert.ToInt16(dr["PaymentMode"]);
                            objCompositeReceiptOder.BankID              = Convert.ToInt16(dr["BankID"]);
                            objCompositeReceiptOder.CheckNumber         = Convert.ToString(dr["Number"]);
                            objCompositeReceiptOder.PaymentDate         = Convert.ToString(dr["PaymentDate"]);
                            objCompositeReceiptOder.Amount              = Convert.ToDouble(dr["Amount"]);
                            objCompositeReceiptOder.BankName            = Convert.ToString(dr["BankName"]);
                            objCompositeReceiptOder.BranchName          = Convert.ToString(dr["BranchName"]);
                            objCompositeReceiptOder.BranchID            = Convert.ToInt16(dr["BranchID"]);
                            objCompositeReceiptOder.BankBranchCode      = Convert.ToString(dr["BankBranchCode"]);
                            objCompositeReceiptOder.CashReceived        = Convert.ToDouble(dr["CashReceived"]);
                            objCompositeReceiptOder.CashRefund          = Convert.ToDouble(dr["CashRefund"]);
                            objCompositeReceiptOder.AdvanceReceiptID    = Convert.ToInt64(dr["AdvanceReceiptID"]);
                            objListCompositeReceiptOrder.Add(objCompositeReceiptOder);
                        }
                    }

                    CompositeReceiptROID objCompositeReceiptROID;
                    if (objdt1.Rows.Count > 0)
                    {
                        foreach (DataRow dr in objdt1.Rows)
                        {
                            objCompositeReceiptROID      = new CompositeReceiptROID();
                            objCompositeReceiptROID.ROID = Convert.ToString(dr["ROID"]);
                            objCompositeReceiptROID.Net  = Convert.ToDouble(dr["Net"]);
                            objListCompositeReceiptROID.Add(objCompositeReceiptROID);
                        }
                    }
                    OrderDetails.Add("CompoReceiptOrder", objListCompositeReceiptOrder);
                    OrderDetails.Add("CompoReceiptROID", objListCompositeReceiptROID);
                }
            }
            catch (Exception ex)
            {
                Utility.ReportError("DisplayOpenOrderController::Post:", ex);
            }
            return(OrderDetails);
        }
Exemplo n.º 2
0
        public Dictionary <string, object> Post(BookingDetail objbookingDetail)
        {
            Dictionary <string, object>  OrderDetails                 = new Dictionary <string, object>();
            List <OpenOrder>             objListOpenOrder             = new List <OpenOrder>();
            List <ReceiptOrder>          objListReceiptOrder          = new List <ReceiptOrder>();
            List <CompositeReceiptOrder> objListCompositeReceiptOrder = new List <CompositeReceiptOrder>();
            List <CompositeReceiptROID>  objListCompositeReceiptROID  = new List <CompositeReceiptROID>();
            List <ROFilesOrder>          objListROFilesOrder          = new List <ROFilesOrder>();
            OpenOrder objOpenOder;

            try
            {
                HomeDAL objHomeDAL = new HomeDAL();
                string  strXml     = string.Empty;
                strXml += "<ebooking><actionname>openreceipt</actionname><receiptid>" + objbookingDetail.ReceiptID + "</receiptid>"
                          + "<loguserid>" + objbookingDetail.UserId + "</loguserid>"
                          + "<logcentreid>" + objbookingDetail.RevenueCentreID + "</logcentreid>"
                          + "<isclassified>" + objbookingDetail.IsClassified + "</isclassified></ebooking>";
                DataSet objds = objHomeDAL.eBookingActions(strXml);

                if (objds.Tables.Count == 1)
                {
                    objOpenOder         = new OpenOrder();
                    objOpenOder.IsValid = Convert.ToInt16(objds.Tables[0].Rows[0]["ErrorFlag"]);
                    if (objOpenOder.IsValid == 1)
                    {
                        objOpenOder.ErrorMessage = Convert.ToString(objds.Tables[0].Rows[0]["ErrorMessage"]);
                        objOpenOder.IsValid      = Convert.ToInt16(objds.Tables[0].Rows[0]["ErrorFlag"]);
                        objListOpenOrder.Add(objOpenOder);
                        OrderDetails.Add("OpenOrder", objListOpenOrder);
                    }
                }

                else if (objds.Tables.Count < 3)
                {
                    DataTable             objdt  = objds.Tables[0];
                    DataTable             objdt1 = objds.Tables[1];
                    CompositeReceiptOrder objCompositeReceiptOder;

                    if (objdt.Rows.Count > 0)
                    {
                        foreach (DataRow dr in objdt.Rows)
                        {
                            objCompositeReceiptOder                     = new CompositeReceiptOrder();
                            objCompositeReceiptOder.ReceiptID           = Convert.ToInt64(dr["ReceiptID"]);
                            objCompositeReceiptOder.TotalPayableAmount  = Convert.ToDouble(dr["TotalPayableAmount"]);
                            objCompositeReceiptOder.TotalAmountPaid     = Convert.ToDouble(dr["TotalAmountPaid"]);
                            objCompositeReceiptOder.WriteOffAmount      = Convert.ToDouble(dr["WriteOffAmount"]);
                            objCompositeReceiptOder.LogUserID           = Convert.ToInt64(dr["LogUserID"]);
                            objCompositeReceiptOder.ReceiptStatus       = Convert.ToInt16(dr["ReceiptStatus"]);
                            objCompositeReceiptOder.ReceiptRemarks      = Convert.ToString(dr["ReceiptRemarks"]);
                            objCompositeReceiptOder.CancelDate          = Convert.ToString(dr["CancelDate"]);
                            objCompositeReceiptOder.BillingRemarks      = Convert.ToString(dr["BillingRemarks"]);
                            objCompositeReceiptOder.CancellationRemarks = Convert.ToString(dr["CancellationRemarks"]);
                            objCompositeReceiptOder.ReceiptDate         = Convert.ToString(dr["ReceiptDate"]);
                            objCompositeReceiptOder.AdvancedUsed        = Convert.ToDouble(dr["AdvancedUsed"]);
                            objCompositeReceiptOder.AdvancedRecieved    = Convert.ToDouble(dr["AdvancedRecieved"]);
                            objCompositeReceiptOder.ReceiptCentreID     = Convert.ToInt16(dr["ReceiptCentreID"]);
                            objCompositeReceiptOder.ReceiptNumber       = Convert.ToInt64(dr["ReceiptNumber"]);
                            objCompositeReceiptOder.IsClassified        = Convert.ToInt16(dr["IsClassified"]);
                            objCompositeReceiptOder.CancelledUserId     = Convert.ToInt16(dr["CancelledUserId"]);
                            objCompositeReceiptOder.AgencyID            = Convert.ToInt16(dr["AgencyID"]);
                            objCompositeReceiptOder.ClientID            = Convert.ToInt16(dr["ClientID"]);
                            objCompositeReceiptOder.CasualClient        = Convert.ToString(dr["CasualClient"]);
                            objCompositeReceiptOder.AgencyName          = Convert.ToString(dr["AgencyName"]);
                            objCompositeReceiptOder.BillTo              = Convert.ToInt16(dr["BillTo"]);
                            objCompositeReceiptOder.RevenueCentreid     = Convert.ToInt16(dr["RevenueCentreid"]);
                            objCompositeReceiptOder.MachineName         = Convert.ToString(dr["MachineName"]);
                            objCompositeReceiptOder.CasualAddress       = Convert.ToString(dr["CasualAddress"]);
                            objCompositeReceiptOder.City                = Convert.ToString(dr["City"]);
                            objCompositeReceiptOder.Phone               = Convert.ToString(dr["Phone"]);
                            objCompositeReceiptOder.Zip                 = Convert.ToString(dr["Zip"]);
                            objCompositeReceiptOder.ReceiptPaymentMode  = Convert.ToInt16(dr["PaymentMode"]);
                            objCompositeReceiptOder.BankID              = Convert.ToInt16(dr["BankID"]);
                            objCompositeReceiptOder.CheckNumber         = Convert.ToString(dr["Number"]);
                            objCompositeReceiptOder.PaymentDate         = Convert.ToString(dr["PaymentDate"]);
                            objCompositeReceiptOder.Amount              = Convert.ToDouble(dr["Amount"]);
                            objCompositeReceiptOder.BankName            = Convert.ToString(dr["BankName"]);
                            objCompositeReceiptOder.BranchName          = Convert.ToString(dr["BranchName"]);
                            objCompositeReceiptOder.BranchID            = Convert.ToInt16(dr["BranchID"]);
                            objCompositeReceiptOder.BankBranchCode      = Convert.ToString(dr["BankBranchCode"]);
                            objCompositeReceiptOder.CashReceived        = Convert.ToDouble(dr["CashReceived"]);
                            objCompositeReceiptOder.CashRefund          = Convert.ToDouble(dr["CashRefund"]);
                            objCompositeReceiptOder.AdvanceReceiptID    = Convert.ToInt64(dr["AdvanceReceiptID"]);
                            objListCompositeReceiptOrder.Add(objCompositeReceiptOder);
                        }
                    }

                    CompositeReceiptROID objCompositeReceiptROID;
                    if (objdt1.Rows.Count > 0)
                    {
                        foreach (DataRow dr in objdt1.Rows)
                        {
                            objCompositeReceiptROID      = new CompositeReceiptROID();
                            objCompositeReceiptROID.ROID = Convert.ToString(dr["ROID"]);
                            objCompositeReceiptROID.Net  = Convert.ToDouble(dr["Net"]);
                            objListCompositeReceiptROID.Add(objCompositeReceiptROID);
                        }
                    }
                    OrderDetails.Add("CompoReceiptOrder", objListCompositeReceiptOrder);
                    OrderDetails.Add("CompoReceiptROID", objListCompositeReceiptROID);
                }

                else
                {
                    DataTable objdt  = objds.Tables[0];
                    DataTable objdt1 = objds.Tables[1];
                    DataTable objdt2 = objds.Tables[2];

                    objOpenOder = new OpenOrder();
                    objOpenOder.IsCancelReceipt = Convert.ToInt16(objds.Tables[2].Rows[0]["ReceiptStatus"]);
                    if (objOpenOder.IsCancelReceipt == 0)
                    {
                        objOpenOder.ErrorMessage = "Invalid ReceiptID !!";
                        objOpenOder.IsValid      = 1;
                        objListOpenOrder.Add(objOpenOder);
                        OrderDetails.Add("OpenOrder", objListOpenOrder);
                        return(OrderDetails);
                    }


                    if (objdt.Rows.Count > 0)
                    {
                        foreach (DataRow dr in objdt.Rows)
                        {
                            objOpenOder = new OpenOrder();

                            objOpenOder.StartCol             = Convert.ToString(dr["StartCol"]);
                            objOpenOder.Yposition            = Convert.ToString(dr["Yposition"]);
                            objOpenOder.BoxNumber            = Convert.ToString(dr["BoxNumber"]);
                            objOpenOder.RevenueCentreID      = Convert.ToInt16(dr["RevenueCentreID"]);
                            objOpenOder.BookingCentreID      = Convert.ToInt16(dr["BookingCentreID"]);
                            objOpenOder.IsClassified         = Convert.ToInt16(dr["IsClassified"]);
                            objOpenOder.RODate               = Convert.ToString(dr["RODate"]);
                            objOpenOder.BookingDate          = Convert.ToDateTime(dr["BookingDate"]).ToString("dd/MM/yyyy HH:mm:ss.fff");
                            objOpenOder.BookingExecID        = Convert.ToInt16(dr["BookingExecID"]);
                            objOpenOder.BookingNumber        = Convert.ToString(dr["BookingNumber"]);
                            objOpenOder.RONumber             = Convert.ToString(dr["RONumber"]);
                            objOpenOder.AgencyID             = Convert.ToInt16(dr["AgencyID"]);
                            objOpenOder.ClientID             = Convert.ToInt16(dr["ClientID"]);
                            objOpenOder.AgentID              = Convert.ToInt16(dr["AgentID"]);
                            objOpenOder.CanvassorID          = Convert.ToInt16(dr["CanvassorID"]);
                            objOpenOder.ROType               = Convert.ToInt16(dr["ROType"]);
                            objOpenOder.BillingCycle         = Convert.ToInt16(dr["BillingCycle"]);
                            objOpenOder.BillTo               = Convert.ToInt16(dr["BillTo"]);
                            objOpenOder.BillType             = Convert.ToInt16(dr["BillType"]);
                            objOpenOder.PaymentModeID        = Convert.ToInt16(dr["PaymentMode"]);
                            objOpenOder.IsManualBilling      = Convert.ToInt16(dr["IsManualBilling"]);
                            objOpenOder.SourceOrder          = Convert.ToInt16(dr["SourceOrder"]);
                            objOpenOder.ROStatus             = Convert.ToInt16(dr["ROStatus"]);
                            objOpenOder.RateFieldChanged     = Convert.ToInt16(dr["RateFieldChanged"]);
                            objOpenOder.ProductID            = Convert.ToInt16(dr["ProductID"]);
                            objOpenOder.BrandID              = Convert.ToInt16(dr["BrandID"]);
                            objOpenOder.SMEID                = Convert.ToInt16(dr["SMEID"]);
                            objOpenOder.BoxTypeID            = Convert.ToInt16(dr["BoxTypeID"]);
                            objOpenOder.ROID                 = Convert.ToInt64(dr["ROID"]);
                            objOpenOder.InsNum               = Convert.ToInt16(dr["InsNum"]);
                            objOpenOder.PEID                 = Convert.ToInt16(dr["PEID"]);
                            objOpenOder.ReleaseID            = Convert.ToInt16(dr["ReleaseID"]);
                            objOpenOder.ProdPEID             = Convert.ToInt16(dr["ProdPEID"]);
                            objOpenOder.ProdReleaseID        = Convert.ToInt16(dr["ProdReleaseID"]);
                            objOpenOder.ScheduledDate        = Convert.ToDateTime(dr["ScheduledDate"]).ToString("dd/MM/yyyy");
                            objOpenOder.PackageID            = Convert.ToInt16(dr["PackageID"]);
                            objOpenOder.AdTypeID             = Convert.ToInt16(dr["AdTypeID"]);
                            objOpenOder.PremiaID             = Convert.ToInt16(dr["PremiaID"]);
                            objOpenOder.ColorID              = Convert.ToInt16(dr["Color"]);
                            objOpenOder.Status               = Convert.ToInt16(dr["Status"]);
                            objOpenOder.AuditStatus          = Convert.ToInt16(dr["AuditStatus"]);
                            objOpenOder.Free_or_Paid         = Convert.ToInt16(dr["Free_or_Paid"]);
                            objOpenOder.FreeAds              = Convert.ToInt16(dr["FreeAds"]);
                            objOpenOder.PaidAds              = Convert.ToInt16(dr["PaidAds"]);
                            objOpenOder.ItemRateFieldChanged = Convert.ToInt16(dr["ItemRateFieldChanged"]);
                            objOpenOder.RateCardID           = Convert.ToInt16(dr["RateCardID"]);
                            objOpenOder.AdRateID             = Convert.ToInt16(dr["AdRateID"]);
                            objOpenOder.CardRate             = Convert.ToDouble(dr["CardRate"]);
                            objOpenOder.CardAmount           = Convert.ToDouble(dr["CardAmount"]);
                            objOpenOder.AgreedRate           = Convert.ToDouble(dr["AgreedRate"]);
                            objOpenOder.AgreedAmount         = Convert.ToDouble(dr["AgreedAmount"]);
                            objOpenOder.PECardBaseRate       = Convert.ToDouble(dr["PECardBaseRate"]);
                            objOpenOder.ColorRate            = Convert.ToDouble(dr["PECardCOlourRate"]);
                            objOpenOder.PremiaRate           = Convert.ToDouble(dr["PECardPremiaRate"]);
                            objOpenOder.AgreedDiscPer        = Convert.ToDecimal(dr["AgreedDiscPer"]);
                            objOpenOder.AgreedDiscAmount     = Convert.ToDouble(dr["AgreedDiscAmount"]);
                            objOpenOder.CommissionPer        = Convert.ToDouble(dr["CommissionPer"]);
                            objOpenOder.CommissionAmount     = Convert.ToDouble(dr["CommissionAmount"]);
                            objOpenOder.DisCountColorPer     = Convert.ToDouble(dr["DisCountColorPer"]);
                            objOpenOder.DisCountPremiaPer    = Convert.ToDouble(dr["DisCountPremiaPer"]);
                            // objOpenOder.ExtraDiscountforPE = Convert.ToDouble(dr["ExtraDiscountforPE"]);
                            objOpenOder.ExtraChargesForPE     = Convert.ToDouble(dr["ExtraChargesForPE"]);
                            objOpenOder.ExtraChargesPer       = Convert.ToDouble(dr["ExtraChargesPer"]);
                            objOpenOder.ExtraDiscPer          = Convert.ToDouble(dr["ExtraDiscPer"]);
                            objOpenOder.ExtraDiscAmount       = Convert.ToDouble(dr["ExtraDiscAmount"]);
                            objOpenOder.ExtraBoxChargesPer    = Convert.ToDouble(dr["BoxChargesPer"]);
                            objOpenOder.ExtraBoxChargesAmount = Convert.ToDouble(dr["BoxChargesAmount"]);
                            objOpenOder.PreVATAmountforPE     = Convert.ToDouble(dr["PreVATAmountforPE"]);
                            objOpenOder.NetAmountforPE        = Convert.ToDouble(dr["NetAmountforPE"]);
                            objOpenOder.Net              = Convert.ToDouble(dr["Net"]);
                            objOpenOder.Receivable       = Convert.ToDouble(dr["Receivable"]);
                            objOpenOder.VatPer           = Convert.ToDouble(dr["VatPer"]);
                            objOpenOder.VatAmount        = Convert.ToDouble(dr["VatAmount"]);
                            objOpenOder.WTPer            = Convert.ToDouble(dr["WTPer"]);
                            objOpenOder.WTAmount         = Convert.ToDouble(dr["WTAmount"]);
                            objOpenOder.MaterialID       = Convert.ToString(dr["MaterialID"]);
                            objOpenOder.AdsizeID         = Convert.ToInt16(dr["AdsizeID"]);
                            objOpenOder.Adsize           = Convert.ToString(dr["AdSize"]);
                            objOpenOder.AdSizeHeight     = Convert.ToDouble(dr["AdHeight"]);
                            objOpenOder.AdSizeWidth      = Convert.ToDouble(dr["AdColsize"]);
                            objOpenOder.BillableSize     = Convert.ToString(dr["BillableSize"]);
                            objOpenOder.BillableColSize  = Convert.ToDouble(dr["BillableColSize"]);
                            objOpenOder.BillableHeight   = Convert.ToDouble(dr["BillableHeight"]);
                            objOpenOder.BillableArea     = Convert.ToDouble(dr["BillableArea"]);
                            objOpenOder.UOM              = Convert.ToInt16(dr["UOM"]);
                            objOpenOder.SchemeID         = Convert.ToInt16(dr["SchemeID"]);
                            objOpenOder.SchemeDetailID   = Convert.ToInt16(dr["SchemedetailID"]);
                            objOpenOder.MaterialSource   = Convert.ToInt16(dr["MaterialSource"]);
                            objOpenOder.MaterialType     = Convert.ToInt16(dr["MaterialType"]);
                            objOpenOder.MaterialStatus   = Convert.ToInt16(dr["MaterialStatus"]);
                            objOpenOder.AgencyName       = Convert.ToString(dr["AgencyName"]);
                            objOpenOder.ClientName       = Convert.ToString(dr["ClientName"]);
                            objOpenOder.CasualClientName = Convert.ToString(dr["CasualClientName"]);
                            objOpenOder.CanvassorName    = Convert.ToString(dr["CanvassorName"]);
                            objOpenOder.UserName         = Convert.ToString(dr["UserName"]);
                            objOpenOder.CentreName       = Convert.ToString(dr["CentreName"]);
                            objOpenOder.MaterialPath     = Convert.ToString(dr["MaterialPath"]);
                            objOpenOder.JobPath          = Convert.ToString(dr["JobPath"]);
                            objOpenOder.ROFilePath       = Convert.ToString(dr["ROFilePath"]);
                            objOpenOder.PkgIDs           = Convert.ToString(dr["PkgIDs"]);
                            objOpenOder.PremiaName       = Convert.ToString(dr["PremiaName"]);
                            objOpenOder.SizeName         = Convert.ToString(dr["SizeName"]);
                            objOpenOder.ColorName        = Convert.ToString(dr["ColorName"]);
                            objOpenOder.CustomerTypeID   = Convert.ToInt16(dr["CasualRegularFlag"]);
                            //objOpenOder.ColumnSize = Convert.ToDouble(dr["ColumnSize"]);
                            //objOpenOder.Gutter = Convert.ToDouble(dr["Gutter"]);
                            objOpenOder.SchedulingInstructions = Convert.ToString(dr["SchedulingInstructions"]);
                            objOpenOder.BillingInstruction     = Convert.ToString(dr["BillingInstruction"]);
                            objOpenOder.ProdInstructions       = Convert.ToString(dr["ProdInstructions"]);
                            objOpenOder.Caption                   = Convert.ToString(dr["Caption"]);
                            objOpenOder.CasualAddress             = Convert.ToString(dr["CasualAddress"]);
                            objOpenOder.CityID                    = Convert.ToInt32(dr["CityID"]);
                            objOpenOder.Zip                       = Convert.ToString(dr["Zip"]);
                            objOpenOder.Phone                     = Convert.ToString(dr["Phone"]);
                            objOpenOder.NicNumber                 = Convert.ToString(dr["NICNumber"]);
                            objOpenOder.VatNumber                 = Convert.ToString(dr["VATNumber"]);
                            objOpenOder.MBodyCount                = Convert.ToString(dr["MBodyCount"]);
                            objOpenOder.AdClassification          = Convert.ToString(dr["AdClassification"]);
                            objOpenOder.AdtypeID1                 = Convert.ToInt32(dr["Adtype1"]);
                            objOpenOder.AdtypeID2                 = Convert.ToInt32(dr["Adtype2"]);
                            objOpenOder.AdtypeID3                 = Convert.ToInt32(dr["Adtype3"]);
                            objOpenOder.AdtypeID4                 = Convert.ToInt32(dr["Adtype4"]);
                            objOpenOder.AllowCasualClient         = Convert.ToInt32(dr["AllowCasualClient"]);
                            objOpenOder.BoxAddress                = Convert.ToString(dr["BoxAddress"]);
                            objOpenOder.IsCD                      = Convert.ToInt32(dr["IsCD"]);
                            objOpenOder.StyleSheetID              = Convert.ToInt32(dr["StyleSheetID"]);
                            objOpenOder.IsLogo                    = Convert.ToInt32(dr["IsLogo"]);
                            objOpenOder.U_BodyText                = Convert.ToString(dr["U_BodyText"]);
                            objOpenOder.PECode                    = Convert.ToString(dr["PECode"]);
                            objOpenOder.AdStatus                  = Convert.ToString(dr["AdStatus"]);
                            objOpenOder.FileNames                 = Convert.ToString(dr["FileNames"]);
                            objOpenOder.ReasonForUnconfirmationID = Convert.ToString(dr["ReasonForUnconfirmationID"]);
                            objOpenOder.FileHeight                = Convert.ToString(dr["FileHeight"]);
                            objOpenOder.ReadOnlyFlag              = Convert.ToString(dr["ReadOnlyFlag"]);
                            objOpenOder.BlockB4ScheduledDate      = Convert.ToDateTime(dr["BlockB4ScheduledDate"]).ToString("dd/MM/yyyy");
                            objOpenOder.AdColumns                 = Convert.ToString(dr["CDADColumns"]);
                            objOpenOder.MaterialTypeDescription   = Convert.ToString(dr["MaterialTypeDescription"]);
                            objOpenOder.DeferredPayment           = Convert.ToInt16(dr["DeferredPayment"]);
                            objOpenOder.AgencyPaymentMode         = Convert.ToInt16(dr["AgencyPaymentMode"]);
                            objListOpenOrder.Add(objOpenOder);
                        }
                    }


                    ROFilesOrder objROFilesOrder;
                    if (objdt1.Rows.Count > 0)
                    {
                        foreach (DataRow dr in objdt1.Rows)
                        {
                            objROFilesOrder             = new ROFilesOrder();
                            objROFilesOrder.ROID        = Convert.ToInt64(dr["ROID"]);
                            objROFilesOrder.ROFileName  = Convert.ToString(dr["ROFileName"]);
                            objROFilesOrder.ROFileType  = Convert.ToString(dr["ROFileType"]);
                            objROFilesOrder.ROFileTitle = Convert.ToString(dr["ROFileTitle"]);
                            objListROFilesOrder.Add(objROFilesOrder);
                        }
                    }

                    ReceiptOrder objReceiptOder;
                    if (objdt2.Rows.Count > 0)
                    {
                        foreach (DataRow dr in objdt2.Rows)
                        {
                            objReceiptOder                    = new ReceiptOrder();
                            objReceiptOder.ReceiptID          = Convert.ToInt64(dr["ReceiptID"]);
                            objReceiptOder.ReceiptNumber      = Convert.ToInt64(dr["ReceiptNumber"]);
                            objReceiptOder.ReceiptPaymentMode = Convert.ToInt16(dr["PaymentMode"]);
                            objReceiptOder.BankID             = Convert.ToInt16(dr["BankID"]);
                            objReceiptOder.BranchID           = Convert.ToInt16(dr["BranchID"]);
                            objReceiptOder.CheckNumber        = Convert.ToString(dr["Number"]);
                            objReceiptOder.Amount             = Convert.ToDouble(dr["Amount"]);
                            objReceiptOder.TotalAmountPaid    = Convert.ToDouble(dr["TotalAmountPaid"]);
                            objReceiptOder.WriteOffAmount     = Convert.ToDouble(dr["WriteOffAmount"]);
                            objReceiptOder.CashRefund         = Convert.ToDouble(dr["CashRefund"]);
                            objReceiptOder.CashReceived       = Convert.ToDouble(dr["CashReceived"]);
                            objListReceiptOrder.Add(objReceiptOder);
                        }
                    }
                    OrderDetails.Add("OpenOrder", objListOpenOrder);
                    OrderDetails.Add("ROFilesOrder", objListROFilesOrder);
                    OrderDetails.Add("ReceiptOrder", objListReceiptOrder);
                }
            }
            catch (Exception ex)
            {
                Utility.ReportError("DisplayOpenOrderController::Post:", ex);
            }
            return(OrderDetails);
        }