public CLayer.Accommodation Get(long AccommodationId) { CLayer.Accommodation result = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, AccommodationId)); DataTable dt = Connection.GetTable("accommodation_Get", param); if (dt.Rows.Count > 0) { result = new CLayer.Accommodation() { AccommodationId = Connection.ToLong(dt.Rows[0]["AccommodationId"]), AccommodationTypeId = Connection.ToInteger(dt.Rows[0]["AccommodationTypeId"]), StayCategoryId = Connection.ToInteger(dt.Rows[0]["StayCategoryId"]), AccommodationCount = Connection.ToInteger(dt.Rows[0]["AccommodationCount"]), PropertyId = Connection.ToLong(dt.Rows[0]["PropertyId"]), Description = Connection.ToString(dt.Rows[0]["Description"]), Location = Connection.ToString(dt.Rows[0]["Location"]), MaxNoOfPeople = Connection.ToInteger(dt.Rows[0]["MaxNoOfPeople"]), MaxNoOfChildren = Connection.ToInteger(dt.Rows[0]["MaxNoOfChildren"]), MinNoOfPeople = Connection.ToInteger(dt.Rows[0]["MinNoOfPeople"]), BedRooms = Connection.ToInteger(dt.Rows[0]["BedRooms"]), Area = Connection.ToDecimal(dt.Rows[0]["Area"]), TotalAccommodations = Connection.ToInteger(dt.Rows[0]["TotalAccommodations"]), Status = Connection.ToInteger(dt.Rows[0]["Status"]) }; } return(result); }
//**Added by rahul on 04/03/2020 //*This is for getting rates for property Accommodation for API public List <CLayer.Rates> GetAccommodationRatesForAPI(string AccIds, DateTime checkIn, DateTime checkOut, int noOfDays, CLayer.Role.Roles rateType, CLayer.Role.Roles defaultType) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pAccs", DataPlug.DataType._Varchar, AccIds)); param.Add(Connection.GetParameter("pCheckIn", DataPlug.DataType._Date, checkIn)); param.Add(Connection.GetParameter("pCheckOut", DataPlug.DataType._Date, checkOut)); param.Add(Connection.GetParameter("pRateType", DataPlug.DataType._Int, rateType)); param.Add(Connection.GetParameter("pDefaultRateType", DataPlug.DataType._Int, (int)defaultType)); param.Add(Connection.GetParameter("pBookingDayCount", DataPlug.DataType._Int, (int)noOfDays)); DataTable dt = Connection.GetTable("accommodation_GetAvailabilityAndRateForAPI", param); List <CLayer.Rates> result = new List <CLayer.Rates>(); CLayer.Rates rt; foreach (DataRow dr in dt.Rows) { rt = new CLayer.Rates(); rt.AccommodationId = Connection.ToLong(dr["AccommodationId"]); rt.Amount = Connection.ToDecimal(dr["Amount"]); rt.GuestRate = Connection.ToDecimal(dr["GuestRate"]); rt.StartDate = Connection.ToDate(dr["startdate"]); rt.EndDate = Connection.ToDate(dr["enddate"]); rt.RateType = Connection.ToInteger(dr["AType"]); rt.NoofAcc = Connection.ToInteger(dr["noofacc"]); rt.PurchaseRateAfterTax = Connection.ToDecimal(dr["DailyRate"]); result.Add(rt); } return(result); }
public List <CLayer.B2B> GetAllSupplier(long userId, int userType) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pB2bId", DataPlug.DataType._BigInt, userId)); param.Add(Connection.GetParameter("pType", DataPlug.DataType._BigInt, userType)); DataTable dt = Connection.GetTable("supplier_GetAll", param); List <CLayer.B2B> result = new List <CLayer.B2B>(); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.B2B() { B2BId = Connection.ToLong(dr["B2BId"]), Name = Connection.ToString(dr["Name"]), MarkupPercent = Connection.ToDecimal(dr["MarkupPercent"]), CommissionPercent = Connection.ToDecimal(dr["CommissionPercent"]), UserCode = Connection.ToString(dr["UserCode"]), ServiceTaxRegNo = Connection.ToString(dr["ServiceTaxRegNo"]), VATRegNo = Connection.ToString(dr["VATRegNo"]), UserId = Connection.ToLong(dr["UserId"]), Email = Connection.ToString(dr["Email"]), UserType = Connection.ToInteger(dr["UserType"]), RequestStatus = Connection.ToInteger(dr["RequestStatus"]), PropertyDescription = Connection.ToString(dr["PropertyDescription"]), AvailableProperties = Connection.ToInteger(dr["AvailableProperties"]) }); } return(result); }
public List <CLayer.SupplierPaymetList> getDetails(long SupplierPaymentId) { List <CLayer.SupplierPaymetList> result = new List <CLayer.SupplierPaymetList>(); CLayer.SupplierPaymetList res = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSupplierPaymentID", DataPlug.DataType._BigInt, SupplierPaymentId)); DataSet ds = Connection.GetDataSet("supplierpaymentvoucher_GetAllBySupplierPaymentID", param); foreach (DataRow dr in ds.Tables[0].Rows) { result.Add(new CLayer.SupplierPaymetList() { SupplierPaymentId = Connection.ToLong(dr["SupplierPaymentId"]), SupplierId = Connection.ToLong(dr["SupplierId"]), OfflineSupplierEmail = Connection.ToString(dr["OfflineSupplierEmail"]), SupplierPayment = Connection.ToDecimal(dr["SupplierPayment"]), dtPayment = Connection.ToDate(dr["dtPayment"]), grossAmount = Connection.ToDecimal(dr["grossAmount"]), tdsAmount = Connection.ToDecimal(dr["tdsAmount"]), netAmtPaid = Connection.ToDecimal(dr["netAmtPaid"]), modeofPayment = Connection.ToString(dr["modeofPayment"]), bank = Connection.ToString(dr["bank"]), SupplierName = Connection.ToString(dr["SupplierName"]), Prop_Name = Connection.ToString(dr["propertyname"]), // Prop_ID = Connection.ToLong(dr["propertyid"]), OrderNo = Connection.ToString(dr["OrderNo"]) }); } return(result); }
public List <CLayer.Recommended> GetAllByManageWithGDS(long ManageFor) { List <CLayer.Recommended> result = new List <CLayer.Recommended>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pManageFor", DataPlug.DataType._BigInt, ManageFor)); DataTable dt = Connection.GetTable("recommendedbymanage_GetAllWithGDS", param); CLayer.Recommended temp; foreach (DataRow dr in dt.Rows) { temp = new CLayer.Recommended(); temp.PropertyId = Connection.ToLong(dr["PropertyId"]); temp.EndDate = Connection.ToDate(dr["EndDate"]); temp.StartDate = Connection.ToDate(dr["StartDate"]); temp.Order = Connection.ToInteger(dr["Order"]); temp.Status = Connection.ToInteger(dr["Status"]); temp.UpdatedByUser = Connection.ToString(dr["UpdatedBy"]); temp.UpdatedDate = Connection.ToDate(dr["UpdatedDate"]); temp.Title = Connection.ToString(dr["Title"]); temp.Supplier = Connection.ToString(dr["Name"]); temp.ManageFor = Connection.ToInteger(dr["ManageFor"]); temp.Amount = Math.Round(Connection.ToDecimal(dr["amount"]), 0); // temp.AccommodationType = Connection.ToString(dr["AccType"]); result.Add(temp); } return(result); }
public CLayer.SupplierInvoice getGetSupplierInvoicedetails(long ID) { CLayer.SupplierInvoice result = new CLayer.SupplierInvoice(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSupplierInvID", DataPlug.DataType._BigInt, ID)); DataTable dt = Connection.GetTable("getGetSupplierInvoicedetails", param); if (dt.Rows.Count > 0) { result = new CLayer.SupplierInvoice(); result.SupplierInvoiceID = Connection.ToLong(dt.Rows[0]["SupplierInvoiceID"]); result.PropertyId = Connection.ToLong(dt.Rows[0]["PropertyID"]); result.Property_Name = Connection.ToString(dt.Rows[0]["Title"]); result.SupplierId = Connection.ToLong(dt.Rows[0]["SupplierID"]); result.InvoiceNumber = Connection.ToString(dt.Rows[0]["InvoiceNumber"]); result.InvoiceDate = Connection.ToDate(dt.Rows[0]["InvoiceDate"]); result.ServiceTaxRegNumber = Connection.ToString(dt.Rows[0]["ServiceTaxRegNumber"]); result.PAN_Number = Connection.ToString(dt.Rows[0]["PAN"]); result.BaseAmount = Connection.ToDecimal(dt.Rows[0]["BaseAmount"]); result.LuxuryTax = Connection.ToDecimal(dt.Rows[0]["LuxuryTax"]); result.ServiceTax = Connection.ToDecimal(dt.Rows[0]["ServiceTax"]); result.TotalInvoiceValue = Connection.ToDecimal(dt.Rows[0]["TotalInvoiceValue"]); result.EntryDate = Connection.ToDate(dt.Rows[0]["EntryDate"]); result.txtTotalAdjustmentResult = Connection.ToDecimal(dt.Rows[0]["TotalAdjustment"]); result.PropertyEmailAddresss = Connection.ToString(dt.Rows[0]["PropertyEmailAddress"]); result.PropertyType = Connection.ToString(dt.Rows[0]["PropertyType"]); result.TaxType = Connection.ToInteger(dt.Rows[0]["TaxType"]); result.IsSupInvoicedone = Connection.ToBoolean(dt.Rows[0]["IsSupInvoicedone"]); result.BookingRefNumber = Connection.ToString(dt.Rows[0]["BookingReferenceIDNo"]); result.CheckedBookingRefNumber = Connection.ToString(dt.Rows[0]["CheckedBookingReferenceIDNo"]); } return(result); }
public List <CLayer.Tax> GetOnStatus(CLayer.ObjectStatus.StatusType status) { List <CLayer.Tax> result = new List <CLayer.Tax>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, (int)status)); DataTable dt = Connection.GetTable("tax_GetOnStatus", null); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.Tax() { TaxId = Connection.ToInteger(dt.Rows[0]["TaxId"]), Title = Connection.ToString(dt.Rows[0]["Title"]), Rate = Connection.ToDecimal(dt.Rows[0]["Title"]), CountryId = Connection.ToInteger(dt.Rows[0]["CountryId"]), StateId = Connection.ToInteger(dt.Rows[0]["StateId"]), Description = Connection.ToString(dt.Rows[0]["Description"]), Notes = Connection.ToString(dt.Rows[0]["Notes"]), IsStandard = Connection.ToBoolean(dt.Rows[0]["IsStandard"]), Status = Connection.ToInteger(dt.Rows[0]["Status"]) }); } return(result); }
public List <CLayer.Tax> GetAll() { List <CLayer.Tax> result = new List <CLayer.Tax>(); DataTable dt = Connection.GetTable("tax_GetAll", null); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.Tax() { TaxId = Connection.ToInteger(dr["TaxId"]), Title = Connection.ToString(dr["Title"]), TaxTitleId = Connection.ToInteger(dr["TaxTitleId"]), Rate = Connection.ToDecimal(dr["Rate"]), CountryId = Connection.ToInteger(dr["CountryId"]), Country = Connection.ToString(dr["CountryName"]), StateId = Connection.ToInteger(dr["StateId"]), State = Connection.ToString(dr["StateName"]), CityId = Connection.ToInteger(dr["CityId"]), City = Connection.ToString(dr["CityName"]), Notes = Connection.ToString(dr["Notes"]), Status = Connection.ToInteger(dr["Status"]), StartDate = Connection.ToDate(dr["StartDate"]), EndDate = Connection.ToDate(dr["EndDate"]), OnDate = Connection.ToInteger(dr["OnDate"]), OnTotalAmount = Connection.ToBoolean(dr["OnTotalAmount"]), PriceUpto = Connection.ToDecimal(dr["PriceUpto"]), UpdatedBy = Connection.ToLong(dr["UpdatedBy"]), UpdatedDate = Connection.ToDate(dr["UpdatedDate"]), Unlimited = Connection.ToBoolean(dr["UnlimitedPrice"]) }); } return(result); }
public List <CLayer.Tax> GetAllForProperty(long propertyId, DateTime checkIn, DateTime bookingDate) { List <CLayer.Tax> result = new List <CLayer.Tax>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyId)); param.Add(Connection.GetParameter("pCheckIn", DataPlug.DataType._Date, checkIn)); param.Add(Connection.GetParameter("pBooking", DataPlug.DataType._Date, bookingDate)); DataTable dt = Connection.GetTable("tax_GetAllByProperty", param); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.Tax() { TaxId = Connection.ToInteger(dr["TaxId"]), TaxTitleId = Connection.ToInteger(dr["TaxTitleId"]), Rate = Connection.ToDecimal(dr["Rate"]), CountryId = Connection.ToInteger(dr["CountryId"]), // Country = Connection.ToString(dr["CountryName"]), StateId = Connection.ToInteger(dr["StateId"]), // State = Connection.ToString(dr["StateName"]), CityId = Connection.ToInteger(dr["CityId"]), // City = Connection.ToString(dr["CityName"]), Notes = Connection.ToString(dr["Notes"]), Status = Connection.ToInteger(dr["Status"]), StartDate = Connection.ToDate(dr["StartDate"]), EndDate = Connection.ToDate(dr["EndDate"]), OnDate = Connection.ToInteger(dr["OnDate"]), OnTotalAmount = Connection.ToBoolean(dr["OnTotalAmount"]), PriceUpto = Connection.ToDecimal(dr["PriceUpto"]), Unlimited = Connection.ToBoolean(dr["UnlimitedPrice"]) }); } return(result); }
public CLayer.BookingExternalInventory GetAllDetailsByRoomIdandHotelId(string RoomId, string HotelId) { CLayer.BookingExternalInventory result = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pRoomId", DataPlug.DataType._Varchar, RoomId)); param.Add(Connection.GetParameter("pHotelId", DataPlug.DataType._Varchar, HotelId)); DataTable dt = Connection.GetTable("BookExternalInventory_ByRoomIdandHotelId", param); if (dt.Rows.Count > 0) { result = new CLayer.BookingExternalInventory() { hotel_id = Connection.ToString(dt.Rows[0]["HotelId"]), hotel_name = Connection.ToString(dt.Rows[0]["HotelName"]), roomtype_id = Connection.ToString(dt.Rows[0]["RoomId"]), room_name = Connection.ToString(dt.Rows[0]["RoomName"]), room_desc = Connection.ToString(dt.Rows[0]["RoomDesc"]), final_price_at_bookingamt = Connection.ToDecimal(dt.Rows[0]["FinalPriceAtBookingAmt"]), final_price_at_bookingamtcurr = Connection.ToString(dt.Rows[0]["FinalPriceAtBookingAmtCurr"]), final_price_at_checkoutamt = Connection.ToDecimal(dt.Rows[0]["FinalPriceAtCheckoutAmt"]), final_price_at_checkoutamtcurr = Connection.ToString(dt.Rows[0]["FinalPriceAtCheckoutAmtCurr"]), DomainId = Connection.ToString(dt.Rows[0]["DomainId"]), RatePlanId = Connection.ToString(dt.Rows[0]["RatePlanId"]), PromotionId = Connection.ToString(dt.Rows[0]["PromotionId"]) }; } return(result); }
public CLayer.OfflinePayment GetOfflinePaymentDetails(long OfflinePaymentId) { CLayer.OfflinePayment result = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pOfflinePayId", DataPlug.DataType._BigInt, OfflinePaymentId)); DataTable dt = Connection.GetTable("OfflinePayment_GetDetails", param); if (dt.Rows.Count > 0) { result = new CLayer.OfflinePayment(); result.UserId = Connection.ToLong(dt.Rows[0]["UserId"]); result.Amount = Connection.ToDecimal(dt.Rows[0]["Amount"]); result.Name = Connection.ToString(dt.Rows[0]["Name"]); result.Message = Connection.ToString(dt.Rows[0]["Message"]); result.ReferenceNumber = Connection.ToString(dt.Rows[0]["ReferenceNo"]); result.PaymentRefNo = Connection.ToString(dt.Rows[0]["PaymentReferenceNo"]); result.CreatedDate = Connection.ToDate(dt.Rows[0]["CreatedDate"]); result.Email = Connection.ToString(dt.Rows[0]["Email"]); result.Mobile = Connection.ToString(dt.Rows[0]["Mobile"]); result.Address = Connection.ToString(dt.Rows[0]["Address"]); result.Country = Connection.ToString(dt.Rows[0]["CountryName"]); result.State = Connection.ToString(dt.Rows[0]["StateName"]); result.City = Connection.ToString(dt.Rows[0]["CityName"]); result.CountryCode = Connection.ToString(dt.Rows[0]["CountryCode"]); result.ZipCode = Connection.ToString(dt.Rows[0]["ZipCode"]); //result.PaymentLinkID = (Guid)(dt.Rows[0]["PaymentLinkGuidId"]); result.PaymentLinkID = Connection.ToString(dt.Rows[0]["PaymentLinkGuidId"]); } return(result); }
public List <CLayer.OfflinePayment> ReportOfflinePayment_GetAll(int status, string searchString, int searchItem, int start, int limit) { List <CLayer.OfflinePayment> bookings = new List <CLayer.OfflinePayment>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, status)); param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Varchar, searchString)); param.Add(Connection.GetParameter("pSearchItem", DataPlug.DataType._Int, searchItem)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit)); DataSet ds = Connection.GetDataSet("Report_OfflinePaymentGetall", param); foreach (DataRow dr in ds.Tables[1].Rows) { bookings.Add(new CLayer.OfflinePayment() { LoginUsername = Connection.ToString(dr["LoginUsername"]), Name = Connection.ToString(dr["PayUserName"]), Amount = Connection.ToDecimal(dr["PayAmount"]), Message = Connection.ToString(dr["Message"]), ReferenceNumber = Connection.ToString(dr["PayUserRefNo"]), PaymentRefNo = Connection.ToString(dr["PaymentReferenceNo"]), Mobile = Connection.ToString(dr["Mobile"]), State = Connection.ToString(dr["State"]), City = Connection.ToString(dr["City"]), Email = Connection.ToString(dr["Email"]), Country = Connection.ToString(dr["CountryName"]), CreatedDate = Connection.ToDate(dr["CreatedDate"]), OfflinePaymentStatus = Connection.ToInteger(dr["OfflinePaymentStatus"]), OfflinePaymentId = Connection.ToInteger(dr["OfflinePaymentId"]), TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]), }); } return(bookings); }
public List <CLayer.OfflinePayment> GetOfflinePaymentDetails2(long OfflinePaymentId) { List <CLayer.OfflinePayment> result = new List <CLayer.OfflinePayment>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pOfflinePayId", DataPlug.DataType._BigInt, OfflinePaymentId)); DataSet ds = Connection.GetDataSet("OfflinePayment_GetDetails", param); foreach (DataRow dr in ds.Tables[0].Rows) { result.Add(new CLayer.OfflinePayment() { //result = new CLayer.OfflinePayment(), UserId = Connection.ToLong(dr["UserId"]), Amount = Connection.ToDecimal(dr["Amount"]), Name = Connection.ToString(dr["Name"]), Message = Connection.ToString(dr["Message"]), ReferenceNumber = Connection.ToString(dr["ReferenceNo"]), PaymentRefNo = Connection.ToString(dr["PaymentReferenceNo"]), CreatedDate = Connection.ToDate(dr["CreatedDate"]), Email = Connection.ToString(dr["Email"]), Mobile = Connection.ToString(dr["Mobile"]), Address = Connection.ToString(dr["Address"]), Country = Connection.ToString(dr["CountryName"]), State = Connection.ToString(dr["StateName"]), City = Connection.ToString(dr["CityName"]), CountryCode = Connection.ToString(dr["CountryCode"]), ZipCode = Connection.ToString(dr["ZipCode"]), //result.PaymentLinkID = (Guid)(dt.Rows[0]["PaymentLinkGuidId"]); PaymentLinkID = Connection.ToString(ds.Tables[0].Rows[0]["PaymentLinkGuidId"]) }); } return(result); }
public List <CLayer.Rates> GetCalcDailyRates(long accommodationId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); List <CLayer.Rates> result = new List <CLayer.Rates>(); param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, accommodationId)); DataTable dt = Connection.GetTable("ratesaccomodation_GetCalcDailyRates", param); CLayer.Rates rt1; foreach (DataRow dr in dt.Rows) { rt1 = new CLayer.Rates(); rt1.RateFor = Connection.ToInteger(dr["RateFor"]); rt1.RateId = Connection.ToLong(dr["RateId"]); rt1.AccommodationId = accommodationId; rt1.DailyRate = Connection.ToDecimal(dr["DailyRate"]); rt1.CalcDailyRate = Connection.ToDecimal(dr["CalcDailyRate"]); rt1.GuestRate = Connection.ToDecimal(dr["GuestRate"]); rt1.LongTermRate = Connection.ToDecimal(dr["LongTermRate"]); rt1.MonthlyRate = Connection.ToDecimal(dr["MonthlyRate"]); rt1.WeeklyRate = Connection.ToDecimal(dr["WeeklyRate"]); result.Add(rt1); } return(result); }
public decimal GetGrantTotalTaxbyBookingId(long BookingId) { string sql = "SELECT SUM(bite.TotalRateTax) FROM bookingitems bite WHERE bite.`BookingId`=" + BookingId.ToString(); object obj = Connection.ExecuteSQLQueryScalar(sql); return(Connection.ToDecimal(obj)); }
public decimal GetFirstDayCharge(long bookingItemId) { string sql = "Select FirstDayCharge from bookingitems where BookingItemId=" + bookingItemId.ToString(); object obj = Connection.ExecuteSQLQueryScalar(sql); return(Connection.ToDecimal(obj)); }
public CLayer.B2B GetbookingcreditforCorte(long b2bId) { CLayer.B2B b2b = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pB2BId", DataPlug.DataType._BigInt, b2bId)); DataTable dt = Connection.GetTable("b2bcorporate_Getbookingcredits", param); if (dt.Rows.Count > 0) { b2b = new CLayer.B2B(); b2b.B2BId = Connection.ToLong(dt.Rows[0]["B2BId"]); b2b.Name = Connection.ToString(dt.Rows[0]["Name"]); b2b.UserCode = Connection.ToString(dt.Rows[0]["UserCode"]); b2b.MarkupPercent = Connection.ToDecimal(dt.Rows[0]["MarkupPercent"]); b2b.CommissionPercent = Connection.ToDecimal(dt.Rows[0]["CommissionPercent"]); b2b.ServiceTaxRegNo = Connection.ToString(dt.Rows[0]["ServiceTaxRegNo"]); b2b.VATRegNo = Connection.ToString(dt.Rows[0]["VATRegNo"]); b2b.MaximumStaff = Connection.ToInteger(dt.Rows[0]["MaximumStaff"]); b2b.RequestStatus = Connection.ToInteger(dt.Rows[0]["RequestStatus"]); b2b.Email = Connection.ToString(dt.Rows[0]["Email"]); b2b.UserId = Connection.ToLong(dt.Rows[0]["UserId"]); b2b.CompanyRegNo = Connection.ToString(dt.Rows[0]["CompanyRegNo"]); b2b.UserType = Connection.ToInteger(dt.Rows[0]["UserType"]); b2b.PropertyDescription = Connection.ToString(dt.Rows[0]["PropertyDescription"]); b2b.AvailableProperties = Connection.ToInteger(dt.Rows[0]["AvailableProperties"]); b2b.PANNo = Connection.ToString(dt.Rows[0]["PANNo"]); b2b.ContactDesignation = Connection.ToString(dt.Rows[0]["ContactDesignation"]); b2b.IsCreditBooking = Connection.ToInteger(dt.Rows[0]["IsCreditBooking"]); b2b.CreditDays = Connection.ToInteger(dt.Rows[0]["CreditDays"]); b2b.CreditAmount = Connection.ToDecimal(dt.Rows[0]["CreditAmount"]); b2b.TotalCreditAmount = Connection.ToDecimal(dt.Rows[0]["TotalCreditAmount"]); } return(b2b); }
public List <CLayer.Offers> GetForAccommodation(long accommodationId, int activeStatus) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pActiveStatus", DataPlug.DataType._Int, activeStatus)); param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, accommodationId)); DataTable dt = Connection.GetTable("offer_ForAccommodation", param); List <CLayer.Offers> result = new List <CLayer.Offers>(); CLayer.Offers temp; foreach (DataRow dr in dt.Rows) { temp = new CLayer.Offers(); temp.OfferId = Connection.ToLong(dr["OfferId"]); temp.OfferTitle = Connection.ToString(dr["OfferTitle"]); temp.OfferType = Connection.ToInteger(dr["OfferType"]); temp.RateType = Connection.ToInteger(dr["RateType"]); temp.StartDate = Connection.ToDate(dr["StartDate"]); temp.EndDate = Connection.ToDate(dr["EndDate"]); temp.FreeDays = Connection.ToInteger(dr["FreeDays"]); temp.NoOfDays = Connection.ToInteger(dr["NoOfDays"]); temp.Amount = Connection.ToDecimal(dr["Amount"]); result.Add(temp); } return(result); }
public decimal GetTotalTax(long propertyId) { string sql = "Select Sum(TaxValue) as val From propertyTax Where PropertyId=" + propertyId.ToString(); object obj = Connection.ExecuteSQLQueryScalar(sql); return(Connection.ToDecimal(obj)); }
public List <CLayer.Accommodation> GetAllForOwnerProperty(long propertyId, int rateType) { List <CLayer.Accommodation> result = new List <CLayer.Accommodation>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyId)); param.Add(Connection.GetParameter("pType", DataPlug.DataType._Int, rateType)); DataTable dt = Connection.GetTable("accommodation_GetAllForProperty", param); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.Accommodation() { AccommodationId = Connection.ToLong(dr["AccommodationId"]), Status = Connection.ToInteger(dr["Status"]), StayCategory = Connection.ToString(dr["Category"]), AccommodationType = Connection.ToString(dr["AType"]), AccommodationCount = Connection.ToInteger(dr["AccommodationCount"]), MaxNoOfPeople = Connection.ToInteger(dr["MaxNoOfPeople"]), MaxNoOfChildren = Connection.ToInteger(dr["MaxNoOfChildren"]), MinNoOfPeople = Connection.ToInteger(dr["MinNoOfPeople"]), AccommodationTypeId = Connection.ToInteger(dr["AccommodationTypeId"]), StayCategoryId = Connection.ToInteger(dr["StayCategoryId"]), PropertyId = Connection.ToLong(dr["PropertyId"]), Description = Connection.ToString(dr["Description"]), // Location = Connection.ToString(dr["Location"]), BedRooms = Connection.ToInteger(dr["BedRooms"]), Area = Connection.ToDecimal(dr["Area"]), Rate = Connection.ToDecimal(dr["Rate"]) }); } return(result); }
public decimal GetSupplierPaymentBybookingid(long OfflineBookingId) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pOfflineBookingId", DataPlug.DataType._BigInt, OfflineBookingId)); object obj = Connection.ExecuteQueryScalar("GetSupplierPaymentBybookingid", param); return(Connection.ToDecimal(obj)); }
public List <CLayer.OfflineBooking> SupplierInvoiceSavedBookingList(long PropID, long ID, string BookingRefIDs, string PropertyEmailAddresss, string PropertyType) { List <CLayer.OfflineBooking> result = new List <CLayer.OfflineBooking>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); DataTable dt = new DataTable(); if (ID > 0) { param.Add(Connection.GetParameter("pProp_ID", DataPlug.DataType._BigInt, PropID)); param.Add(Connection.GetParameter("pSupplierInvoice_ID", DataPlug.DataType._BigInt, ID)); param.Add(Connection.GetParameter("pPropertyEmailAddresss", DataPlug.DataType._Text, PropertyEmailAddresss)); param.Add(Connection.GetParameter("pPropertyType", DataPlug.DataType._Text, PropertyType)); dt = Connection.GetTable("SupplierInvoicePropertySavedBooking_List", param); } else { param.Add(Connection.GetParameter("pProp_ID", DataPlug.DataType._BigInt, PropID)); param.Add(Connection.GetParameter("pBookingIDs", DataPlug.DataType._Varchar, BookingRefIDs)); param.Add(Connection.GetParameter("pPropertyEmailAddresss", DataPlug.DataType._Text, PropertyEmailAddresss)); param.Add(Connection.GetParameter("pPropertyType", DataPlug.DataType._Text, PropertyType)); dt = Connection.GetTable("SupplierInvoicePropertyBooking_List_ForSaving", param); } //param.Add(Connection.GetParameter("pProp_ID", DataPlug.DataType._BigInt, PropID)); //param.Add(Connection.GetParameter("pSupplierInvoice_ID", DataPlug.DataType._BigInt, ID)); //DataTable dt = Connection.GetTable("SupplierInvoicePropertySavedBooking_List", param); CLayer.OfflineBooking res = null; if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { res = new CLayer.OfflineBooking(); res.PropertyId = Connection.ToLong(dr["Prop_ID"]); res.OfflineBookingId = Connection.ToLong(dr["Primary_ID"]); res.ConfirmationNumber = Connection.ToString(dr["OrderNo"]); //res.Amount = Connection.ToLong(dr["Amount"]); res.CheckIn_date = Connection.ToDate(dr["CheckIn_date"]); res.CheckOut_date = Connection.ToDate(dr["CheckOut_date"]); //res.BookingDate = Connection.ToDate(dr["BookingDate"]); res.PropertyName = Connection.ToString(dr["PropertyName"]); res.PropertyContactNo = Connection.ToString(dr["PropertyContactNo"]); res.PropertyEmail = Connection.ToString(dr["PropertyEmail"]); res.SupplierName = Connection.ToString(dr["SupplierName"]); res.SupplierMobile = Connection.ToString(dr["SupplierMobile"]); res.SupplierEmail = Connection.ToString(dr["SupplierEmail"]); res.TotalBuyPrice = Connection.ToDecimal(dr["TotalBuyPrice"]); res.City = Connection.ToString(dr["City"]); res.isOpen = Connection.ToBoolean(dr["open"]); res.SupInvoiceValueBRef = Connection.ToDecimal(dr["SupInvoiceValueBRef"]); res.PaidValueBRef = Connection.ToDecimal(dr["PaidValueBRef"]); res.AmtTobePaid = Connection.ToDecimal(dr["AmtTobePaid"]); result.Add(res); } } return(result); }
public List <CLayer.SupplierPayment> GetAllSupllierPaymentVoucher(long SupplierPaymentId) { List <CLayer.SupplierPayment> users = new List <CLayer.SupplierPayment>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSupplierPaymentID", DataPlug.DataType._Int, SupplierPaymentId)); DataSet ds = Connection.GetDataSet("supplierpaymentvoucher_GetAllBySupplierPaymentID", param); foreach (DataRow dr in ds.Tables[0].Rows) { users.Add(new CLayer.SupplierPayment() { grossAmount = Connection.ToDecimal(dr["grossAmount"]), tdsAmount = Connection.ToDecimal(dr["tdsAmount"]), netAmtPaid = Connection.ToDecimal(dr["netAmtPaid"]), modeofPayment = Connection.ToString(dr["modeofPayment"]), BAnk = Connection.ToString(dr["bank"]), NoOfPaxChild = Connection.ToLong(dr["NoOfPaxChild"]), NoOfPaxAdult = Connection.ToLong(dr["NoOfPaxAdult"]), NoofRooms = Connection.ToLong(dr["NoofRooms"]), Guestname = Connection.ToString(dr["Guestname"]), // Salutation = Connection.ToString(dr["Salutation"]), propertyname = Connection.ToString(dr["PropertyName"]), propertycity = Connection.ToString(dr["propertycity"]), Region = Connection.ToString(dr["Region"]), Amount = Connection.ToDecimal(dr["Amount"]), SupplierCity = Connection.ToString(dr["SupplierCity"]), // FirstName = Connection.ToString(dr["FirstName"]), // LastName = Connection.ToString(dr["LastName"]), SupplierEmail = Connection.ToString(dr["SupplierEmail"]), SupplierName = Connection.ToString(dr["SupplierName"]), Buyprice = Connection.ToDouble(dr["TotalBuyPrice"]), pdtPayment = Connection.ToDate(dr["dtPayment"]), AmountPaid = Connection.ToDouble(dr["amount"]), SupplierMobile = Connection.ToString(dr["SupplierMobile"]), OrderId = Connection.ToString(dr["Orderno"]), CheckIn_date = Connection.ToDate(dr["CheckIn_date"]), // DeletedDate = Connection.ToDate(dr["DeletedDate"]), CheckOut_date = Connection.ToDate(dr["CheckOut_date"]), BookingDate = Connection.ToDate(dr["BookingDate"]), NoofDays = Connection.ToLong(dr["Noofnight"]), Payamount = Connection.ToDecimal(dr["PayAmount"]) // Status = Connection.ToInteger(dr["Status"]), // PANNo = Connection.ToString(dr["PANNo"]), // UserCode = Connection.ToString(dr["UserCode"]), }); } return(users); }
//*This is for getting details of offlinebooking //*Done by rahul on 06-02-2020 public List <CLayer.BookingItem> GetAllOfflineDetails(long bookingId, bool IsAmedus = false) { List <CLayer.BookingItem> result = new List <CLayer.BookingItem>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); try { param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, bookingId)); DataTable dt; dt = Connection.GetTable("offlinebooking_GetAllItems", param); CLayer.BookingItem bi; foreach (DataRow dr in dt.Rows) { bi = new CLayer.BookingItem(); bi.BookingItemId = Connection.ToLong(dr["BookingId"]); bi.AccommodationId = Connection.ToLong(dr["AccommodatoinTypeId"]); bi.BookingId = Connection.ToLong(dr["Offline_BookingId"]); bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]); bi.CheckIn = Connection.ToDate(dr["CheckIn_date"]); bi.CheckOut = Connection.ToDate(dr["CheckOut_date"]); bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfRooms"]); bi.NoOfAdults = Connection.ToInteger(dr["NoOfPaxAdult"]); bi.NoOfChildren = Connection.ToInteger(dr["NoOfPaxChild"]); bi.NoOfDays = Connection.ToInteger(dr["Noofnight"]); bi.Amount = Connection.ToDecimal(dr["TotalBuyPrice"]); bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]); bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]); bi.PropertyId = Connection.ToLong(dr["PropertyId"]); bi.TotalAmount = Connection.ToDecimal(dr["TotalAmtForBuyPrice"]); bi.TotalTax = Connection.ToDecimal(dr["StaxForBuyPrice"]); bi.AccommodationTypeT = Connection.ToString(dr["AccommodationType"]); bi.StayCategoryT = Connection.ToString(dr["StayCategory"]); bi.DailyRate = Connection.ToDecimal(dr["DailyRate"]); bi.HotelConfirmNumber = Connection.ToString(dr["HotelConfirmNumber"]); bi.CountryName = Connection.ToString(dr["CountryName"]); result.Add(bi); } } catch (Exception ex) { result = null; } return(result); }
public List <CLayer.SupplierInvoice> getSupplierInvoiceList_Report(long Start, long Limit, DateTime?fromDT, DateTime?toDT) { fromDT = fromDT == DateTime.MinValue ? null : fromDT; toDT = toDT == DateTime.MinValue ? null : toDT; List <CLayer.SupplierInvoice> result = new List <CLayer.SupplierInvoice>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pfromDT", DataPlug.DataType._Date, fromDT)); param.Add(Connection.GetParameter("ptoDT", DataPlug.DataType._Date, toDT)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._BigInt, Start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._BigInt, Limit)); DataSet ds = Connection.GetDataSet("getGetSupplierInvoiceList_Report", param); CLayer.SupplierInvoice res = null; if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[1].Rows) { res = new CLayer.SupplierInvoice(); res.SupplierInvoiceID = Connection.ToLong(dr["SupplierInvoiceID"]); res.PropertyId = Connection.ToLong(dr["PropertyID"]); res.Property_Name = Connection.ToString(dr["Title"]); res.SupplierId = Connection.ToLong(dr["SupplierID"]); res.SupplierName = Connection.ToString(dr["SupplierName"]); res.City = Connection.ToString(dr["City"]); res.InvoiceNumber = Connection.ToString(dr["InvoiceNumber"]); res.InvoiceDate = Connection.ToDate(dr["InvoiceDate"]); res.ServiceTaxRegNumber = Connection.ToString(dr["ServiceTaxRegNumber"]); res.PAN_Number = Connection.ToString(dr["PAN"]); res.BaseAmount = Connection.ToDecimal(dr["BaseAmount"]); res.LuxuryTax = Connection.ToDecimal(dr["LuxuryTax"]); res.ServiceTax = Connection.ToDecimal(dr["ServiceTax"]); res.TotalInvoiceValue = Connection.ToDecimal(dr["TotalInvoiceValue"]); res.EntryDate = Connection.ToDate(dr["EntryDate"]); res.SupplierInvoiceBooking_ID = Connection.ToLong(dr["SupplierInvoiceBooking_ID"]); res.BookingRefNumber = Connection.ToString(dr["BookingRefNumber"]); res.CheckIn_date = Connection.ToDate(dr["CheckIn_date"]); res.CheckOut_date = Connection.ToDate(dr["CheckOut_date"]); res.BookinCreatedDT = Connection.ToDate(dr["BookinCreatedDT"]); res.TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]); result.Add(res); } } return(result); }
//**End Here** public List <CLayer.BookingExternalInventory> GetAllForSearch(string searchString, int searchItem, int start, int limit, int Status) { List <CLayer.BookingExternalInventory> bookings = new List <CLayer.BookingExternalInventory>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Varchar, searchString)); param.Add(Connection.GetParameter("pSearchItem", DataPlug.DataType._Int, searchItem)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit)); param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, Status)); DataSet ds = Connection.GetDataSet("BookingExternalInventoryRequest_GetSearch", param); foreach (DataRow dr in ds.Tables[1].Rows) { bookings.Add(new CLayer.BookingExternalInventory() { hotel_id = Connection.ToString(dr["Hotel_Id"]), hotel_name = Connection.ToString(dr["PropertyName"]), roomtype_id = Connection.ToString(dr["RoomId"]), room_name = Connection.ToString(dr["RoomName"]), room_desc = Connection.ToString(dr["RoomDesc"]), Reference_Id = Connection.ToString(dr["Reference_Id"]), reservation_id = Connection.ToString(dr["Reservation_Id"]), final_price_at_bookingamt = Connection.ToDecimal(dr["FinalPriceAtBookingAmt"]), final_price_at_checkoutamt = Connection.ToDecimal(dr["FinalPriceAtCheckoutAmt"]), IpAddtress = Connection.ToString(dr["Ip_Address"]), PromotionId = Connection.ToString(dr["PromotionId"]), query_key = Connection.ToString(dr["Query_Key"]), DomainId = Connection.ToString(dr["DomainId"]), CreateDate = Connection.ToString(dr["CreatedDate"]), CustomerId = Connection.ToLong(dr["Customer_Id"]), BookingApiType = Connection.ToInteger(dr["BookingApi_Type"]), BookingExtInvReqId = Connection.ToLong(dr["BookingExtInvReqId"]), BookingId = Connection.ToLong(dr["Booking_Id"]), BookingStatus = Connection.ToInteger(dr["Status"]), ReservationStatus = Connection.ToInteger(dr["Reservation_Status"]), RatePlanId = Connection.ToString(dr["RatePlanId"]), CheckInDate = Connection.ToString(dr["CheckIn_date"]), CheckOutDate = Connection.ToString(dr["CheckOut_date"]), TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]) }); } return(bookings); }
public List <CLayer.OfflineBooking> getSupplierInvoicePendings_Report(long Start, long Limit, DateTime?fromDT, DateTime?toDT) { fromDT = fromDT == DateTime.MinValue ? null : fromDT; toDT = toDT == DateTime.MinValue ? null : toDT; List <CLayer.OfflineBooking> result = new List <CLayer.OfflineBooking>(); List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pfromDT", DataPlug.DataType._Date, fromDT)); param.Add(Connection.GetParameter("ptoDT", DataPlug.DataType._Date, toDT)); param.Add(Connection.GetParameter("pStart", DataPlug.DataType._BigInt, Start)); param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._BigInt, Limit)); DataSet ds = Connection.GetDataSet("getGetSupplierInvoicePending_Report", param); CLayer.OfflineBooking res = null; if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[1].Rows) { res = new CLayer.OfflineBooking(); res.PropertyId = Connection.ToLong(dr["Prop_ID"]); res.OfflineBookingId = Connection.ToLong(dr["Primary_ID"]); //res.UserId = Connection.ToString(dr["UserId"]); res.City = Connection.ToString(dr["City"]); res.CustomerName = Connection.ToString(dr["CustomerFirstname"]) + " " + Connection.ToString(dr["CustomerLastName"]); res.GuestName = Connection.ToString(dr["Guestname"]); res.NoOfRooms = Connection.ToLong(dr["NoOfRooms"]); res.ConfirmationNumber = Connection.ToString(dr["OrderNo"]); res.SupplierName = Connection.ToString(dr["SupplierName"]); res.CheckIn = Connection.ToDate(dr["CheckIn_Date"]); res.CheckOut = Connection.ToDate(dr["CheckOut_Date"]); res.Accommodationname = Connection.ToString(dr["AccommodatoinTypeName"]); res.BookingDate = Connection.ToString(dr["BookingDate"]); res.TotalBuyPrice = Connection.ToDecimal(dr["TotalBuyPrice"]); res.TotalSalePrice = Connection.ToDecimal(dr["TotalSalePrice"]); res.PropertyName = Connection.ToString(dr["PropertyName"]); res.SupplierEmail = Connection.ToString(dr["SupplierEmail"]); res.SupplierMobile = Connection.ToString(dr["SupplierMobile"]); res.PropertyContactNo = Connection.ToString(dr["PropertyContactNo"]); res.PropertyEmail = Connection.ToString(dr["PropertyEmail"]); res.TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]); result.Add(res); } } return(result); }
public CLayer.BookingItem GetTotalTaxDetails(long bookingItemId) { CLayer.BookingItem result = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pbookingItemId", DataPlug.DataType._BigInt, bookingItemId)); DataTable dt = Connection.GetTable("bookingitems_GetTotalRateTax", param); CLayer.BookingItem bi; foreach (DataRow dr in dt.Rows) { bi = new CLayer.BookingItem(); bi.TotalRateTax = Connection.ToDecimal(dr["TotalRateTax"]); bi.TotalGuestTax = Connection.ToDecimal(dr["TotalGuestTax"]); result = bi; } return(result); }
public List <CLayer.Currency> GetForListing() { DataTable dt = Connection.GetTable("currency_GetAll"); List <CLayer.Currency> result = new List <CLayer.Currency>(); foreach (DataRow dr in dt.Rows) { result.Add(new CLayer.Currency() { CurrencyId = Connection.ToLong(dr["CurrencyId"]), Title = Connection.ToString(dr["Title"]), Symbol = Connection.ToString(dr["Symbol"]), ConversionRate = Connection.ToDecimal(dr["ConversionRate"]), // IsDefault = Connection.ToBoolean(dr["IsDefault"]), }); } return(result); }
public List <CLayer.Tax> GetAmadeusTaxRates(long PropertyID) { List <CLayer.Tax> result = new List <CLayer.Tax>(); try { string sql = "Select * From amadeustaxrates Where PropertyID=" + PropertyID + ""; DataTable dt = Connection.GetSQLTable(sql); CLayer.Tax temp; foreach (DataRow dr in dt.Rows) { temp = new CLayer.Tax(); temp.TaxId = Connection.ToInteger(dr["TaxId"]); temp.PropertyId = Connection.ToLong(dr["PropertyID"]); temp.BookingCode = Connection.ToString(dr["BookingCode"]); temp.BookingId = Connection.ToLong(dr["BookingId"]); temp.CGSTTitle = Connection.ToString(dr["CGSTTitle"]); temp.SGSTTitle = Connection.ToString(dr["SGSTTitle"]); temp.IGSTTitle = Connection.ToString(dr["IGSTTitle"]); temp.TotalCGSTTaxAmount = Connection.ToDecimal(dr["TotalCGSTTaxAmount"]); temp.TotalSGSTTaxAmount = Connection.ToDecimal(dr["TotalSGSTTaxAmount"]); temp.TotalIGSTTaxAmount = Connection.ToDecimal(dr["TotalIGSTTaxAmount"]); temp.AccommodationId = Connection.ToLong(dr["AccommodationId"]); temp.TaxRate = Connection.ToDouble(dr["TaxRate"]); temp.CGSTTaxRate = Connection.ToDouble(dr["CGSTTaxRate"]); temp.SGSTTaxRate = Connection.ToDouble(dr["SGSTTaxRate"]); temp.IGSTTaxRate = Connection.ToDouble(dr["IGSTTaxRate"]); temp.CGSTTaxRate = (temp.CGSTTaxRate <= 0) ? Convert.ToDouble(GetValue(CLayer.Settings.CGST_TAXRATE)) : temp.CGSTTaxRate; temp.SGSTTaxRate = (temp.SGSTTaxRate <= 0) ? Convert.ToDouble(GetValue(CLayer.Settings.SGST_TAXRATE)) : temp.SGSTTaxRate; temp.IGSTTaxRate = (temp.IGSTTaxRate <= 0) ? Convert.ToDouble(GetValue(CLayer.Settings.IGST_TAXRATE)) : temp.IGSTTaxRate; result.Add(temp); } } catch (Exception ex) { result = null; throw ex; } return(result); }