public string GetLocation(string search)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pLocation", DataPlug.DataType._Varchar, search));
DataTable result = Connection.GetTable("common_getLocation", param);
string city, state, country;
city = "";
state = country = "";
StringBuilder sb = new StringBuilder();
if (result.Rows.Count > 0)
{
city = Connection.ToString(result.Rows[0]["city"]);
state = Connection.ToString(result.Rows[0]["state"]);
country = Connection.ToString(result.Rows[0]["country"]);
}
if (state != "")
{
if (city != "")
{
city = city + ",";
}
city = city + state;
}
if (country != "")
{
if (city != "")
{
city = city + ",";
}
city = city + country;
}
return(city);
}
public List <CLayer.BookingItem> GetAllUnderCart(int status, long userId)
{
List <CLayer.BookingItem> result = new List <CLayer.BookingItem>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, status));
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, userId));
DataTable dt = Connection.GetTable("Booking_GetCartItems", param);
CLayer.BookingItem bi;
foreach (DataRow dr in dt.Rows)
{
bi = new CLayer.BookingItem();
bi.BookingItemId = Connection.ToLong(dr["BookingItemId"]);
bi.BookingId = Connection.ToLong(dr["BookingId"]);
bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]);
bi.CheckIn = Connection.ToDate(dr["CheckIn"]);
bi.CheckOut = Connection.ToDate(dr["CheckOut"]);
bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfAccommodations"]);
bi.NoOfAdults = Connection.ToInteger(dr["NoOfAdults"]);
bi.NoOfChildren = Connection.ToInteger(dr["NoOfChildren"]);
bi.NoOfGuests = Connection.ToInteger(dr["NoOfGuests"]);
bi.NoOfDays = Connection.ToInteger(dr["NoOfDays"]);
bi.Amount = Connection.ToDecimal(dr["Amount"]);
bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]);
bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]);
bi.ForUserFirstName = Connection.ToString(dr["ForUserFirstName"]);
bi.ForUserLastName = Connection.ToString(dr["ForUserLastName"]);
bi.ForUserEmail = Connection.ToString(dr["ForUserEmail"]);
bi.ForUserMobile = Connection.ToString(dr["ForUserMobile"]);
bi.TotalAmount = Connection.ToDecimal(dr["TotalAmount"]);
bi.TotalTax = Connection.ToDecimal(dr["TotalTax"]);
result.Add(bi);
}
return(result);
}
public decimal GetAdjustmentAmount(string bookIdList, decimal totalInvoiceValue)
{
//CLayer.SupplierInvoice result = new CLayer.SupplierInvoice();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
bookIdList = bookIdList.Replace(",", "','");
bookIdList = "'" + bookIdList + "'";
param.Add(Connection.GetParameter("bookidlist", DataPlug.DataType._Varchar, bookIdList));
//string newNum = string.Empty;
//foreach (string num in bookIdList.Split(',').ToList<string>())
//{
// string orgNum = num == null ? "" : num;
// if(orgNum!="")
// {
// if(newNum== string.Empty)
// {
// newNum = "'"+orgNum;
// }
// else
// {
// newNum = newNum+"'," + orgNum + "'";
// }
// }
//}
param.Add(Connection.GetParameter("totalinvoicevalue", DataPlug.DataType._Decimal, totalInvoiceValue));
object result = Connection.ExecuteQueryScalar("GetAdjustementAmountForSupplierInvoice", param);
return(Connection.ToDecimal(result));
}
public DataTable SaveGDSFeatureProperties(List <string> codes)
{
string fullcsv = string.Join("','", codes);
fullcsv = "'" + fullcsv + "'";
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCodes", DataPlug.DataType._Text, fullcsv));
DataTable dt = Connection.GetTable("gds_GetGDSPropertyFeatureSaveProperty", param);
string insertcsv = "";
if (dt.Rows.Count != codes.Count)
{
foreach (DataRow dr in dt.Rows)
{
codes.Remove(Connection.ToString(dr[0]));
}
foreach (string item in codes)
{
if (insertcsv != "")
{
insertcsv = insertcsv + ",";
}
insertcsv = insertcsv + "('',2,'" + item + "',1)";
}
}
param.Clear();
//param.Add(Connection.GetParameter("pCodes", DataPlug.DataType._Text, insertcsv));
//param.Add(Connection.GetParameter("pFullCodes", DataPlug.DataType._Text, fullcsv));
//dt = Connection.GetTable("gds_GetSearchProperties", param);
return(dt);
}
public long SaveInitialPaymentData(CLayer.OfflinePayment data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._Int, data.UserId));
param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, data.Name));
param.Add(Connection.GetParameter("pRefNumber", DataPlug.DataType._Varchar, data.ReferenceNumber));
param.Add(Connection.GetParameter("pAmount", DataPlug.DataType._Decimal, data.Amount));
param.Add(Connection.GetParameter("pMessage", DataPlug.DataType._Varchar, data.Message));
param.Add(Connection.GetParameter("pAddress", DataPlug.DataType._Varchar, data.Address));
param.Add(Connection.GetParameter("pEmail", DataPlug.DataType._Varchar, data.Email));
param.Add(Connection.GetParameter("pMobile", DataPlug.DataType._Varchar, data.Mobile));
param.Add(Connection.GetParameter("pCountryId", DataPlug.DataType._Int, data.CountryId));
param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._Int, data.StateId));
param.Add(Connection.GetParameter("pCityId", DataPlug.DataType._Int, data.CityId));
param.Add(Connection.GetParameter("pCityName", DataPlug.DataType._Varchar, data.City));
param.Add(Connection.GetParameter("pZipCode", DataPlug.DataType._Varchar, data.ZipCode));
param.Add(Connection.GetParameter("pGatewaytype", DataPlug.DataType._Int, data.Gatewaytype));
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, (int)CLayer.ObjectStatus.OfflinePyamentStatus.Processing));
object result = Connection.ExecuteQueryScalar("offlineBookingPayment_Save", param);
return(Connection.ToLong(result));
}
public CLayer.BankAccount GetOnUser(long UserId)
{
CLayer.BankAccount result = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, UserId));
DataTable dt = Connection.GetTable("bankaccount_GetOnUser", param);
if (dt.Rows.Count > 0)
{
result = new CLayer.BankAccount()
{
BankAccountId = Connection.ToLong(dt.Rows[0]["BankAccountId"]),
UserId = Connection.ToLong(dt.Rows[0]["UserId"]),
AccountName = Connection.ToString(dt.Rows[0]["AccountName"]),
AccountNumber = Connection.ToString(dt.Rows[0]["AccountNumber"]),
BankName = Connection.ToString(dt.Rows[0]["BankName"]),
BranchAddress = Connection.ToString(dt.Rows[0]["BranchAddress"]),
RTGSNumber = Connection.ToString(dt.Rows[0]["RTGSNumber"]),
MICRCode = Connection.ToString(dt.Rows[0]["MIRCCode"])
};
}
return(result);
}
public CLayer.Offers GetByOfferId(long OfferId, int Status)
{
CLayer.Offers Offerob = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pOfferId", DataPlug.DataType._BigInt, OfferId));
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._BigInt, Status));
DataTable dt = Connection.GetTable("Offer_GetById", param);
if (dt.Rows.Count > 0)
{
Offerob = new CLayer.Offers();
Offerob.OfferId = OfferId;
Offerob.OfferTitle = Connection.ToString(dt.Rows[0]["OfferTitle"]);
Offerob.OfferId = Connection.ToLong(dt.Rows[0]["OfferId"]);
Offerob.NoOfDays = Connection.ToInteger(dt.Rows[0]["NoOfDays"]);
Offerob.StartDate = Connection.ToDate(dt.Rows[0]["StartDate"]);
Offerob.EndDate = Connection.ToDate(dt.Rows[0]["EndDate"]);
Offerob.Status = Connection.ToInteger(dt.Rows[0]["Status"]);
//AccommodationId = Connection.ToLong(dt.Rows[0]["AccommodationId"]);
Offerob.Amount = Connection.ToDecimal(dt.Rows[0]["Amount"]);
Offerob.OfferFor = Connection.ToInteger(dt.Rows[0]["OfferFor"]);
Offerob.RateType = Connection.ToInteger(dt.Rows[0]["RateType"]);
Offerob.SBCommission = Connection.ToDecimal(dt.Rows[0]["SBCommission"]);
Offerob.OfferTitle = Connection.ToString(dt.Rows[0]["OfferTitle"]);
Offerob.FreeDays = Connection.ToInteger(dt.Rows[0]["FreeDays"]);
//PropertyId = Connection.ToLong(dt.Rows[0]["PropertyId"]);
Offerob.OfferType = Connection.ToInteger(dt.Rows[0]["OfferType"]);
Offerob.StayCategoryId = Connection.ToInteger(dt.Rows[0]["StayCategoryId"]);
//Display
Offerob.Title = Connection.ToString(dt.Rows[0]["Title"]);
Offerob.Location = Connection.ToString(dt.Rows[0]["Location"]);
Offerob.Address = Connection.ToString(dt.Rows[0]["Address"]);
}
return(Offerob);
}
public List <CLayer.Tax> GetAllByTaxtTitleId(int taxtitleId)
{
List <CLayer.Tax> result = new List <CLayer.Tax>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pTaxTitleId", DataPlug.DataType._Int, taxtitleId));
DataTable dt = Connection.GetTable("tax_GetAllByTaxTitleId", param);
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 CLayer.Address GetAddressOnUserId(long UserId)
{
CLayer.Address address = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, UserId));
DataTable dt = Connection.GetTable("address_GetonUserIdByType", param);
if (dt.Rows.Count > 0)
{
address = new CLayer.Address();
address.Firstname = Connection.ToString(dt.Rows[0]["Firstname"]);
address.Lastname = Connection.ToString(dt.Rows[0]["LastName"]);
address.Email = Connection.ToString(dt.Rows[0]["Email"]);
address.City = Connection.ToString(dt.Rows[0]["City"]);
address.AddressText = Connection.ToString(dt.Rows[0]["Address"]);
address.Country = Connection.ToString(dt.Rows[0]["Country"]);
address.Phone = Connection.ToString(dt.Rows[0]["Phone"]);
address.Mobile = Connection.ToString(dt.Rows[0]["Mobile"]);
address.StateName = Connection.ToString(dt.Rows[0]["State"]);
address.ZipCode = Connection.ToString(dt.Rows[0]["ZipCode"]);
}
return(address);
}
public List <CLayer.Review> RecommendedView(string SearchString, int Status, bool Recommended, int Start, int Limit)
{
List <CLayer.Review> result = new List <CLayer.Review>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Varchar, SearchString));
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, Status));
param.Add(Connection.GetParameter("pRecommended", DataPlug.DataType._Bool, Recommended));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit));
DataSet ds = Connection.GetDataSet("review_Recommended", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
result.Add(new CLayer.Review()
{
PropertyId = Connection.ToLong(dr["PropertyId"]),
UserId = Connection.ToLong(dr["UserId"]),
BookingId = Connection.ToLong(dr["BookingId"]),
Rating = Connection.ToInteger(dr["Rating"]),
Status = Connection.ToInteger(dr["Status"]),
ReviewDate = Connection.ToDate(dr["ReviewDate"]),
FirstName = Connection.ToString(dr["FirstName"]),
LastName = Connection.ToString(dr["LastName"]),
Title = Connection.ToString(dr["Title"]),
Location = Connection.ToString(dr["Location"]),
Address = Connection.ToString(dr["Address"]),
Description = Connection.ToString(dr["Description"]),
UpdatedBy = Connection.ToLong(dr["UpdatedBy"]),
UpdatedDate = Connection.ToDate(dr["UpdatedDate"]),
Recommended = Connection.ToBoolean(dr["IsRecommended"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(result);
}
public CLayer.BookingItem GetDetails(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_GetDetails", param);
CLayer.BookingItem bi;
foreach (DataRow dr in dt.Rows)
{
bi = new CLayer.BookingItem();
bi.BookingItemId = Connection.ToLong(dr["BookingItemId"]);
bi.BookingId = Connection.ToLong(dr["BookingId"]);
bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]);
bi.CheckIn = Connection.ToDate(dr["CheckIn"]);
bi.CheckOut = Connection.ToDate(dr["CheckOut"]);
bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfAccommodations"]);
bi.NoOfAdults = Connection.ToInteger(dr["NoOfAdults"]);
bi.NoOfChildren = Connection.ToInteger(dr["NoOfChildren"]);
bi.NoOfGuests = Connection.ToInteger(dr["NoOfGuests"]);
bi.NoOfDays = Connection.ToInteger(dr["NoOfDays"]);
bi.Amount = Connection.ToDecimal(dr["Amount"]);
bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]);
bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]);
bi.ForUserFirstName = Connection.ToString(dr["ForUserFirstName"]);
bi.ForUserLastName = Connection.ToString(dr["ForUserLastName"]);
bi.ForUserEmail = Connection.ToString(dr["ForUserEmail"]);
bi.ForUserMobile = Connection.ToString(dr["ForUserMobile"]);
bi.TotalAmount = Connection.ToDecimal(dr["TotalAmount"]);
bi.TotalTax = Connection.ToDecimal(dr["TotalTax"]);
result = bi;
}
return(result);
}
public CLayer.State GetStateID(string cityname)
{
CLayer.State state = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCity", DataPlug.DataType._Varchar, cityname));
DataTable dt = Connection.GetTable("stateID_Get", param);
if (dt.Rows.Count > 0)
{
state = new CLayer.State();
state.StateId = Connection.ToInteger(dt.Rows[0]["StateId"]);
state.Name = Connection.ToString(dt.Rows[0]["Name"]);
//state.CountryId = Connection.ToInteger(dt.Rows[0]["CountryId"]);
//state.GSTStateCode = Connection.ToString(dt.Rows[0]["GSTStateCode"]);
}
else
{
state = new CLayer.State();
state.StateId = 0;
state.Name = "";
}
return(state);
}
public List <CLayer.APIPriceMarkup> GetAPIPriceMarkup(string SearchString, int start, int limit)
{
List <CLayer.APIPriceMarkup> API = new List <CLayer.APIPriceMarkup>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, SearchString));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit));
DataSet ds = Connection.GetDataSet("Sp_APIPriceMarkup_Get", param);
//foreach (DataRow dr in ds.Tables[0].Rows)
//{
// API.Add(new CLayer.APIPriceMarkup()
// {
// TotalRows = Connection.ToInteger(dr["NumberOfRows"])
// });
//}
foreach (DataRow dr in ds.Tables[1].Rows)
{
API.Add(new CLayer.APIPriceMarkup()
{
//APIPriceMarkupCode = Connection.ToInteger(dt.Rows[0]["api_pricemarkup_code"]),
//APIDescription = Connection.ToString(dt.Rows[0]["api_description"]),
//CustomerId = Connection.ToInteger(dt.Rows[0]["customer_id"]),
//SellMarkup = Connection.ToDecimal(dt.Rows[0]["sell_markup_inPercentage"])
APIPriceMarkupCode = Connection.ToInteger(dr["api_pricemarkup_code"]),
DescriptionId = Connection.ToInteger(dr["api_code"]),
CustomerId = Connection.ToInteger(dr["customer_id"]),
SellMarkup = Connection.ToString(dr["sell_markup_inPercentage"]),
CustomerName = Connection.ToString(dr["Name"]),
TotalRows = Connection.ToInteger(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(API);
}
public CLayer.BookingExternalInventory GetExternalBookingInvetoryCanceldetById(long bookinBookingExtInvReqId, string ReservattionId)
{
CLayer.BookingExternalInventory result = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pbookinBookingExtInvReqId", DataPlug.DataType._Varchar, bookinBookingExtInvReqId));
param.Add(Connection.GetParameter("pReservattionId", DataPlug.DataType._Varchar, ReservattionId));
DataTable dt = Connection.GetTable("GetExternalBookingInvetoryCanceldet_ByIdResId", param);
if (dt.Rows.Count > 0)
{
result = new CLayer.BookingExternalInventory()
{
BookingExtInvCancelId = Connection.ToLong(dt.Rows[0]["BookingExtInvCancelId"]),
BookingExtInvReqId = Connection.ToLong(dt.Rows[0]["BookingExtInvReqId"]),
BookingId = Connection.ToLong(dt.Rows[0]["Booking_Id"]),
reservation_id = Connection.ToString(dt.Rows[0]["Reservation_Id"]),
Cancellation_Status = Connection.ToInteger(dt.Rows[0]["Cancellation_Status"]),
Cancelled_Date = Connection.ToString(dt.Rows[0]["Cancelled_Date"]),
Cancellation_Number = Connection.ToString(dt.Rows[0]["Cancellation_Number"])
};
}
return(result);
}
public long Save(CLayer.SupplierPayment data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSupplierPaymentId", DataPlug.DataType._BigInt, data.supplierPaymentId));
// param.Add(Connection.GetParameter("pBusinessName", DataPlug.DataType._Varchar, data.Businessname));
param.Add(Connection.GetParameter("pSupplierId", DataPlug.DataType._BigInt, data.FirstName));
param.Add(Connection.GetParameter("pOfflineSupplierEmail", DataPlug.DataType._Varchar, data.SupplierEmail));
param.Add(Connection.GetParameter("pbookingreference", DataPlug.DataType._Varchar, data.OrderId));
param.Add(Connection.GetParameter("pAmount", DataPlug.DataType._Decimal, data.Amount));
param.Add(Connection.GetParameter("pSupplierPayment", DataPlug.DataType._Bool, data.supplierPayment));
param.Add(Connection.GetParameter("pdtPayment", DataPlug.DataType._DateTime, data.pdtPayment));
param.Add(Connection.GetParameter("pgrossAmount", DataPlug.DataType._Decimal, data.grossAmount));
param.Add(Connection.GetParameter("ptdsAmount", DataPlug.DataType._Decimal, data.tdsAmount));
param.Add(Connection.GetParameter("pnetAmtPaid", DataPlug.DataType._Decimal, data.netAmtPaid));
param.Add(Connection.GetParameter("pmodeofPayment", DataPlug.DataType._Varchar, data.modeofPayment));
param.Add(Connection.GetParameter("pbank", DataPlug.DataType._Varchar, data.BAnk));
object result = Connection.ExecuteQueryScalar("SupplierPayment_Save", param);
return(Connection.ToLong(result));
}
public List <CLayer.BookingExternalInventory> GetExternalInventoryCancelDetailsByBookingId(long BookingId)
{
List <CLayer.BookingExternalInventory> result = new List <CLayer.BookingExternalInventory>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._Varchar, BookingId));
DataTable dt = Connection.GetTable("GetExternalInventoryCancelDetailsByBookingId", param);
foreach (DataRow dr in dt.Rows)
{
result.Add(new CLayer.BookingExternalInventory()
{
BookingExtInvCancelId = Connection.ToLong(dr["BookingExtInvCancelId"]),
BookingExtInvReqId = Connection.ToLong(dr["BookingExtInvReqId"]),
BookingId = Connection.ToLong(dr["Booking_Id"]),
reservation_id = Connection.ToString(dr["Reservation_Id"]),
Cancellation_Status = Connection.ToInteger(dr["Cancellation_Status"]),
Cancelled_Date = Connection.ToString(dr["Cancelled_Date"]),
Cancellation_Number = Connection.ToString(dr["Cancellation_Number"])
});
}
return(result);
}
//special Offer Home page Display
public List <CLayer.Offers> specialOfferGet(long PropertyId)
{
List <CLayer.Offers> offer = new List <CLayer.Offers>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, PropertyId));
DataTable dt = Connection.GetTable("Offer_specialByPropertyId", param);
//`OfferspecialOffer_PropertyId`(pOfferStatus INT ,pPropertyStatus INT )
foreach (DataRow dr in dt.Rows)
{
offer.Add(new CLayer.Offers()
{
OfferId = Connection.ToLong(dr["OfferId"]),
NoOfDays = Connection.ToInteger(dr["NoOfDays"]),
StartDate = Connection.ToDate(dr["StartDate"]),
EndDate = Connection.ToDate(dr["EndDate"]),
Status = Connection.ToInteger(dr["Status"]),
//AccommodationId = Connection.ToLong(dr["AccommodationId"]),
Amount = Connection.ToDecimal(dr["Amount"]),
OfferFor = Connection.ToInteger(dr["OfferFor"]),
RateType = Connection.ToInteger(dr["RateType"]),
SBCommission = Connection.ToDecimal(dr["SBCommission"]),
OfferTitle = Connection.ToString(dr["OfferTitle"]),
FreeDays = Connection.ToInteger(dr["FreeDays"]),
//PropertyId = Connection.ToLong(dr["PropertyId"]),
OfferType = Connection.ToInteger(dr["OfferType"]),
StayCategoryId = Connection.ToInteger(dr["StayCategoryId"]),
//Display
Title = Connection.ToString(dr["Title"]),
Location = Connection.ToString(dr["Location"]),
Address = Connection.ToString(dr["Address"])
});
}
return(offer);
}
public List <CLayer.Inventory> GetAllAccomodationId(int Start, int Limit, long?AccommodationId)
{
List <CLayer.Inventory> result = new List <CLayer.Inventory>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit));
param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, AccommodationId));
DataSet ds = Connection.GetDataSet("inventory_GetAllAccommodationId", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
result.Add(new CLayer.Inventory()
{
AccommodationId = Connection.ToLong(dr["AccommodationId"]),
InventoryId = Connection.ToLong(dr["InventoryId"]),
Quantity = Connection.ToInteger(dr["Quantity"]),
FromDate = Connection.ToDate(dr["FromDate"]),
ToDate = Connection.ToDate(dr["ToDate"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(result);
}
public List <CLayer.Accommodation> PropertyListAccommodationListByOfferId(int Status, long OfferId, int SearchValue, int Start, int Limit)
{
if (SearchValue == 1)
{
List <CLayer.Accommodation> accommodations = new List <CLayer.Accommodation>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, Status));
param.Add(Connection.GetParameter("pOfferId", DataPlug.DataType._BigInt, OfferId));
param.Add(Connection.GetParameter("pSearchValue", DataPlug.DataType._Int, SearchValue));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit));
DataSet ds = Connection.GetDataSet("offer_PropertyListAccommodationListByOfferId", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
accommodations.Add(new CLayer.Accommodation()
{
AccommodationId = Connection.ToLong(dr["AccommodationId"]),
PropertyId = Connection.ToLong(dr["PropertyId"]),
PropertyTitle = Connection.ToString(dr["PropertyTitle"]),
Status = Connection.ToInteger(dr["Status"]),
StayCategory = Connection.ToString(dr["StayCategory"]),
Location = Connection.ToString(dr["Location"]),
AccommodationType = Connection.ToString(dr["AccommodationType"]),
MaxNoOfPeople = Connection.ToInteger(dr["MaxNoOfPeople"]),
MaxNoOfChildren = Connection.ToInteger(dr["MaxNoOfChildren"]),
MinNoOfPeople = Connection.ToInteger(dr["MinNoOfPeople"]),
BedRooms = Connection.ToInteger(dr["BedRooms"]),
Description = Connection.ToString(dr["Description"]),
Area = Connection.ToDecimal(dr["Area"]),
Address = Connection.ToString(dr["Address"]),
Statename = Connection.ToString(dr["Statename"]),
City = Connection.ToString(dr["City"]),
Ownername = Connection.ToString(dr["Ownername"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(accommodations);
}
else
{
List <CLayer.Accommodation> accommodations = new List <CLayer.Accommodation>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, Status));
param.Add(Connection.GetParameter("pOfferId", DataPlug.DataType._BigInt, OfferId));
param.Add(Connection.GetParameter("pSearchValue", DataPlug.DataType._Int, SearchValue));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit));
DataSet ds = Connection.GetDataSet("offer_PropertyListAccommodationListByOfferId", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
accommodations.Add(new CLayer.Accommodation()
{
PropertyId = Connection.ToLong(dr["PropertyId"]),
PropertyTitle = Connection.ToString(dr["PropertyTitle"]),
Location = Connection.ToString(dr["Location"]),
Address = Connection.ToString(dr["Address"]),
Statename = Connection.ToString(dr["Statename"]),
City = Connection.ToString(dr["City"]),
Ownername = Connection.ToString(dr["Ownername"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(accommodations);
}
}
public string ImportToDBFromExcel(DataTable dtSupplierDetails, DataTable dtPorpertyDetails, DataTable dtAccomodationDetails)
{
double ara = 0;
int x;
if (dtSupplierDetails.Rows.Count > 0)
{
string sql = "DELETE FROM supplierdetails_excel";
object obj = Connection.ExecuteSQLQueryScalar(sql);
}
foreach (DataRow dr in dtSupplierDetails.Rows)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSupplierName", DataPlug.DataType._Varchar, CutString(dr["Supplier Name"], 100), 255));
param.Add(Connection.GetParameter("pContactName", DataPlug.DataType._Varchar, CutString(dr["Contact Name"], 100), 255));
param.Add(Connection.GetParameter("pEmail", DataPlug.DataType._Varchar, CutString(dr["Email"], 150), 255));
param.Add(Connection.GetParameter("pAddress", DataPlug.DataType._Varchar, CutString(dr["Address"], 500), 500));
param.Add(Connection.GetParameter("pCity", DataPlug.DataType._Varchar, CutString(dr["City"], 150), 255));
param.Add(Connection.GetParameter("pState", DataPlug.DataType._Varchar, CutString(dr["State"], 150), 255));
param.Add(Connection.GetParameter("pCountry", DataPlug.DataType._Varchar, CutString(dr["Country"], 150), 255));
param.Add(Connection.GetParameter("pPincode", DataPlug.DataType._Varchar, CutString(dr["Pincode"], 10), 255));
param.Add(Connection.GetParameter("pPhone", DataPlug.DataType._Varchar, CutString(dr["Phone"], 50), 255));
param.Add(Connection.GetParameter("pMobile", DataPlug.DataType._Varchar, CutString(dr["Mobile"], 50), 255));
param.Add(Connection.GetParameter("pService_Tax_Number", DataPlug.DataType._Varchar, CutString(dr["Service_Tax_Number"], 30), 255));
param.Add(Connection.GetParameter("pVATNumber", DataPlug.DataType._Varchar, CutString(dr["VAT Number"], 30), 255));
param.Add(Connection.GetParameter("pBank_Account_Number", DataPlug.DataType._Varchar, CutString(dr["Bank_Account_Number"], 150), 255));
param.Add(Connection.GetParameter("pBank_name", DataPlug.DataType._Varchar, CutString(dr["Bank_name"], 100), 255));
param.Add(Connection.GetParameter("pBranch_Address", DataPlug.DataType._Varchar, CutString(dr["Branch_Address"], 500), 500));
param.Add(Connection.GetParameter("pRTGSNumber", DataPlug.DataType._Varchar, CutString(dr["RTGS Number"], 150), 255));
param.Add(Connection.GetParameter("pMICR_Code", DataPlug.DataType._Varchar, CutString(dr["MICR_Code"], 150), 255));
param.Add(Connection.GetParameter("pPANNo", DataPlug.DataType._Varchar, CutString(dr["PAN No"], 20), 255));
object result = Connection.ExecuteQueryScalar("supplierdetails_excel_save", param);
}
if (dtSupplierDetails.Rows.Count > 0)
{
string sql = "DELETE FROM propertydetails_excel";
object obj = Connection.ExecuteSQLQueryScalar(sql);
}
bool bl;
string tmp;
foreach (DataRow dr in dtPorpertyDetails.Rows)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSupplierName", DataPlug.DataType._Varchar, CutString(dr["Supplier Name"], 100), 255));
param.Add(Connection.GetParameter("pPropertyName", DataPlug.DataType._Varchar, CutString(dr["Property Name"], 100), 255));
param.Add(Connection.GetParameter("pDescription", DataPlug.DataType._Varchar, CutString(dr["Description"], 8000), 8000));
param.Add(Connection.GetParameter("pLocation", DataPlug.DataType._Varchar, CutString(dr["Location"], 50), 255));
param.Add(Connection.GetParameter("pAddress", DataPlug.DataType._Varchar, CutString(dr["Address"], 500), 500));
param.Add(Connection.GetParameter("pCity", DataPlug.DataType._Varchar, CutString(dr["City"], 150), 255));
param.Add(Connection.GetParameter("pState", DataPlug.DataType._Varchar, CutString(dr["State"], 150), 255));
param.Add(Connection.GetParameter("pCountry", DataPlug.DataType._Varchar, CutString(dr["Country"], 150), 255));
param.Add(Connection.GetParameter("pPincode", DataPlug.DataType._Varchar, CutString(dr["Pincode"], 10), 255));
param.Add(Connection.GetParameter("pProperty_Features", DataPlug.DataType._Varchar, FixCSV(CutString(dr["Property_Features"], 2000)), 2000));
param.Add(Connection.GetParameter("pCancellation_Charge", DataPlug.DataType._Double, ToDouble(CutString(dr["Cancellation_Charge"], 50)).ToString()));
param.Add(Connection.GetParameter("pCancellation_Period_Hours", DataPlug.DataType._Varchar, ToDouble(CutString(dr["Cancellation_Period_Hours"], 11)).ToString(), 255));
param.Add(Connection.GetParameter("pCop_Discount_ShortTerm", DataPlug.DataType._Double, ToDouble(CutString(dr["Cop_Discount_ShortTerm"], 50)).ToString()));
param.Add(Connection.GetParameter("pCorp_Discount_LongTerm", DataPlug.DataType._Double, ToDouble(CutString(dr["Corp_Discount_LongTerm"], 50)).ToString()));
param.Add(Connection.GetParameter("pService_Tax", DataPlug.DataType._Double, ToDouble(CutString(dr["Service_Tax"], 50)).ToString()));
param.Add(Connection.GetParameter("pLuxury_Tax", DataPlug.DataType._Double, ToDouble(CutString(dr["Luxury_Tax"], 50)).ToString()));
param.Add(Connection.GetParameter("pMarkup_B2B_ShortTerm", DataPlug.DataType._Double, ToDouble(CutString(dr["Markup_B2B_ShortTerm"], 50)).ToString()));
param.Add(Connection.GetParameter("pMarkup_B2B_LongTerm", DataPlug.DataType._Double, ToDouble(CutString(dr["Markup_B2B_LongTerm"], 50)).ToString()));
param.Add(Connection.GetParameter("pMarkup_B2C_ShortTerm", DataPlug.DataType._Double, ToDouble(CutString(dr["Markup_B2C_ShortTerm"], 50)).ToString()));
param.Add(Connection.GetParameter("pMarkup_B2C_LongTerm", DataPlug.DataType._Double, ToDouble(CutString(dr["Markup_B2C_LongTerm"], 50)).ToString()));
param.Add(Connection.GetParameter("pCancellation_Policy", DataPlug.DataType._Varchar, CutString(dr["Cancellation_Policy"], 200), 255));
x = 0;
int.TryParse(CutString(dr["Cancellation_Value"], 200), out x);
if (x < 1)
{
x = 1;
}
param.Add(Connection.GetParameter("pCancellation_Value", DataPlug.DataType._Double, x));
param.Add(Connection.GetParameter("pCancellation_Period", DataPlug.DataType._Double, ToDouble(CutString(dr["Cancellation_Period"], 11)).ToString()));
tmp = CutString(dr["Policy_Applicable_ForRefund"], 50).ToLower();
if (tmp.Length > 0)
{
tmp = tmp.Trim();
}
if (tmp == "yes" || tmp == "true")
{
bl = true;
}
else
{
bl = false;
}
param.Add(Connection.GetParameter("pPolicy_Applicable_ForRefund", DataPlug.DataType._Bool, bl));
param.Add(Connection.GetParameter("pEmailId", DataPlug.DataType._Varchar, CutString(dr["Property_Email_ID"], 255), 255));
param.Add(Connection.GetParameter("pPhone", DataPlug.DataType._Varchar, CutString(dr["Phone"], 50), 255));
param.Add(Connection.GetParameter("pMobile", DataPlug.DataType._Varchar, CutString(dr["Mobile"], 50), 255));
object result = Connection.ExecuteQueryScalar("propertydetails_excel_save", param);
}
if (dtSupplierDetails.Rows.Count > 0)
{
string sql = "DELETE FROM accommodations_excel";
object obj = Connection.ExecuteSQLQueryScalar(sql);
}
foreach (DataRow dr in dtAccomodationDetails.Rows)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyName", DataPlug.DataType._Varchar, CutString(dr["Property Name"], 100), 255));
param.Add(Connection.GetParameter("pCategory", DataPlug.DataType._Varchar, CutString(dr["Category"], 100), 255));
param.Add(Connection.GetParameter("pAccommodationType", DataPlug.DataType._Varchar, CutString(dr["Type"], 50), 255));
param.Add(Connection.GetParameter("pDescription", DataPlug.DataType._Varchar, CutString(dr["Description"], 3000), 3000));
param.Add(Connection.GetParameter("pMaxAdults", DataPlug.DataType._Varchar, ToInteger(CutString(dr["Max Adults"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pMaxKids", DataPlug.DataType._Varchar, ToInteger(CutString(dr["Max Kids"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pMaxOccupancy", DataPlug.DataType._Varchar, ToInteger(CutString(dr["Max Occupancy"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pBedRooms", DataPlug.DataType._Varchar, ToInteger(CutString(dr["BedRooms"], 50)).ToString(), 255));
ara = 0;
double.TryParse(CutString(dr["Area m#sq"], 200), out ara);
x = 0;
int.TryParse(CutString(dr["Available Accommodation"], 100), out x);
param.Add(Connection.GetParameter("pAreamsq", DataPlug.DataType._Varchar, ara.ToString(), 255));
param.Add(Connection.GetParameter("pAvailableAccommodation", DataPlug.DataType._Varchar, x.ToString(), 255));
x = 0;
int.TryParse(CutString(dr["Total Accommodation"], 100), out x);
param.Add(Connection.GetParameter("pTotalAccommodation", DataPlug.DataType._Varchar, x.ToString(), 255));
param.Add(Connection.GetParameter("pAccommodationFeatures", DataPlug.DataType._Varchar, FixCSV(CutString(dr["Accommodation Features"], 2000)), 2000));
param.Add(Connection.GetParameter("pB2B_Daily", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2B_Daily"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pB2B_Weekly", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2B_Weekly"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pB2B_Monthly", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2B_Monthly"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pB2B_Long", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2B_Long"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pB2B_Guest", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2B_Guest"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pB2C_Daily", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2C_Daily"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pB2C_Weekly", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2C_Weekly"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pB2C_Monthly", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2C_Monthly"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pB2C_Long", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2C_Long"], 50)).ToString(), 255));
param.Add(Connection.GetParameter("pB2C_Guest", DataPlug.DataType._Varchar, ToDouble(CutString(dr["B2C_Guest"], 50)).ToString(), 255));
object result = Connection.ExecuteQueryScalar("accommodations_excel_save", param);
}
return("imported");
}
public List <CLayer.OfflineBooking> SupplierInvoiceBookingList(long PropID, long ID, string BookingRefIDs, string PropertyEmailAddresss, string PropertyType, int searchTypeBooking, string searchTextBooking, int Start, int Limit, int TaxType, out int TotalRows_Booking)
{
List <CLayer.OfflineBooking> result = new List <CLayer.OfflineBooking>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pProp_ID", DataPlug.DataType._BigInt, PropID));
param.Add(Connection.GetParameter("pSupplierInvoice_ID", DataPlug.DataType._BigInt, ID));
param.Add(Connection.GetParameter("psearchTypeBooking", DataPlug.DataType._Int, searchTypeBooking));
param.Add(Connection.GetParameter("psearchTextBooking", DataPlug.DataType._Text, searchTextBooking));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start == 1 ? 0 : Start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit));
param.Add(Connection.GetParameter("pPropertyEmailAddresss", DataPlug.DataType._Text, PropertyEmailAddresss));
param.Add(Connection.GetParameter("pPropertyType", DataPlug.DataType._Text, PropertyType));
DataSet ds = new DataSet();
if (TaxType == (int)CLayer.SupplierInvoice.TaxTypes.ServiceTax)
{
ds = Connection.GetDataSet("SupplierInvoicePropertyBooking_List", param);
}
else
{
ds = Connection.GetDataSet("SupplierInvoicePropertyBooking_ListForGST", param);
}
DataTable dt_Row = ds.Tables[0];
if (dt_Row.Rows.Count > 0)
{
TotalRows_Booking = Connection.ToInteger(dt_Row.Rows[0]["NumberOfRows"]);
}
else
{
TotalRows_Booking = 0;
}
DataTable dt = ds.Tables[1];
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.AmtTobePaid = Connection.ToDecimal(dr["AmtTobePaid"]);
foreach (string st in BookingRefIDs.Split(',').ToList <string>())
{
if (st == Connection.ToString(dr["OrderNo"]))
{
res.isCheckBook = true;
}
}
result.Add(res);
}
}
return(result);
}
public List <CLayer.OfflineBooking> GetAllBooking(int status, string searchString, int searchItem, int start, int limit, out int totalRows)
{
List <CLayer.OfflineBooking> bookings = new List <CLayer.OfflineBooking>();
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));
DataPlug.Parameter paramo = Connection.GetParameter("pTotalRows", DataPlug.DataType._Int, 0, 0, ParameterDirection.Output);
param.Add(paramo);
DataTable ds = Connection.GetTable("Invoice_Search", param);
totalRows = Connection.ToInteger(paramo.Value); // Connection.ToInteger(ds.Tables[0].Rows[0][0]);
foreach (DataRow dr in ds.Rows)
{
bookings.Add(new CLayer.OfflineBooking()
{
OfflineBookingId = Connection.ToLong(dr["Offline_BookingId"]),
InvoiceNumber = Connection.ToString(dr["InvoiceNumber"]),
//CustomerId = Connection.ToLong(dr["CustomerId"]),
//PropertyId = Connection.ToLong(dr["PropertyId"]),
//SupplierId = Connection.ToLong(dr["SupplierId"]),
//CustomerAddress = Connection.ToString(dr["CustomerAddress"]),
//CustomerCityname = Connection.ToString(dr["CustomerCityname"]),
//CustomerCountryname = Connection.ToString(dr["CustomerCountryname"]),
//CustomerStatename = Connection.ToString(dr["CustomerStatename"]),
//CustomerEmail = Connection.ToString(dr["CustomerEmail"]),
CustomerName = Connection.ToString(dr["CustomerName"]),
//CustomerMobile = Connection.ToString(dr["CustomerMobile"]),
//GuestEmail = Connection.ToString(dr["GuestEmail"]),
//GuestName = Connection.ToString(dr["GuestName"]),
CheckIn = Connection.ToDate(dr["CheckIn_Date"]),
CheckOut = Connection.ToDate(dr["CheckOut_Date"]),
PropertyName = Connection.ToString(dr["PropertyName"]),
//PropertyAddress = Connection.ToString(dr["PropertyAddress"]),
//PropertyCaretakerName = Connection.ToString(dr["PropertyCaretakerName"]),
//PropertyCountryname = Connection.ToString(dr["PropertyCountryname"]),
//PropertyStatename = Connection.ToString(dr["PropertyStatename"]),
PropertyCityname = Connection.ToString(dr["PropertyCityname"]),
//PropertyContactNo = Connection.ToString(dr["PropertyContactNo"]),
//PropertyEmail = Connection.ToString(dr["PropertyEmail"]),
//SupplierName = Connection.ToString(dr["SupplierName"]),
////SupplierMobile = Connection.ToString(dr["SupplierMobile"]),
////SupplierEmail = Connection.ToString(dr["SupplierEmail"]),
////SupplierAddress = Connection.ToString(dr["SupplierAddress"]),
////SupplierCountryname = Connection.ToString(dr["SupplierCountryname"]),
////SupplierStatename = Connection.ToString(dr["SupplierStatename"]),
////SupplierCityname = Connection.ToString(dr["SupplierCityname"]),
//NoOfNight = Connection.ToLong(dr["NoOfNight"]),
//NoOfPaxAdult = Connection.ToLong(dr["NoOfPaxAdult"]),
//NoOfPaxChild = Connection.ToLong(dr["NoOfPaxChild"]),
//NoOfRooms = Connection.ToLong(dr["NoOfRooms"]),
//Accommodationid = Connection.ToLong(dr["Accommodationid"]),
//Accommodationname = Connection.ToString(dr["Accommodationname"]),
//Accommodationtypeid = Connection.ToLong(dr["Accommodationtypeid"]),
//AccommodatoinTypename = Connection.ToString(dr["AccommodatoinTypename"]),
//StayCategory = Connection.ToLong(dr["StayCategory"]),
//StayCategoryName = Connection.ToString(dr["StayCategoryName"]),
//OtherService = Connection.ToString(dr["OtherService"]),
//sendmailtocustomer = Connection.ToBoolean(dr["sendmailtocustomer"]),
//sendmailtosupplier = Connection.ToBoolean(dr["sendmailtosupplier"]),
//AvgDailyRateBefreStaxForBuyPrice = Connection.ToDecimal(dr["AvgDailyRateBefreStaxForBuyPrice"]),
//StaxForBuyPrice = Connection.ToDecimal(dr["StaxForBuyPrice"]),
//TotalAmtForBuyPrice = Connection.ToDecimal(dr["TotalAmtForBuyPrice"]),
//BuyPriceforotherservicesForBuyprice = Connection.ToDecimal(dr["BuyPriceforotherservicesForBuyprice"]),
//StaxForotherBuyPrice = Connection.ToDecimal(dr["StaxForotherBuyPrice"]),
//TotalAmtotherForBuyPrice = Connection.ToDecimal(dr["TotalAmtotherForBuyPrice"]),
//AvgDailyRateBefreStaxForSalePrice = Connection.ToDecimal(dr["AvgDailyRateBefreStaxForSalePrice"]),
//StaxForSalePrice = Connection.ToDecimal(dr["StaxForSalePrice"]),
//TotalAmtForSalePrice = Connection.ToDecimal(dr["TotalAmtForSalePrice"]),
//BuyPriceforotherservicesForSalePrice = Connection.ToDecimal(dr["BuyPriceforotherservicesForSalePrice"]),
//StaxForotherForSalePrice = Connection.ToDecimal(dr["StaxForotherForSalePrice"]),
//TotalAmtotherForSalePrice = Connection.ToDecimal(dr["TotalAmtotherForSalePrice"]),
ConfirmationNumber = Connection.ToString(dr["orderno"]),
//TotalBuyPrice = Connection.ToDecimal(dr["TotalBuyPrice"]),
TotalSalePrice = Connection.ToDecimal(dr["TotalSalePrice"]),
CreatedTime = Connection.ToDate(dr["BookingDate"]),
SaveStatus = Connection.ToInteger(dr["SaveStatus"]),
InvoiceStatus = Connection.ToInteger(dr["InvoiceStatus"])
//CreatedBy = Connection.ToInteger(dr["CreatedBy"]),
//CreatedName = Connection.ToString(dr["CraetedFirstname"]) + ' ' + Connection.ToString(dr["CraetedLastname"]),
//TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(bookings);
}
public List <CLayer.AutoCompletedList> GetAutoListGDSAll(string term)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
if (term.Length > 50)
{
term = term.Substring(0, 50);
}
param.Add(Connection.GetParameter("pTerm", DataPlug.DataType._Varchar, term));
param.Add(Connection.GetParameter("pPropertyStatus", DataPlug.DataType._Int, (int)CLayer.ObjectStatus.StatusType.Active));
DataTable dt = Connection.GetTable("xtra_autocompelete_gds", param);
List <CLayer.AutoCompletedList> result = new List <CLayer.AutoCompletedList>();
string a, b;
int ix;
bool IsHotelName = false;
string cCity;
string cLocation;
string cPropertyId;
int i;
foreach (DataRow dr in dt.Rows)
{
string Location = Connection.ToString(dr["a"]);
b = (term.ToLower() == Location.ToLower()) ? "" : Connection.ToString(dr["num"]);
ix = Connection.ToInteger(dr["ix"]);
cCity = Connection.ToString(dr["city"]);
cLocation = Connection.ToString(dr["location"]);
cPropertyId = Connection.ToString(dr["propertyId"]);
IsHotelName = Connection.ToInteger(dr["IsHotelName"]) == 1 ? true : false;
if (!IsHotelName)
{
string[] aList = Location.Split(',');
if (aList.Length > 2)
{
string LocationAdvanced = aList[1].Trim() + "," + aList[2].Trim();
if (aList[1].ToLower().Trim() == aList[2].ToLower().Trim())
{
Location = aList[0].Trim() + "," + aList[1].Trim();
}
else
{
LocationAdvanced = GetFormattedLocation(LocationAdvanced);
Location = aList[0] + "," + LocationAdvanced;
}
}
else if (aList.Length == 2)
{
string LocationAdvanced = aList[1].Trim();
LocationAdvanced = GetFormattedLocation(LocationAdvanced);
Location = aList[0] + "," + LocationAdvanced;
}
}
CLayer.AutoCompletedList objResult = new CLayer.AutoCompletedList();
objResult.value = Location;
objResult.label = b;
objResult.desc = stringCnt(Location);
objResult.City = cCity;
objResult.Location = cLocation;
objResult.PropertyId = cPropertyId;
objResult.bHotelName = IsHotelName;
result.Add(objResult);
}
var resultlist = result.GroupBy(x => x.value).Select(y => y.First());
List <CLayer.AutoCompletedList> resultFinal = new List <CLayer.AutoCompletedList>();
foreach (var item in resultlist)
{
CLayer.AutoCompletedList objResult = new CLayer.AutoCompletedList();
objResult.value = item.value;
objResult.label = item.label;
objResult.desc = item.desc;
objResult.City = item.City;
objResult.Location = item.Location;
objResult.PropertyId = item.PropertyId;
objResult.bHotelName = item.bHotelName;
resultFinal.Add(objResult);
//Add to other List
}
return(resultFinal);
}
//********Ends Here*********
public List <CLayer.BookingItem> GetAllBookingDetailsForApproval(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;
if (IsAmedus)
{
dt = Connection.GetTable("booking_GetAllItemsamedusForApproval", param);
}
else
{
dt = Connection.GetTable("booking_GetAllItems", param);
}
CLayer.BookingItem bi;
foreach (DataRow dr in dt.Rows)
{
bi = new CLayer.BookingItem();
bi.BookingItemId = Connection.ToLong(dr["BookingItemId"]);
bi.AccommodationId = Connection.ToLong(dr["AccommodationId"]);
bi.BookingId = Connection.ToLong(dr["BookingId"]);
bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]);
bi.CheckIn = Connection.ToDate(dr["CheckIn"]);
bi.CheckOut = Connection.ToDate(dr["CheckOut"]);
bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfAccommodations"]);
bi.NoOfAdults = Connection.ToInteger(dr["NoOfAdults"]);
bi.NoOfChildren = Connection.ToInteger(dr["NoOfChildren"]);
bi.NoOfGuests = Connection.ToInteger(dr["NoOfGuests"]);
bi.NoOfDays = Connection.ToInteger(dr["NoOfDays"]);
bi.Amount = Connection.ToDecimal(dr["Amount"]);
bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]);
bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]);
bi.PropertyId = Connection.ToLong(dr["PropertyId"]);
//bi.ForUserFirstName = Connection.ToString(dr["ForUserFirstName"]);
//bi.ForUserLastName = Connection.ToString(dr["ForUserLastName"]);
// bi.ForUserEmail = Connection.ToString(dr["ForUserEmail"]);
// bi.ForUserMobile = Connection.ToString(dr["ForUserMobile"]);
bi.TotalAmount = Connection.ToDecimal(dr["TotalAmount"]);
bi.TotalTax = Connection.ToDecimal(dr["TotalTax"]);
bi.AccommodationTypeT = Connection.ToString(dr["AccommodationType"]);
bi.StayCategoryT = Connection.ToString(dr["StayCategory"]);
bi.DailyRate = Connection.ToDecimal(dr["DailyRate"]);
bi.FirstDayCharge = Connection.ToDecimal(dr["FirstDayCharge"]);
// bi.CommissionSB = Connection.ToDecimal(dr["TotalComForSB"]);
bi.CommissionSB = Connection.ToDecimal(dr["MarkupForSB"]);
bi.TotalCommissionforother = Connection.ToDecimal(dr["TotalComForOther"]);
bi.CorporateDiscountAmount = Connection.ToDecimal(dr["B2BDiscount"]);
bi.HotelConfirmNumber = Connection.ToString(dr["HotelConfirmNumber"]);
bi.TotalRateTax = Connection.ToDecimal(dr["TotalRateTax"]);
bi.CountryName = Connection.ToString(dr["CountryName"]);
bi.cityName = Connection.ToString(dr["City"]);
if (IsAmedus)
{
bi.ApproverName = Connection.ToString(dr["ApproverName"]);
bi.RejectionNote = Connection.ToString(dr["RejectionNote"]);
}
result.Add(bi);
}
}
catch (Exception ex)
{
result = null;
}
return(result);
}
