using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace LogisticsDAL.DTO.Booking { public class BookingRegisterReportDTO //: ReportPaginationDTO { #region PrivateMembers private int bookingid; private DateTime bookingdate; private string bookingnumber; private DateTime referencedate; private string referencenumber; private string deliveryremarks; private int fromcityid; private string fromcitycode; private string fromcityname; private int tocityid; private string tocitycode; private string tocityname; private byte doctype; private byte paymenttype; private string paymenttypename; private byte risk; private byte ratetype; private double rate; private decimal amountplus; private decimal amountminus; private decimal totalvalue; private decimal actualweight; private decimal volumeweight; private decimal billableweight; private decimal valueofgoods; private byte iscod; private int bookingstatusid; private byte isdelivered; private DateTime deliverydate; private Int16 deliverytime; private int deliveredbyemployeeid; private int deliverybycontactid; private DateTime grndate; private string grnnumber; private string receivedby; private byte issignature; private byte isseal; private decimal length; private decimal weight; private decimal height; private Int16 pax; private int bookingdetailid; private string invoicenumber; private string detailreferencenumber; private string partnumber; private decimal codamount; private string detaildescription; private string cinvoicenumber; private int consigneeid; private string consigneecode; private string consigneename; private string consigneeaddressline1; private string consigneeaddressline2; private string consigneeaddressline3; private string consigneezipcode; private int consignerid; private string consignercode; private string consignername; private string consigneraddressline1; private string consigneraddressline2; private string consigneraddressline3; private string consignerzipcode; private int ouid; private string oucode; private string ouname; private int billid; private int documentid; private string documentnumber; private DateTime documentdate; private byte billstatus; private string billstatusname; private int deliveryemployeeid; private string deliveryemployeecode; private string deliveryemployeename; private string deliveryrunnumber; private DateTime deliveryrundate; private DateTime manifestdate; private string manifestnumber; private DateTime tripdate; private string tripnumber; private string vehiclenumber; private string goodstypecode; private string goodstypename; private string vehicletype; private int transporterid; private string transportercode; private string transportername; private int manifestfromcityid; private string manifestfromcitycode; private string manifestfromcityname; private int manifesttocityid; private string manifesttocitycode; private string manifesttocityname; private int driverid; private string drivercode; private string drivername; private Int32 exemptedamount; private Int32 servicetax; private Int32 educess; private decimal abatementamount; private decimal taxablefreight; private decimal totalfax; private int bookedbyemployeeid; private string employeecode; private string employeename; private string bookingstatuscode; private string bookingstatusname; private int formulaid; private string formulacode; private string formulaname; private decimal calculatedvalue; private string baleno; private decimal invoicevalue; private string receipttypecode; private string receipttypename; public string TotalAmountInWords; private decimal rentamount; private decimal fueltokenamount; private decimal advanceamount; private decimal balanceamount; private string manifestremarks; private string modeofdelivery; private DateTime tripstarton; private DateTime tripendon; private string startlocationname; private string startlocationcode; private string endlocationname; private string endlocationcode; private string deliverystatus; private string paymentdetails; private decimal quantity; private decimal basicfarevalue; private int totalpax; private decimal totalbillableweight; private decimal finaltotalvalue; private decimal totalcodamount; private decimal totalrentamount; private decimal totalfueltokenamount; private decimal totaladvanceamount; private decimal totalbalanceamount; private decimal totalactualweight; private int totalstartmeter; private int totalendmeter; private int totalstartendmeter; private decimal totaltaxablefreight; private double totalnumberofbookings; private int tripid; private int manifestid; private string storename; private string consigneecopyname; private string goodscontentname; private string consigneecityname; private string consigneephone; private string consigneemobile; private string deliverytype; private string deliverystatusonloadedquantity; private DateTime bookinghistorydate; private string historydetails; private int historybookingid = -1; private string skucode; private string reschedulereasoncode; private string reschedulereasonname; private DateTime rescheduleddate; private string uomcode; private string uomname; public int TripId { get { return tripid; } set { tripid = value; } } public int ManifestId { get { return manifestid; } set { manifestid = value; } } public double TotalNumberofBookings { get { return totalnumberofbookings; } set { totalnumberofbookings = value; } } public decimal TotalTaxableFreight { get { return totaltaxablefreight; } set { totaltaxablefreight = value; } } public int TotalPax { get { return totalpax; } set { totalpax = value; } } public decimal TotalBillableWeight { get { return totalbillableweight; } set { totalbillableweight = value; } } public decimal FinalTotalValue { get { return finaltotalvalue; } set { finaltotalvalue = value; } } public decimal TotalCODAmount { get { return totalcodamount; } set { totalcodamount = value; } } public decimal TotalRentAmount { get { return totalrentamount; } set { totalrentamount = value; } } public decimal TotalFuelTokenAmount { get { return totalfueltokenamount; } set { totalfueltokenamount = value; } } public decimal TotalAdvanceAmount { get { return totaladvanceamount; } set { totaladvanceamount = value; } } public decimal TotalBalanceAmount { get { return totalbalanceamount; } set { totalbalanceamount = value; } } public int TotalStartMeter { get { return totalstartmeter; } set { totalstartmeter = value; } } public decimal TotalActualWeight { get { return totalactualweight; } set { totalactualweight = value; } } public int TotalEndMeter { get { return totalendmeter; } set { totalendmeter = value; } } public int TotalStartEndMeter { get { return totalstartendmeter; } set { totalstartendmeter = value; } } private int chargedetailid; private int chargeslno; #endregion #region PublicMembers public int ChargeDetailId { get { return chargedetailid; } set { chargedetailid = value; } } public int ChargeSlNo { get { return chargeslno; } set { chargeslno = value; } } public decimal Quantity { get { return quantity; } set { quantity = value; } } public int FormulaId { get { return formulaid; } set { formulaid = value; } } public DateTime DeliveryRunDate { get { return deliveryrundate; } set { deliveryrundate = value; } } public decimal RentAmount { get { return rentamount; } set { rentamount = value; } } public decimal FuelTokenAmount { get { return fueltokenamount; } set { fueltokenamount = value; } } public decimal AdvanceAmount { get { return advanceamount; } set { advanceamount = value; } } public decimal BalanceAmount { get { return balanceamount; } set { balanceamount = value; } } public string ManifestRemarks { get { return manifestremarks; } set { manifestremarks = value; } } public string ModeOfDelivery { get { return modeofdelivery; } set { modeofdelivery = value; } } public DateTime TripStartOn { get { return tripstarton; } set { tripstarton = value; } } public DateTime TripEndOn { get { return tripendon; } set { tripendon = value; } } public string StartLocationName { get { return startlocationname; } set { startlocationname = value; } } public string EndLocationName { get { return endlocationname; } set { endlocationname = value; } } public string StartLocationCode { get { return startlocationcode; } set { startlocationcode = value; } } public string EndLocationCode { get { return endlocationcode; } set { endlocationcode = value; } } public string DeliverStatus { get { return deliverystatus; } set { deliverystatus = value; } } public int BookedByEmployeeId { get { return bookedbyemployeeid; } set { bookedbyemployeeid = value; } } public string Employeecode { get { return employeecode; } set { employeecode = value; } } public string EmployeeName { get { return employeename; } set { employeename = value; } } public int TransporterId { get { return transporterid; } set { transporterid = value; } } public string TransporterCode { get { return transportercode; } set { transportercode = value; } } public string TransporterName { get { return transportername; } set { transportername = value; } } public int ManifestFromCityId { get { return manifestfromcityid; } set { manifestfromcityid = value; } } public string ManifestFromCityCode { get { return manifestfromcitycode; } set { manifestfromcitycode = value; } } public string ManifestFromCityName { get { return manifestfromcityname; } set { manifestfromcityname = value; } } public int ManifestToCityId { get { return manifesttocityid; } set { manifesttocityid = value; } } public string ManifestToCityCode { get { return manifesttocitycode; } set { manifesttocitycode = value; } } public string ManifestToCityName { get { return manifesttocityname; } set { manifesttocityname = value; } } public string VehicleType { get { return vehicletype; } set { vehicletype = value; } } public string GoodsTypeCode { get { return goodstypecode; } set { goodstypecode = value; } } public string GoodsTypeName { get { return goodstypename; } set { goodstypename = value; } } public int DriverId { get { return driverid; } set { driverid = value; } } public string DriverCode { get { return drivercode; } set { drivercode = value; } } public string DriverName { get { return drivername; } set { drivername = value; } } public Int32 ServiceTax { get { return servicetax; } set { servicetax = value; } } public Int32 ExemptedAmount { get { return exemptedamount; } set { exemptedamount = value; } } public Int32 EduCess { get { return educess; } set { educess = value; } } public decimal AbatementAmount { get { return abatementamount; } set { abatementamount = value; } } public decimal TaxableFreight { get { return taxablefreight; } set { taxablefreight = value; } } public decimal TotalFax { get { return totalfax; } set { totalfax = value; } } public int BookingId { get { return bookingid; } //LeadCode set { bookingid = value; } //LeadCode } public DateTime BookingDate { get { return bookingdate; } ////date set { bookingdate = value; } ////date } public string BookingNumber { get { return bookingnumber; } ////Number set { bookingnumber = value; } ////Number } public DateTime ReferenceDate { get { return referencedate; } ////date set { referencedate = value; } ////date } public string ReferenceNumber { get { return referencenumber; } ////Number set { referencenumber = value; } ////Number } public string DeliveryRemarks { get { return deliveryremarks; } ////Number set { deliveryremarks = value; } ////Number } public int FromCityId { get { return fromcityid; } //LeadCode set { fromcityid = value; } //LeadCode } public string FromCityCode { get { return fromcitycode; } ////Number set { fromcitycode = value; } ////Number } public string FromCityName { get { return fromcityname; } ////Number set { fromcityname = value; } ////Number } public int ToCityId { get { return tocityid; } //LeadCode set { tocityid = value; } //LeadCode } public string ToCityCode { get { return tocitycode; } ////Number set { tocitycode = value; } ////Number } public string ToCityName { get { return tocityname; } ////Number set { tocityname = value; } ////Number } public byte DocType { get { return doctype; } ////Number set { doctype = value; } ////Number } public byte PaymentType { get { return paymenttype; } ////Number set { paymenttype = value; } ////Number } public string PaymentTypeName { get { return paymenttypename; } ////Number set { paymenttypename = value; } ////Number } public byte Risk { get { return risk; } ////Number set { risk = value; } ////Number } public byte RateType { get { return ratetype; } ////Number set { ratetype = value; } ////Number } public double Rate { get { return rate; } ////Number set { rate = value; } ////Number } public decimal BasicFareValue { get { return basicfarevalue; } ////Number set { basicfarevalue = value; } ////Number } public decimal AmountPlus { get { return amountplus; } ////Number set { amountplus = value; } ////Number } public decimal AmountMinus { get { return amountminus; } ////Number set { amountminus = value; } ////Number } public decimal TotalValue { get { return totalvalue; } ////Number set { totalvalue = value; } ////Number } public decimal ActualWeight { get { return actualweight; } ////Number set { actualweight = value; } } public decimal VolumeWeight { get { return volumeweight; } ////Number set { volumeweight = value; } ////Number } public decimal BillableWeight { get { return billableweight; } ////Number set { billableweight = value; } ////Number } public decimal ValueOfGoods { get { return valueofgoods; } ////Number set { valueofgoods = value; } ////Number } public byte IsCOD { get { return iscod; } ////Number set { iscod = value; } ////Number } public int BookingStatusId { get { return bookingstatusid; } //LeadCode set { bookingstatusid = value; } //LeadCode } public byte IsDelivered { get { return isdelivered; } ////Number set { isdelivered = value; } ////Number } public DateTime DeliveryDate { get { return deliverydate; } ////Number set { deliverydate = value; } ////Number } public Int16 DeliveryTime { get { return deliverytime; } ////Number set { deliverytime = value; } ////Number } public int DeliveredByEmployeeId { get { return deliveredbyemployeeid; } //LeadCode set { deliveredbyemployeeid = value; } //LeadCode } public int DeliveryByContactId { get { return deliverybycontactid; } //LeadCode set { deliverybycontactid = value; } //LeadCode } public DateTime GRNDate { get { return grndate; } ////Number set { grndate = value; } ////Number } public string GRNNumber { get { return grnnumber; } ////Number set { grnnumber = value; } ////Number } public string ReceivedBy { get { return receivedby; } ////Number set { receivedby = value; } ////Number } public byte IsSignature { get { return issignature; } ////Number set { issignature = value; } ////Number } public byte IsSeal { get { return isseal; } ////Number set { isseal = value; } ////Number } public decimal Length { get { return length; } ////Number set { length = value; } ////Number } public decimal Weight { get { return weight; } ////Number set { weight = value; } ////Number } public decimal Height { get { return height; } ////Number set { height = value; } ////Number } public Int16 Pax { get { return pax; } set { pax = value; } } public int BookingDetailId { get { return bookingdetailid; } //LeadCode set { bookingdetailid = value; } //LeadCode } public string InvoiceNumber { get { return invoicenumber; } ////Number set { invoicenumber = value; } ////Number } public string DetailReferenceNumber { get { return detailreferencenumber; } ////Number set { detailreferencenumber = value; } ////Number } public string PartNumber { get { return partnumber; } ////Number set { partnumber = value; } ////Number } public decimal CODAmount { get { return codamount; } ////Number set { codamount = value; } ////Number } public string DetailDescription { get { return detaildescription; } ////Number set { detaildescription = value; } ////Number } public string CInvoiceNumber { get { return cinvoicenumber; } ////Number set { cinvoicenumber = value; } ////Number } public int ConsigneeId { get { return consigneeid; } ////Number set { consigneeid = value; } ////Number } public string ConsigneeCode { get { return consigneecode; } ////Number set { consigneecode = value; } ////Number } public string ConsigneeName { get { return consigneename; } ////Number set { consigneename = value; } ////Number } public int ConsignerId { get { return consignerid; } ////Number set { consignerid = value; } ////Number } public string ConsignerCode { get { return consignercode; } ////Number set { consignercode = value; } ////Number } public string ConsignerName { get { return consignername; } ////Number set { consignername = value; } ////Number } public string ConsigneeAddressLine1 { get { return consigneeaddressline1; } ////Number set { consigneeaddressline1 = value; } ////Number } public string ConsigneeAddressLine2 { get { return consigneeaddressline2; } ////Number set { consigneeaddressline2 = value; } ////Number } public string ConsigneeAddressLine3 { get { return consigneeaddressline3; } ////Number set { consigneeaddressline3 = value; } ////Number } public string ConsigneeZipCode { get { return consigneezipcode; } ////Number set { consigneezipcode = value; } ////Number } public string ConsignerAddressLine1 { get { return consigneraddressline1; } ////Number set { consigneraddressline1 = value; } ////Number } public string ConsignerAddressLine2 { get { return consigneraddressline2; } ////Number set { consigneraddressline2 = value; } ////Number } public string ConsignerAddressLine3 { get { return consigneraddressline3; } ////Number set { consigneraddressline3 = value; } ////Number } public string ConsignerZipCode { get { return consignerzipcode; } ////Number set { consignerzipcode = value; } ////Number } public int OUId { get { return ouid; } ////Number set { ouid = value; } ////Number } public string OUCode { get { return oucode; } ////Number set { oucode = value; } ////Number } public string OUName { get { return ouname; } ////Number set { ouname = value; } ////Number } public int BillId { get { return billid; } //BillId set { billid = value; } //BillId } public int DocumentId { get { return documentid; } //DocumentId set { documentid = value; } //DocumentId } public string DocumentNumber { get { return documentnumber; } ////DocumentNumber set { documentnumber = value; } ////DocumentNumber } public DateTime DocumentDate { get { return documentdate; } ////DocumentDate set { documentdate = value; } ////DocumentDate } public byte BillStatus { get { return billstatus; } ////BillStatus set { billstatus = value; } ////BillStatus } public string BillStatusName { get { return billstatusname; } ////BillStatusName set { billstatusname = value; } ////BillStatusName } public int DeliveryEmployeeId { get { return deliveryemployeeid; } //DocumentId set { deliveryemployeeid = value; } //DocumentId } public string DeliveryEmployeeCode { get { return deliveryemployeecode; } ////DocumentNumber set { deliveryemployeecode = value; } ////DocumentNumber } public string DeliveryEmployeeName { get { return deliveryemployeename; } ////DocumentDate set { deliveryemployeename = value; } ////DocumentDate } public string DeliveryRunNumber { get { return deliveryrunnumber; } ////DocumentDate set { deliveryrunnumber = value; } ////DocumentDate } public DateTime ManifestDate { get { return manifestdate; } ////DocumentDate set { manifestdate = value; } ////DocumentDate } public string ManifestNumber { get { return manifestnumber; } ////DocumentDate set { manifestnumber = value; } ////DocumentDate } public DateTime TripDate { get { return tripdate; } ////DocumentDate set { tripdate = value; } ////DocumentDate } public string TripNumber { get { return tripnumber; } ////DocumentDate set { tripnumber = value; } ////DocumentDate } public string VehicleNumber { get { return vehiclenumber; } ////DocumentDate set { vehiclenumber = value; } ////DocumentDate } public string BookingStatusCode { get { return bookingstatuscode; } ////DocumentDate set { bookingstatuscode = value; } ////DocumentDate } public string BookingStatusName { get { return bookingstatusname; } ////DocumentDate set { bookingstatusname = value; } ////DocumentDate } public string FormulaCode { get { return formulacode; } ////DocumentDate set { formulacode = value; } ////DocumentDate } public string FormulaName { get { return formulaname; } ////DocumentDate set { formulaname = value; } ////DocumentDate } public decimal CalculatedValue { get { return calculatedvalue; } ////DocumentDate set { calculatedvalue = value; } ////DocumentDate } public string BaleNo { get { return baleno; } ////DocumentDate set { baleno = value; } ////DocumentDate } public decimal InvoiceValue { get { return invoicevalue; } ////DocumentDate set { invoicevalue = value; } ////DocumentDate } public string ReceiptTypeCode { get { return receipttypecode; } ////DocumentDate set { receipttypecode = value; } ////DocumentDate } public string ReceiptTypeName { get { return receipttypename; } ////DocumentDate set { receipttypename = value; } ////DocumentDate } public string PaymentDetails { get { return paymentdetails; } set { paymentdetails = value; } } public string StoreName { get { return storename; } set { storename = value; } } public string ConsigneeCopyName { get { return consigneecopyname; } set { consigneecopyname = value; } } public string GoodsContentName { get { return goodscontentname; } set { goodscontentname = value; } } public string ConsigneeCityName { get { return consigneecityname; } set { consigneecityname = value; } } public string ConsigneePhone { get { return consigneephone; } set { consigneephone = value; } } public string ConsigneeMobile { get { return consigneemobile; } set { consigneemobile = value; } } public string DeliveryType { get { return deliverytype; } set { deliverytype = value; } } public string DeliveryStatusOnLoadedQuantity { get { return deliverystatusonloadedquantity; } set { deliverystatusonloadedquantity = value; } } #endregion #region private DateTime invoicedate; private DateTime mmheadinvoicedate; private int startmeter; private int endmeter; private int totalkm; private double numberofcount; private int noofdays; private decimal deliveryquantity; private string itemcode; private string itemname; private string partycode; private string partyname; private string itemcategorycode; private string itemcategoryname; private decimal deliveryqty; public string ItemCategoryCode { get { return itemcategorycode; } set { itemcategorycode = value; } } public string ItemCategoryName { get { return itemcategoryname; } set { itemcategoryname = value; } } public string PartyCode { get { return partycode; } set { partycode = value; } } public string PartyName { get { return partyname; } set { partyname = value; } } public string ItemCode { get { return itemcode; } set { itemcode = value; } } public string ItemName { get { return itemname; } set { itemname = value; } } public decimal DeliveryQuantity { get { return deliveryquantity; } set { deliveryquantity = value; } } public int NoofDays { get { return noofdays; } set { noofdays = value; } } public DateTime InvoiceDate { get { return invoicedate; } ////DocumentDate set { invoicedate = value; } ////DocumentDate } public DateTime MMHeadInvoiceDate { get { return mmheadinvoicedate; } ////MMHeadInvoiceDate set { mmheadinvoicedate = value; } ////MMHeadInvoiceDate } public int StartMeter { get { return startmeter; } set { startmeter = value; } } public int EndMeter { get { return endmeter; } set { endmeter = value; } } public int TotalKM { get { return totalkm; } set { totalkm = value; } } public double NumberofCount { get { return numberofcount; } set { numberofcount = value; } } public decimal DeliveryQty { get { return deliveryqty; } set { deliveryqty = value; } } #endregion public DateTime BookingHistoryDate { get { return bookinghistorydate; } set { bookinghistorydate = value; } } public string HistoryDetails { get { return historydetails; } set { historydetails = value; } } public int HistoryBookingid { get { return historybookingid; } set { historybookingid = value; } } public string SKUCode { get { return skucode; } set { skucode = value; } } public string RescheduleReasonCode { get { return reschedulereasoncode; } set { reschedulereasoncode = value; } } public string RescheduleReasonName { get { return reschedulereasonname; } set { reschedulereasonname = value; } } public DateTime RescheduledDate { get { return rescheduleddate; } set { rescheduleddate = value; } } public string UomCode { get { return uomcode; } set { uomcode = value; } } public string UomName { get { return uomname; } set { uomname = value; } } } }