public JsonResult GetSSIS_ConfigurationForDataTable(string type)
{
try
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortDirection = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var sortColumnIndex = Request.Form.GetValues("order[0][column]").FirstOrDefault();
var sortColumn = Request.Form.GetValues(String.Format("columns[{0}][name]", sortColumnIndex)).FirstOrDefault();
//Paging Size (10,20,50,100)
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
using (var db = new logconfigEntities())
{
IQueryable <SSIS_Configurations> query = db.SSIS_Configurations;
//Sorting
if (sortDirection.ToLowerInvariant() == "asc")
{
query = query.OrderBy(sortColumn);
}
else
{
query = query.OrderBy(sortColumn + " " + sortDirection);
}
//Filtering
if (!String.IsNullOrWhiteSpace(type))
{
query = query.Where(s => s.ConfiguredValueType == type);
}
//total number of rows count
recordsTotal = query.Count();
//Paging
var data = query
.Skip(skip)
.Take(pageSize)
.ToList();
//Returning Json Data
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public JsonResult GetEvents()
{
try
{
using (var db = new logconfigEntities())
{
var events = db.sysssislogs.Select(l => l.@event).Distinct().ToList();
return(Json(events));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public JsonResult GetConfiguration(String application, String key)
{
try
{
using (var db = new logconfigEntities())
{
var config = db.Configurations.Find(application, key);
return(Json(config));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public JsonResult GetSysssislog(int logID)
{
try
{
using (var db = new logconfigEntities())
{
var sysssislog = db.sysssislogs.Find(logID);
var request = Mapper.Map <SysssislogViewModel>(sysssislog);
return(Json(request));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public JsonResult GetTypes()
{
try
{
using (var db = new logconfigEntities())
{
var types = db.SSIS_Configurations.Select(l => l.ConfiguredValueType).Distinct().ToList();
return(Json(types));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public JsonResult GetApplications()
{
try
{
using (var db = new logconfigEntities())
{
var applications = db.Configurations.Select(l => l.Application).Distinct().ToList();
return(Json(applications));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public JsonResult SetConfiguration(String application, String key, String value)
{
try
{
using (var db = new logconfigEntities())
{
var config = db.Configurations.Find(application, key);
config.Value = value;
db.SaveChanges();
return(Json("successfully changed to" + value));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public JsonResult GetSysssislogForDataTable(string searchTerm, string @event)
{
try
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortDirection = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var sortColumnIndex = Request.Form.GetValues("order[0][column]").FirstOrDefault();
var sortColumn = Request.Form.GetValues(String.Format("columns[{0}][name]", sortColumnIndex)).FirstOrDefault();
//Paging Size (10,20,50,100)
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
using (var db = new logconfigEntities())
{
IQueryable <sysssislog> query = db.sysssislogs;
//Sorting
if (sortDirection.ToLowerInvariant() == "asc")
{
query = query.OrderBy(sortColumn);
}
else
{
query = query.OrderBy(sortColumn + " " + sortDirection);
}
//Filtering
if (!String.IsNullOrEmpty(searchTerm))
{
query = query.Where(l => l.message.Contains(searchTerm) ||
[email protected](searchTerm) ||
l.source.Contains(searchTerm) ||
l.computer.Contains(searchTerm));
}
if (!String.IsNullOrWhiteSpace(@event))
{
query = query.Where(l => l.@event == @event);
}
//total number of rows count
recordsTotal = query.Count();
//Paging
var data = query.Skip(skip).Take(pageSize).ToList();
//Returning Json Data
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public JsonResult GetLogForDataTable(string application, string searchTerm)
{
try
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortDirection = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var sortColumnIndex = Request.Form.GetValues("order[0][column]").FirstOrDefault();
var sortColumn = Request.Form.GetValues(String.Format("columns[{0}][name]", sortColumnIndex)).FirstOrDefault();
//Paging Size (10,20,50,100)
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
using (var db = new logconfigEntities())
{
IQueryable <Log> query = db.Logs;
//Sorting
if (sortDirection.ToLowerInvariant() == "asc")
{
query = query.OrderBy(sortColumn);
}
else
{
query = query.OrderBy(sortColumn + " " + sortDirection);
}
//filtering
if (!String.IsNullOrWhiteSpace(application))
{
query = query.Where(l => l.Title == application.Trim());
}
if (!String.IsNullOrWhiteSpace(searchTerm))
{
query = query.Where(l => l.Message.Contains(searchTerm) ||
l.Title.Contains(searchTerm) ||
l.AuthenticatedUser.Contains(searchTerm));
}
//total number of rows count
recordsTotal = query.Count();
//Paging
var data = query
.Skip(skip)
.Take(pageSize)
.ToList();
var requests = Mapper.Map <List <LogViewModel> >(data);
//Returning Json Data
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = requests }));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}