public static List <eTblPurchaseHistory> GetRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eTblPurchaseHistory> purchaseHistoryList = new List <eTblPurchaseHistory>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var purchaseHistoryList_AsQueryable = db.tblPurchaseHistories.Where(u => u.FIRSTNAME.Contains(param.sSearch)).AsQueryable();
TotalCount = purchaseHistoryList_AsQueryable.Count();
switch (param.iSortingCols)
{
case 0:
purchaseHistoryList_AsQueryable = param.sortDirection == "asc" ? purchaseHistoryList_AsQueryable.OrderBy(u => u.FIRSTNAME) : purchaseHistoryList_AsQueryable.OrderByDescending(u => u.FIRSTNAME);
break;
}
List <tblPurchaseHistory> lstUser = purchaseHistoryList_AsQueryable.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
foreach (var item in lstUser)
{
purchaseHistoryList.Add((eTblPurchaseHistory)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eTblPurchaseHistory()));
}
return(purchaseHistoryList);
}
}
//Get list of records
public static List <eCountries> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eCountries> user = new List <eCountries>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//for searching
var objTblUser = db.tblCountryMs.Where(u => u.sCountry.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblUser.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sCountry) : objTblUser.OrderByDescending(u => u.sCountry);
break;
}
////implemented paging
List <tblCountryM> lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in lstUser)
{
user.Add((eCountries)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eCountries()));
}
return(user);
}
}
public static List <etblBannerM> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <etblBannerM> bannerRec = new List <etblBannerM>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//for searching
var objTbl = (from m in db.tblBannerMs
join u in db.tblUserMs on m.iActionBy equals u.iUserId
select new
{
m.iBannerId,
m.sBannerName,
m.sBannerType,
m.sDescription,
m.sTextPosition,
m.sLinkId,
m.sImgUrl,
m.iResolutionH,
m.iResolutionW,
m.UniqueAzureFileName,
cstatus = m.cstatus == "A" ? "Live" : "Disable"
// iActionBy = u.sFirstName + " " + u.sLastName
}
).Where(u => u.sBannerName.Contains(param.sSearch) || u.sBannerType.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTbl.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTbl = param.sortDirection == "asc" ? objTbl.OrderBy(u => u.sBannerType) : objTbl.OrderByDescending(u => u.sBannerType);
break;
case 2:
objTbl = param.sortDirection == "asc" ? objTbl.OrderBy(u => u.sBannerName) : objTbl.OrderByDescending(u => u.sBannerName);
break;
case 5:
objTbl = param.sortDirection == "asc" ? objTbl.OrderBy(u => u.cstatus) : objTbl.OrderByDescending(u => u.cstatus);
break;
}
////implemented paging
var data = objTbl.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in data)
{
bannerRec.Add((etblBannerM)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new etblBannerM()));
}
return(bannerRec);
}
}
//Get list of records
public static List <eTaxDisp> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eTaxDisp> taxlst = new List <eTaxDisp>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//SqlParameter[] MyParam = new SqlParameter[5];
//MyParam[0] = new SqlParameter("@Tax", param.sSearch + "%");
//MyParam[1] = new SqlParameter("@DisplayLength", param.iDisplayLength);
//MyParam[2] = new SqlParameter("@DisplayStart", param.iDisplayStart);
//MyParam[3] = new SqlParameter("@SortDirection", param.sortDirection == "asc" ? "A" : "D");
//MyParam[4] = new SqlParameter("@TotalCount", 0);
//MyParam[4].Direction = System.Data.ParameterDirection.Output;
////var objTblUser = db.Database.SqlQuery<eTaxDisp>("uspGetAmenitiesByName @Tax, @DisplayLength, @DisplayStart, @SortDirection", new SqlParameter("@Tax", param.sSearch + "%"),new SqlParameter("@DisplayLength", param.iDisplayLength),new SqlParameter("@DisplayStart", param.iDisplayStart),new SqlParameter("@SortDirection", param.sortDirection == "asc" ? "A" : "D"));
//user = db.Database.SqlQuery<eTaxDisp>("uspGetTaxByName @Tax, @DisplayLength, @DisplayStart, @SortDirection, @TotalCount out", MyParam).ToList();
////get Total Count for show total records
//TotalCount = Convert.ToInt16(MyParam[4].Value);//user.Count();
var objTblTax = (from s in db.tblTaxMs
join c in db.tblUserMs on s.iActionBy equals c.iUserId into Tax
from T in Tax.DefaultIfEmpty()
select new
{
s.iTaxId,
s.sTaxName,
s.dtActionDate,
cStatus = s.cStatus == "A" ? "Live" : "Disable",
ActionBy = T.sFirstName + " " + T.sLastName
}).Where(u => u.sTaxName.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblTax.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblTax = param.sortDirection == "asc" ? objTblTax.OrderBy(u => u.sTaxName) : objTblTax.OrderByDescending(u => u.sTaxName);
break;
case 1:
objTblTax = param.sortDirection == "asc" ? objTblTax.OrderBy(u => u.cStatus) : objTblTax.OrderByDescending(u => u.cStatus);
break;
}
////implemented paging
var lstUser = objTblTax.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in lstUser)
{
taxlst.Add((eTaxDisp)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eTaxDisp()));
}
return(taxlst);
}
}
//Get list of records
public static List <GroupsForGrid> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <GroupsForGrid> groups = new List <GroupsForGrid>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//for searching
//var objTblUser = db.tblUserMs.Where(u => u.sUserName.Contains(param.sSearch) || u.sFirstName.Contains(param.sSearch) || u.sLastName.Contains(param.sSearch) || u.sEmail.Contains(param.sSearch)).AsQueryable();
var objTblGroup = (from s in db.tblGroupMs
join c in db.tblUserMs on s.iCreatedBy equals c.iUserId into Groups
from grps in Groups.DefaultIfEmpty()
join c1 in db.tblUserMs on s.iActionBy equals c1.iUserId into Users
from usrs in Users.DefaultIfEmpty()
select new
{
s.iGroupId,
s.sGroupName,
s.sDescription,
s.dtCreationDate,
cStatus = s.cStatus == "A" ? "Live" : "Disable",
s.dtActionDate,
CreatedBy = grps.sFirstName + " " + grps.sLastName,
ActionBy = usrs.sFirstName + " " + usrs.sLastName
}).Where(u => u.sGroupName.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblGroup.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblGroup = param.sortDirection == "asc" ? objTblGroup.OrderBy(u => u.sGroupName) : objTblGroup.OrderByDescending(u => u.sGroupName);
break;
case 2:
objTblGroup = param.sortDirection == "asc" ? objTblGroup.OrderBy(u => u.cStatus) : objTblGroup.OrderByDescending(u => u.cStatus);
break;
}
////implemented paging
//List<tblUserM> lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
var lstUser = objTblGroup.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
groups.AddRange(lstUser.Select(user => (GroupsForGrid)OneFineRateAppUtil.clsUtils.ConvertToObject(user, new GroupsForGrid())));
return(groups);
}
}
//Get list of records
public static List <eUserList> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
List <eUserList> objTblUserList = new List <eUserList>();
List <eUserList> objTblUser = new List <eUserList>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
objTblUser = db.Database.SqlQuery <eUserList>("uspGetAllUsers").ToList();
var result = objTblUser.Where(a => a.sEmail.ToLower().Contains(param.sSearch.ToLower()) ||
a.sFirstName.ToLower().Contains(param.sSearch.ToLower()) ||
a.sGroup.ToLower().Contains(param.sSearch.ToLower()) ||
a.sContact.ToLower().Contains(param.sSearch.ToLower()));
//get Total Count for show total records
TotalCount = result.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.sUserName) : result.OrderByDescending(u => u.sUserName);
break;
case 1:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.sFirstName) : result.OrderByDescending(u => u.sFirstName);
break;
//case 3:
// objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sEmail) : objTblUser.OrderByDescending(u => u.sEmail);
// break;
case 4:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.cStatus) : result.OrderByDescending(u => u.cStatus);
break;
}
////implemented paging
var lstUser = result.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in lstUser)
{
objTblUserList.Add((eUserList)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eUserList()));
}
return(objTblUserList);
}
catch (Exception Ex)
{
throw;
}
}
}
public static List <etblPropertyPromotionMap> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount, int promoid, int propid)
{
List <etblPropertyPromotionMap> promorec = new List <etblPropertyPromotionMap>();
List <etblPropertyPromotionMap> objResult = new List <etblPropertyPromotionMap>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
using (OneFineRateEntities _context = new OneFineRateEntities())
{
SqlParameter[] MyParam = new SqlParameter[2];
MyParam[0] = new SqlParameter("@promoid", promoid);
MyParam[1] = new SqlParameter("@propid", propid);
objResult = _context.Database.SqlQuery <etblPropertyPromotionMap>("uspPromotionsListByID @promoid , @propid", MyParam).ToList();
var result = objResult.Where(a => a.sRoomTypeId.ToLower().Contains(param.sSearch.ToLower()));
//for sorting
switch (param.iSortingCols)
{
case 1:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.dtBookingDateFrom) : result.OrderByDescending(u => u.dtBookingDateFrom);
break;
case 2:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.dtBookingDateTo) : result.OrderByDescending(u => u.dtBookingDateTo);
break;
case 3:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.dtStayDateFrom) : result.OrderByDescending(u => u.dtStayDateFrom);
break;
case 4:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.dtStayDateTo) : result.OrderByDescending(u => u.dtStayDateTo);
break;
}
//get Total Count for show total records
var result1 = result.ToList();
TotalCount = result1.Count;
////implemented paging
var lstUser = result.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
foreach (var item in lstUser)
{
promorec.Add((etblPropertyPromotionMap)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new etblPropertyPromotionMap()));
}
return(promorec);
}
}
//Get list of records
public static List <etblStateM> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <etblStateM> state = new List <etblStateM>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//for searching
var objTblState = (from s in db.tblStateMs
join c in db.tblCountryMs on s.iCountryId equals c.iCountryId
select new
{
s.iStateId,
s.iCountryId,
c.sCountry,
s.sState,
cStatus = s.cStatus == "A" ? "Active" : "InActive",
s.dtActionDate,
s.iActionBy
}).Where(u => u.sState.Contains(param.sSearch) || u.sCountry.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblState.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblState = param.sortDirection == "asc" ? objTblState.OrderBy(u => u.sCountry) : objTblState.OrderByDescending(u => u.sCountry);
break;
case 1:
objTblState = param.sortDirection == "asc" ? objTblState.OrderBy(u => u.sState) : objTblState.OrderByDescending(u => u.sState);
break;
default:
objTblState = param.sortDirection == "asc" ? objTblState.OrderBy(u => u.sState) : objTblState.OrderByDescending(u => u.sState);
break;
}
////implemented paging
var data = objTblState.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in data)
{
state.Add((etblStateM)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new etblStateM()));
}
return(state);
}
}
public static List <etblUnfinishedTransactions> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount, string sSearchType, string sName, string sEmailID, string iTelephone, Int64 iBookingID, string sTransDate)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <etblUnfinishedTransactions> user = new List <etblUnfinishedTransactions>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
List <etblUnfinishedTransactions> changeLst = new List <etblUnfinishedTransactions>();
List <etblUnfinishedTransactions> objResult = new List <etblUnfinishedTransactions>();
SqlParameter[] MyParam = new SqlParameter[6];
MyParam[0] = new SqlParameter("@sSearchType", sSearchType);
MyParam[1] = new SqlParameter("@sName", sName + "%");
MyParam[2] = new SqlParameter("@sEmailID", sEmailID);
MyParam[3] = new SqlParameter("@iTelephone", iTelephone);
MyParam[4] = new SqlParameter("@iBookingID", iBookingID);
//MyParam[5] = new SqlParameter("@sTransDate", (sTransDate.Trim() == string.Empty ? null : OneFineRateAppUtil.clsUtils.ConvertddmmyyyytoDateTime(sTransDate)));
MyParam[5] = new SqlParameter("@sTransDate", "");
if (sTransDate.Trim() == string.Empty)
{
MyParam[5].Value = "";
}
else
{
MyParam[5].Value = OneFineRateAppUtil.clsUtils.ConvertddmmyyyytoDateTime(sTransDate);
}
try
{
objResult = db.Database.SqlQuery <etblUnfinishedTransactions>("uspGetUnFinishedTransactionData @sSearchType ,@sName ,@sEmailID ,@iTelephone ,@iBookingID ,@sTransDate", MyParam).ToList();
}
catch (System.Exception)
{
throw;
}
var result = objResult.Where(a => a.sName.Contains(param.sSearch.ToLower()) || a.sEmailID.Contains(param.sSearch.ToUpper())).ToList();
//get Total Count for show total records
TotalCount = result.Count();
////implemented paging
var lstUser = result.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
foreach (var item in lstUser)
{
changeLst.Add((etblUnfinishedTransactions)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new etblUnfinishedTransactions()));
}
return(changeLst);
}
}
public string GetAllRecords1(int sEcho, int iDisplayLength, int iDisplayStart, string sSortDir_0, string sSearch, int iSortCol_0)
{
OneFineRateAppUtil.jQueryDataTableParamModel tblobj = new OneFineRateAppUtil.jQueryDataTableParamModel();
// int sEcho = ToInt(HttpContext.Current.Request.Params["sEcho"]);
tblobj.iDisplayLength = iDisplayLength; // ToInt(HttpContext.Current.Request.Params["iDisplayLength"]);
tblobj.iDisplayStart = iDisplayStart; // ToInt(HttpContext.Current.Request.Params["iDisplayStart"]);
tblobj.sortDirection = sSortDir_0; //HttpContext.Current.Request.Params["sSortDir_0"];
tblobj.sSearch = sSearch; // HttpContext.Current.Request.Params["sSearch"];
tblobj.iSortingCols = iSortCol_0; // Convert.ToInt32(HttpContext.Current.Request.Params["iSortCol_0"]);
string outputJson = string.Empty;
StringBuilder sb = new StringBuilder();
int TotalCount;
List <eCountries> list = BL_Country.getRecordForSearch(tblobj, out TotalCount).ToList();
if (list.Count > 0)
{
sb.Clear();
sb.Append("{");
sb.Append(@"""sEcho"": ");
sb.AppendFormat(@"""{0}""", sEcho);
sb.Append(",");
sb.Append(@"""iTotalRecords"": ");
sb.Append(TotalCount.ToString());
sb.Append(",");
sb.Append(@"""iTotalDisplayRecords"": ");
sb.Append(TotalCount.ToString());
sb.Append(", ");
sb.Append(@"""aaData"": ");
sb.Append(OneFineRateAppUtil.clsUtils.ConvertToJson(list));
sb.Append("}");
outputJson = sb.ToString();
}
else
{
sb.Clear();
sb.Append("{");
sb.Append(@"""sEcho"": ");
sb.AppendFormat(@"""{0}""", sEcho);
sb.Append(",");
sb.Append(@"""iTotalRecords"": 0");
sb.Append(",");
sb.Append(@"""iTotalDisplayRecords"": 0");
sb.Append(", ");
sb.Append(@"""aaData"": [ ");
sb.Append("]}");
outputJson = sb.ToString();
}
return(outputJson);
}
public static List <eChannelManager> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eChannelManager> ChannelManager = new List <eChannelManager>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var objTblUser = (from PCM in db.tblPropertyChannelMgrMaps
join U in db.tblUserMs on PCM.iActionBy equals U.iUserId into S1
from Users in S1.DefaultIfEmpty()
join P in db.tblPropertyMs on PCM.iPropId equals P.iPropId into Prop
from Property in Prop.DefaultIfEmpty()
join CM in db.tblChannelMgrMs on PCM.iChannelMgr equals CM.iChannelMgr into ChMgr
from channelmanager in ChMgr.DefaultIfEmpty()
join C in db.tblCityMs on Property.iCityId equals C.iCityId into Cit
from City in Cit.DefaultIfEmpty()
select new
{
PCM.iPropId,
sHotelName = Property.sHotelName + " , " + City.sCity,
channelmanager.sChannelMgrName,
PCM.dtActionDate,
sActionBy = Users.sFirstName + " " + Users.sLastName
}).Distinct().Where(u => u.sHotelName.Contains(param.sSearch) || u.sChannelMgrName.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblUser.Count();
switch (param.iSortingCols)
{
case 0:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sHotelName) : objTblUser.OrderByDescending(u => u.sHotelName);
break;
case 1:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sChannelMgrName) : objTblUser.OrderByDescending(u => u.sChannelMgrName);
break;
}
////implemented paging
//List<tblUserM> lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
var lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
ChannelManager.AddRange(lstUser.Select(usr => (eChannelManager)OneFineRateAppUtil.clsUtils.ConvertToObject(usr, new eChannelManager())));
return(ChannelManager);
}
}
//Get list of records
public static List <eLoyalityAmenityDisp> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eLoyalityAmenityDisp> Amenitylst = new List <eLoyalityAmenityDisp>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var objTblAmenity = (from s in db.tblLoyalityAmenityMaps
join a in db.tblAmenityMs on s.iAmenityId equals a.iAmenityId
join c in db.tblUserMs on s.iActionBy equals c.iUserId into Tax
from T in Tax.DefaultIfEmpty()
select new
{
s.iLoyalityAmenityId,
s.iPoints,
a.sAmenityName,
s.dtActionDate,
cStatus = s.cStatus == "A" ? "Live" : "Disable",
ActionBy = T.sFirstName + " " + T.sLastName
}).Where(u => u.sAmenityName.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblAmenity.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblAmenity = param.sortDirection == "asc" ? objTblAmenity.OrderBy(u => u.iPoints) : objTblAmenity.OrderByDescending(u => u.iPoints);
break;
case 1:
objTblAmenity = param.sortDirection == "asc" ? objTblAmenity.OrderBy(u => u.sAmenityName) : objTblAmenity.OrderByDescending(u => u.sAmenityName);
break;
}
////implemented paging
var lstUser = objTblAmenity.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in lstUser)
{
Amenitylst.Add((eLoyalityAmenityDisp)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eLoyalityAmenityDisp()));
}
return(Amenitylst);
}
}
public static List <eExchange> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eExchange> Exchange = new List <eExchange>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var objTblUser = (from ER in db.tblExchangeRatesMs
join U in db.tblUserMs on ER.iActionBy equals U.iUserId into S1
from Users in S1.DefaultIfEmpty()
join C1 in db.tblCurrencyMs on ER.sCurrencyCodeFrom equals C1.sCurrencyCode into Curr1
from Currency1 in Curr1.DefaultIfEmpty()
join C2 in db.tblCurrencyMs on ER.sCurrencyCodeTo equals C2.sCurrencyCode into Curr2
from Currency2 in Curr2.DefaultIfEmpty()
select new
{
sCurrencyCodeFrom = ER.sCurrencyCodeFrom + " - " + Currency1.sCurrency,
sCurrencyCodeTo = ER.sCurrencyCodeTo + " - " + Currency2.sCurrency,
ER.dRate,
ER.dtActionDate,
sActionBy = Users.sFirstName + " " + Users.sLastName
}).Distinct().Where(u => u.sCurrencyCodeFrom.Contains(param.sSearch) || u.sCurrencyCodeTo.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblUser.Count();
switch (param.iSortingCols)
{
case 0:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sCurrencyCodeFrom) : objTblUser.OrderByDescending(u => u.sCurrencyCodeFrom);
break;
case 1:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sCurrencyCodeTo) : objTblUser.OrderByDescending(u => u.sCurrencyCodeTo);
break;
}
////implemented paging
//List<tblUserM> lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
var lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
Exchange.AddRange(lstUser.Select(usr => (eExchange)OneFineRateAppUtil.clsUtils.ConvertToObject(usr, new eExchange())));
return(Exchange);
}
}
//Get list of records
public static List <eChains> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eChains> user = new List <eChains>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//var objTblUser = db.tblChainMs.Include("tblExtranetUserM").Where(u => u.sChainName.Contains(param.sSearch)).AsQueryable();
//for searching
var objTblUser = (from C in db.tblChainMs
join U in db.tblUserMs on C.iActionBy equals U.iUserId
select new
{
C.iChainID,
C.sChainName,
C.dtActionDate,
cStatus = C.cStatus == "A" ? "Live" : "Disable",
ActionBy = U.sFirstName + " " + U.sLastName
}).Where(u => u.sChainName.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblUser.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sChainName) : objTblUser.OrderByDescending(u => u.sChainName);
break;
case 1:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.cStatus) : objTblUser.OrderByDescending(u => u.cStatus);
break;
}
////implemented paging
var lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
user.AddRange(lstUser.Select(item => (eChains)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eChains())));
return(user);
}
}
//Get list of records
public static List <etblPropertyDiningMap> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, int propid, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <etblPropertyDiningMap> user = new List <etblPropertyDiningMap>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//for searching
var objTblUser = db.tblPropertyDiningMaps.Where(u => u.sRestaurantName.Contains(param.sSearch) && u.iPropId == propid).AsQueryable();
//get Total Count for show total records
TotalCount = objTblUser.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.cType) : objTblUser.OrderByDescending(u => u.cType);
break;
case 1:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sRestaurantName) : objTblUser.OrderByDescending(u => u.sRestaurantName);
break;
case 2:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sDescription) : objTblUser.OrderByDescending(u => u.sDescription);
break;
case 3:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.b24hours) : objTblUser.OrderByDescending(u => u.b24hours);
break;
}
////implemented paging
List <tblPropertyDiningMap> lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in lstUser)
{
user.Add((etblPropertyDiningMap)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new etblPropertyDiningMap()));
}
return(user);
}
}
//Get list of records
public static List <etblLocalityList> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <etblLocalityList> locality = new List <etblLocalityList>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//for searching
var objTblMacroArea = (from l in db.tblLocalityMs
join m in db.tblMacroAreaMs on l.iAreaId equals m.iAreaId
join c in db.tblCountryMs on l.iCountryId equals c.iCountryId
join s in db.tblStateMs on l.iStateId equals s.iStateId
join ct in db.tblCityMs on l.iCityId equals ct.iCityId
join u in db.tblUserMs on l.iActionBy equals u.iUserId into lt
from T in lt.DefaultIfEmpty()
join c1 in db.tblPropertyMs on l.iLocalityId equals c1.iLocalityId into S2
from a in S2.DefaultIfEmpty()
select new
{
l.iLocalityId,
l.iCountryId,
c.sCountry,
l.iStateId,
s.sState,
l.iCityId,
ct.sCity,
l.iAreaId,
m.sArea,
l.sLocality,
cStatus = l.cStatus == "A" ? "Live" : "Disable",
l.dtActionDate,
iActionBy = T.sFirstName + " " + T.sLastName,
iPropId = S2.Count()
}
).Distinct().Where(u => u.sCountry.Contains(param.sSearch) || u.sState.Contains(param.sSearch) ||
u.sCity.Contains(param.sSearch) || u.sArea.Contains(param.sSearch) || u.sLocality.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblMacroArea.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sCountry) : objTblMacroArea.OrderByDescending(u => u.sCountry);
break;
case 1:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sState) : objTblMacroArea.OrderByDescending(u => u.sState);
break;
case 2:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sCity) : objTblMacroArea.OrderByDescending(u => u.sCity);
break;
case 3:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sArea) : objTblMacroArea.OrderByDescending(u => u.sArea);
break;
case 4:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sLocality) : objTblMacroArea.OrderByDescending(u => u.sLocality);
break;
case 5:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.cStatus) : objTblMacroArea.OrderByDescending(u => u.cStatus);
break;
}
////implemented paging
var data = objTblMacroArea.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in data)
{
locality.Add((etblLocalityList)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new etblLocalityList()));
}
return(locality);
}
}
//Get list of records
public static List <ePromoCodeDisp> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <ePromoCodeDisp> Promolst = new List <ePromoCodeDisp>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var objTblPromo = (from a in db.tblPromoCodeMs
join c in db.tblUserMs on a.iActionBy equals c.iUserId into PC
from T in PC.DefaultIfEmpty()
join am in db.tblAmenityMs on a.iAmenityId equals am.iAmenityId into S2
from am1 in S2.DefaultIfEmpty()
join PPM in db.tblPropertyPromoMaps on a.iPromoCodeId equals PPM.iPromoCodeId into PPM1
from PPM2 in PPM1.DefaultIfEmpty()
select new
{
a.iPromoCodeId,
a.sPromoCode,
a.sPromoTitle,
a.sPromoDescription,
sAmenityName = am1.sAmenityName == null || am1.sAmenityName == "" ? (a.cPercentageValue == "1" ? a.dValue.ToString() + " %" : "Value: " + a.dValue.ToString()) : am1.sAmenityName,
a.dtBookingFrom,
a.dtBookingTo,
a.dtStayFrom,
a.dtStayTo,
a.dtActionDate,
cStatus = a.cStatus == "A" ? "Live" : "Disable",
ActionBy = T.sFirstName + " " + T.sLastName,
HotelCount = PPM1.Count()
}).Distinct().Where(u => u.sPromoCode.Contains(param.sSearch) || u.sPromoTitle.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblPromo.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblPromo = param.sortDirection == "asc" ? objTblPromo.OrderBy(u => u.sPromoCode) : objTblPromo.OrderByDescending(u => u.sPromoCode);
break;
case 3:
objTblPromo = param.sortDirection == "asc" ? objTblPromo.OrderBy(u => u.dtBookingFrom) : objTblPromo.OrderByDescending(u => u.dtBookingFrom);
break;
case 4:
objTblPromo = param.sortDirection == "asc" ? objTblPromo.OrderBy(u => u.dtBookingTo) : objTblPromo.OrderByDescending(u => u.dtBookingTo);
break;
case 5:
objTblPromo = param.sortDirection == "asc" ? objTblPromo.OrderBy(u => u.dtStayFrom) : objTblPromo.OrderByDescending(u => u.dtStayFrom);
break;
case 6:
objTblPromo = param.sortDirection == "asc" ? objTblPromo.OrderBy(u => u.dtStayTo) : objTblPromo.OrderByDescending(u => u.dtStayTo);
break;
case 7:
objTblPromo = param.sortDirection == "asc" ? objTblPromo.OrderBy(u => u.cStatus) : objTblPromo.OrderByDescending(u => u.cStatus);
break;
case 8:
objTblPromo = param.sortDirection == "asc" ? objTblPromo.OrderBy(u => u.ActionBy) : objTblPromo.OrderByDescending(u => u.ActionBy);
break;
case 9:
objTblPromo = param.sortDirection == "asc" ? objTblPromo.OrderBy(u => u.dtActionDate) : objTblPromo.OrderByDescending(u => u.dtActionDate);
break;
}
////implemented paging
var lstUser = objTblPromo.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in lstUser)
{
Promolst.Add((ePromoCodeDisp)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new ePromoCodeDisp()));
}
return(Promolst);
}
}
// Added for Addional commission detail to show in grid.
//Get list of records
public static List <etblAdditionalCommission> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, int propid, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <etblAdditionalCommission> commissionList = new List <etblAdditionalCommission>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var objTblUser = (from t1 in db.tblAdditionalCommisions
join t2 in db.tblPropertyMs on t1.iPropId equals t2.iPropId
join u in db.tblUserMs on t1.iActionBy equals u.iUserId
where t1.iPropId == propid
select new
{
t1.iPropId,
t1.iAdditionalCommisionId,
t1.dtCommisionStartDate,
t1.dtCommisionEndDate,
t1.bActive,
t1.dCommission,
t1.dtActionDate,
t2.sHotelName,
iActionByName = u.sFirstName + " " + u.sLastName,
}).AsQueryable();
//get Total Count for show total records
TotalCount = objTblUser.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.dtCommisionStartDate) : objTblUser.OrderByDescending(u => u.dtCommisionStartDate);
break;
case 1:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.dtCommisionEndDate) : objTblUser.OrderByDescending(u => u.dtCommisionEndDate);
break;
case 2:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.dCommission) : objTblUser.OrderByDescending(u => u.dCommission);
break;
case 3:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.bActive) : objTblUser.OrderByDescending(u => u.bActive);
break;
case 4:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.dtActionDate) : objTblUser.OrderByDescending(u => u.dtActionDate);
break;
default:
break;
}
////implemented paging
var data = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in data)
{
commissionList.Add(new etblAdditionalCommission()
{
dtCommisionEndDate = item.dtCommisionEndDate.Value.ToString("dd/MM/yyy"),
dtCommisionStartDate = item.dtCommisionStartDate.Value.ToString("dd/MM/yyy"),
iPropId = item.iPropId,
iAdditionalCommisionId = item.iAdditionalCommisionId,
iActionByName = item.iActionByName,
bActive = item.bActive,
dtActionDate = item.dtActionDate,
dCommission = item.dCommission,
});
}
return(commissionList);
}
}
public static List <ePendingChanges> GetPendingNegotiations(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount, int iPropId)
{
List <ePendingChanges> objMapping = new List <ePendingChanges>();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var Negotiations = (from B in db.tblBookingTxes.Where(a => a.cBookingType == "N" && a.BookingStatus == "NC" && a.iPropId == iPropId)
join BD in db.tblBookingDetailsTxes on B.iBookingId equals BD.iBookingId into AllBooking
from Bookings in AllBooking
join P in db.tblPropertyMs on B.iPropId equals P.iPropId
join C in db.tblCurrencyMs on P.iCurrencyId equals C.iCurrencyId into CC
from Curr in CC.DefaultIfEmpty()
join E in db.tblExchangeRatesMs on new { a = B.sCurrencyCode, b = Curr.sCurrencyCode } equals new { a = E.sCurrencyCodeFrom, b = E.sCurrencyCodeTo } into RATES
from R in RATES.DefaultIfEmpty()
select new
{
ID = B.iBookingId,
StayFrom = B.dtCheckIn,
StayTo = B.dtChekOut,
NegotiateRate = B.dTotalNegotiateAmount,
ActualAmount = B.dTotalAmount + B.dTotalExtraBedAmount,
BidRate = B.dBidAmount,
Timer1 = B.dtReservationDate,
CurrentTime = DateTime.Now,
ActionDate = B.dtReservationDate,
RatePlanRoomType = (Bookings.iPromoType == 1) ? Bookings.sRoomName + " - Promo(Basic)" :
(Bookings.iPromoType == 2) ? Bookings.sRoomName + " - Promo(Minimum Stay)" :
(Bookings.iPromoType == 3) ? Bookings.sRoomName + " - Promo(Early Booker)" :
(Bookings.iPromoType == 4) ? Bookings.sRoomName + " - Promo(Last Minute)" :
(Bookings.iPromoType == 5) ? Bookings.sRoomName + " - Promo(24 Hrs Promotions)" :
(Bookings.iPromoType == 6) ? Bookings.sRoomName + " - Promo(OFR Freebies)" :
Bookings.sRoomName + " - " + Bookings.sRPName,
Attempts = B.iNegotiateAttempts,
NoOfRooms = AllBooking.Count(),
Symbol = Curr.sCurrencyCode == null ? "INR" : Curr.sCurrencyCode,
Code = Curr.sSymbol
}
).Distinct().AsQueryable();
var lstUser = Negotiations.OrderBy(a => a.ActionDate).ToList();
TotalCount = Negotiations.Count();
objMapping.AddRange(lstUser.Select(item => (ePendingChanges)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new ePendingChanges())));
int counter = 0;
for (int i = 0; i < TotalCount; i++)
{
if (i == 0)
{
objMapping[i].Timer = (objMapping[i].CurrentTime - objMapping[i].Timer1).ToString(@"hh\:mm");
continue;
}
else
{
if (objMapping[counter].ID == objMapping[i].ID)
{
objMapping[counter].RatePlanRoomType = objMapping[counter].RatePlanRoomType + ",<br/>" + objMapping[i].RatePlanRoomType;
objMapping.RemoveAt(i);
i--;
TotalCount--;
continue;
}
else
{
counter = i;
objMapping[i].Timer = (objMapping[i].CurrentTime - objMapping[i].Timer1).ToString(@"hh\:mm");
continue;
}
}
}
// ALSO ADD COUNT OF NEGOTIATIONS
}
return(objMapping);
}
{ //Get list of records
public static List <eConserveCommissionDisp> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eConserveCommissionDisp> CClst = new List <eConserveCommissionDisp>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var objTblCC = (from a in db.tblConserveCommissionMs
join c in db.tblUserMs on a.iActionBy equals c.iUserId into PC
from T in PC.DefaultIfEmpty()
join PPM in db.tblPropConserveCommissionMaps on a.iCCId equals PPM.iCCId into PPM1
from PPM2 in PPM1.DefaultIfEmpty()
select new
{
a.iCCId,
a.dCommission,
a.dtFrom,
a.dtTo,
bDisplayRateComm = (bool)a.bDisplayRateComm ? "Yes" : "No",
bBidComm = (bool)a.bBidComm ? "Yes" : "No",
bCOComm = (bool)a.bCOComm ? "Yes" : "No",
dCounterTrigger = (bool)a.bCOComm ? a.dCounterTrigger : 0,
a.dtActionDate,
cStatus = a.cStatus == "A" ? "Live" : "Disable",
ActionBy = T.sFirstName + " " + T.sLastName,
HotelCount = PPM1.Count()
}).Distinct().AsQueryable();
//get Total Count for show total records
TotalCount = objTblCC.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblCC = param.sortDirection == "asc" ? objTblCC.OrderBy(u => u.iCCId) : objTblCC.OrderByDescending(u => u.iCCId);
break;
case 6:
objTblCC = param.sortDirection == "asc" ? objTblCC.OrderBy(u => u.dtFrom) : objTblCC.OrderByDescending(u => u.dtFrom);
break;
case 7:
objTblCC = param.sortDirection == "asc" ? objTblCC.OrderBy(u => u.dtTo) : objTblCC.OrderByDescending(u => u.dtTo);
break;
case 8:
objTblCC = param.sortDirection == "asc" ? objTblCC.OrderBy(u => u.cStatus) : objTblCC.OrderByDescending(u => u.cStatus);
break;
}
////implemented paging
var lstUser = objTblCC.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in lstUser)
{
CClst.Add((eConserveCommissionDisp)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eConserveCommissionDisp()));
}
return(CClst);
}
}
//Get list of records
public static List <eMacroAreaMList> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eMacroAreaMList> macroarea = new List <eMacroAreaMList>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//for searching
// var objTblMacroArea1 = db.Database.SqlQuery<eMacroAreaMList>("uspGetMacroAreas");
var objTblMacroArea = (from m in db.tblMacroAreaMs
join c in db.tblCountryMs on m.iCountryId equals c.iCountryId
join s in db.tblStateMs on m.iStateId equals s.iStateId
join ct in db.tblCityMs on m.iCityId equals ct.iCityId
join u in db.tblUserMs on m.iActionBy equals u.iUserId into lt
from T in lt.DefaultIfEmpty()
join p in db.tblPropertyMs on m.iAreaId equals p.iAreaId into MP
from Pr in MP.DefaultIfEmpty()
select new
{
m.iAreaId,
m.iCountryId,
c.sCountry,
m.iStateId,
s.sState,
m.iCityId,
ct.sCity,
m.sArea,
cStatus = m.cStatus == "A" ? "Live" : "Disabled",
m.dtActionDate,
iActionBy = T.sFirstName + " " + T.sLastName,
ipropId = MP.Count()
}
).Distinct().Where(u => u.sCountry.Contains(param.sSearch) || u.sState.Contains(param.sSearch) ||
u.sCity.Contains(param.sSearch) || u.sArea.Contains(param.sSearch)).AsQueryable();
//var objTblMacroArea = objTblMacroArea1.Where(u => u.sCountry.Contains(param.sSearch) || u.sState.Contains(param.sSearch)
// || u.sCity.Contains(param.sSearch) || u.sArea.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblMacroArea.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sCountry) : objTblMacroArea.OrderByDescending(u => u.sCountry);
break;
case 1:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sState) : objTblMacroArea.OrderByDescending(u => u.sState);
break;
case 2:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sCity) : objTblMacroArea.OrderByDescending(u => u.sCity);
break;
case 3:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sArea) : objTblMacroArea.OrderByDescending(u => u.sArea);
break;
case 4:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.cStatus) : objTblMacroArea.OrderByDescending(u => u.cStatus);
break;
}
////implemented paging
var data = objTblMacroArea.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//macroarea.AddRange(data.Select(item => (eMacroAreaMList)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eMacroAreaMList())));
//convert bll entity object to db entity object
foreach (var item in data)
{
//item.cStatus = item.cStatus == "A" ? "Live" : "Disabled";
macroarea.Add((eMacroAreaMList)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eMacroAreaMList()));
}
return(macroarea);
}
}
//Get list of records
public static List <etblPropertyCancellationPolicyMap> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, int propid, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
IQueryable <etblPropertyCancellationPolicyMap> objTblUser;
List <etblPropertyCancellationPolicyMap> user = new List <etblPropertyCancellationPolicyMap>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//if (datefrom.ToString() == "01-01-0001 00:00:00" || dateto.ToString() == "01-01-0001 00:00:00")
//{
objTblUser = (from t1 in db.tblPropertyCancellationPolicyMaps
join t2 in db.tblUserMs on t1.iActionBy equals t2.iUserId
where t1.iPropId == propid
select new etblPropertyCancellationPolicyMap
{
sPolicyName = t1.sPolicyName,
iPropId = t1.iPropId,
iCancellationPolicyId = t1.iCancellationPolicyId,
dtValidFrom = t1.dtValidFrom,
dtValidTo = t1.dtValidTo,
bIsNonRefundable = t1.bIsNonRefundable,
cStatus = t1.cStatus == "A" ? "Live" : "Disable",
dtActionDate = t1.dtActionDate,
ActionBy = t2.sFirstName + " " + t2.sLastName
}).Where(u => u.sPolicyName.Contains(param.sSearch)).AsQueryable();
//}
//else
//{
// objTblUser = (from t1 in db.tblPropertyCancellationPolicyMaps
// join t2 in db.tblUserMs on t1.iActionBy equals t2.iUserId
// select new etblPropertyCancellationPolicyMap
// {
// sPolicyName = t1.sPolicyName,
// iPropId = t1.iPropId,
// iCancellationPolicyId = t1.iCancellationPolicyId,
// dtValidFrom = t1.dtValidFrom,
// dtValidTo = t1.dtValidTo,
// bIsNonRefundable = t1.bIsNonRefundable,
// cStatus = t1.cStatus == "A" ? "Live" : "Disable",
// dtActionDate = t1.dtActionDate,
// ActionBy = t2.sFirstName + " " + t2.sLastName
// }).Where(u => u.sPolicyName.Contains(param.sSearch) && (u.dtValidFrom >= datefrom && u.dtValidTo <= dateto)).AsQueryable();
//}
//for searching
// var objTblUser = db.tblPropertyMs.Where(u => u.sHotelName.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblUser.Count();
//for sorting
switch (param.iSortingCols)
{
case 0:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.iCancellationPolicyId) : objTblUser.OrderByDescending(u => u.iCancellationPolicyId);
break;
case 1:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sPolicyName) : objTblUser.OrderByDescending(u => u.sPolicyName);
break;
}
////implemented paging
var lstUser = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in lstUser)
{
user.Add((etblPropertyCancellationPolicyMap)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new etblPropertyCancellationPolicyMap()));
}
return(user);
}
}
//Get list of records
public static List <etblPropertyRoomMap> getRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, int propid, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <etblPropertyRoomMap> user = new List <etblPropertyRoomMap>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
//for searching
//var objTblUser = db.tblPropertyRoomMaps.Where(u => u.sRoomName.Contains(param.sSearch)).AsQueryable();
var objTblUser = (from t1 in db.tblPropertyRoomMaps
join t2 in db.tblRoomTypeMs on t1.iRoomTypeId equals t2.iRoomTypeId
where t1.iPropId == propid
select new
{
t1.iRoomId,
t1.iPropId,
t1.sRoomName,
t1.sRoomCode,
t1.iMaxOccupancy,
t1.iMaxChildren,
t1.bActive,
t1.dSizeMtr,
t1.dSizeSqft,
t2.sRoomType
}).Where(u => u.sRoomName.Contains(param.sSearch) || u.sRoomType.Contains(param.sSearch)).AsQueryable();
//get Total Count for show total records
TotalCount = objTblUser.Count();
//for sorting
switch (param.iSortingCols)
{
//case 0:
// objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.iPropId) : objTblUser.OrderByDescending(u => u.iPropId);
// break;
case 0:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sRoomName) : objTblUser.OrderByDescending(u => u.sRoomName);
break;
case 1:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.sRoomType) : objTblUser.OrderByDescending(u => u.sRoomType);
break;
case 3:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.iMaxOccupancy) : objTblUser.OrderByDescending(u => u.iMaxOccupancy);
break;
case 4:
objTblUser = param.sortDirection == "asc" ? objTblUser.OrderBy(u => u.iMaxChildren) : objTblUser.OrderByDescending(u => u.iMaxChildren);
break;
}
////implemented paging
var data = objTblUser.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in data)
{
user.Add((etblPropertyRoomMap)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new etblPropertyRoomMap()));
}
return(user);
}
}
//Get list of records
public static List <eLoyalityPointsCustomerData> getRecordForSearchCustomerData(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eLoyalityPointsCustomerData> Customerlst = new List <eLoyalityPointsCustomerData>();
List <eLoyalityPointsCustomerData> objResult = new List <eLoyalityPointsCustomerData>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
objResult = db.Database.SqlQuery <eLoyalityPointsCustomerData>("uspGetAllLoyalityPointsCustomerData").ToList();
var result = objResult.Where(a => a.DisplayName.ToLower().Contains(param.sSearch.ToLower()) ||
a.Email.ToLower().Contains(param.sSearch.ToLower()) ||
a.PhoneNumber.ToLower().Contains(param.sSearch.ToLower()));
//get Total Count for show total records
TotalCount = result.Count();
//for sorting
switch (param.iSortingCols)
{
case 2:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.dtCreatedOn) : result.OrderByDescending(u => u.dtCreatedOn);
break;
case 6:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.iTotalPoints) : result.OrderByDescending(u => u.iTotalPoints);
break;
case 7:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.iRemPoints) : result.OrderByDescending(u => u.iRemPoints);
break;
case 8:
result = param.sortDirection == "asc" ? result.OrderBy(u => u.dtExpiry) : result.OrderByDescending(u => u.dtExpiry);
break;
}
////implemented paging
var lstUser = result.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
//convert bll entity object to db entity object
foreach (var item in lstUser)
{
Customerlst.Add((eLoyalityPointsCustomerData)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eLoyalityPointsCustomerData()));
}
return(Customerlst);
}
}
