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