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