public string GetDataTable()
{
string role = Session["UserRole"] + "";
role = role.ToLower();
string[] coloumns = { "Name", "UploadedByUser", };
int echo = Int32.Parse(Request.Params["sEcho"]);
int displayLength = Int32.Parse(Request.Params["iDisplayLength"]);
int colIndex = Int32.Parse(Request.Params["iSortCol_0"]);
int displayStart = Int32.Parse(Request.Params["iDisplayStart"]);
string search = (Request.Params["sSearch"] + "").Trim();
ImportFileRepository dal = new ImportFileRepository();
var records = dal.AsQueryable();
int totalRecords = records.Count();
int totalDisplayRecords = totalRecords;
var filteredList = records;
if (search != "")
filteredList = records.Where(p =>
p.Name.Contains(search)
|| p.UploadedByUser.Contains(search)
);
var orderedList = filteredList.OrderByDescending(p => p.ID);
if (colIndex < coloumns.Length && coloumns[colIndex] + "" != "")
{
string sortDir = Request.Params["sSortDir_0"];
string sortExpression = coloumns[colIndex] + sortDir;
orderedList = sortDir == "asc" ? filteredList.OrderBy(coloumns[colIndex]) : filteredList.OrderByDescending(coloumns[colIndex]);
}
StringBuilder sb = new StringBuilder();
sb.Clear();
JQueryResponse rs = new JQueryResponse();
foreach (var item in orderedList.Skip(displayStart).Take(displayLength))
{
List<string> data = new List<string>();
string nameHTML = "<a href='ImportFiles/" + item.URL + "'>" + item.Name + "</a>";
data.Add(nameHTML);
data.Add(item.UploadedByUser);
data.Add(item.UploadedAt.ToString());
string deleteIcon = "<img id='delete' src='images/delete.png' class='icon' alt='' onclick=\"Delete(" + item.ID + ")\" style='float:right' title='Delete Record' />";
string icons = "";
if (CanDelete)
icons = deleteIcon;
data.Add(icons);
rs.aaData.Add(data);
}
rs.sEcho = echo;
rs.iTotalRecords = totalRecords;
rs.iTotalDisplayRecords = totalDisplayRecords;
return new JavaScriptSerializer().Serialize(rs);
}
public string GetDataTable()
{
string role = Session["UserRole"] + "";
role = role.ToLower();
string[] coloumns = { "DateSent", "Direction", "FromNumber", "ToNumber", "Body", "Status" };
int echo = Int32.Parse(Request.Params["sEcho"]);
int displayLength = Int32.Parse(Request.Params["iDisplayLength"]);
int colIndex = Int32.Parse(Request.Params["iSortCol_0"]);
int displayStart = Int32.Parse(Request.Params["iDisplayStart"]);
string search = (Request.Params["sSearch"] + "").Trim();
MessageRepository dal = new MessageRepository();
var records = dal.AsQueryable();
if (Session["IncludeInactiveSMS"] + "" != "true")
records = records.Where(p => p.RecordStatus != (byte)RecordStatus.Inactive);
int totalRecords = records.Count();
int totalDisplayRecords = totalRecords;
var filteredList = records;
if (search != "")
filteredList = records.Where(p =>
p.FromNumber.Contains(search)
|| p.ToNumber.Contains(search)
|| p.Direction.Contains(search)
|| p.SmsStatus.Contains(search)
|| p.Body.Contains(search)
);
var orderedList = filteredList.OrderByDescending(p => p.ID);
if (colIndex < coloumns.Length && coloumns[colIndex] + "" != "")
{
string sortDir = Request.Params["sSortDir_0"];
string sortExpression = coloumns[colIndex] + sortDir;
orderedList = sortDir == "asc" ? filteredList.OrderBy(coloumns[colIndex]) : filteredList.OrderByDescending(coloumns[colIndex]);
}
StringBuilder sb = new StringBuilder();
sb.Clear();
JQueryResponse rs = new JQueryResponse();
Dictionary<string, string> directions = new Dictionary<string, string>();
directions.Add("outbound-reply", "Reply");
directions.Add("inbound", "Incoming");
directions.Add("outbound-api", "Outgoing API");
foreach (var item in orderedList.Skip(displayStart).Take(displayLength))
{
List<string> data = new List<string>();
var method = "";
var disabled = "disabled='disabled'";
if (CanEdit)
{
method = "onclick='ChangeStatus(this)'";
disabled = "";
}
var status = "<img class='icon' src='images/status-online.png' title='Click to make it inactive' " + disabled + method + " data-id='" + item.ID + "' status-id='" + item.RecordStatus + "' />";
if (item.RecordStatus == (byte)RecordStatus.Inactive)
status = "<img class='icon' src='images/status-offline.png' title='Click to make it active' " + disabled + method + " data-id='" + item.ID + "' status-id='" + item.RecordStatus + "' />";
data.Add(status);
data.Add(item.DateSent.ToString());
data.Add(directions.ContainsKey(item.Direction) ? directions[item.Direction] : "Outgoing API");
data.Add(item.FromNumber);
data.Add(item.ToNumber);
data.Add(WrapToolTip(item.Body));
data.Add(item.SmsStatus == "received" ? "Received" : "Sent");
string deleteIcon = "<img id='delete' src='images/delete.png' class='icon' alt='' onclick=\"Delete(" + item.ID + ")\" style='float:right' title='Delete Record'/>";
string icons = "";
if (CanDelete)
icons = deleteIcon;
data.Add(icons);
rs.aaData.Add(data);
}
rs.sEcho = echo;
rs.iTotalRecords = totalRecords;
rs.iTotalDisplayRecords = totalDisplayRecords;
return new JavaScriptSerializer().Serialize(rs);
}
public string GetDataTable()
{
string role = Session["UserRole"] + "";
role = role.ToLower();
string[] coloumns = { "", "HistoricArc", "SBC_VIN", "UUID", "TruckID", "InstallType", "SerialNumber", "City", "State", "InstallationDate" };
int echo = Int32.Parse(Request.Params["sEcho"]);
int displayLength = Int32.Parse(Request.Params["iDisplayLength"]);
int colIndex = Int32.Parse(Request.Params["iSortCol_0"]);
int displayStart = Int32.Parse(Request.Params["iDisplayStart"]);
string search = (Request.Params["sSearch"] + "").Trim();
OWRInfoRepository dal = new OWRInfoRepository();
var records = dal.AsQueryable();
int totalRecords = records.Count();
int totalDisplayRecords = totalRecords;
var filteredList = records;
if (search != "")
filteredList = records.Where(p =>
p.RequestID.Contains(search)
|| p.MAKE.Contains(search)
|| p.MODEL.Contains(search)
|| p.COMPANY.Contains(search)
|| p.SBC_VIN.Contains(search)
|| p.GARAGE_STATE.Contains(search)
|| p.GARAGE_CITY.Contains(search)
);
var orderedList = filteredList.OrderByDescending(p => p.ID);
if (colIndex < coloumns.Length && coloumns[colIndex] + "" != "")
{
string sortDir = Request.Params["sSortDir_0"];
string sortExpression = coloumns[colIndex] + sortDir;
orderedList = sortDir == "asc" ? filteredList.OrderBy(coloumns[colIndex]) : filteredList.OrderByDescending(coloumns[colIndex]);
}
StringBuilder sb = new StringBuilder();
sb.Clear();
JQueryResponse rs = new JQueryResponse();
foreach (var item in orderedList.Skip(displayStart).Take(displayLength))
{
List<string> data = new List<string>();
string status = "";
//if (item.DeInstallRequired) status = "<div class='de-install-required' title='De-Install Required'></div>";
//if (item.InstallComplete) status += "<div class='install-completed' title='Completed'></div>";
data.Add(status);
data.Add(item.RequestID);
data.Add(item.SBC_VIN);
data.Add(item.MAKE + " " + item.MODEL);
data.Add(item.GARAGE_CITY + " " + item.GARAGE_STATE);
data.Add(item.SUPER_FIRST_NAME + " " + item.SUPER_LAST_NAME);
data.Add(item.E_MAIL);
data.Add(item.COMPANY);
data.Add(item.WorkingDays + "");
data.Add(item.TotalDuration + "");
data.Add(item.SUBMISSION_DATE);
string editIcon = "";
string deleteIcon = "<img id='delete' src='images/delete.png' class='icon' alt='' onclick=\"Delete(" + item.ID + ")\" style='float:right' title='Delete Record' />";
string icons = "";
if (CanEdit)
icons = editIcon;
if (CanDelete)
icons = editIcon + deleteIcon;
data.Add(icons);
rs.aaData.Add(data);
}
rs.sEcho = echo;
rs.iTotalRecords = totalRecords;
rs.iTotalDisplayRecords = totalDisplayRecords;
return new JavaScriptSerializer().Serialize(rs);
}
public string GetDataTable()
{
string role = Session["UserRole"] + "";
role = role.ToLower();
string[] coloumns = { "", "UserName", "RoleName", "" };
int echo = Int32.Parse(Request.Params["sEcho"]);
int displayLength = Int32.Parse(Request.Params["iDisplayLength"]);
int colIndex = Int32.Parse(Request.Params["iSortCol_0"]);
int displayStart = Int32.Parse(Request.Params["iDisplayStart"]);
string search = (Request.Params["sSearch"] + "").Trim();
var dal = new RoleRepository();
var records = dal.AsQueryable();
int totalRecords = records.Count();
int totalDisplayRecords = totalRecords;
var filteredList = records;
if (search != "")
filteredList = records.Where(p =>
p.Name.Contains(search)
);
var orderedList = filteredList.OrderByDescending(p => p.ID);
if (colIndex < coloumns.Length && coloumns[colIndex] + "" != "")
{
string sortDir = Request.Params["sSortDir_0"];
string sortExpression = coloumns[colIndex] + sortDir;
orderedList = sortDir == "asc" ? filteredList.OrderBy(coloumns[colIndex]) : filteredList.OrderByDescending(coloumns[colIndex]);
}
StringBuilder sb = new StringBuilder();
sb.Clear();
JQueryResponse rs = new JQueryResponse();
foreach (var item in orderedList.Skip(displayStart).Take(displayLength))
{
List<string> data = new List<string>();
var method = "";
var disabled = "disabled='disabled'";
if (CanEdit)
{
method = "onclick='ChangeStatus(this)'";
disabled = "";
}
var status = "<img class='icon' src='images/status-online.png' title='Click to make it inactive' " + disabled + method + " data-id='" + item.ID + "' status-id='" + item.RecordStatus + "' />";
if (item.RecordStatus == (byte)RecordStatus.Inactive)
status = "<img class='icon' src='images/status-offline.png' title='Click to make it active' " + disabled + method + " data-id='" + item.ID + "' status-id='" + item.RecordStatus + "' />";
data.Add(status);
data.Add(item.Name);
string editIcon = "<img src='images/edit.png' class='icon' alt='' onclick=\"Edit(" + item.ID + ")\" style='float:left' title='Edit Record' />";
string deleteIcon = "<img id='delete' src='images/delete.png' class='icon' alt='' onclick=\"Delete(" + item.ID + ")\" style='float:right' title='Delete Record' />";
string icons = "";
if (CanEdit)
icons = editIcon;
if (CanDelete)
icons = editIcon + deleteIcon;
data.Add(icons);
rs.aaData.Add(data);
}
rs.sEcho = echo;
rs.iTotalRecords = totalRecords;
rs.iTotalDisplayRecords = totalDisplayRecords;
return new JavaScriptSerializer().Serialize(rs);
}
public string GetDataTable()
{
string role = Session["UserRole"] + "";
role = role.ToLower();
string[] coloumns = { "", "HistoricArc", "SBC_VIN", "UUID", "TruckID", "InstallType", "SerialNumber", "PhoneNumber", "City", "State", "InstallationDate" };
int echo = Int32.Parse(Request.Params["sEcho"]);
int displayLength = Int32.Parse(Request.Params["iDisplayLength"]);
int colIndex = Int32.Parse(Request.Params["iSortCol_0"]);
int displayStart = Int32.Parse(Request.Params["iDisplayStart"]);
string search = (Request.Params["sSearch"] + "").Trim();
DailyRecordRepository dal = new DailyRecordRepository();
var records = dal.AsQueryable();
int totalRecords = records.Count();
int totalDisplayRecords = totalRecords;
var filteredList = records;
if (search != "")
filteredList = records.Where(p =>
p.TruckID.Contains(search)
|| p.SerialNumber.Contains(search)
|| p.PhoneNumber.Contains(search)
|| p.SBC_VIN.Contains(search)
|| p.State.Contains(search)
|| p.City.Contains(search)
);
var orderedList = filteredList.OrderByDescending(p => p.ID);
if (colIndex < coloumns.Length && coloumns[colIndex] + "" != "")
{
string sortDir = Request.Params["sSortDir_0"];
string sortExpression = coloumns[colIndex] + sortDir;
orderedList = sortDir == "asc" ? filteredList.OrderBy(coloumns[colIndex]) : filteredList.OrderByDescending(coloumns[colIndex]);
}
StringBuilder sb = new StringBuilder();
sb.Clear();
JQueryResponse rs = new JQueryResponse();
var pagedList = orderedList.Skip(displayStart).Take(displayLength).ToList();
var numbers = pagedList.Where(p => p.PhoneNumber + "" != "").Select(p => p.PhoneNumber).ToList();
var messageRepo = new MessageRepository();
foreach (var item in pagedList)
{
List<string> data = new List<string>();
string status = "";
if (item.DeInstallRequired) status = "<div class='de-install-required' title='De-Install Required'></div>";
if (item.InstallComplete) status += "<div class='install-completed' title='Completed'></div>";
data.Add(status);
//data.Add(item.HistoricArc);
data.Add(item.SBC_VIN);
//data.Add(item.UUID);
//data.Add(item.TruckID);
data.Add(item.InstallType);
data.Add(item.SerialNumber);
data.Add(WrapToolTip(item.PhoneNumber));
var msg = "";
item.PhoneNumber = (item.PhoneNumber + "").Trim().Trim('-');
if (item.PhoneNumber != "")
{
var message = messageRepo.GetMessage(item.PhoneNumber);
if (message != null)
msg = WrapToolTip(message.Body);
}
data.Add(msg);
data.Add(item.City);
data.Add(item.State);
data.Add(item.InstallDate.ToString("MM/dd/yyyy"));
string editIcon = "<img src='images/edit.png' class='icon' alt='' onclick=\"Edit(" + item.ID + ")\" title='Edit Record' />";
string deleteIcon = "<img id='delete' src='images/delete.png' class='icon' alt='' onclick=\"Delete(" + item.ID + ")\" title='Delete Record' />";
string icons = "<img src='images/log.png' class='icon' alt='' onclick=\"SmsLog('" + item.PhoneNumber + "')\" title='SMS Log' />"; ;
if (CanEdit)
icons += editIcon;
if (CanDelete)
icons += deleteIcon;
data.Add(icons);
rs.aaData.Add(data);
}
rs.sEcho = echo;
rs.iTotalRecords = totalRecords;
rs.iTotalDisplayRecords = totalDisplayRecords;
return new JavaScriptSerializer().Serialize(rs);
}
