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