//**Added by rahul on 04/03/2020
//*This is for getting rates for property Accommodation for API
public List <CLayer.Rates> GetAccommodationRatesForAPI(string AccIds, DateTime checkIn, DateTime checkOut, int noOfDays, CLayer.Role.Roles rateType, CLayer.Role.Roles defaultType)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pAccs", DataPlug.DataType._Varchar, AccIds));
param.Add(Connection.GetParameter("pCheckIn", DataPlug.DataType._Date, checkIn));
param.Add(Connection.GetParameter("pCheckOut", DataPlug.DataType._Date, checkOut));
param.Add(Connection.GetParameter("pRateType", DataPlug.DataType._Int, rateType));
param.Add(Connection.GetParameter("pDefaultRateType", DataPlug.DataType._Int, (int)defaultType));
param.Add(Connection.GetParameter("pBookingDayCount", DataPlug.DataType._Int, (int)noOfDays));
DataTable dt = Connection.GetTable("accommodation_GetAvailabilityAndRateForAPI", param);
List <CLayer.Rates> result = new List <CLayer.Rates>();
CLayer.Rates rt;
foreach (DataRow dr in dt.Rows)
{
rt = new CLayer.Rates();
rt.AccommodationId = Connection.ToLong(dr["AccommodationId"]);
rt.Amount = Connection.ToDecimal(dr["Amount"]);
rt.GuestRate = Connection.ToDecimal(dr["GuestRate"]);
rt.StartDate = Connection.ToDate(dr["startdate"]);
rt.EndDate = Connection.ToDate(dr["enddate"]);
rt.RateType = Connection.ToInteger(dr["AType"]);
rt.NoofAcc = Connection.ToInteger(dr["noofacc"]);
rt.PurchaseRateAfterTax = Connection.ToDecimal(dr["DailyRate"]);
result.Add(rt);
}
return(result);
}
public List <CLayer.User> GetAllSalespersonandRegionalmanager()
{
List <CLayer.User> users = new List <CLayer.User>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
DataTable dt = Connection.GetTable("user_GetAllSalespersonandRegionalmanager", param);
foreach (DataRow dr in dt.Rows)
{
users.Add(new CLayer.User()
{
UserId = Connection.ToLong(dr["UserId"]),
Salutation = Connection.ToString(dr["Salutation"]),
Name = Connection.ToString(dr["FirstName"]) + " " + Connection.ToString(dr["LastName"]),
FirstName = Connection.ToString(dr["FirstName"]),
LastName = Connection.ToString(dr["LastName"]),
DateOfBirth = Connection.ToDate(dr["DateOfBirth"]),
Sex = Connection.ToInteger(dr["Sex"]),
UserType = Connection.ToString(dr["UserType"]),
Status = Connection.ToInteger(dr["Status"]),
Email = Connection.ToString(dr["Email"]),
CreatedDate = Connection.ToDate(dr["CreatedDate"]),
DeletedDate = Connection.ToDate(dr["DeletedDate"]),
LastLoginOn = Connection.ToDate(dr["LastLoginOn"])
});
}
return(users);
}
public CLayer.Recommended GetData(long propertyId, long ManageFor)
{
CLayer.Recommended result = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyId));
param.Add(Connection.GetParameter("pManageFor", DataPlug.DataType._BigInt, ManageFor));
DataTable dt = Connection.GetTable("recommended_Get", param);
if (dt.Rows.Count > 0)
{
result = new CLayer.Recommended()
{
StartDate = Connection.ToDate(dt.Rows[0]["StartDate"]),
EndDate = Connection.ToDate(dt.Rows[0]["EndDate"]),
Status = Connection.ToInteger(dt.Rows[0]["Status"]),
Order = Connection.ToInteger(dt.Rows[0]["Order"]),
UpdatedBy = Connection.ToLong(dt.Rows[0]["UpdatedBy"]),
UpdatedDate = Connection.ToDate(dt.Rows[0]["UpdatedDate"]),
Title = Connection.ToString(dt.Rows[0]["Title"]),
ManageFor = Connection.ToInteger(dt.Rows[0]["ManageFor"])
};
}
return(result);
}
public List <CLayer.Recommended> GetAllByManage(long ManageFor)
{
List <CLayer.Recommended> result = new List <CLayer.Recommended>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pManageFor", DataPlug.DataType._BigInt, ManageFor));
DataTable dt = Connection.GetTable("recommendedbymanage_GetAll", param);
CLayer.Recommended temp;
foreach (DataRow dr in dt.Rows)
{
temp = new CLayer.Recommended();
temp.PropertyId = Connection.ToLong(dr["PropertyId"]);
temp.EndDate = Connection.ToDate(dr["EndDate"]);
temp.StartDate = Connection.ToDate(dr["StartDate"]);
temp.Order = Connection.ToInteger(dr["Order"]);
temp.Status = Connection.ToInteger(dr["Status"]);
temp.UpdatedByUser = Connection.ToString(dr["UpdatedBy"]);
temp.UpdatedDate = Connection.ToDate(dr["UpdatedDate"]);
temp.Title = Connection.ToString(dr["Title"]);
temp.Supplier = Connection.ToString(dr["Name"]);
temp.ManageFor = Connection.ToInteger(dr["ManageFor"]);
// temp.AccommodationType = Connection.ToString(dr["AccType"]);
result.Add(temp);
}
return(result);
}
public CLayer.Invoice GetInvoice(long invoiceId)
{
string sql = "Select * from Invoices Where InvoiceId=" + invoiceId.ToString();
DataTable dt = Connection.GetSQLTable(sql);
CLayer.Invoice data = null;
if (dt.Rows.Count == 0)
{
return(data);
}
data = new CLayer.Invoice();
DataRow dr = dt.Rows[0];
data.InvoiceId = Connection.ToLong(dr["InvoiceId"]);
data.InvoiceNumber = Connection.ToString(dr["InvoiceNumber"]);
data.Discounts = Connection.ToDouble(dr["Discounts"]);
data.DueDate = Connection.ToDate(dr["DueDate"]);
data.HtmlSection1 = Connection.ToString(dr["HtmlSection1"]);
data.HtmlSection2 = Connection.ToString(dr["HtmlSection2"]);
data.HtmlSection3 = Connection.ToString(dr["HtmlSection3"]);
data.InvoiceDate = Connection.ToDate(dr["InvoiceDate"]);
data.InvoiceType = Connection.ToInteger(dr["InvoiceType"]);
data.MailedDate = Connection.ToDate(dr["MailedDate"]);
data.OfflineBookingId = Connection.ToLong(dr["OfflineBookingId"]);
data.Others = Connection.ToDouble(dr["Others"]);
data.Reimbursements = Connection.ToDouble(dr["Reimbursements"]);
data.Status = Connection.ToInteger(dr["Status"]);
data.ToAddress = Connection.ToString(dr["ToAddress"]);
return(data);
}
public CLayer.Suggest Get(int InfoId)
{
CLayer.Suggest suggest = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pInfoId", DataPlug.DataType._BigInt, InfoId));
DataTable dt = Connection.GetTable("propertysuggestion_Get", param);
if (dt.Rows.Count > 0)
{
suggest = new CLayer.Suggest();
suggest.InfoId = Connection.ToLong(dt.Rows[0]["InfoId"]);
suggest.Name = Connection.ToString(dt.Rows[0]["Name"]);
suggest.Location = Connection.ToString(dt.Rows[0]["Location"]);
suggest.City = Connection.ToString(dt.Rows[0]["City"]);
suggest.CountryId = Connection.ToInteger(dt.Rows[0]["CountryId"]);
suggest.Country = Connection.ToString(dt.Rows[0]["Country"]);
suggest.Address = Connection.ToString(dt.Rows[0]["Address"]);
suggest.Phone = Connection.ToString(dt.Rows[0]["Phone"]);
suggest.Email = Connection.ToString(dt.Rows[0]["Email"]);
suggest.SuggestionDate = Connection.ToDate(dt.Rows[0]["SuggestionDate"]);
suggest.Status = Connection.ToInteger(dt.Rows[0]["Status"]);
}
return(suggest);
}
public List <CLayer.StaticPage> GetAll()
{
string sql = "Select * From staticpage";
DataTable dt = Connection.GetSQLTable(sql);
List <CLayer.StaticPage> result = new List <CLayer.StaticPage>();
CLayer.StaticPage t;
DateTime tm;
foreach (DataRow dr in dt.Rows)
{
t = new CLayer.StaticPage();
t.PageId = Connection.ToLong(dr["PageId"]);
t.City = Connection.ToString(dr["City"]);
t.Location = Connection.ToString(dr["Location"]);
t.PageTitle = Connection.ToString(dr["PageTitle"]);
tm = Connection.ToDate(dr["LastUpdate"]);
if (tm == DateTime.Now)
{
t.LastUpdate = "";
}
else
{
t.LastUpdate = tm.ToShortDateString();
}
//t.City = Connection.ToString(dr["City"]);
//t.City = Connection.ToString(dr["City"]);
//t.City = Connection.ToString(dr["City"]);
//t.City = Connection.ToString(dr["City"]);
result.Add(t);
}
return(result);
}
public List <CLayer.Rates> GetAllRatesByAccId(long accommodationId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
List <CLayer.Rates> result = new List <CLayer.Rates>();
param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, accommodationId));
DataTable dt = Connection.GetTable("ratesaccomodation_GetAllByAccId", param);
CLayer.Rates rt1;
foreach (DataRow dr in dt.Rows)
{
rt1 = new CLayer.Rates();
rt1.RateFor = Connection.ToInteger(dr["RateFor"]);
rt1.RateId = Connection.ToLong(dr["RateId"]);
rt1.AccommodationId = accommodationId;
rt1.DailyRate = Connection.ToDecimal(dr["DailyRate"]);
rt1.CalcDailyRate = Connection.ToDecimal(dr["CalcDailyRate"]);
rt1.GuestRate = Connection.ToDecimal(dr["GuestRate"]);
rt1.LongTermRate = Connection.ToDecimal(dr["LongTermRate"]);
rt1.MonthlyRate = Connection.ToDecimal(dr["MonthlyRate"]);
rt1.WeeklyRate = Connection.ToDecimal(dr["WeeklyRate"]);
rt1.StartDate = Connection.ToDate(dr["StartDate"]);
rt1.EndDate = Connection.ToDate(dr["EndDate"]);
rt1.UpdatedBy = Connection.ToInteger(dr["UpdatedBy"]);
result.Add(rt1);
}
return(result);
}
public List <CLayer.GDSTransactionsLog> GetGDSTransactionLog()
{
try
{
List <CLayer.GDSTransactionsLog> result = new List <CLayer.GDSTransactionsLog>();
DataTable dt = Connection.GetTable("GetGDSTransactionLog");
foreach (DataRow dr in dt.Rows)
{
CLayer.GDSTransactionsLog objResult = new CLayer.GDSTransactionsLog();
objResult.GDSID = Connection.ToLong(dr["GDSID"]);
objResult.BookingID = Connection.ToLong(dr["BookingID"]);
objResult.CreatedAt = Connection.ToDate(dr["CreatedAt"]);
objResult.GDSTypeValue = Connection.ToString(dr["GDSTypeValue"]);
objResult.GDSRequest = Connection.ToString(dr["GDSRequest"]);
objResult.GDSResult = Connection.ToString(dr["GDSResult"]);
objResult.GDSError = Connection.ToString(dr["GDSError"]);
objResult.GDSErrorMessage = Connection.ToString(dr["GDSErrorMessage"]);
objResult.UserID = Connection.ToInteger(dr["UserID"]);
objResult.GDSTransID = Connection.ToString(dr["GDSTransID"]);
result.Add(objResult);
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public CLayer.SupplierPayment GetPaymentdetails(string refId)
{
CLayer.SupplierPayment user = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pRefId", DataPlug.DataType._Varchar, refId));
DataTable dt = Connection.GetTable("OfflineBooking_GetAllByRefid", param);
if (dt.Rows.Count > 0)
{
user = new CLayer.SupplierPayment();
user.Buyprice = Connection.ToDouble(dt.Rows[0]["TotalBuyPrice"]);
user.propertyname = Connection.ToString(dt.Rows[0]["PropertyName"]);
user.propertycity = Connection.ToString(dt.Rows[0]["PropertyCityname"]);
// FirstName = Connection.ToString(dr["FirstName"]),
// LastName = Connection.ToString(dr["LastName"]),
user.SupplierEmail = Connection.ToString(dt.Rows[0]["SupplierEmail"]);
user.SupplierName = Connection.ToString(dt.Rows[0]["SupplierName"]);
user.Buyprice = Connection.ToDouble(dt.Rows[0]["TotalBuyPrice"]);
user.AmountPaid = Connection.ToDouble(dt.Rows[0]["amount"]);
user.SupplierMobile = Connection.ToString(dt.Rows[0]["SupplierMobile"]);
user.OrderId = Connection.ToString(dt.Rows[0]["Orderno"]);
user.CheckIn_date = Connection.ToDate(dt.Rows[0]["CheckIn_date"]);
user.CustomerName = Connection.ToString(dt.Rows[0]["CustName"]);
// DeletedDate = Connection.ToDate(dr["DeletedDate"]),
user.CheckOut_date = Connection.ToDate(dt.Rows[0]["CheckOut_date"]);
user.BookingDate = Connection.ToDate(dt.Rows[0]["BookingDate"]);
user.supplierId = Connection.ToLong(dt.Rows[0]["SupplierId"]);
user.supplierPayment = Connection.ToBoolean(dt.Rows[0]["supplierPayment"]);
}
return(user);
}
public List <CLayer.User> GetAllStaff(int status)
{
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));
DataTable dt = Connection.GetTable("user_GetAllStaff", param);
foreach (DataRow dr in dt.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"]),
DateOfBirth = Connection.ToDate(dr["DateOfBirth"]),
Sex = Connection.ToInteger(dr["Sex"]),
UserType = Connection.ToString(dr["UserType"]),
Status = Connection.ToInteger(dr["Status"]),
Email = Connection.ToString(dr["Email"]),
CreatedDate = Connection.ToDate(dr["CreatedDate"]),
DeletedDate = Connection.ToDate(dr["DeletedDate"]),
LastLoginOn = Connection.ToDate(dr["LastLoginOn"])
});
}
return(users);
}
public CLayer.OfflinePayment GetOfflinePaymentDetails(long OfflinePaymentId)
{
CLayer.OfflinePayment result = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pOfflinePayId", DataPlug.DataType._BigInt, OfflinePaymentId));
DataTable dt = Connection.GetTable("OfflinePayment_GetDetails", param);
if (dt.Rows.Count > 0)
{
result = new CLayer.OfflinePayment();
result.UserId = Connection.ToLong(dt.Rows[0]["UserId"]);
result.Amount = Connection.ToDecimal(dt.Rows[0]["Amount"]);
result.Name = Connection.ToString(dt.Rows[0]["Name"]);
result.Message = Connection.ToString(dt.Rows[0]["Message"]);
result.ReferenceNumber = Connection.ToString(dt.Rows[0]["ReferenceNo"]);
result.PaymentRefNo = Connection.ToString(dt.Rows[0]["PaymentReferenceNo"]);
result.CreatedDate = Connection.ToDate(dt.Rows[0]["CreatedDate"]);
result.Email = Connection.ToString(dt.Rows[0]["Email"]);
result.Mobile = Connection.ToString(dt.Rows[0]["Mobile"]);
result.Address = Connection.ToString(dt.Rows[0]["Address"]);
result.Country = Connection.ToString(dt.Rows[0]["CountryName"]);
result.State = Connection.ToString(dt.Rows[0]["StateName"]);
result.City = Connection.ToString(dt.Rows[0]["CityName"]);
result.CountryCode = Connection.ToString(dt.Rows[0]["CountryCode"]);
result.ZipCode = Connection.ToString(dt.Rows[0]["ZipCode"]);
//result.PaymentLinkID = (Guid)(dt.Rows[0]["PaymentLinkGuidId"]);
result.PaymentLinkID = Connection.ToString(dt.Rows[0]["PaymentLinkGuidId"]);
}
return(result);
}
public List <CLayer.OfflinePayment> ReportOfflinePayment_GetAll(int status, string searchString, int searchItem, int start, int limit)
{
List <CLayer.OfflinePayment> bookings = new List <CLayer.OfflinePayment>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStatus", DataPlug.DataType._Int, status));
param.Add(Connection.GetParameter("pSearchString", DataPlug.DataType._Varchar, searchString));
param.Add(Connection.GetParameter("pSearchItem", DataPlug.DataType._Int, searchItem));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._Int, start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._Int, limit));
DataSet ds = Connection.GetDataSet("Report_OfflinePaymentGetall", param);
foreach (DataRow dr in ds.Tables[1].Rows)
{
bookings.Add(new CLayer.OfflinePayment()
{
LoginUsername = Connection.ToString(dr["LoginUsername"]),
Name = Connection.ToString(dr["PayUserName"]),
Amount = Connection.ToDecimal(dr["PayAmount"]),
Message = Connection.ToString(dr["Message"]),
ReferenceNumber = Connection.ToString(dr["PayUserRefNo"]),
PaymentRefNo = Connection.ToString(dr["PaymentReferenceNo"]),
Mobile = Connection.ToString(dr["Mobile"]),
State = Connection.ToString(dr["State"]),
City = Connection.ToString(dr["City"]),
Email = Connection.ToString(dr["Email"]),
Country = Connection.ToString(dr["CountryName"]),
CreatedDate = Connection.ToDate(dr["CreatedDate"]),
OfflinePaymentStatus = Connection.ToInteger(dr["OfflinePaymentStatus"]),
OfflinePaymentId = Connection.ToInteger(dr["OfflinePaymentId"]),
TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]),
});
}
return(bookings);
}
public List <CLayer.Offers> GetForAccommodation(long accommodationId, int activeStatus)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pActiveStatus", DataPlug.DataType._Int, activeStatus));
param.Add(Connection.GetParameter("pAccommodationId", DataPlug.DataType._BigInt, accommodationId));
DataTable dt = Connection.GetTable("offer_ForAccommodation", param);
List <CLayer.Offers> result = new List <CLayer.Offers>();
CLayer.Offers temp;
foreach (DataRow dr in dt.Rows)
{
temp = new CLayer.Offers();
temp.OfferId = Connection.ToLong(dr["OfferId"]);
temp.OfferTitle = Connection.ToString(dr["OfferTitle"]);
temp.OfferType = Connection.ToInteger(dr["OfferType"]);
temp.RateType = Connection.ToInteger(dr["RateType"]);
temp.StartDate = Connection.ToDate(dr["StartDate"]);
temp.EndDate = Connection.ToDate(dr["EndDate"]);
temp.FreeDays = Connection.ToInteger(dr["FreeDays"]);
temp.NoOfDays = Connection.ToInteger(dr["NoOfDays"]);
temp.Amount = Connection.ToDecimal(dr["Amount"]);
result.Add(temp);
}
return(result);
}
public List <CLayer.Tax> GetAllForProperty(long propertyId, DateTime checkIn, DateTime bookingDate)
{
List <CLayer.Tax> result = new List <CLayer.Tax>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, propertyId));
param.Add(Connection.GetParameter("pCheckIn", DataPlug.DataType._Date, checkIn));
param.Add(Connection.GetParameter("pBooking", DataPlug.DataType._Date, bookingDate));
DataTable dt = Connection.GetTable("tax_GetAllByProperty", param);
foreach (DataRow dr in dt.Rows)
{
result.Add(new CLayer.Tax()
{
TaxId = Connection.ToInteger(dr["TaxId"]),
TaxTitleId = Connection.ToInteger(dr["TaxTitleId"]),
Rate = Connection.ToDecimal(dr["Rate"]),
CountryId = Connection.ToInteger(dr["CountryId"]),
// Country = Connection.ToString(dr["CountryName"]),
StateId = Connection.ToInteger(dr["StateId"]),
// State = Connection.ToString(dr["StateName"]),
CityId = Connection.ToInteger(dr["CityId"]),
// City = Connection.ToString(dr["CityName"]),
Notes = Connection.ToString(dr["Notes"]),
Status = Connection.ToInteger(dr["Status"]),
StartDate = Connection.ToDate(dr["StartDate"]),
EndDate = Connection.ToDate(dr["EndDate"]),
OnDate = Connection.ToInteger(dr["OnDate"]),
OnTotalAmount = Connection.ToBoolean(dr["OnTotalAmount"]),
PriceUpto = Connection.ToDecimal(dr["PriceUpto"]),
Unlimited = Connection.ToBoolean(dr["UnlimitedPrice"])
});
}
return(result);
}
public CLayer.SupplierInvoice getGetSupplierInvoicedetails(long ID)
{
CLayer.SupplierInvoice result = new CLayer.SupplierInvoice();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSupplierInvID", DataPlug.DataType._BigInt, ID));
DataTable dt = Connection.GetTable("getGetSupplierInvoicedetails", param);
if (dt.Rows.Count > 0)
{
result = new CLayer.SupplierInvoice();
result.SupplierInvoiceID = Connection.ToLong(dt.Rows[0]["SupplierInvoiceID"]);
result.PropertyId = Connection.ToLong(dt.Rows[0]["PropertyID"]);
result.Property_Name = Connection.ToString(dt.Rows[0]["Title"]);
result.SupplierId = Connection.ToLong(dt.Rows[0]["SupplierID"]);
result.InvoiceNumber = Connection.ToString(dt.Rows[0]["InvoiceNumber"]);
result.InvoiceDate = Connection.ToDate(dt.Rows[0]["InvoiceDate"]);
result.ServiceTaxRegNumber = Connection.ToString(dt.Rows[0]["ServiceTaxRegNumber"]);
result.PAN_Number = Connection.ToString(dt.Rows[0]["PAN"]);
result.BaseAmount = Connection.ToDecimal(dt.Rows[0]["BaseAmount"]);
result.LuxuryTax = Connection.ToDecimal(dt.Rows[0]["LuxuryTax"]);
result.ServiceTax = Connection.ToDecimal(dt.Rows[0]["ServiceTax"]);
result.TotalInvoiceValue = Connection.ToDecimal(dt.Rows[0]["TotalInvoiceValue"]);
result.EntryDate = Connection.ToDate(dt.Rows[0]["EntryDate"]);
result.txtTotalAdjustmentResult = Connection.ToDecimal(dt.Rows[0]["TotalAdjustment"]);
result.PropertyEmailAddresss = Connection.ToString(dt.Rows[0]["PropertyEmailAddress"]);
result.PropertyType = Connection.ToString(dt.Rows[0]["PropertyType"]);
result.TaxType = Connection.ToInteger(dt.Rows[0]["TaxType"]);
result.IsSupInvoicedone = Connection.ToBoolean(dt.Rows[0]["IsSupInvoicedone"]);
result.BookingRefNumber = Connection.ToString(dt.Rows[0]["BookingReferenceIDNo"]);
result.CheckedBookingRefNumber = Connection.ToString(dt.Rows[0]["CheckedBookingReferenceIDNo"]);
}
return(result);
}
public List <CLayer.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.Tax> GetAll()
{
List <CLayer.Tax> result = new List <CLayer.Tax>();
DataTable dt = Connection.GetTable("tax_GetAll", null);
foreach (DataRow dr in dt.Rows)
{
result.Add(new CLayer.Tax()
{
TaxId = Connection.ToInteger(dr["TaxId"]),
Title = Connection.ToString(dr["Title"]),
TaxTitleId = Connection.ToInteger(dr["TaxTitleId"]),
Rate = Connection.ToDecimal(dr["Rate"]),
CountryId = Connection.ToInteger(dr["CountryId"]),
Country = Connection.ToString(dr["CountryName"]),
StateId = Connection.ToInteger(dr["StateId"]),
State = Connection.ToString(dr["StateName"]),
CityId = Connection.ToInteger(dr["CityId"]),
City = Connection.ToString(dr["CityName"]),
Notes = Connection.ToString(dr["Notes"]),
Status = Connection.ToInteger(dr["Status"]),
StartDate = Connection.ToDate(dr["StartDate"]),
EndDate = Connection.ToDate(dr["EndDate"]),
OnDate = Connection.ToInteger(dr["OnDate"]),
OnTotalAmount = Connection.ToBoolean(dr["OnTotalAmount"]),
PriceUpto = Connection.ToDecimal(dr["PriceUpto"]),
UpdatedBy = Connection.ToLong(dr["UpdatedBy"]),
UpdatedDate = Connection.ToDate(dr["UpdatedDate"]),
Unlimited = Connection.ToBoolean(dr["UnlimitedPrice"])
});
}
return(result);
}
public List <CLayer.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.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 CLayer.Review Get(long PropertyId, long UserId, long BookingId)
{
CLayer.Review rev = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, PropertyId));
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, UserId));
param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, BookingId));
DataTable dt = Connection.GetTable("review_Details", param);
if (dt.Rows.Count > 0)
{
rev = new CLayer.Review();
rev.PropertyId = Connection.ToLong(dt.Rows[0]["PropertyId"]);
rev.UserId = Connection.ToLong(dt.Rows[0]["UserId"]);
rev.BookingId = Connection.ToLong(dt.Rows[0]["BookingId"]);
rev.Rating = Connection.ToInteger(dt.Rows[0]["Rating"]);
rev.Status = Connection.ToInteger(dt.Rows[0]["Status"]);
rev.ReviewDate = Connection.ToDate(dt.Rows[0]["ReviewDate"]);
rev.FirstName = Connection.ToString(dt.Rows[0]["FirstName"]);
rev.LastName = Connection.ToString(dt.Rows[0]["LastName"]);
rev.Title = Connection.ToString(dt.Rows[0]["Title"]);
rev.Location = Connection.ToString(dt.Rows[0]["Location"]);
rev.Address = Connection.ToString(dt.Rows[0]["Address"]);
rev.Description = Connection.ToString(dt.Rows[0]["Description"]);
rev.UpdatedBy = Connection.ToLong(dt.Rows[0]["UpdatedBy"]);
rev.UpdatedDate = Connection.ToDate(dt.Rows[0]["UpdatedDate"]);
rev.Recommended = Connection.ToBoolean(dt.Rows[0]["IsRecommended"]);
}
return(rev);
}
public CLayer.User GetCountrUser(long userid)
{
CLayer.User user = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pUserId", DataPlug.DataType._BigInt, userid));
DataTable dt = Connection.GetTable("user_Get", param);
if (dt.Rows.Count > 0)
{
user = new CLayer.User();
user.UserId = Connection.ToLong(dt.Rows[0]["UserId"]);
user.SalutationId = Connection.ToInteger(dt.Rows[0]["SalutationId"]);
user.FirstName = Connection.ToString(dt.Rows[0]["FirstName"]);
user.LastName = Connection.ToString(dt.Rows[0]["LastName"]);
user.DateOfBirth = Connection.ToDate(dt.Rows[0]["DateOfBirth"]);
user.Sex = Connection.ToInteger(dt.Rows[0]["Sex"]);
user.UserTypeId = Connection.ToInteger(dt.Rows[0]["UserType"]);
user.Status = Connection.ToInteger(dt.Rows[0]["Status"]);
user.Email = Connection.ToString(dt.Rows[0]["Email"]);
user.CreatedDate = Connection.ToDate(dt.Rows[0]["CreatedDate"]);
user.Phone = Connection.ToString(dt.Rows[0]["Phone"]);
user.Mobile = Connection.ToString(dt.Rows[0]["Mobile"]);
user.Country = Connection.ToString(dt.Rows[0]["Country"]);
}
return(user);
}
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 DateTime GetbookingsmedayforCorp(long b2bId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pB2BId", DataPlug.DataType._BigInt, b2bId));
object result = Connection.ExecuteQueryScalar("b2bcorporate_GetbookingsmedayforCorp", param);
return(Connection.ToDate(result));
}
public List <CLayer.OfflineBooking> SupplierInvoiceSavedBookingList(long PropID, long ID, string BookingRefIDs, string PropertyEmailAddresss, string PropertyType)
{
List <CLayer.OfflineBooking> result = new List <CLayer.OfflineBooking>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
DataTable dt = new DataTable();
if (ID > 0)
{
param.Add(Connection.GetParameter("pProp_ID", DataPlug.DataType._BigInt, PropID));
param.Add(Connection.GetParameter("pSupplierInvoice_ID", DataPlug.DataType._BigInt, ID));
param.Add(Connection.GetParameter("pPropertyEmailAddresss", DataPlug.DataType._Text, PropertyEmailAddresss));
param.Add(Connection.GetParameter("pPropertyType", DataPlug.DataType._Text, PropertyType));
dt = Connection.GetTable("SupplierInvoicePropertySavedBooking_List", param);
}
else
{
param.Add(Connection.GetParameter("pProp_ID", DataPlug.DataType._BigInt, PropID));
param.Add(Connection.GetParameter("pBookingIDs", DataPlug.DataType._Varchar, BookingRefIDs));
param.Add(Connection.GetParameter("pPropertyEmailAddresss", DataPlug.DataType._Text, PropertyEmailAddresss));
param.Add(Connection.GetParameter("pPropertyType", DataPlug.DataType._Text, PropertyType));
dt = Connection.GetTable("SupplierInvoicePropertyBooking_List_ForSaving", param);
}
//param.Add(Connection.GetParameter("pProp_ID", DataPlug.DataType._BigInt, PropID));
//param.Add(Connection.GetParameter("pSupplierInvoice_ID", DataPlug.DataType._BigInt, ID));
//DataTable dt = Connection.GetTable("SupplierInvoicePropertySavedBooking_List", param);
CLayer.OfflineBooking res = null;
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
res = new CLayer.OfflineBooking();
res.PropertyId = Connection.ToLong(dr["Prop_ID"]);
res.OfflineBookingId = Connection.ToLong(dr["Primary_ID"]);
res.ConfirmationNumber = Connection.ToString(dr["OrderNo"]);
//res.Amount = Connection.ToLong(dr["Amount"]);
res.CheckIn_date = Connection.ToDate(dr["CheckIn_date"]);
res.CheckOut_date = Connection.ToDate(dr["CheckOut_date"]);
//res.BookingDate = Connection.ToDate(dr["BookingDate"]);
res.PropertyName = Connection.ToString(dr["PropertyName"]);
res.PropertyContactNo = Connection.ToString(dr["PropertyContactNo"]);
res.PropertyEmail = Connection.ToString(dr["PropertyEmail"]);
res.SupplierName = Connection.ToString(dr["SupplierName"]);
res.SupplierMobile = Connection.ToString(dr["SupplierMobile"]);
res.SupplierEmail = Connection.ToString(dr["SupplierEmail"]);
res.TotalBuyPrice = Connection.ToDecimal(dr["TotalBuyPrice"]);
res.City = Connection.ToString(dr["City"]);
res.isOpen = Connection.ToBoolean(dr["open"]);
res.SupInvoiceValueBRef = Connection.ToDecimal(dr["SupInvoiceValueBRef"]);
res.PaidValueBRef = Connection.ToDecimal(dr["PaidValueBRef"]);
res.AmtTobePaid = Connection.ToDecimal(dr["AmtTobePaid"]);
result.Add(res);
}
}
return(result);
}
public List <CLayer.SupplierPayment> GetAllSupllierPaymentVoucher(long SupplierPaymentId)
{
List <CLayer.SupplierPayment> users = new List <CLayer.SupplierPayment>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pSupplierPaymentID", DataPlug.DataType._Int, SupplierPaymentId));
DataSet ds = Connection.GetDataSet("supplierpaymentvoucher_GetAllBySupplierPaymentID", param);
foreach (DataRow dr in ds.Tables[0].Rows)
{
users.Add(new CLayer.SupplierPayment()
{
grossAmount = Connection.ToDecimal(dr["grossAmount"]),
tdsAmount = Connection.ToDecimal(dr["tdsAmount"]),
netAmtPaid = Connection.ToDecimal(dr["netAmtPaid"]),
modeofPayment = Connection.ToString(dr["modeofPayment"]),
BAnk = Connection.ToString(dr["bank"]),
NoOfPaxChild = Connection.ToLong(dr["NoOfPaxChild"]),
NoOfPaxAdult = Connection.ToLong(dr["NoOfPaxAdult"]),
NoofRooms = Connection.ToLong(dr["NoofRooms"]),
Guestname = Connection.ToString(dr["Guestname"]),
// Salutation = Connection.ToString(dr["Salutation"]),
propertyname = Connection.ToString(dr["PropertyName"]),
propertycity = Connection.ToString(dr["propertycity"]),
Region = Connection.ToString(dr["Region"]),
Amount = Connection.ToDecimal(dr["Amount"]),
SupplierCity = Connection.ToString(dr["SupplierCity"]),
// FirstName = Connection.ToString(dr["FirstName"]),
// LastName = Connection.ToString(dr["LastName"]),
SupplierEmail = Connection.ToString(dr["SupplierEmail"]),
SupplierName = Connection.ToString(dr["SupplierName"]),
Buyprice = Connection.ToDouble(dr["TotalBuyPrice"]),
pdtPayment = Connection.ToDate(dr["dtPayment"]),
AmountPaid = Connection.ToDouble(dr["amount"]),
SupplierMobile = Connection.ToString(dr["SupplierMobile"]),
OrderId = Connection.ToString(dr["Orderno"]),
CheckIn_date = Connection.ToDate(dr["CheckIn_date"]),
// DeletedDate = Connection.ToDate(dr["DeletedDate"]),
CheckOut_date = Connection.ToDate(dr["CheckOut_date"]),
BookingDate = Connection.ToDate(dr["BookingDate"]),
NoofDays = Connection.ToLong(dr["Noofnight"]),
Payamount = Connection.ToDecimal(dr["PayAmount"])
// Status = Connection.ToInteger(dr["Status"]),
// PANNo = Connection.ToString(dr["PANNo"]),
// UserCode = Connection.ToString(dr["UserCode"]),
});
}
return(users);
}
//*This is for getting details of offlinebooking
//*Done by rahul on 06-02-2020
public List <CLayer.BookingItem> GetAllOfflineDetails(long bookingId, bool IsAmedus = false)
{
List <CLayer.BookingItem> result = new List <CLayer.BookingItem>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
try
{
param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, bookingId));
DataTable dt;
dt = Connection.GetTable("offlinebooking_GetAllItems", param);
CLayer.BookingItem bi;
foreach (DataRow dr in dt.Rows)
{
bi = new CLayer.BookingItem();
bi.BookingItemId = Connection.ToLong(dr["BookingId"]);
bi.AccommodationId = Connection.ToLong(dr["AccommodatoinTypeId"]);
bi.BookingId = Connection.ToLong(dr["Offline_BookingId"]);
bi.AccommodationTitle = Connection.ToString(dr["AccommodationType"]);
bi.CheckIn = Connection.ToDate(dr["CheckIn_date"]);
bi.CheckOut = Connection.ToDate(dr["CheckOut_date"]);
bi.NoOfAccommodations = Connection.ToInteger(dr["NoOfRooms"]);
bi.NoOfAdults = Connection.ToInteger(dr["NoOfPaxAdult"]);
bi.NoOfChildren = Connection.ToInteger(dr["NoOfPaxChild"]);
bi.NoOfDays = Connection.ToInteger(dr["Noofnight"]);
bi.Amount = Connection.ToDecimal(dr["TotalBuyPrice"]);
bi.PropertyTitle = Connection.ToString(dr["PropertyTitle"]);
bi.PropertyAddress = Connection.ToString(dr["PropertyAddress"]);
bi.PropertyId = Connection.ToLong(dr["PropertyId"]);
bi.TotalAmount = Connection.ToDecimal(dr["TotalAmtForBuyPrice"]);
bi.TotalTax = Connection.ToDecimal(dr["StaxForBuyPrice"]);
bi.AccommodationTypeT = Connection.ToString(dr["AccommodationType"]);
bi.StayCategoryT = Connection.ToString(dr["StayCategory"]);
bi.DailyRate = Connection.ToDecimal(dr["DailyRate"]);
bi.HotelConfirmNumber = Connection.ToString(dr["HotelConfirmNumber"]);
bi.CountryName = Connection.ToString(dr["CountryName"]);
result.Add(bi);
}
}
catch (Exception ex)
{
result = null;
}
return(result);
}
public List <CLayer.SupplierInvoice> getSupplierInvoiceList_Report(long Start, long Limit, DateTime?fromDT, DateTime?toDT)
{
fromDT = fromDT == DateTime.MinValue ? null : fromDT;
toDT = toDT == DateTime.MinValue ? null : toDT;
List <CLayer.SupplierInvoice> result = new List <CLayer.SupplierInvoice>();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pfromDT", DataPlug.DataType._Date, fromDT));
param.Add(Connection.GetParameter("ptoDT", DataPlug.DataType._Date, toDT));
param.Add(Connection.GetParameter("pStart", DataPlug.DataType._BigInt, Start));
param.Add(Connection.GetParameter("pLimit", DataPlug.DataType._BigInt, Limit));
DataSet ds = Connection.GetDataSet("getGetSupplierInvoiceList_Report", param);
CLayer.SupplierInvoice res = null;
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
res = new CLayer.SupplierInvoice();
res.SupplierInvoiceID = Connection.ToLong(dr["SupplierInvoiceID"]);
res.PropertyId = Connection.ToLong(dr["PropertyID"]);
res.Property_Name = Connection.ToString(dr["Title"]);
res.SupplierId = Connection.ToLong(dr["SupplierID"]);
res.SupplierName = Connection.ToString(dr["SupplierName"]);
res.City = Connection.ToString(dr["City"]);
res.InvoiceNumber = Connection.ToString(dr["InvoiceNumber"]);
res.InvoiceDate = Connection.ToDate(dr["InvoiceDate"]);
res.ServiceTaxRegNumber = Connection.ToString(dr["ServiceTaxRegNumber"]);
res.PAN_Number = Connection.ToString(dr["PAN"]);
res.BaseAmount = Connection.ToDecimal(dr["BaseAmount"]);
res.LuxuryTax = Connection.ToDecimal(dr["LuxuryTax"]);
res.ServiceTax = Connection.ToDecimal(dr["ServiceTax"]);
res.TotalInvoiceValue = Connection.ToDecimal(dr["TotalInvoiceValue"]);
res.EntryDate = Connection.ToDate(dr["EntryDate"]);
res.SupplierInvoiceBooking_ID = Connection.ToLong(dr["SupplierInvoiceBooking_ID"]);
res.BookingRefNumber = Connection.ToString(dr["BookingRefNumber"]);
res.CheckIn_date = Connection.ToDate(dr["CheckIn_date"]);
res.CheckOut_date = Connection.ToDate(dr["CheckOut_date"]);
res.BookinCreatedDT = Connection.ToDate(dr["BookinCreatedDT"]);
res.TotalRows = Connection.ToLong(ds.Tables[0].Rows[0]["NumberOfRows"]);
result.Add(res);
}
}
return(result);
}
public CLayer.InvoiceNumberData GetOldGDSInvoiceNumber(long stateId)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._BigInt, stateId));
DataTable dt = Connection.GetTable("State_OldGDSInvoiceNumber", param);
if (dt.Rows.Count == 0)
{
return(null);
}
CLayer.InvoiceNumberData data = new CLayer.InvoiceNumberData();
data.InvoiceNumber = Connection.ToString(dt.Rows[0]["IncNumber"]);
data.InvoiceDate = Connection.ToDate(dt.Rows[0]["InvDate"]);
return(data);
}
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);
}