public List <CLayer.OfflineBooking> SearchPaymentCustomerList(string name, int start, int limit)
{
List <CLayer.OfflineBooking> users = new List <CLayer.OfflineBooking>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, name));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit));
DataSet ds = Connection.GetDataSet("SP_SearchPaymentListToCustomer", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
users.Add(new CLayer.OfflineBooking()
{
CustomerId = Connection.ToLong(dr["b2bid"]),
CustomerName = Connection.ToString(dr["customername"]),
CustomerEmail = Connection.ToString(dr["Email"]),
CustomerAddress = Connection.ToString(dr["Address"]),
CustomerMobile = Connection.ToString(dr["Mobile"]),
CustomerCountry = Connection.ToInteger(dr["countryname"]),
CustomerState = Connection.ToInteger(dr["statename"]),
CustomerCity = Connection.ToInteger(dr["city"]),
CustomerCityname = Connection.ToString(dr["cityname"]),
UserType = Connection.ToLong(dr["UserType"]),
//temp.CustomerType = Connection.ToInteger(dr["UserType"]);
CategoryType = Connection.ToString(dr["UserTableCat"]),
ZipCode = Connection.ToString(dr["ZipCode"]),
NoInvoiceMail = Connection.ToBoolean(dr["NoInvoiceMail"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(users);
}
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.Review> GetAll(int Start, int Limit)
{
List <CLayer.Review> result = new List <CLayer.Review>();
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));
DataSet ds = Connection.GetDataSet("review_GetAll", 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 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.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.Review> GetpropertyId(long propertyId, int Status)
{
List <CLayer.Review> result = new List <CLayer.Review>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyId));
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, Status));
DataSet ds = Connection.GetDataSet("review_GetPropertyId", 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"]),
BookingItemId = Connection.ToLong(dr["BookingItemId"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(result);
}
public List <CLayer.Accommodation> GetProperties(int Status, string SearchString, int SearchValue, int Start, int Limit)
{
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("pSearchString", DataPlug.DataType._Varchar, SearchString));
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_PropertyAllList", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
accommodations.Add(new CLayer.Accommodation()
{
PropertyId = Connection.ToLong(dr["PropertyId"]),
PropertyTitle = Connection.ToString(dr["PropertyTitle"]),
// Status = Connection.ToInteger(dr["Status"]),
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 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);
}
public List <CLayer.APIOfflineCustomer> GetAlCustomerList()
{
List <CLayer.APIOfflineCustomer> bookings = new List <CLayer.APIOfflineCustomer>();
DataSet ds = Connection.GetDataSet("sp_offlinecustomerlist_for_APIPriceMarkup");
foreach (DataRow dr in ds.Tables[0].Rows)
{
bookings.Add(new CLayer.APIOfflineCustomer()
{
CustomerId = Connection.ToLong(dr["CustomerId"]),
CustomerName = Connection.ToString(dr["CustomerName"])
});
}
return(bookings);
}
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);
}
//Added by rahul for Listing New API Markup price for new Screen on 30-01-2020
public List <CLayer.APIPriceMarkup> GetNewAPIPriceMarkUp()
{
List <CLayer.APIPriceMarkup> API = new List <CLayer.APIPriceMarkup>();
DataSet ds = Connection.GetDataSet("Sp_NewAPIPriceMarkup_Get");
foreach (DataRow dr in ds.Tables[0].Rows)
{
API.Add(new CLayer.APIPriceMarkup()
{
APIPriceMarkupCode = Connection.ToInteger(dr["pricemarkup_code"]),
DescriptionId = Connection.ToInteger(dr["description"]),
SellMarkup = Connection.ToString(dr["markup_per"])
});
}
return(API);
}
public List <CLayer.Review> GetUserId(int Start, int Limit, long id, int status)
{
List <CLayer.Review> result = new List <CLayer.Review>();
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("pUserId", DataPlug.DataType._BigInt, id));
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, status));
DataSet ds = Connection.GetDataSet("review_GetUserId", 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"]),
AccommodationCity = Connection.ToString(dr["AccommodationCity"]),
Accessibility = Connection.ToInteger(dr["Accessibilitytoproperty"]),
Easiness = Connection.ToInteger(dr["EasinessInCheckIn"]),
CleanlinessBed = Connection.ToInteger(dr["CleanlinessBedroom"]),
CleanlinessBath = Connection.ToInteger(dr["CleanlinessBathroom"]),
SleepQuality = Connection.ToInteger(dr["SleepQuality"]),
Staffbehave = Connection.ToInteger(dr["StaffBehavior"]),
Considerfornext = Connection.ToInteger(dr["ConsiderForNextTravel"]),
OverallExp = Connection.ToInteger(dr["OverallExperience"]),
//BookingItemId=Connection.ToLong(dr["BookingItemId"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
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.User> GetAllPropertyStatusWithType(int statusfor, int status, int Type, string searchString, int searchItem, int userType, int start, int limit)
{
List <CLayer.User> users = new List <CLayer.User>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStatusFor", DataPlug.DataType._Int, statusfor));
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, status));
param.Add(Connection.GetParameter("pType", DataPlug.DataType._Int, Type));
param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Varchar, searchString));
param.Add(Connection.GetParameter("pSearchItem", DataPlug.DataType._Int, searchItem));
param.Add(Connection.GetParameter("pUserType", DataPlug.DataType._Int, userType));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit));
DataSet ds = Connection.GetDataSet("propertymanage_GetAllForSearchWithType", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
users.Add(new CLayer.User()
{
UserId = Connection.ToLong(dr["UserId"]),
// Salutation = Connection.ToString(dr["Salutation"]),
Businessname = Connection.ToString(dr["Businessname"]),
FirstName = Connection.ToString(dr["FirstName"]),
LastName = Connection.ToString(dr["LastName"]),
Email = Connection.ToString(dr["Email"]),
City = Connection.ToString(dr["City"]),
State = Connection.ToString(dr["State"]),
Country = Connection.ToString(dr["Country"]),
Phone = Connection.ToString(dr["Phone"]),
Mobile = Connection.ToString(dr["Mobile"]),
CreatedDate = Connection.ToDate(dr["CreatedDate"]),
DeletedDate = Connection.ToDate(dr["DeletedDate"]),
LastLoginOn = Connection.ToDate(dr["LastLoginOn"]),
Status = Connection.ToInteger(dr["Status"]),
PANNo = Connection.ToString(dr["PANNo"]),
UserCode = Connection.ToString(dr["UserCode"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]),
PropertyName = Connection.ToString(dr["PropertyName"]),
PropertyId = Connection.ToLong(dr["propertyId"]),
Location = Connection.ToString(dr["Location"]),
InventoryAPIType = Connection.ToInteger(dr["InventoryAPIType"])
});
}
return(users);
}
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 List <CLayer.SupplierPayment> GetAllB2BForSearch(int status, string searchString, int searchItem, int userType, int start, int limit)
{
List <CLayer.SupplierPayment> users = new List <CLayer.SupplierPayment>();
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("pUserType", DataPlug.DataType._Int, userType));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit));
DataSet ds = Connection.GetDataSet("user_GetAllB2BForSearch", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
users.Add(new CLayer.SupplierPayment()
{
UserId = Connection.ToLong(dr["UserId"]),
// Salutation = Connection.ToString(dr["Salutation"]),
propertyname = Connection.ToString(dr["Title"]),
FirstName = Connection.ToString(dr["FirstName"]),
LastName = Connection.ToString(dr["LastName"]),
Email = Connection.ToString(dr["Email"]),
SupplierEmail = Connection.ToString(dr["SupplierEmail"]),
SupplierMobile = Connection.ToString(dr["SupplierMobile"]),
SupplierName = Connection.ToString(dr["SupplierName"]),
City = Connection.ToString(dr["City"]),
State = Connection.ToString(dr["State"]),
Country = Connection.ToString(dr["Country"]),
Phone = Connection.ToString(dr["Phone"]),
Mobile = Connection.ToString(dr["Mobile"]),
CheckIn_date = Connection.ToDate(dr["CheckIn_date"]),
DeletedDate = Connection.ToDate(dr["DeletedDate"]),
CheckOut_date = Connection.ToDate(dr["CheckOut_date"]),
Status = Connection.ToInteger(dr["Status"]),
PANNo = Connection.ToString(dr["PANNo"]),
UserCode = Connection.ToString(dr["UserCode"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(users);
}
public List <CLayer.Tax> GetPropertyTax()
{
List <CLayer.Tax> PropertyTax = new List <CLayer.Tax>();
DataSet ds = Connection.GetDataSet("propertyTax_AllList");
foreach (DataRow dr in ds.Tables[0].Rows)
{
PropertyTax.Add(new CLayer.Tax()
{
Title = Connection.ToString(dr["TaxName"]),
PropertyTitle = Connection.ToString(dr["PropertyTitle"]),
Rate = Connection.ToDecimal(dr["TaxValue"]),
UpdatedBy = Connection.ToInteger(dr["UpdatedBy"]),
UpdatedDate = Connection.ToDate(dr["UpdatedDate"]),
PropertyId = Connection.ToInteger(dr["PropertyId"]),
});
}
return(PropertyTax);
}
public List <CLayer.OfflinePayment> GetOfflinePaymentDetails1(long OfflinePaymentId)
{
List <CLayer.OfflinePayment> bookings = 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("Sp_Confirmation_Mail", param);
foreach (DataRow dr in ds.Tables[0].Rows)
{
bookings.Add(new CLayer.OfflinePayment()
{
//OfflineBookingId = Connection.ToLong(dr["OfflineBookingId"]),
//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"]),
ConfirmationNumber = Connection.ToString(dr["orderno"]),
CheckIn = Connection.ToDate(dr["CheckIn"]),
CheckOut = Connection.ToDate(dr["CheckOut"]),
PropertyName = Connection.ToString(dr["PropertyName"]),
PropertyCityname = Connection.ToString(dr["PropertyCityname"]),
TotalSalePrice = Connection.ToDecimal(dr["TotalSalePrice"]),
PayableSalePrice = Connection.ToDecimal(dr["TotalSalePrice"]) - Connection.ToDecimal(dr["AdvanceReceived"]),
SumTotalSalePrice = Connection.ToDecimal(dr["SumofSalePrice"]),
//SumofAdvanceReceived = Connection.ToDecimal(dr["SumofAdvanceReceived"]),
AdvanceReceived = Connection.ToDecimal(dr["AdvanceReceived"]),
PaymentLinkID = Connection.ToString(ds.Tables[0].Rows[0]["PaymentLinkID"]),
//PaymentLinkStatus = Connection.ToString(dr["SendCustomerPaymentLinkStatus"]),
GuestName = Connection.ToString(dr["GuestName"]),
NoOfRooms = Connection.ToInteger(dr["NoOfRooms"]),
//PaymentLinkID = Connection.ToString(dr["PaymentLinkId"])
});
}
return(bookings);
}
public List <CLayer.SupplierPayment> GetAllSupllierPaymentSearch(int status, string searchString, int searchItem, int userType, int start, int limit)
{
List <CLayer.SupplierPayment> users = new List <CLayer.SupplierPayment>();
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("pUserType", DataPlug.DataType._Int, userType));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit));
DataSet ds = Connection.GetDataSet("OfflineBookingSupplierpayment_GetSearch", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
users.Add(new CLayer.SupplierPayment()
{
// Salutation = Connection.ToString(dr["Salutation"]),
propertyname = Connection.ToString(dr["PropertyName"]),
// 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"]),
supplierPayment = Connection.ToBoolean(dr["supplierPayment"]),
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"]),
// Status = Connection.ToInteger(dr["Status"]),
// PANNo = Connection.ToString(dr["PANNo"]),
// UserCode = Connection.ToString(dr["UserCode"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(users);
}
public List <CLayer.SupplierPaymetList> getPaymentList(string pSearchString, int start, int limit, int pSearchType = 0)
{
List <CLayer.SupplierPaymetList> result = new List <CLayer.SupplierPaymetList>();
CLayer.SupplierPaymetList res = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Text, pSearchString));
param.Add(Connection.GetParameter("pSearchType", DataPlug.DataType._Int, pSearchType));
param.Add(Connection.GetParameter("pstart", DataPlug.DataType._Int, start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit));
DataSet ds = Connection.GetDataSet("SupplierPaymentList_Get", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
res = 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"]),
AmountPaid = Connection.ToDouble(dr["Amount"]),
netAmtPaid = Connection.ToDecimal(dr["netAmtPaid"]),
modeofPayment = Connection.ToString(dr["modeofPayment"]),
CheckIn_date = Connection.ToDate(dr["CheckIn_date"]),
CheckOut_date = Connection.ToDate(dr["CheckOut_date"]),
bank = Connection.ToString(dr["bank"]),
SupplierName = Connection.ToString(dr["Supplier_Name"]),
Prop_Name = Connection.ToString(dr["Prop_Name"]),
Prop_ID = Connection.ToLong(dr["Prop_ID"]),
OrderNo = Connection.ToString(dr["OrderNo"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
};
result.Add(res);
}
return(result);
}
//OfferList Display Expired Date and Active Date with Tab value
public List <CLayer.Offers> GetAllExpiredandActive(int Status, string SearchString, int Tab, int Start, int Limit)
{
//`Offer_GetExpiredAndActive`(IN pStatus INT ,IN pType INT, pStart INT, pLimit INT)
List <CLayer.Offers> offer = new List <CLayer.Offers>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._BigInt, Status));
param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Varchar, SearchString));
param.Add(Connection.GetParameter("pType", DataPlug.DataType._BigInt, Tab));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit));
DataSet ds = Connection.GetDataSet("Offer_GetExpiredAndActive", param);
foreach (DataRow dr in ds.Tables[1].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"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(offer);
}
public List <CLayer.SupplierInvoice> getSupplierInvoiceList(string searchText, int searchType, int Start, int Limit, int TaxType, int Status)
{
List <CLayer.SupplierInvoice> result = new List <CLayer.SupplierInvoice>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSearchText", DataPlug.DataType._Text, searchText));
param.Add(Connection.GetParameter("pSearchType", DataPlug.DataType._Int, searchType));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit));
param.Add(Connection.GetParameter("pTaxType", DataPlug.DataType._Int, TaxType));
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, Status));
DataSet ds = Connection.GetDataSet("getGetSupplierInvoiceList_Pager", param);
CLayer.SupplierInvoice res = null;
if (ds.Tables[1].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.TaxType = Connection.ToInteger(dr["TaxType"]);
res.TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]);
result.Add(res);
}
}
return(result);
}
public List <CLayer.User> GetAllCustomerForSearch(int status, string searchString, int searchItem, int userType, int start, int limit)
{
List <CLayer.User> users = new List <CLayer.User>();
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("pUserType", DataPlug.DataType._Int, userType));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit));
DataSet ds = Connection.GetDataSet("user_GetAllCustomerForSearch", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
users.Add(new CLayer.User()
{
UserId = Connection.ToLong(dr["UserId"]),
Salutation = Connection.ToString(dr["Salutation"]),
//Businessname = Connection.ToString(dr["Businessname"]),
FirstName = Connection.ToString(dr["FirstName"]),
LastName = Connection.ToString(dr["LastName"]),
Email = Connection.ToString(dr["Email"]),
City = Connection.ToString(dr["City"]),
State = Connection.ToString(dr["State"]),
Country = Connection.ToString(dr["Country"]),
Phone = Connection.ToString(dr["Phone"]),
Mobile = Connection.ToString(dr["Mobile"]),
CreatedDate = Connection.ToDate(dr["CreatedDate"]),
DeletedDate = Connection.ToDate(dr["DeletedDate"]),
LastLoginOn = Connection.ToDate(dr["LastLoginOn"]),
Status = Connection.ToInteger(dr["Status"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]),
OrderId = Connection.ToString(dr["OrderNo"])
});
}
return(users);
}
public List <CLayer.Condition> GetAllAccomodationId(int Start, int Limit, long?AccommodationId)
{
List <CLayer.Condition> result = new List <CLayer.Condition>();
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("condition_GetAllAccommodationId", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
result.Add(new CLayer.Condition()
{
AccommodationId = Connection.ToLong(dr["AccommodationId"]),
ConditionId = Connection.ToLong(dr["ConditionId"]),
ConditionText = Connection.ToString(dr["ConditionText"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(result);
}
public List <CLayer.User> GSTList(int Cust)
{
List <CLayer.User> bookings = new List <CLayer.User>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pcustid", DataPlug.DataType._Int, Cust));
DataSet ds = Connection.GetDataSet("GetGSTListForCorporate", param);
foreach (DataRow dr in ds.Tables[0].Rows)
{
bookings.Add(new CLayer.User()
{
B2bGSTId = Connection.ToLong(dr["OffGSTId"]),
GSTstateid = Connection.ToLong(dr["Stateid"]),
GSTRegistrationNo = Connection.ToString(dr["GSTRegNO"]),
StateOfRegistration = Connection.ToString(dr["StateName"]),
//CustomerEmail = Connection.ToString(dr["OfflinebookingCustomerId"]),
});
}
return(bookings);
}
public List <CLayer.Accommodation> GetAccommodation(int Status, int StayCategoryId, string SearchString, int SearchValue, int Start, int Limit)
{
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("pStayCategoryId", DataPlug.DataType._Int, StayCategoryId));
param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Varchar, SearchString));
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_AccommodationAllList", 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"]),
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);
}
//OfferList for Admin
public List <CLayer.Offers> GetAllBySatus(CLayer.ObjectStatus.StatusType Status, int Start, int Limit)
{
List <CLayer.Offers> offer = new List <CLayer.Offers>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._BigInt, Status));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, Start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, Limit));
DataSet ds = Connection.GetDataSet("offer_GetByStatusAll", param);
foreach (DataRow dr in ds.Tables[1].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"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"])
});
}
return(offer);
}
public List <CLayer.Tax> GetPropertyTaxById(long PropertyId)
{
List <CLayer.Tax> PropertyTax = new List <CLayer.Tax>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._Int, PropertyId));
DataSet dt = Connection.GetDataSet("PropertyTaxById_Get", param);
foreach (DataRow dr in dt.Tables[0].Rows)
{
PropertyTax.Add(new CLayer.Tax()
{
Title = Connection.ToString(dr["TaxName"]),
PropertyTitle = Connection.ToString(dr["PropertyTitle"]),
Rate = Connection.ToDecimal(dr["TaxValue"]),
UpdatedBy = Connection.ToInteger(dr["UpdatedBy"]),
UpdatedDate = Connection.ToDate(dr["UpdatedDate"]),
PropertyId = Connection.ToInteger(dr["PropertyId"]),
TaxTitleId = Connection.ToInteger(dr["TaxTitle"]),
});
}
return(PropertyTax);
}
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.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);
}
