public IActionResult GetOrganizationDatatable(JQueryDataTableParamModel param)
{
if (GetUserId() != 0)
{
return(null);
}
List <OrganizationListModel> list = operations.Organization.GetOrganizationList(param.iDisplayStart, param.iDisplayLength, 0);
List <string[]> listReturn = new List <string[]>();
foreach (var item in list)
{
listReturn.Add(new[] { item.Name, item.PersonFullName, item.ContactEmail, item.AddressBindings, item.ActiveStatus.ToString(), WebUtilities.EncryptId(item.Id, GetUserName(), GetOrganizationId()) });
}
int count = 0;
if (list != null && list.Count > 0)
{
count = list.FirstOrDefault().Count;
}
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = count,
iTotalDisplayRecords = count,
aaData = listReturn
}));
}
public JsonResult AdvList(JQueryDataTableParamModel param, DateTimeRange periodtime, string positionnumber = "")
{
var query = Query.Null;
query = periodtime.GetDateTimeQuery();
if (!string.IsNullOrEmpty(positionnumber))
{
query = Query.And(query, Query.EQ("PositionNumber", positionnumber));
}
var all = MongoHelper.Instance.Find <Advertisement>(query);
var result = all.Skip(param.iDisplayStart).Take(param.iDisplayLength);
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = all.Count(),
iTotalDisplayRecords = all.Count(),
aaData = result.Select(s => new
{
CheckBox = string.Format("<label><input name=\"sId\" value=\"{0}\" type=\"checkbox\" /><span class=\"lbl\"></span></label>", s.Id),
Available = s.IsAvailable ? "有效" : "无效",
s.AdvertiseNumber,
PositionNumber = string.Format("{0}({1})", s.Position.Name, s.Position.PositionNumber),
DataRange = string.Format("{0} 至 {1}", s.StartTime.HasValue ? s.StartTime.Value.ToString("yyyy/M/d HH:mm") : "当前", s.EndTime.HasValue ? s.EndTime.Value.ToString("yyyy/M/d HH:mm") : "一直"),
CreationDate = s.CreationDate.ToString("yyyy/MM/dd HH:mm:ss"),
Operate = string.Format("<a href='javascript:op.edit({0});'>更新</a>", s.Id)
})
}, JsonRequestBehavior.AllowGet));
}
public JsonResult AdvPositionList(JQueryDataTableParamModel param, DateTimeRange periodtime, string keyword = "")
{
var query = Query.Null;
query = periodtime.GetDateTimeQuery();
if (!string.IsNullOrEmpty(keyword))
{
query = Query.And(query, Query.Matches("Name", keyword));
}
var all = MongoHelper.Instance.Find <AdvertisePosition>(query);
var result = all.Skip(param.iDisplayStart).Take(param.iDisplayLength);
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = all.Count(),
iTotalDisplayRecords = all.Count(),
aaData = result.Select(s => new
{
CheckBox = string.Format("<label><input name=\"sId\" value=\"{0}\" type=\"checkbox\" /><span class=\"lbl\"></span></label>", s.Id),
s.PositionNumber,
s.Name,
Detail = string.Format("宽:{0}px 高:{1}px", s.Width, s.Height),
s.Price,
s.Description,
CreationDate = s.CreationDate.ToString("yyyy/MM/dd HH:mm:ss"),
Operate = string.Format("<a href='javascript:op.edit({0});'>更新</a>", s.Id)
})
}, JsonRequestBehavior.AllowGet));
}
public JsonResult NotificationList(JQueryDataTableParamModel param, DateTimeRange periodtime, string keyword = "")
{
var condition = Query.Null;
condition = periodtime.GetDateTimeQuery();
if (!string.IsNullOrEmpty(keyword))
{
condition = Query.And(condition, Query.Or(Query.Matches("Title", keyword), Query.Matches("Contents", keyword)));
}
var all = MongoHelper.Instance.Find <UserNotification>(condition).SetSortOrder(SortBy.Descending("CreationDate"));
var result = all.Skip(param.iDisplayStart).Take(param.iDisplayLength);
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = all.Count(),
iTotalDisplayRecords = all.Count(),
aaData = result.Select(s => new
{
CheckBox = string.Format("<label><input name=\"sId\" value=\"{0}\" type=\"checkbox\" /><span class=\"lbl\"></span></label>", s.Id),
Receiver = s.UserName,
MessageType = s.MessageType.ToString(),
Contents = string.Format("{0}<br/>{1}", s.Title, s.Contents),
CreationDate = s.CreationDate.ToString(),
Status = s.IsRead ? string.Format("已读({0})", s.ReadDate.Value.ToString()) : "未读"
})
}, JsonRequestBehavior.AllowGet));
}
public JsonResult UserIntegral(string u, JQueryDataTableParamModel param, DateTimeRange periodtime)
{
var condition = Query.Null;
var userId = WebSecurity.GetUserId(u).ToString();
condition = periodtime.GetDateTimeQuery();
condition = Query.And(condition, Query.EQ("UserId", userId));
var all = MongoHelper.Instance.Find <Integral>(condition).OrderByDescending(s => s.CreationDate);
var result = all.Skip(param.iDisplayStart).Take(param.iDisplayLength);
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = all.Count(),
iTotalDisplayRecords = all.Count(),
aaData = result.Select(s => new
{
CheckBox = string.Format("<label><input name=\"sId\" value=\"{0}\" type=\"checkbox\" /><span class=\"lbl\"></span></label>", s.Id),
Title = string.Format("{0}{1}", s.IntegralType.ToString(), s.IntegralType == IntegralType.效访问 ? "(yqurl.com/" + s.ShortUrl + ")" : ""),
CreationDate = s.CreationDate.ToString("yyyy/MM/dd HH:mm:ss")
})
}, JsonRequestBehavior.AllowGet));
}
public ActionResult Search(string[] lanhDao, int tuanLe, string search)
{
KeHoachCT keHoachCT = new KeHoachCT();
PhongBanBussinessService phongBanBussinessService = new PhongBanBussinessService();
keHoachCT.ListPhongBan = phongBanBussinessService.GetNguoiDungLanhDao();
ViewBag.TuanLe = this.GetListWeek();
ViewBag.KeHoachCT = keHoachCT.ListPhongBan;
KeHoachCTBussinessService ketHoachCTBussinessService = new KeHoachCTBussinessService();
JQueryDataTableParamModel param = new JQueryDataTableParamModel();
param.CanBo = "'" + CurrentUser.Name + "'";
if (lanhDao == null || string.IsNullOrEmpty(lanhDao[0]))
{
param.CanBo = StringExtensions.GetListPhongBanOrLanhDao(keHoachCT.ListPhongBan);
}
else
{
param.CanBo = StringExtensions.GetStringListUser(lanhDao);
}
param.StartDate = DateTimeExtensions.FirstDateOfWeek(DateTime.Now.Year, tuanLe, System.Globalization.CultureInfo.CurrentCulture);
param.EndDate = param.StartDate.AddDays(6);
param.sSearch = search;
//Print day of week
GetDayOfWeek(param.StartDate);
List <KeHoachCongTacModel> listKeHoachCongTacModel = ketHoachCTBussinessService.GetKeHoachCongTac(param);
return(View(listKeHoachCongTacModel));
}
public static IList <BO_SubscriptoinPayment> LoadSubscriptionPaymentVoucher(JQueryDataTableParamModel Param)
{
List <BO_SubscriptoinPayment> lst_SubscriptionPaymentVoucherTable = new List <BO_SubscriptoinPayment>();
using (AprosysAccountingEntities db_aa = new AprosysAccountingEntities())
{
BO_SubscriptoinPayment obj;
var lst = db_aa.GetSubscriptionVoucherList("", Param.Start_Date, Param.End_Date);
foreach (var item in lst.ToList())
{
obj = new BO_SubscriptoinPayment();
obj.invoiceNo = item.InvoiceNo;
obj.activityDate = item.ActivityTimestamp;
obj.customerName = item.Customer;
obj.paidAmount = item.Amount;
// obj.sort = item.sort??0;
obj.totalDues = item.Amount;//Farooq
lst_SubscriptionPaymentVoucherTable.Add(obj);
}
}
if (Param.SearchType != 0)
{
}
// List<BO_ReceiptVoucherTable> ListtoReturn = new List<BO_ReceiptVoucherTable>();
// ListtoReturn = lst_receiptVoucherTable;
return(lst_SubscriptionPaymentVoucherTable);
}
public static IList <BO_Equity> LoadEquityInfo(JQueryDataTableParamModel Param)
{
List <BO_Equity> obj = null;
using (AprosysAccountingEntities db_aa = new AprosysAccountingEntities())
{
obj = (from gl in db_aa.Acc_GL
join coa in db_aa.Acc_COA on gl.CoaId equals coa.CoaId
where gl.TranTypeId == 11 && gl.IsActive == true && coa.PId == 3
select new BO_Equity
{
invoiceNo = gl.InvoiceNo,
investorName = coa.TreeName,
amount = ((gl.Credit != null && gl.Credit > 0) ? (gl.Credit ?? 0) : (gl.Debit ?? 0)),
activity = (gl.Credit != null && gl.Credit > 0) ? "Deposit" : "WithDraw",
activityTime = gl.ActivityTimestamp.Value,
}).ToList();
if (obj != null && obj.Count > 0)
{
for (int i = 0; i < obj.Count; i++)
{
string _invoiceno = obj[i].invoiceNo;
int _coaId = obj[i].investorId;
string _accountNo = (from gl in db_aa.Acc_GL
join coa in db_aa.Acc_COA on gl.CoaId equals coa.CoaId
where gl.TranTypeId == 11 && gl.IsActive == true && gl.InvoiceNo == _invoiceno && gl.CoaId != _coaId
select coa.TreeName).FirstOrDefault();
obj[i].accountNo = _accountNo;
}
}
}
return(obj.OrderByDescending(x => (Convert.ToInt32(x.invoiceNo.Remove(0, 3)))).ToList());
}
public IActionResult GetUsersDatatable(JQueryDataTableParamModel param, string organizationId)
{
organizationId = WebUtility.HtmlDecode(organizationId);
if (GetUserId() != 0)
{
return(null);
}
List <UserListModel> list = operations.User.GetUserList(param.iDisplayStart, param.iDisplayLength, WebUtilities.DecryptId(organizationId, GetUserName(), GetOrganizationId()));
List <string[]> listReturn = new List <string[]>();
foreach (var item in list)
{
listReturn.Add(new[] { item.UserName, item.FullName, item.Email, item.ActiveStatus.ToString(), WebUtilities.EncryptId(item.Id, GetUserName(), GetOrganizationId()) });
}
int count = 0;
if (list != null && list.Count > 0)
{
count = list.FirstOrDefault().Count;
}
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = count,
iTotalDisplayRecords = count,
aaData = listReturn
}));
}
public ActionResult IndexList(JQueryDataTableParamModel request, int?id)
{
var service = this.Service <IParticipationService>();
var totalRecord = 0;
var count = 1;
var results = service.GetPaticipation(request, out totalRecord)
.AsEnumerable()
.Where(x => x.EventId == id || id == null).Select(a => new IConvertible[] {
count++,
a.Event.Name,
a.AspNetUser.FullName,
a.Type,
a.TeamName,
a.Id,
a.AspNetUser.Id,
a.Event.Id
}).ToArray();
var model = new
{
draw = request.sEcho,
data = results,
recordsFiltered = totalRecord,
recordsTotal = totalRecord
};
return(Json(model));
}
public JsonResult GetCVVLDG(JQueryDataTableParamModel jModel, string SerchBy)
{
try
{
var result = UserRepository.GetCVVLDG(Convert.ToInt32(UserSession.ClientID), SerchBy, jModel.iDisplayStart, jModel.iDisplayLength);
int?totalRecord = result.Count > 0 ? result[0].TotalRecords : 0;
var CVVLDG = result.Select(row => new string[]
{
Convert.ToString(row.FirstName), //0
Convert.ToString(row.LastName), //1
Convert.ToString(row.Address), //2
Convert.ToString(row.Price), //3
Convert.ToString(row.City), //4
Convert.ToString(row.STATE), //5
Convert.ToString(row.Zip), //6
Convert.ToString(row.DOB), //7
Convert.ToString(row.Phone), //8
Convert.ToString(row.Gender), //9
Convert.ToString(row.SSN), //10
Convert.ToString(row.DateADDED), //11
});
return(Json(new
{
iTotalRecords = totalRecord,
iTotalDisplayRecords = totalRecord,
aaData = CVVLDG
}, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public ActionResult AjaxDataProvider(JQueryDataTableParamModel param)
{
var allPrices = commodity.Prices;
IEnumerable <aih.oems.wapi.models.Price> filteredPrices;
if (!string.IsNullOrEmpty(param.sSearch))
{
//Used if particulare columns are filtered
var nameFilter = Convert.ToString(Request["sSearch_1"]);
var amountFilter = Convert.ToString(Request["sSearch_2"]);
var dateFilter = Convert.ToString(Request["sSearch_3"]);
//Optionally check whether the columns are searchable at all
var isNameSearchable = Convert.ToBoolean(Request["bSearchable_1"]);
var isAmountSearchable = Convert.ToBoolean(Request["bSearchable_2"]);
var isDateSearchable = Convert.ToBoolean(Request["bSearchable_3"]);
CultureInfo provider = new CultureInfo("en-us");
filteredPrices = commodity.Prices.Where(c => isNameSearchable && c.Vendor.Name.ToLower().Contains(param.sSearch.ToLower())
||
isAmountSearchable && c.Amount.ToString().Contains(param.sSearch.ToLower())
||
isDateSearchable && c.StartDate.ToString("dd/MM/yyyy").ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filteredPrices = allPrices;
}
var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]);
var isAmountSortable = Convert.ToBoolean(Request["bSortable_2"]);
var isDateSortable = Convert.ToBoolean(Request["bSortable_3"]);
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <aih.oems.wapi.models.Price, string> orderingFunction = (c => sortColumnIndex == 1 && isNameSortable ? c.Vendor.Name :
sortColumnIndex == 2 && isAmountSortable ? c.Amount.ToString() :
sortColumnIndex == 3 && isDateSortable ? c.StartDate.ToString("dd/MM/yyyy") :
"");
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredPrices = filteredPrices.OrderBy(orderingFunction);
}
else
{
filteredPrices = filteredPrices.OrderByDescending(orderingFunction);
}
var displayedCompanies = filteredPrices.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedCompanies select new[] { c.Id, c.Vendor.Name, c.Amount.ToString(), c.StartDate.ToString("dd/MM/yyyy") };
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = allPrices.Count(),
iTotalDisplayRecords = filteredPrices.Count(),
aaData = result
}, JsonRequestBehavior.AllowGet));
}
public JsonResult UserTypeTableAjax(JQueryDataTableParamModel param)
{
#region byDefaultReturnData
int rowCount = 0;
int lnRowCount = 0;
var result = from q in new List <UserType>()
select new
{
q.Id,
q.Name
};
#endregion
var oUserType = new UserType();
if (!string.IsNullOrEmpty(Request.QueryString["Name"]))
{
oUserType.Name = Request.QueryString["Name"];
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
//oUserType.SortCol = dtProcess.SortCol;
//oUserType.SortType = dtProcess.SortType;
//oUserType.Page = dtProcess.Page;
//oUserType.RowPerPage = dtProcess.RowPerPage;
//var oResultModel = DAL.Account.UserType.GetUserType(oUserType);
var filters = new Filters <UserType>();
//filters.Add(Convert.ToBoolean(oUserType.Name), x => x.Name == oUserType.Name);
filters.Add(true, x => x.IsDeleted == false);
var sorts = new Sorts <UserType>();
sorts.Add(dtProcess.SortCol == "Id", x => x.Name);
var getUsers = _db.UserTypes.Paginate(dtProcess.Page, dtProcess.RowPerPage, sorts, filters);
if (getUsers.RecordCount > 0)
{
var lstUserType = getUsers.Results;
rowCount = getUsers.RecordCount;
lnRowCount = rowCount;
result = from q in lstUserType
select new
{
q.Id,
q.Name
};
}
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public WebsiteMonitoringResult ListWebsiteMonitoringsByClient(JQueryDataTableParamModel param, int clientID)
{
try
{
int totalRecord;
BSL.WebsiteMonitoringService service = new BSL.WebsiteMonitoringService();
var infos = service.ListWebsiteMonitoringsByClient(clientID);
var sr = new WebsiteMonitoringResult
{
IsSuccess = true,
ListWebsiteMonitoringInfos = infos,
TotalRecords = infos.Count
};
return(sr);
}
catch (Exception ex)
{
new RMSWebException(this, "0500", "ListWebsiteMonitoringsByClient failed. " + ex.Message, ex, true);
var sr = new WebsiteMonitoringResult
{
IsSuccess = false,
ErrorMessage = "ListWebsiteMonitoringsByClient failed. " + ex.Message
};
return(sr);
}
}
public JsonResult LoadTable(JQueryDataTableParamModel param)
{
int pageRows = param.iDisplayLength;
int pageNumber = (param.iDisplayStart / param.iDisplayLength);
var searchTerm = param.SearchTerms;
var sortorder = param.sSortDir_0;
var sortname = param.FilteringColums[param.iSortCol_0];
IEnumerable <BoxRegistration> rows;
int tableRows;
try
{
rows = registrationService.GetRegistrationsPaged(HttpContext.User.Identity.Name, searchTerm, null, pageNumber, pageRows, sortorder, sortname, out tableRows);
}
catch (Exception)
{
return(Json(new { sEcho = param.sEcho, iTotalRecords = 0, iTotalDisplayRecords = 0 }, JsonRequestBehavior.AllowGet));
}
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = tableRows,
iTotalDisplayRecords = tableRows,
aaData = rows.Select(x => new string[]
{
x.Id.ToString(),
x.Description,
x.Box.Description,
x.Amount.ToString("C2")
}).ToList()
},
JsonRequestBehavior.AllowGet));
}
public MonitoringProfileResult Search(JQueryDataTableParamModel param, string name, bool?activeList)
{
try
{
int totalRecord;
BSL.MonitoringProfileService service = new BSL.MonitoringProfileService();
List <MonitoringProfileInfo> monitoringProfileInfos = service.Search(param, name, activeList, out totalRecord);
var sr = new MonitoringProfileResult
{
IsSuccess = true,
ListMonitoringProfileInfo = monitoringProfileInfos,
TotalRecords = totalRecord
};
return(sr);
}
catch (Exception ex)
{
new RMSWebException(this, "0500", "Search failed. " + ex.Message, ex, true);
var sr = new MonitoringProfileResult
{
IsSuccess = false,
ErrorMessage = "Search errors. " + ex.Message
};
return(sr);
}
}
public static List <BO_BonusRevenue> GetBonusRevenue(JQueryDataTableParamModel Param)
{
using (AprosysAccountingEntities db_aa = new AprosysAccountingEntities())
{
Param.End_Date = Param.End_Date.AddDays(1);
List <BO_BonusRevenue> lst_bonus = new List <BO_BonusRevenue>();
//var temp = new BO_BonusRevenue();
var lst_bonusList = (from glRevenue in db_aa.Acc_GL
join glAccount in db_aa.Acc_GL on glRevenue.TranId equals glAccount.TranId
join caRevenue in db_aa.Acc_COA on glRevenue.CoaId equals caRevenue.CoaId
join caAccount in db_aa.Acc_COA on glAccount.CoaId equals caAccount.CoaId
where caRevenue.PId == 25 && glRevenue.IsActive == true && glAccount.IsActive == true &&
glRevenue.ActivityTimestamp >= Param.Start_Date && glAccount.ActivityTimestamp <= Param.End_Date
select new BO_BonusRevenue
{
TransactionId = glRevenue.TranId,
BonusAmount = glRevenue.Credit,
Misc = glRevenue.Comments,
activityDate = glRevenue.CreatedDate,
BankAccount = caAccount.TreeName,
RevenueAccount = caRevenue.TreeName,
}).ToList();
//foreach (var item in lst_bonusList)
//{
// if (temp.TransactionId != item.TransactionId)
// {
// lst_bonus.Add(item);
// temp = item;
// }
//}
lst_bonus = lst_bonusList.DistinctBy(x => x.TransactionId).ToList();
return(lst_bonus.OrderByDescending(x => x.activityDate).ToList());
}
}
public ClientInfoResult Search(JQueryDataTableParamModel param, DateTime?asOfDate, int?clientTypeID, string clientCode, bool?clientStatus, string ipAddress, string location)
{
try
{
int totalRecord;
BSL.ClientService cs = new BSL.ClientService();
List <ClientInfo> clientInfos = cs.SearchClient(param, asOfDate, clientTypeID, clientCode, clientStatus, ipAddress, location, out totalRecord);
var sr = new ClientInfoResult
{
IsSuccess = true,
ListClients = clientInfos,
TotalRecords = totalRecord
};
return(sr);
}
catch (Exception ex)
{
new RMSWebException(this, "0500", "Search failed. " + ex.Message, ex, true);
var sr = new ClientInfoResult
{
IsSuccess = false,
ErrorMessage = "Search errors. " + ex.Message
};
return(sr);
}
}
public JsonResult GetAjaxData(JQueryDataTableParamModel param)
{
using (var e = new ExampleEntities())
{
var totalRowsCount = new System.Data.Objects.ObjectParameter("TotalRowsCount", typeof(int));
var filteredRowsCount = new System.Data.Objects.ObjectParameter("FilteredRowsCount", typeof(int));
var data = e.pr_SearchPerson(param.sSearch,
Convert.ToInt32(Request["iSortCol_0"]),
Request["sSortDir_0"],
param.iDisplayStart,
param.iDisplayStart + param.iDisplayLength,
totalRowsCount,
filteredRowsCount);
var aaData = data.Select(d => new string[] { d.FirstName, d.LastName, d.Nationality, d.DateOfBirth.Value.ToString("dd MMM yyyy") }).ToArray();
return(Json(new
{
sEcho = param.sEcho,
aaData = aaData,
iTotalRecords = Convert.ToInt32(totalRowsCount.Value),
iTotalDisplayRecords = Convert.ToInt32(filteredRowsCount.Value)
}, JsonRequestBehavior.AllowGet));
}
}
public IQueryable <AspNetUser> GetPlaceOwner(JQueryDataTableParamModel request, out int totalRecord)
{
var filter = request.sSearch;
var list1 = this.GetActive(u => u.Active == true);
List <AspNetUser> users = new List <AspNetUser>();
foreach (var item in list1)
{
if (item.AspNetRoles.FirstOrDefault().Id.Equals(UserRole.Member.ToString("d")) && item.Status == (int)UserStatus.Pending)
{
users.Add(item);
}
}
var list = users.AsQueryable().Where(
u => filter == null ||
u.UserName.ToLower().Contains(filter.ToLower()) ||
u.FullName.ToLower().Contains(filter.ToLower()) ||
u.Email.ToLower().Contains(filter.ToLower())
);
//list = list.Where(u => u.AspNetRoles.Where(r => r.Id.Equals(UserRole.Member.ToString())).Count()>0);
totalRecord = list.Count();
var result = list.OrderBy(u => u.FullName)
.Skip(request.iDisplayStart)
.Take(request.iDisplayLength);
return(result);
}
public ActionResult MasterDetailsAjaxHandler(JQueryDataTableParamModel param, int?CompanyID)
{
var employees = System.IO.File.ReadAllLines("Models\\Data\\menus.csv")
.Skip(1)
.Select(v => new Menus(v))
.ToList();
//"Business logic" methog that filter menu items by the rest id
var companyEmployees = (from e in employees
//where (CompanyID == null || e.RestID == CompanyID)
where (e.RestID == CompanyID)
select e).ToList();
//UI processing logic that filter company employees by name and paginates them
var filteredEmployees = (from e in companyEmployees
where (param.sSearch == null || e.RestaurantName.ToLower().Contains(param.sSearch.ToLower()))
select e).ToList();
var result = from emp in filteredEmployees.Skip(param.iDisplayStart).Take(param.iDisplayLength)
select new[] { emp.ItemName, emp.Description, emp.VegComment, Convert.ToString(emp.Price),
emp.Category, emp.Comment, emp.SizeComment, emp.PriceComment,
emp.MenuLink, emp.MenuType, Convert.ToString(emp.RestID), emp.UpdateTime };
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = companyEmployees.Count,
iTotalDisplayRecords = filteredEmployees.Count,
aaData = result
}));
}
public MasterTableResult SearchMessageMaster(JQueryDataTableParamModel param, string message)
{
try
{
int totalRecord;
BSL.MasterTableService service = new BSL.MasterTableService();
var infos = service.SearchMessageMaster(param, message, out totalRecord);
var sr = new MasterTableResult
{
IsSuccess = true,
ListMessageMasterInfos = infos,
TotalRecords = totalRecord
};
return(sr);
}
catch (Exception ex)
{
new RMSWebException(this, "0500", "SearchMessageMaster failed. " + ex.Message, ex, true);
var sr = new MasterTableResult
{
IsSuccess = false,
ErrorMessage = "SearchMessageMaster errors. " + ex.Message
};
return(sr);
}
}
public ActionResult IndexList(JQueryDataTableParamModel request)
{
var service = this.Service <IAspNetUserService>();
var totalRecord = 0;
var count = 1;
var results = service.GetPlaceOwner(request, out totalRecord)
.AsEnumerable()
.Select(a => new IConvertible[] {
count++,
a.FullName,
a.PhoneNumber,
a.Email,
a.UserName,
a.Status,
a.Id
}).ToArray();
var model = new
{
draw = request.sEcho,
data = results,
recordsFiltered = totalRecord,
recordsTotal = totalRecord
};
return(Json(model));
}
public JsonResult LoadDanhSachLog(JQueryDataTableParamModel param)
{
var systemLogService = this.Service <ISystemLogService>();
var listSystemLog = systemLogService.GetActive().ToList();
//try
//{
var rs = listSystemLog
.Where(q => string.IsNullOrEmpty(param.sSearch) ||
q.HanhDong.ToLower().Contains(param.sSearch.ToLower()) ||
q.ThucHienBoi.ToLower().Contains(param.sSearch.ToLower()))
.OrderByDescending(q => q.NgayThucHien)
.Skip(param.iDisplayStart)
.Take(param.iDisplayLength)
.Select(q => new IConvertible[]
{
q.TenBang,
q.HanhDong,
q.NgayThucHien.Value.ToString(),
q.ThucHienBoi,
});
var totalRecords = listSystemLog.Count();
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = rs
}, JsonRequestBehavior.AllowGet));
//}
//catch (Exception e)
//{
// return Json(new { success = false, message = Resource.ErrorMessage });
//}
}
public async Task <IActionResult> GetExamList(JQueryDataTableParamModel param)
{
using (var txscope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
try
{
var parameters = CommonMethod.GetJQueryDatatableParamList(param, GetSortingColumnName(param.iSortCol_0));
var allList = await _examService.GetExamList(parameters.Parameters.ToArray());
var total = allList.FirstOrDefault()?.TotalRecords ?? 0;
return(Json(new
{
param.sEcho,
iTotalRecords = total,
iTotalDisplayRecords = total,
aaData = allList
}));
}
catch (Exception ex)
{
ErrorLog.AddErrorLog(ex, "GetExamList");
return(Json(new
{
param.sEcho,
iTotalRecords = 0,
iTotalDisplayRecords = 0,
aaData = ""
}));
}
}
}
public SeverityLevelResult Search(JQueryDataTableParamModel param, string severityLevel, bool? activeList)
{
try
{
int totalRecord;
BSL.SeverityLevelService service = new BSL.SeverityLevelService();
var infos = service.Search(param, severityLevel, activeList, out totalRecord);
var sr = new SeverityLevelResult
{
IsSuccess = true,
ListSeverityLevelInfos = infos,
TotalRecords = totalRecord
};
return sr;
}
catch (Exception ex)
{
new RMSWebException(this, "0500", "Search failed. " + ex.Message, ex, true);
var sr = new SeverityLevelResult
{
IsSuccess = false,
ErrorMessage = "Search errors. " + ex.Message
};
return sr;
}
}
public LocationResult Search(JQueryDataTableParamModel param, string location, bool?activeList)
{
try
{
int totalRecord;
BSL.LocationService ls = new BSL.LocationService();
var listLocationInfos = ls.Search(param, location, activeList, out totalRecord);
var sr = new LocationResult
{
IsSuccess = true,
ListLocationInfos = listLocationInfos,
TotalRecords = totalRecord
};
return(sr);
}
catch (Exception ex)
{
new RMSWebException(this, "0500", "Search failed. " + ex.Message, ex, true);
var sr = new LocationResult
{
IsSuccess = false,
ErrorMessage = "Search errors. " + ex.Message
};
return(sr);
}
}
public JsonResult LoadDanhSachBangCap(JQueryDataTableParamModel param)
{
var bangCapService = this.Service <IBangCapService>();
var listBangCap = bangCapService.GetActive().ToList();
try
{
var rs = listBangCap
.Where(q => string.IsNullOrEmpty(param.sSearch) ||
q.BangCap1.ToLower().Contains(param.sSearch.ToLower()))
.OrderByDescending(q => q.Id)
.Skip(param.iDisplayStart)
.Take(param.iDisplayLength)
.Select(q => new IConvertible[]
{
q.BangCap1,
q.Thang + "/" + q.Nam,
q.TrinhDo,
q.DaNop.GetValueOrDefault()?"Rồi":"Chưa",
q.Id,
});
var totalRecords = listBangCap.Count();
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = rs
}, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { success = false, message = Resource.ErrorMessage }));
}
}
public ActionResult ReportQueueRefresh(JQueryDataTableParamModel param)
{
//WebLog.LogClass.WriteToLog("RefreshTable");
CardPerso.Administration.ServiceClass sc = new CardPerso.Administration.ServiceClass();
var UserId = sc.UserGuid(User.Identity.Name);
DataSet ds = new DataSet();
using (SqlConnection conn =
new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ConnectionString))
{
conn.Open();
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandText = $"SELECT UserId, ReportType, ReportStatus, ReportDate, id, ReportParameters, (select count(*) from ReportQuery where id<r.id and ReportStatus=1) as waitcnt FROM ReportQuery r WHERE UserId = '{UserId}' ORDER BY ReportDate DESC";
SqlDataAdapter da = new SqlDataAdapter(comm);
da.Fill(ds);
}
conn.Close();
}
IList <Report> reports = new List <Report>();
foreach (DataRow r in ds.Tables[0].Rows)
{
reports.Add(new Report()
{
Date = $"{r["ReportDate"]:dd.MM.yyyy HH:mm:ss}", Status = Convert.ToInt32(r["ReportStatus"]),
Type = Convert.ToInt32(r["ReportType"]), Parameters = Convert.ToString(r["ReportParameters"]),
id = Convert.ToInt32(r["id"]), WaitCnt = Convert.ToInt32(r["WaitCnt"])
});
public ActionResult AjaxHandler(JQueryDataTableParamModel param)
{
var all = db.ВидКомплектующих.AsEnumerable();
IEnumerable <ВидКомплектующих> filtered;
//Search
if (!string.IsNullOrEmpty(param.sSearch))
{
filtered = db.ВидКомплектующих.AsEnumerable()
.Where(c => c.Наименование.ToLower().Contains(param.sSearch.ToLower()) ||
c.Описание.ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filtered = all;
}
//Sorting
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
var sortDirection = Request["sSortDir_0"]; // asc or desc
switch (sortColumnIndex)
{
case 0:
{
Func <ВидКомплектующих, int> orderingFunction = (c => c.КодВида);
filtered = SortHelper <ВидКомплектующих, int> .Order(sortDirection, filtered, orderingFunction);
}
break;
case 1:
{
Func <ВидКомплектующих, string> orderingFunction = (c => c.Наименование);
filtered = SortHelper <ВидКомплектующих, string> .Order(sortDirection, filtered, orderingFunction);
}
break;
case 2:
{
Func <ВидКомплектующих, string> orderingFunction = (c => c.Описание);
filtered = SortHelper <ВидКомплектующих, string> .Order(sortDirection, filtered, orderingFunction);
}
break;
}
//Pagination
var displayed = filtered.Skip(param.iDisplayStart).Take(param.iDisplayLength);
//Finish selection from DB
var result = from c in displayed select new[] { Convert.ToString(c.КодВида), c.Наименование, c.Описание };
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = all.Count(),
iTotalDisplayRecords = filtered.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
/// <summary>
/// To populate the Patient Grid on patient builder
/// </summary>
/// <param name="param"></param>
/// <param name="parentFolderIdentifier"></param>
/// <param name="folderType"></param>
/// <param name="filterByAge"></param>
/// <param name="filterBySearch"></param>
/// <param name="selectedPatientList"> </param>
/// <param name="folderUrl"> </param>
/// <returns></returns>
public ActionResult GetPatientList(JQueryDataTableParamModel param, string parentFolderIdentifier, int folderType, string filterByAge, string filterBySearch, string selectedPatientList, string folderUrl)
{
try
{
int sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
string sortColumnOrder = Request["sSortDir_0"];
IList<Patient> patientList = _patientService.GetPatientItems(parentFolderIdentifier, folderType, sortColumnIndex, sortColumnOrder,
GetLoginUserCourse() + "/" + GetLoginUserRole(), folderUrl);
IList<Patient> patientListToRender =
patientList.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
string[] strArray = AppCommon.GetStringArrayAfterSplitting(selectedPatientList);
int patientListCount = patientList.Count;
var data = (from patientItem in patientListToRender
select new[]
{
"<input type='checkbox' id='" + patientItem.UniqueIdentifier + "' onClick='patient.gridOperations.patientItemChanged(this)'" + AppCommon.CheckForFlagAndReturnValue(strArray, patientItem.UniqueIdentifier) + "/>",
!string.IsNullOrEmpty(patientItem.FirstName) ? patientItem.FirstName : "",
!string.IsNullOrEmpty(patientItem.LastName)
? "<a href='#' onclick=\"patient.pageOperations.loadPatientInEditMode('"+patientItem.Url+"')\" class=\"link select-hand\">" + patientItem.LastName +
"</a>"
: "",
!string.IsNullOrEmpty(patientItem.Sex) ? ((patientItem.Sex == "Male")?"M":"F") : "",
!string.IsNullOrEmpty(patientItem.DateOfBirth) ? patientItem.DateOfBirth : "",
//!string.IsNullOrEmpty(patientItem.AgeInYears.ToString()) ? patientItem.AgeInYears.ToString() : "",
patientItem.FormAgeText(),
!string.IsNullOrEmpty(patientItem.CreatedTimeStamp.ToString("MM/dd/yyyy"))
? patientItem.CreatedTimeStamp.ToString("MM/dd/yyyy")
: "",
!string.IsNullOrEmpty(patientItem.Status) ? patientItem.Status : ""
}).ToArray();
var jsonData = Json(new
{
sEcho = param.sEcho,
iTotalRecords = patientListCount,
iTotalDisplayRecords = patientListCount,
aaData = data
},
JsonRequestBehavior.AllowGet);
return jsonData;
}
catch (Exception patientGrid)
{
string result = AjaxCallResult(new AjaxResult(AppEnum.ResultType.Error, patientGrid.ToString(), ""));
return Json(new { Result = result });
}
}
public ActionResult AjaxDataProvider(JQueryDataTableParamModel param)
{
IEnumerable<VF_API_CATALOG_CLIENTS> filteredClients;
if (!string.IsNullOrEmpty(param.sSearch))
{
//Used if particulare columns are filtered
var nameFilter = Convert.ToString(Request["sSearch_1"]);
var status = Convert.ToString(Request["sSearch_2"]);
//Optionally check whether the columns are searchable at all
var isNameSearchable = Convert.ToBoolean(Request["bSearchable_1"]);
var isStatusSearchable = Convert.ToBoolean(Request["bSearchable_2"]);
filteredClients = _catalogClientProvider.GetAll().Where(c => isNameSearchable && c.CLIENT_NAME.ToLower().Contains(param.sSearch.ToLower())
||
isStatusSearchable && c.CLIENT_STATUS == (status == "Active" ? true : false));
}
else
{
filteredClients = _catalogClientProvider.GetAll();
}
var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]);
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func<VF_API_CATALOG_CLIENTS, string> orderingFunction = (c => sortColumnIndex == 1 && isNameSortable ? c.CLIENT_NAME : "");
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
filteredClients = filteredClients.OrderBy(orderingFunction);
else
filteredClients = filteredClients.OrderByDescending(orderingFunction);
var displayedClients = filteredClients.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedClients select new[] { Convert.ToString(c.CLIENT_ID), c.CLIENT_NAME, ((c.CLIENT_STATUS && c.CLIENT_STATUS) ? "Active" : "In-Active") };
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = filteredClients.Count(),
iTotalDisplayRecords = displayedClients.Count(),
aaData = result
}, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// To refresh the grid on search
/// </summary>
/// <param name="param"></param>
/// <param name="strSearchText"></param>
/// <param name="strModule"> </param>
/// <returns></returns>
public ActionResult GetAssignmentSearchList(JQueryDataTableParamModel param, string strSearchText, string strModule)
{
string result;
int sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
string sortColumnOrder = Request["sSortDir_0"];
try
{
IList<AssignmentProxy> lstAssignmentSearchResultTemp = _assignmentService.GetSearchResultsForAssignment(strSearchText, sortColumnIndex, sortColumnOrder, strModule);
IList<AssignmentProxy> lstAssignmentSearchResult = lstAssignmentSearchResultTemp.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
var data = (from assignmentItem in lstAssignmentSearchResult
select new[]
{
(!String.IsNullOrEmpty(assignmentItem.Patients)) ? assignmentItem.Patients :String.Empty,
!string.IsNullOrEmpty(assignmentItem.AssignmentTitle) ? "<a href='#' onclick='assignBuilder.commonFunctions.LoadStep1OrStep5(\""+(!string.IsNullOrEmpty(assignmentItem.Url)?assignmentItem.Url:"")+"\","+(!string.IsNullOrEmpty(assignmentItem.Status)?(assignmentItem.Status.ToLower()=="published"?"true":"false"):"false") +")' class=\"link select-hand\">" + assignmentItem.AssignmentTitle + "</a>" : "",
(!String.IsNullOrEmpty(assignmentItem.ModuleText)) ? assignmentItem.ModuleText :String.Empty,
(!String.IsNullOrEmpty(assignmentItem.LinkedCompetencies)) ? assignmentItem.LinkedCompetencies :String.Empty,
(!String.IsNullOrEmpty(assignmentItem.Duration)) ? assignmentItem.Duration :String.Empty,
(!String.IsNullOrEmpty(assignmentItem.FolderName)) ? assignmentItem.FolderName :String.Empty,
!string.IsNullOrEmpty(assignmentItem.CreatedTimeStamp.ToString("MM/dd/yyyy")) ? assignmentItem.CreatedTimeStamp.ToString("MM/dd/yyyy") : "",
(!String.IsNullOrEmpty(assignmentItem.Status)) ? assignmentItem.Status :String.Empty
}).ToArray();
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = lstAssignmentSearchResultTemp.Count,
iTotalDisplayRecords = lstAssignmentSearchResultTemp.Count,
aaData = data
},
JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
result = AjaxCallResult(new AjaxResult(AppEnum.ResultType.Error, ex.ToString(), ""));
ExceptionManager.Error("Error: ControllerName: AssignmentBuilder, MethodName:GetAssignmentSearchList", ex);
}
return Json(new { Result = result });
}
/// <summary>
/// method to load the Assignments in the datatable
/// </summary>
/// <param name="param"></param>
/// <param name="parentFolderIdentifier"></param>
/// <param name="folderType"></param>
/// <param name="filterByModule"></param>
/// <param name="selectedAssignmentList"></param>
/// <param name="folderUrl"></param>
/// <returns></returns>
public ActionResult GetAssignmentList(JQueryDataTableParamModel param, string parentFolderIdentifier, int folderType, string filterByModule, string selectedAssignmentList, string folderUrl)
{
string[] gridColumnList = { "Title", "Module", "LinkedCompetencies", "Duration", "CreatedTimeStamp", "Status" };
List<Assignment> assignmentList = (List<Assignment>)_assignmentService.GetAssignmentItems(parentFolderIdentifier, folderType,
GetLoginUserCourse() + "/" +
GetLoginUserRole(), folderUrl);
if (filterByModule != "")
{
assignmentList.RemoveAll(assignment => assignment.Module == null);
assignmentList = (from assignment in assignmentList where assignment.Module.Select(x => x.ToLower()).Contains(filterByModule.ToLower()) select assignment).ToList();
}
int sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
string sortColumnOrder = Request["sSortDir_0"];
string sortColumnName = gridColumnList[sortColumnIndex - 1];
switch (gridColumnList[sortColumnIndex - 1])
{
case "Module":
if (sortColumnOrder == "asc")
{
assignmentList = (from assignmentItem in assignmentList
let module = ((assignmentItem.Module) != null && (assignmentItem.Module.Count) > 0) ? assignmentItem.Module.Aggregate((first, next) => first + ", " + next) : ""
orderby module
select assignmentItem).ToList();
}
else
{
assignmentList = (from assignmentItem in assignmentList
let module = ((assignmentItem.Module) != null && (assignmentItem.Module.Count) > 0) ? assignmentItem.Module.Aggregate((first, next) => first + ", " + next) : ""
orderby module descending
select assignmentItem).ToList();
}
break;
case "LinkedCompetencies":
if (sortColumnOrder == "asc")
{
assignmentList = (from assignmentItem in assignmentList
let competency = ((assignmentItem.SkillSets) != null && (assignmentItem.SkillSets.Count) > 0) ? _competencyService.GetCompetencyNameForListofCompetencies(_assignmentService.ConvertSkillsetToCompetencies(assignmentItem.SkillSets)) : ""
orderby competency
select assignmentItem).ToList();
}
else
{
assignmentList = (from assignmentItem in assignmentList
let competency = ((assignmentItem.SkillSets) != null && (assignmentItem.SkillSets.Count) > 0) ? _competencyService.GetCompetencyNameForListofCompetencies(_assignmentService.ConvertSkillsetToCompetencies(assignmentItem.SkillSets)) : ""
orderby competency descending
select assignmentItem).ToList();
}
break;
default:
var sortableList = assignmentList.AsQueryable();
assignmentList = sortableList.OrderBy(sortColumnName, sortColumnOrder).ToList();
break;
}
IList<Assignment> assignmentListToRender = assignmentList.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
int assignmentListCount = assignmentList.Count;
string[] strArray = AppCommon.GetStringArrayAfterSplitting(selectedAssignmentList);
var data = (from assignmentItem in assignmentListToRender
select new[]
{
"<input type='checkbox' id='" + assignmentItem.UniqueIdentifier + "' onClick='assignBuilder.commonFunctions.gridOperations.AssignmentItemChanged(this)'" + AppCommon.CheckForFlagAndReturnValue(strArray, assignmentItem.UniqueIdentifier) + "/>",
!string.IsNullOrEmpty(assignmentItem.Title) ? "<a href='#' onclick='assignBuilder.commonFunctions.LoadStep1OrStep5(\""+(!string.IsNullOrEmpty(assignmentItem.Url)?assignmentItem.Url:"")+"\","+(!string.IsNullOrEmpty(assignmentItem.Status)?(assignmentItem.Status.ToLower()=="published"?"true":"false"):"false") +")' class=\"link select-hand\">" + assignmentItem.Title + "</a>" : "",
((assignmentItem.Module) !=null &&(assignmentItem.Module.Count) > 0) ? assignmentItem.Module.Aggregate((first, next) => first + ", " + next) : "",
((assignmentItem.SkillSets) !=null &&(assignmentItem.SkillSets.Count) > 0) ? _competencyService.GetCompetencyNameForListofCompetencies(_assignmentService.ConvertSkillsetToCompetencies(assignmentItem.SkillSets)) : "",
!string.IsNullOrEmpty(assignmentItem.Duration) ? assignmentItem.Duration : "",
!string.IsNullOrEmpty(assignmentItem.CreatedTimeStamp.ToString("MM/dd/yyyy")) ? assignmentItem.CreatedTimeStamp.ToString("MM/dd/yyyy") : "",
!string.IsNullOrEmpty(assignmentItem.Status) ? assignmentItem.Status : ""
}).ToArray();
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = assignmentListCount,
iTotalDisplayRecords = assignmentListCount,
aaData = data
},
JsonRequestBehavior.AllowGet);
}
/// <summary>
/// To refresh the grid on search
/// </summary>
/// <param name="param"></param>
/// <param name="strSearchText"></param>
/// <param name="strQuestionType"> </param>
/// <returns></returns>
public ActionResult GetQuestionBankSearchList(JQueryDataTableParamModel param, string strSearchText, string strQuestionType)
{
int sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
string sortColumnOrder = Request["sSortDir_0"];
try
{
IList<DocumentProxy> lstQuestionSearchResultTemp = _questionBankService.GetSearchResultsForQuestionBank(strSearchText, sortColumnIndex, sortColumnOrder, strQuestionType);
IList<DocumentProxy> lstQuestionSearchResult = lstQuestionSearchResultTemp.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
var data = (from questionBankItem in lstQuestionSearchResult
select new[]
{
!string.IsNullOrEmpty(questionBankItem.Text) ? "<a href='#' onclick=\"questionBank.commonFunctions.loadQuestionInEditMode('"+questionBankItem.Url+"','"+Convert.ToInt32(((AppCommon.QuestionTypeOptionsForLanding.Single(x => x.Value == questionBankItem.TypeOfQuestion)).Key).ToString(CultureInfo.InvariantCulture))+"')\" class=\"link select-hand\">" + AppCommon.BreakWord(AppCommon.ReplaceEscapeCharacterWithHtmlForReports(questionBankItem.Text), 20) + "</a>" : "",
!string.IsNullOrEmpty(questionBankItem.LinkedItemReference) ? questionBankItem.LinkedItemReference : String.Empty,
"<a href='#' onclick=\"questionBank.commonFunctions.loadFolder('"+questionBankItem.FolderUrl+"','"+questionBankItem.FolderIdentifier+"')\" class=\"link select-hand\">" + (!String.IsNullOrEmpty(questionBankItem.FolderName)? questionBankItem.FolderName: AppCommon.QuestionBankLandingPageFolderName) + "</a>",
(!String.IsNullOrEmpty(questionBankItem.TypeOfQuestion)) ? questionBankItem.TypeOfQuestion :String.Empty,
!string.IsNullOrEmpty(questionBankItem.CreatedTimeStamp.ToString("MM/dd/yyyy")) ? questionBankItem.CreatedTimeStamp.ToString("MM/dd/yyyy") : ""
}).ToArray();
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = lstQuestionSearchResultTemp.Count,
iTotalDisplayRecords = lstQuestionSearchResultTemp.Count,
aaData = data
},
JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
AjaxCallResult(new AjaxResult(AppEnum.ResultType.Error, ex.ToString(), ""));
ExceptionManager.Error("Error: ControllerName: QuestionBank, MethodName: GetQuestionBankSearchList", ex);
}
return Json(new { Result = string.Empty });
}
/// <summary>
/// To populate the patient search grid
/// </summary>
/// <param name="param"></param>
/// <param name="strSearchText"></param>
/// <returns></returns>
public ActionResult GetPatientSearchList(JQueryDataTableParamModel param, string strSearchText)
{
try
{
int sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
string sortColumnOrder = Request["sSortDir_0"];
IList<PatientProxy> lstPatientSearchResult = _patientService.GetSearchResultsForPatient(strSearchText, sortColumnIndex, sortColumnOrder, GetLoginUserCourse(), GetLoginUserRole());
IList<PatientProxy> patientSearchListToRender = lstPatientSearchResult.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
int patientCount = lstPatientSearchResult.Count;
var data = (from patientItem in patientSearchListToRender
select new[]
{
!string.IsNullOrEmpty(patientItem.FirstName) ? patientItem.FirstName : "",
!string.IsNullOrEmpty(patientItem.LastName)
? "<a href='#' onclick=\"patient.pageOperations.loadPatientInEditMode('"+patientItem.Url+"')\" class=\"link select-hand\">" + patientItem.LastName +
"</a>"
: "",
!string.IsNullOrEmpty(patientItem.Sex) ? ((patientItem.Sex == "Male")?"M":"F") : "",
!string.IsNullOrEmpty(patientItem.DateOfBirth) ? patientItem.DateOfBirth : "",
!string.IsNullOrEmpty(patientItem.Age) ? patientItem.Age : "",
!string.IsNullOrEmpty(patientItem.CreatedTimeStamp.ToString("MM/dd/yyyy"))
? patientItem.CreatedTimeStamp.ToString("MM/dd/yyyy")
: "",
!string.IsNullOrEmpty(patientItem.Status) ? patientItem.Status : ""
}).ToArray();
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = patientCount,
iTotalDisplayRecords = patientCount,
aaData = data
},
JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
AjaxCallResult(new AjaxResult(AppEnum.ResultType.Error, ex.ToString(), ""));
ExceptionManager.Error("Error: ControllerName: Patient, MethodName: GetPatientSearchList", ex);
}
return Json(new { Result = string.Empty });
}
/// <summary>
/// To refresh the grid on search
/// </summary>
/// <param name="param"></param>
/// <param name="strSearchText"></param>
/// <param name="strSource"> </param>
/// <returns></returns>
public ActionResult GetSkillSetSearchList(JQueryDataTableParamModel param, string strSearchText, string strSource)
{
try
{
int sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
string sortColumnOrder = Request["sSortDir_0"];
IList<SkillSetProxy> lstSkillSetSearchResultTemp = _skillSetService.GetSearchResultsForSkillSet(strSearchText, sortColumnIndex, sortColumnOrder, strSource);
IList<SkillSetProxy> lstSkillSetSearchResult = lstSkillSetSearchResultTemp.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
var data = (from skillSetItem in lstSkillSetSearchResult
select new[]
{
!string.IsNullOrEmpty(skillSetItem.SkillSetTitle) ? "<a href='#' onclick=\""+(AppCommon.CheckIfPublished(skillSetItem.Status)?"skillSet.commonFunctions.loadStep4('"+skillSetItem.Url+"')":"skillSet.commonFunctions.loadStep1('"+skillSetItem.Url+"')") +"\" class=\"link select-hand\">" + skillSetItem.SkillSetTitle + "</a>" : "",
(skillSetItem.LinkedCompetencies!=null && skillSetItem.LinkedCompetencies.Count>0 ? _competencyService.GetCompetencyNameForListofCompetencies(skillSetItem.LinkedCompetencies):""),
(skillSetItem.Source!=null&&skillSetItem.Source.Count>0)?String.Join(", ",skillSetItem.Source.Select(s=>s)):String.Empty,
!string.IsNullOrEmpty(skillSetItem.CreatedTimeStamp.ToString("MM/dd/yyyy")) ? skillSetItem.CreatedTimeStamp.ToString("MM/dd/yyyy") : "",
(!String.IsNullOrEmpty(skillSetItem.Status)) ? skillSetItem.Status :String.Empty
}).ToArray();
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = lstSkillSetSearchResultTemp.Count,
iTotalDisplayRecords = lstSkillSetSearchResultTemp.Count,
aaData = data
},
JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
ExceptionManager.Error("Page Name : SkillSet - Search Results, Controller Method : GetSkillSetSearchList, Service Method : _skillSetService.GetSearchResultsForSkillSet", ex);
}
return Json(new { Result = string.Empty });
}
/// <summary>
/// method to load the SkillSets in the datatable
/// </summary>
/// <param name="param"></param>
/// <param name="parentFolderIdentifier"></param>
/// <param name="folderType"></param>
/// <param name="filterBySource"></param>
/// <param name="selectedSkillSetList"></param>
/// <param name="folderUrl"></param>
/// <returns></returns>
//[AcceptVerbs(HttpVerbs.Post)]
public ActionResult GetSkillSetList(JQueryDataTableParamModel param, string parentFolderIdentifier, int folderType, string filterBySource, string selectedSkillSetList, string folderUrl)
{
string[] gridColumnList = { "SkillSetTitle", "Competency", "Source", "CreatedTimeStamp", "Status" };
IList<SkillSet> skillSetList = _skillSetService.GetSkillSetItems(parentFolderIdentifier, folderType, GetLoginUserCourse() + "/" + GetLoginUserRole(), folderUrl);
IList<Competency> competencyAll = _competencyService.GetAllCompetencies();
if (filterBySource != "")
{
IList<SkillSet> skillSetLocal = (from skillSet in skillSetList
where
skillSet.Competencies != null && skillSet.Competencies.Count > 0 &&
(_skillSetService.GetLinkedCompetencySources(skillSet.Competencies, competencyAll).
Any(x => x.ToLower().Contains(filterBySource.ToLower())))
select skillSet).ToList();
skillSetList = skillSetLocal;
}
int sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
string sortColumnOrder = Request["sSortDir_0"];
string sortColumnName = gridColumnList[sortColumnIndex - 1];
switch (gridColumnList[sortColumnIndex - 1])
{
case "Competency":
if (sortColumnOrder == "asc")
{
skillSetList = (from skillSetItem in skillSetList
let competency = ((skillSetItem.Competencies) != null && (skillSetItem.Competencies.Count) > 0) ? _competencyService.GetCompetencyNameForListofCompetencies(skillSetItem.Competencies) : ""
orderby competency
select skillSetItem).ToList();
}
else
{
skillSetList = (from skillSetItem in skillSetList
let competency = ((skillSetItem.Competencies) != null && (skillSetItem.Competencies.Count) > 0) ? _competencyService.GetCompetencyNameForListofCompetencies(skillSetItem.Competencies) : ""
orderby competency descending
select skillSetItem).ToList();
}
break;
case "Source":
if (sortColumnOrder == "asc")
{
skillSetList = (from skillSetItem in skillSetList
let sources = ((skillSetItem.Competencies) != null && (skillSetItem.Competencies.Count) > 0) ? String.Join(",<br/> ", _skillSetService.GetLinkedCompetencySources(skillSetItem.Competencies, _skillSetService.GetAllCompetenciesForASkillSet(skillSetItem))) : ""
orderby sources
select skillSetItem).ToList();
}
else
{
skillSetList = (from skillSetItem in skillSetList
let sources = ((skillSetItem.Competencies) != null && (skillSetItem.Competencies.Count) > 0) ? String.Join(",<br/> ", _skillSetService.GetLinkedCompetencySources(skillSetItem.Competencies, _skillSetService.GetAllCompetenciesForASkillSet(skillSetItem))) : ""
orderby sources descending
select skillSetItem).ToList();
}
break;
default:
var sortableList = skillSetList.AsQueryable();
skillSetList = sortableList.OrderBy(sortColumnName, sortColumnOrder).ToList();
break;
}
IList<SkillSet> skillSetListToRender = skillSetList.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
IList<Competency> skillSetCompetencies = _skillSetService.GetAllCompetenciesForSkillSets(skillSetListToRender);
int skillSetCount = skillSetList.Count;
string[] strArray = AppCommon.GetStringArrayAfterSplitting(selectedSkillSetList);
var data = (from skillSetItem in skillSetListToRender
select new[]
{
"<input type='checkbox' id='" + skillSetItem.UniqueIdentifier + "' onClick='skillSet.commonFunctions.gridOperations.skillSetItemChanged(this)'" + AppCommon.CheckForFlagAndReturnValue(strArray, skillSetItem.UniqueIdentifier) + "/>",
!string.IsNullOrEmpty(skillSetItem.SkillSetTitle) ? "<a href='#' onclick=\""+(AppCommon.CheckIfPublished(skillSetItem.Status)?"skillSet.commonFunctions.loadStep4('"+skillSetItem.Url+"')":"skillSet.commonFunctions.loadStep1('"+skillSetItem.Url+"')") +"\" class=\"link select-hand\">" + skillSetItem.SkillSetTitle + "</a>" : "",
(skillSetItem.Competencies!=null && skillSetItem.Competencies.Count>0 ? _competencyService.GetCompetencyNameForListofCompetencies(skillSetItem.Competencies):""),
(skillSetItem.Competencies!=null && skillSetItem.Competencies.Count>0 ? String.Join(",<br/> ",_skillSetService.GetLinkedCompetencySources(skillSetItem.Competencies,skillSetCompetencies)):"") ,
!string.IsNullOrEmpty(skillSetItem.CreatedTimeStamp.ToString("MM/dd/yyyy")) ? skillSetItem.CreatedTimeStamp.ToString("MM/dd/yyyy") : "",
(!String.IsNullOrEmpty(skillSetItem.Status)) ? skillSetItem.Status :String.Empty
}).ToArray();
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = skillSetCount,
iTotalDisplayRecords = skillSetCount,
aaData = data
},
JsonRequestBehavior.AllowGet);
}
/// <summary>
/// method to load the questions in the datatable
/// </summary>
/// <param name="param"></param>
/// <param name="parentFolderIdentifier"></param>
/// <param name="folderType"></param>
/// <param name="filterByType"></param>
/// <param name="selectedQuestionList"></param>
/// <param name="folderUrl"></param>
/// <returns></returns>
public ActionResult GetQuestionBankList(JQueryDataTableParamModel param, string parentFolderIdentifier, int folderType, string filterByType, string selectedQuestionList, string folderUrl)
{
string[] gridColumnList = { "QuestionText", "Competency", "QuestionType", "CreatedTimeStamp" };
IList<Question> questionBankList = _questionBankService.GetQuestionItems(parentFolderIdentifier, folderType, GetDropBoxFromCookie(), folderUrl);
if (filterByType != "")
{
string filterValue = AppCommon.QuestionTypeOptionsForLanding.Single(x => x.Value == filterByType).Key.ToString(CultureInfo.InvariantCulture);
questionBankList = (from qb in questionBankList where qb.QuestionType == filterValue select qb).ToList();
}
int sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
string sortColumnOrder = Request["sSortDir_0"];
string sortColumnName = gridColumnList[sortColumnIndex - 1];
switch (gridColumnList[sortColumnIndex - 1])
{
case "Competency":
if (sortColumnOrder == "asc")
{
questionBankList = (from question in questionBankList
let competency =
GetLinkedCompetencyForAGuid(question.CompetencyReferenceGuid)
orderby competency
select question).ToList();
}
else
{
questionBankList = (from question in questionBankList
let competency =
GetLinkedCompetencyForAGuid(question.CompetencyReferenceGuid)
orderby competency descending
select question).ToList();
}
break;
case "QuestionType":
{
if (sortColumnOrder == "asc")
{
questionBankList = (from question in questionBankList
let questionType =
AppCommon.GetKeyBasedOnQuestionType(
Convert.ToInt32(question.QuestionType))
orderby questionType
select question).ToList();
}
else
{
questionBankList = (from question in questionBankList
let questionType =
AppCommon.GetKeyBasedOnQuestionType(
Convert.ToInt32(question.QuestionType))
orderby questionType descending
select question).ToList();
}
}
break;
default:
var sortableList = questionBankList.AsQueryable();
questionBankList = sortableList.OrderBy(sortColumnName, sortColumnOrder).ToList();
break;
}
IList<Question> questionBankListToRender = questionBankList.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
int questionBankCount = questionBankList.Count;
string[] strArray = AppCommon.GetStringArrayAfterSplitting(selectedQuestionList);
var data = (from questionBankItem in questionBankListToRender
select new[]
{
"<input type='checkbox' id='" + questionBankItem.UniqueIdentifier + "' onClick='questionBank.commonFunctions.gridOperations.questionItemChanged(this)'" + AppCommon.CheckForFlagAndReturnValue(strArray, questionBankItem.UniqueIdentifier) + "/>",
!string.IsNullOrEmpty(questionBankItem.QuestionText) ? "<a href='#' onclick=\"questionBank.commonFunctions.loadQuestionInEditMode('"+questionBankItem.Url+"','"+questionBankItem.QuestionType+"')\" class=\"link select-hand\">" + AppCommon.BreakWord(AppCommon.ReplaceEscapeCharacterWithHtmlForReports(questionBankItem.QuestionText), 20) + "</a>" : "",
!string.IsNullOrEmpty(questionBankItem.CompetencyReferenceGuid) ? GetLinkedCompetencyForAGuid(questionBankItem.CompetencyReferenceGuid) : "",
!string.IsNullOrEmpty(questionBankItem.QuestionType) && questionBankItem.QuestionType != "-1" ? ((AppCommon.QuestionTypeOptions.Single(x => x.Key == Convert.ToInt32(questionBankItem.QuestionType))).Value).ToString(CultureInfo.InvariantCulture) : "",
!string.IsNullOrEmpty(questionBankItem.CreatedTimeStamp.ToString("MM/dd/yyyy")) ? questionBankItem.CreatedTimeStamp.ToString("MM/dd/yyyy") : ""
}).ToArray();
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = questionBankCount,
iTotalDisplayRecords = questionBankCount,
aaData = data
},
JsonRequestBehavior.AllowGet);
}
