public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <Company>(_db); var items = repo.GetItemsByExpression(w => w.Name.Contains(search), x => x.Name, parameters.Start, parameters.Length, out var recordsTotal) .Select(s => new { s.CompanyId, s.Logo, s.Name, s.Cnpj }).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttons = new ButtonsCompany(); foreach (var item in items) { dtResult.data.Add(new object[] { item.Name, item.Cnpj, buttons.ToPagination(item.CompanyId, Account.Current.Roles) }); } return(Json(dtResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <Event>(_db); var items = repo.GetItemsByExpression(w => w.Name.Contains(search), x => x.Name, parameters.Start, parameters.Length, out var recordsTotal, i => i.Address.City) .Select(s => new { s.EventId, s.Name, s.StartDate, s.EndDate, s.Address.City }).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttons = new ButtonsEvent(); foreach (var item in items) { dtResult.data.Add(new object[] { item.Name, $"{(item.StartDate == item.EndDate ? item.StartDate.ToString("dd/MM/yyyy HH:mm") : $"{item.StartDate:dd/MM/yyyy HH:mm} - {item.EndDate:dd/MM/yyyy HH:mm}")}", item.City.Name, buttons.ToPagination(item.EventId, Account.Current.Roles) });
public JsonResult GetVisit(DataTableParameters dataTableParameters, string from) { VIST_CONTACTOR vit = new VIST_CONTACTOR(); EMPLOYEE em = new EMPLOYEE(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = vit.SelectPaging(from, dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1); resultSet.recordsTotal = resultSet.recordsFiltered = em.GetCount(); foreach (var i in lst) { var columns = new List <string>(); var tar = i.tar == null ? 0 : i.tar; var Ratio = tar == 0 ? 0 : Math.Round(Convert.ToDouble(i.result) / i.tar * 100, 2, MidpointRounding.ToEven).ToString(); columns.Add("<a href='#' class='emp' data-emid='" + i.EMP_ID + "'>" + i.EMP_ID + "</a>"); columns.Add(i.EMP_NAME.Trim()); columns.Add(tar.ToString()); columns.Add(i.result.ToString()); columns.Add(i.dir.ToString()); columns.Add(i.ca.ToString()); columns.Add(i.email.ToString()); columns.Add(Ratio.ToString()); columns.Add(i.EMP_DEPT == null ? "" : i.EMP_DEPT.Trim()); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <User>(_db); var items = repo.GetItemsByExpression(w => string.Concat(w.FirstName, " ", w.LastName).Contains(search), x => x.FirstName, parameters.Start, parameters.Length, out var recordsTotal) .Select(s => new { s.UserId, s.FullName, s.Cpf, s.IsActive }).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttonsUser = new ButtonsUser(); foreach (var item in items) { dtResult.data.Add(new[] { item.UserId.ToString(), item.FullName, item.Cpf, $"{(item.IsActive ? "Ativado" : "Desativado")}", buttonsUser.ToPagination(item.UserId, item.IsActive) }); } return(Json(dtResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetEmployee(DataTableParameters dataTableParameters) { EMPLOYEE cus = new EMPLOYEE(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = cus.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1, dataTableParameters.Search.Value); resultSet.recordsTotal = resultSet.recordsFiltered = cus.GetCount(dataTableParameters.Search.Value); foreach (var i in lst) { var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.EMP_ID.Trim() + "' />"); columns.Add(i.EMP_NAME.Trim()); columns.Add(i.EMP_ID.Trim()); columns.Add(i.C_ID == null ? "" : i.C_ID.Trim()); columns.Add(i.CUST_NAME == null ? "" : i.CUST_NAME.Trim()); columns.Add(i.EMP_MOBILE == null ? "" : i.EMP_MOBILE.Trim()); columns.Add(i.EMP_EMAIL == null ? "" : i.EMP_EMAIL.Trim()); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetIdea(DataTableParameters dataTableParameters, string div, string dep) { IdeaManager idea = IdeaManager.GetInstance(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = idea.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1, div, dep); resultSet.recordsTotal = resultSet.recordsFiltered = idea.GetCount(div, dep); foreach (var i in lst) { var columns = new List <string>(); columns.Add(i.ROWNUM.ToString()); columns.Add((i.DIVISION == null) ? "" : i.DIVISION.Trim()); columns.Add((i.DEPARTMENT == null) ? "" : i.DEPARTMENT.Trim()); columns.Add((i.EMP_NAME == null) ? "" : i.EMP_NAME.Trim()); columns.Add("<a class='title' href='#' id='" + i.ID + "' data-emp='" + i.EMP_ID.Trim() + "'>" + i.IDEA_TITLE.Trim() + "</a>"); columns.Add((i.DATE == null) ? "" : i.DATE.ToShortDateString()); columns.Add("<a href='#' class='rep' title='Reply' data-id='" + i.ID + "' data-trigger='focus'><span class='badge badge-pill badge-primary'>" + i.REP.ToString() + "</span></a>"); columns.Add("<a href='#' class='like' title='Like' data-id='" + i.ID + "' data-table='1' data-trigger='focus'><span class='badge badge-pill badge-primary'>" + i.L.ToString() + "</span></a>"); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetVisit(DataTableParameters dataTableParameters, string from, string to, string cus_id, string emp_id) { VIST_CONTACTOR vit = new VIST_CONTACTOR(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = vit.GetVisit(from, to, cus_id, emp_id, dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1); resultSet.recordsTotal = resultSet.recordsFiltered = vit.GetCountVisit(from, to, cus_id, emp_id); foreach (var i in lst) { var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' data-emp='" + i.EMP_ID + "' />"); columns.Add(i.CONTACT_DATE.ToShortDateString()); columns.Add(i.CUSTOMER_ID.ToString()); columns.Add(i.CUS_NAME.ToString()); columns.Add(i.CUST_VIST_TYPE == null ? "" : i.CUST_VIST_TYPE); columns.Add(i.CUST_VIST_PURPOSE == null ? "" : i.CUST_VIST_PURPOSE); columns.Add(i.VIST_REMARK == null ? "" : i.VIST_REMARK); columns.Add(i.EMP_NAME == null? "":i.EMP_NAME); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetCourseById(DataTableParameters dataTableParameters, int ID) { COURSE course = new COURSE(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = course.GetCourseByID(ID, dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1); resultSet.recordsTotal = resultSet.recordsFiltered = course.GetCount(ID); foreach (var i in lst) { var columns = new List <string>(); columns.Add("<img src='" + i.PICTURE + "' class='img-rounded' height='100' width='100' alt='X' />"); columns.Add(i.EMP_ID == null ? "" : i.EMP_ID.Trim()); columns.Add(i.EMP_NAME == null ? "" : i.EMP_NAME.Trim()); columns.Add(i.DEPARTMENT == null ? "" : i.DEPARTMENT.Trim()); columns.Add(i.COURSE.Trim()); columns.Add(i.TEACHER == null ? "" : i.TEACHER.Trim()); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetCustomer(DataTableParameters dataTableParameters) { CUSTOMER cus = new CUSTOMER(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = cus.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1, dataTableParameters.Search.Value); resultSet.recordsTotal = resultSet.recordsFiltered = cus.GetCount(dataTableParameters.Search.Value); foreach (var i in lst) { var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' />"); columns.Add(i.ID); columns.Add(i.NAME); columns.Add(i.LOCATION == null ? "" : i.LOCATION.Trim()); columns.Add(i.EMP_NAME == null ? "" : i.EMP_NAME); columns.Add(i.TYPE == null ? "": i.TYPE); columns.Add("<a href='#' class='end' title='End User' id='" + i.ID + "'><span class='badge badge-pill badge-primary'>" + i.NUM_END + "</span></a>"); resultSet.data.Add(columns); } return(Json(resultSet)); }
private static void SendResponse(HttpResponse response, DataTableResultSet result) { response.Clear(); response.Headers.Add("X-Content-Type-Options", "nosniff"); response.Headers.Add("X-Frame-Options", "SAMEORIGIN"); response.ContentType = "application/json; charset=utf-8"; response.Write(result.ToJSON()); response.Flush(); response.End(); }
public void Data(object parameters, string css, int tipo) { var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); EstadisticosAfiliados Datos = new EstadisticosAfiliados(); Datos.Start = req.Start; Datos.Length = req.Length; Datos.SearchValue = req.SearchValue; Datos.OrderBy = -1; if (req.Order.Count > 0) { foreach (var aux in req.Order.Keys) { Datos.OrderBy = req.Order[aux].Column; Datos.OrderDirection = req.Order[aux].Direction; } } Datos.Conexion = Comun.Conexion; Datos.TipoLista = tipo; EstadisticosAfiliados_Negocio neg = new EstadisticosAfiliados_Negocio(); neg.ObtenerEvaluacionAJAX(Datos); resultSet.draw = req.Draw; resultSet.recordsTotal = Datos.RecordTotal; resultSet.recordsFiltered = Datos.RecordFilter; foreach (EstadisticosRepresentantesSeccion Item in Datos.Lista) { var columns = new List <string>(); string ColImagen = string.Empty, ColAvance = string.Empty; if (!string.IsNullOrEmpty(Item.Imagen)) { ColImagen = @"<a href='#' class='thumb-sm m-r'><img class='r r-2x' src='data:image/jpg;base64," + Item.Imagen + @"' /></a>"; } else { ColImagen = @"<a href='#' class='thumb-sm m-r'><img class='r r-2x' src='img/anonymous.jpg'/></a>"; } ColAvance = @"<div class='progress'> <div class='progress-bar " + css + @"' role='progressbar' aria-valuenow='" + Item.Avance + @"' aria-valuemin='0' aria-valuemax='100' style='width: " + Item.Avance + @"%'> <span class=''>" + Item.Avance + @"%</span> </div> </div>"; columns.Add(ColImagen); columns.Add(Item.Seccion.ToString()); columns.Add(Item.Nombre); columns.Add(ColAvance); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public void Data(object parameters) { //Read paramater from datatable along with additional parms var req = DataTableParameters.Get(parameters); QuerySP query = new QuerySP(); DataTable table = query.QueryData(); DataView dv = table.DefaultView; //dv.Sort = "ID DESC"; foreach (var col in req.Columns) { if (req.Order.ContainsKey(col.Key)) { dv.Sort = table.Columns[req.Order[col.Key].Column].ToString() + " " + req.Order[col.Key].Direction; } } table = dv.ToTable(); var resultSet = new DataTableResultSet(); resultSet.draw = req.Draw; resultSet.recordsTotal = table.Rows.Count; resultSet.recordsFiltered = table.Rows.Count; foreach (DataRow recordFromDb in table.Select().Skip(req.Start).Take(req.Length)) { //var columns = new List<string>(); // Working var columns = new List <string>(); foreach (DataColumn col in table.Columns) { //columns.Add(recordFromDb[col.ColumnName].ToString()); - Working //columns.Add(recordFromDb[col.ColumnName] as LiteralControl); //columns.Add(((LiteralControl)recordFromDb[col.ColumnName]).Text); columns.Add(recordFromDb[col.ColumnName].ToString()); } //columns.Add("<a href='https://google.com'>Link</a>"); //columns.Add(recordFromDb[0].ToString()); //columns.Add(recordFromDb[1].ToString()); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public void CajaChicaIndex(object parameters) { var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); _CajaChica_Datos Datos = new _CajaChica_Datos(); CajaChicaModelsResult Resultado = Datos.ObtenerCajasChicasHistorial(req); resultSet.draw = req.Draw; resultSet.recordsTotal = Resultado.TotalRecords; resultSet.recordsFiltered = Resultado.SearchRecords; foreach (CajaChicaModels Item in Resultado.Lista) { var columns = new List <string>(); columns.Add(Item.FechaAperturaString); columns.Add(Item.NombreEmpleado); columns.Add(Item.MontoAperturaString); //columns.Add(Item.PersonaEntrega); columns.Add(Item.SaldoString); columns.Add(Item.TotalArqueoString); columns.Add(Item.DiferenciaString); UrlHelper urlHlp = new UrlHelper(HttpContext.Current.Request.RequestContext, RouteTable.Routes); string acciones = @" <div class='visible-md visible-lg hidden-sm hidden-xs'> <a title='Reporte' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CajaChica", action = "ReporteCajaChica", id = Item.IdCaja }) + @"' class='btn btn-green tooltips' data-placement='top' data-original-title='Reporte'><i class='fa fa-bar-chart-o'></i></a> </div> <div class='visible-xs visible-sm hidden-md hidden-lg'> <div class='btn-group'> <a class='btn btn-danger dropdown-toggle btn-sm' data-toggle='dropdown' href='#'> <i class='fa fa-cog'></i> <span class='caret'></span> </a> <ul role='menu' class='dropdown-menu pull-right dropdown-dark'> <li> <a role='menuitem' tabindex='-1' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CajaChica", action = "ReporteCajaChica", id = Item.IdCaja }) + @"'> <i class='fa fa-bar-chart-o'></i> Reporte </a> </li> </ul> </div> </div> "; columns.Add(acciones); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public JsonResult GetOrder(DataTableParameters dataTableParameters, string from, string to, string cust_id, string status) { ORDERED order = new ORDERED(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = order.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1, from, to, cust_id, status); resultSet.recordsTotal = resultSet.recordsFiltered = order.GetCount(from, to, cust_id, status); CUSTOMER cus = new CUSTOMER(); foreach (var i in lst) { END_USER end = cus.GetEndUserById(i.END_USER); var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' data-cus='" + i.CUSTOMER_ID + "' data-emp='" + i.EMP_ID + "' />"); columns.Add(i.ORDED_DATE.ToShortDateString()); columns.Add(i.CUSTOMER_ID); columns.Add(i.NAME); columns.Add(end == null ? i.NAME.Trim() : end.NAME.Trim()); columns.Add(i.ORDER_CR_HR); columns.Add(i.STS_ST_CLS); columns.Add(i.STS_ST_SER); columns.Add(i.SURFACE_CD); columns.Add(i.ORD_THK == null ? "" : Math.Round(Convert.ToDouble(i.ORD_THK), 2, MidpointRounding.ToEven).ToString()); columns.Add(i.ORD_WTH == null ? "" : Math.Round(Convert.ToDouble(i.ORD_WTH), 2, MidpointRounding.ToEven).ToString()); columns.Add(i.ORD_EDGE == null ? "" : i.ORD_EDGE.ToString()); columns.Add(i.QUANTITY == null ? "" : Math.Round(Convert.ToDouble(i.QUANTITY), 2, MidpointRounding.ToEven).ToString()); //columns.Add(i.ORD_WGT == null ? "" : i.ORD_WGT.ToString()); columns.Add(i.BASE_PRICE == null ? "" : Math.Round(Convert.ToDouble(i.BASE_PRICE), 2, MidpointRounding.ToEven).ToString()); columns.Add(i.EFFECT_PRICE == null ? "" : Math.Round(Convert.ToDouble(i.EFFECT_PRICE), 2, MidpointRounding.ToEven).ToString()); columns.Add(i.BIDD_PRICE == null ? "" : Math.Round(Convert.ToDouble(i.BIDD_PRICE), 2, MidpointRounding.ToEven).ToString()); columns.Add(i.CONTRACT_NO == null ? "" : i.CONTRACT_NO.ToString()); columns.Add(i.ORD_USAGE); columns.Add(i.ORD_STAT); columns.Add(i.EMP_NAME.Trim()); columns.Add(i.DELIVERY_TIME == null ? "" : i.DELIVERY_TIME.Trim()); columns.Add(i.REMARK == null ? "" : i.REMARK.Trim()); columns.Add(i.CREATE_AT == null ? "" : i.CREATE_AT.ToString()); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <SubCategory>(_db); var items = repo.GetItemsByExpression(w => w.CategoryId == null && w.Name.Contains(search), x => x.Name, parameters.Start, parameters.Length, out var recordsTotal).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttons = new ButtonsCategory(); foreach (var item in items) { dtResult.data.Add(new[] { item.CategoryId.ToString(), item.Name, buttons.ToPagination(item.SubCategoryId) }); } return(Json(dtResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <SubCategory>(_db); var items = repo.GetItemsByExpression(w => w.CategoryId.HasValue && w.Name.Contains(search), x => x.Name, parameters.Start, parameters.Length, out var recordsTotal, x => x.Category).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttons = new ButtonsSubCategory(); foreach (var item in items.ToList()) { dtResult.data.Add(new object[] { item.Name, $"{item.Category?.Name ?? "Não informada"}", buttons.ToPagination(item.SubCategoryId, item.ShowOnApp, Account.Current.Roles) }); } return(Json(dtResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetUsers(DataTableParameters dataTableParameters) { EmployeeManager employeeManager = EmployeeManager.GetInstance(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; List <EMPLOYEE> lst = new List <EMPLOYEE>(); if (!string.IsNullOrWhiteSpace(dataTableParameters.Search.Value)) { lst = employeeManager.Search(dataTableParameters.Search.Value); resultSet.recordsTotal = resultSet.recordsFiltered = employeeManager.GetSearchCount(dataTableParameters.Search.Value); } else { lst = employeeManager.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1); resultSet.recordsTotal = resultSet.recordsFiltered = employeeManager.GetCount(); } foreach (var i in lst) { var role = "User"; if (i.ROLE == 1) { role = "Leader"; } if (i.ROLE == 2) { role = "Admin"; } var columns = new List <string>(); columns.Add("<a class='empId' href='#' data-emp='" + i.EMP_ID.Trim() + "'>" + i.EMP_ID.Trim() + "</a>"); columns.Add((i.EMP_NAME == null) ? "" : i.EMP_NAME.Trim()); columns.Add((i.DIVISION == null) ? "" : i.DIVISION.Trim()); columns.Add((i.DEPARTMENT == null) ? "" : i.DEPARTMENT.Trim()); columns.Add((i.EMAIL == null) ? "" : i.EMAIL.Trim()); columns.Add(role); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <Event>(_db); var items = repo.GetItemsByExpression(w => w.Name.Contains(search), x => x.Name, parameters.Start, parameters.Length, out var recordsTotal, i => i.Address.City) .Select(s => new { s.EventId, s.Name, s.StartDate, s.EndDate, s.Address.City }).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttons = new ButtonsEvent(); foreach (var item in items) { dtResult.data.Add(new[]
public JsonResult GetPagination(DataTableParameters parameters, MessageStatus status) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <Message>(_db); var items = repo.GetItemsByExpression(w => w.Title.Contains(search), x => x.Title, parameters.Start, parameters.Length, out var recordsTotal).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, recordsTotal); var buttons = new ButtonsMessage(); foreach (var item in items) { dtResult.data.Add(new object[] { item.Status == MessageStatus.Unread, item.Title, EnumDescription.Get(item.Subject), buttons.ToPagination(item.MessageId, Account.Current.Roles) }); } return(Json(dtResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetPagination(DataTableParameters parameters) { var search = parameters.Search.Value?.ToLower() ?? string.Empty; var repo = new RepositoryBase <SubCategory>(_db); var items = repo.GetItemsByExpression(w => w.CategoryId != null && w.Name.Contains(search), x => x.Category).ToList(); var dtResult = new DataTableResultSet(parameters.Draw, 10); var buttons = new ButtonsSubCategory(); foreach (var item in items.ToList()) { dtResult.data.Add(new[] { item.SubCategoryId.ToString(), $"{item.Name}", $"{item.Category?.Name ?? "Não informada"}", buttons.ToPagination(item.SubCategoryId) }); } return(Json(dtResult, JsonRequestBehavior.AllowGet)); }
public JsonResult GetEmployee(DataTableParameters dataTableParameters) { EMPLOYEE em = new EMPLOYEE(); var lst = new List <EMPLOYEE>(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; if (!string.IsNullOrWhiteSpace(dataTableParameters.Search.Value)) { lst = em.Search(dataTableParameters.Search.Value); resultSet.recordsTotal = resultSet.recordsFiltered = em.GetSearchCount(dataTableParameters.Search.Value); } else { lst = em.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1); resultSet.recordsTotal = resultSet.recordsFiltered = em.GetCount(); } foreach (var i in lst) { string role = ""; if (i.ROLE == 2) { role = "Manager"; } if (i.ROLE == 3) { role = "HR"; } var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' />"); columns.Add("<img src='" + i.PICTURE + "' class='img-rounded' height='100' width='100' alt='X' />"); columns.Add(i.ID.ToString().Trim()); columns.Add(i.NAME == null ? "" : i.NAME.Trim()); columns.Add(i.DEPARTMENT == null ? "" : i.DEPARTMENT.Trim()); columns.Add(role); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetClaim(DataTableParameters dataTableParameters, string month, string cust_id, string status) { CLAIM cl = new CLAIM(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = cl.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1, month, cust_id, status); resultSet.recordsTotal = resultSet.recordsFiltered = cl.GetCount(month, cust_id, status); CUSTOMER cus = new CUSTOMER(); foreach (var i in lst) { END_USER end = cus.GetEndUserById(i.END_USER); var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.CLAIM_NO + "' data-cus='" + i.CUSTOMER_ID + "' data-emp='" + i.EMP_ID.Trim() + "' />"); columns.Add(i.CLAIM_DATE == null? "" : i.CLAIM_DATE.ToShortDateString()); columns.Add(i.NAME); columns.Add(end == null ? i.NAME : end.NAME); columns.Add(i.LOC); columns.Add(i.COIL_NO); columns.Add(i.SPEC); columns.Add(i.SURFACE_CD); columns.Add(Math.Round(Convert.ToDouble(i.COIL_THK), 2, MidpointRounding.ToEven).ToString()); columns.Add(Math.Round(Convert.ToDouble(i.COIL_WTH), 2, MidpointRounding.ToEven).ToString()); columns.Add(Math.Round(Convert.ToDouble(i.NET_WGT), 2, MidpointRounding.ToEven).ToString()); columns.Add(Math.Round(Convert.ToDouble(i.CLAIM_WGT), 2, MidpointRounding.ToEven).ToString()); columns.Add(i.VISIT_DATE == null ? "" : i.VISIT_DATE.ToShortDateString()); columns.Add(i.REMARK); columns.Add(i.DEFFECT_KIND == null ? "" : i.DEFFECT_KIND.Trim()); columns.Add(i.EMP_NAME); resultSet.data.Add(columns); } return(Json(resultSet)); }
public JsonResult GetProjectSum(DataTableParameters dataTableParameters, string from = "", string to = "") { ProjectReplyManager prj = ProjectReplyManager.GetInstance(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = prj.GetReplySummary(from, to, dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1); resultSet.recordsTotal = resultSet.recordsFiltered = prj.GetReplySumCount(from, to); foreach (var i in lst) { var columns = new List <string>(); columns.Add((i.DIVISION == null) ? "" : i.DIVISION.Trim()); columns.Add((i.DEPARTMENT == null) ? "" : i.DEPARTMENT.Trim()); columns.Add(i.IDEA_TITLE.Trim()); columns.Add((i.EMP_NAME == null) ? "" : i.EMP_NAME.Trim()); columns.Add((i.numLike == null) ? "" : i.numLike.ToString()); columns.Add((i.REP_EMP_NAME == null) ? "" : i.REP_EMP_NAME.ToString()); columns.Add((i.COMMENTS == null) ? "" : i.COMMENTS.ToString()); resultSet.data.Add(columns); } return(Json(resultSet)); }
//debug public DataTableResultSet <VotingCreditorGenerationInfo> GetDataTable(List <Dictionary <string, string> > criteria, int start, int draw) { string clientID = criteria[0]["value"]; string creditorID = criteria[1]["value"]; db.Open(); String query = @"SELECT top 10 CreditorMaster.CreditorID, CreditorMaster.CreditorName FROM CreditorMaster join ( select ROW_NUMBER() OVER (ORDER BY CreditorID) AS ROW_NUM,ClientID,CreditorID from CreditorMaster where CreditorMaster.ClientID = @ClientID and CreditorMaster.CreditorID like '%' + @CreditorID + '%' ) x on x.ClientID = CreditorMaster.ClientID and x.CreditorID = CreditorMaster.CreditorID WHERE ROW_NUM > @Start ORDER BY CreditorMaster.CreditorID"; List <VotingCreditorGenerationInfo> obj = (List <VotingCreditorGenerationInfo>)db.Query <VotingCreditorGenerationInfo>(query, new { ClientID = clientID, CreditorID = creditorID, @Start = start }); query = @"SELECT count(*) FROM CreditorMaster WHERE CreditorMaster.ClientID = @ClientID and CreditorMaster.CreditorID like '%' + @CreditorID + '%' "; List <int> countList = (List <int>)db.Query <int>(query, new { ClientID = clientID, CreditorID = creditorID, }); db.Close(); DataTableResultSet <VotingCreditorGenerationInfo> result = new DataTableResultSet <VotingCreditorGenerationInfo>(); result.data = obj; result.draw = Convert.ToInt32(draw); result.recordsFiltered = countList[0]; result.recordsTotal = countList[0]; return(result); }
public void ComprasAlmacenAjax(object parameters) { var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); int _Start = req.Start; int _Length = req.Length; string _SearchValue = req.SearchValue; int _OrderBy = -1; string _OrderDirection = string.Empty; int _TipoBusqueda = -1; if (req.Order.Count > 0) { foreach (var aux in req.Order.Keys) { _OrderBy = req.Order[aux].Column; _OrderDirection = req.Order[aux].Direction; } } foreach (var busq in req.Columns.Keys) { if (!string.IsNullOrEmpty(req.Columns[busq].SearchValue)) { _TipoBusqueda = busq; _SearchValue = req.Columns[busq].SearchValue; break; } } _CompraAlmacen_Datos Datos = new _CompraAlmacen_Datos(); CompraAlmacenModels Resultado = Datos.ObtenerGridComprasAJAX(Conexion, _Start, _Length, _SearchValue, _OrderBy, _OrderDirection); resultSet.draw = req.Draw; resultSet.recordsTotal = Resultado.TotalRecords; resultSet.recordsFiltered = Resultado.SearchRecords; foreach (CompraAlmacenModels Item in Resultado.Lista) { var columns = new List <string>(); columns.Add(Item.Sucursal.NombreSucursal); columns.Add(Item.NumFacturaNota); columns.Add(Item.Proveedor.nombreProveedor); string estatus = string.Empty; switch (Item.IDEstatusCompra) { case 1: estatus = @"<td><span class='label label-warning'>" + Item.StatusCompra + @"</span></td>"; break; case 2: estatus = @"<td><span class='label label-primary'>" + Item.StatusCompra + @"</span></td>"; break; case 3: estatus = @"<td><span class='label label-success'>" + Item.StatusCompra + @"</span></td>"; break; } columns.Add(estatus); columns.Add("<span class='pull-right'>" + Item.MontoTotalFormato + "</span>"); string acciones = "<div class='visible-md visible-lg hidden-sm hidden-xs'>"; UrlHelper urlHlp = new UrlHelper(HttpContext.Current.Request.RequestContext, RouteTable.Routes); //string aux = urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen, id2="0" }); if (Item.IDEstatusCompra == 1) { acciones += @" <a title='Editar' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Edit", id = Item.IDCompraAlmacen }) + @"' class='btn btn-yellow tooltips' data-placement='top' data-original-title='Edit'><i class='fa fa-edit'></i></a> <a title='Detalles' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen }) + @"' class='btn btn-blue tooltips' data-placement='top' data-original-title='Detalles'><i class='fa fa-bars'></i></a> <a title='Procesar' class='btn btn-primary tooltips processRow' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Process", id = Item.IDCompraAlmacen }) + @"' data-placement='top' data-original-title='Procesar'><i class='fa fa-gear'></i></a> <a title='Cancelar' class='btn btn-danger tooltips deleteRow' id='delete-" + Item.IDCompraAlmacen + @"' data-hrefa='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Cancel", id = Item.IDCompraAlmacen }) + @"' data-placement='top' data-original-title='Cancelar'><i class='fa fa-times'></i></a>"; } else { acciones += @" <label title='No se puede Editar' href='#' class='btn' style='background-color:gray;' data-placement='top' data-original-title='Edit'><i class='fa fa-edit' style='color:white'></i></label> <a title='Detalles' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen }) + @"' class='btn btn-blue tooltips' data-placement='top' data-original-title='Detalles'><i class='fa fa-bars'></i></a> <a title='Procesar' class='btn btn-primary tooltips processRow' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Process", id = Item.IDCompraAlmacen }) + @"' data-placement='top' data-original-title='Procesar'><i class='fa fa-gear'></i></a> <a title='Cancelar' class='btn btn-danger tooltips deleteRow' id='delete-" + Item.IDCompraAlmacen + @"' data-hrefa='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Cancel", id = Item.IDCompraAlmacen }) + @"' data-placement='top' data-original-title='Cancelar'><i class='fa fa-times'></i></a>"; } acciones += @" </div> <div class='visible-xs visible-sm hidden-md hidden-lg'> <div class='btn-group'> <a class='btn btn-danger dropdown-toggle btn-sm' data-toggle='dropdown' href='#'> <i class='fa fa-cog'></i> <span class='caret'></span> </a> <ul role='menu' class='dropdown-menu pull-right dropdown-dark'>"; if (Item.IDEstatusCompra == 1) { acciones += @" <li> <a role='menuitem' tabindex='-1' href = '" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Edit", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-edit'></i>Editar </a> </li> <li> <a role='menuitem' tabindex='-1' href= '" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-gears'></i> Detalles </a> </li> <li> <a role='menuitem' tabindex='-1' class='processRow' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Process", Item.IDCompraAlmacen }) + @"'> <i class='fa fa-caret-square-o-right'></i> Procesar </a> </li> <li> <a role='menuitem' tabindex='-1' class='deleteRow' id='delete-" + Item.IDCompraAlmacen + @"' data-hrefa='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Delete", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-trash-o'></i> Eliminar </a> </li>"; } else { acciones += @" <li> <a role='menuitem' tabindex='-1' href='#'> <i class='fa fa-edit'></i> No se puede editar </a> </li> <li> <a role='menuitem' tabindex='-1' href= '" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-gears'></i> Detalles </a> </li> <li> <a role='menuitem' tabindex='-1' class='processRow' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Process", Item.IDCompraAlmacen }) + @"'> <i class='fa fa-caret-square-o-right'></i> Procesar </a> </li> <li> <a role='menuitem' tabindex='-1' class='deleteRow' id='delete-" + Item.IDCompraAlmacen + @"' data-hrefa='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Delete", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-trash-o'></i> Eliminar </a> </li>"; } acciones += @"</ul></div></div>"; columns.Add(acciones); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public ActionResult IndexAjax(object data) { try { var req = DataTableParameters.Get(data); var resultSet = new DataTableResultSet(); int _Start = req.Start; int _Length = req.Length; string _SearchValue = req.SearchValue; int _OrderBy = -1; string _OrderDirection = string.Empty; int _TipoBusqueda = -1; if (req.Order.Count > 0) { foreach (var aux in req.Order.Keys) { _OrderBy = req.Order[aux].Column; _OrderDirection = req.Order[aux].Direction; } } foreach (var busq in req.Columns.Keys) { if (!string.IsNullOrEmpty(req.Columns[busq].SearchValue)) { _TipoBusqueda = busq; _SearchValue = req.Columns[busq].SearchValue; break; } } _CompraAlmacen_Datos Datos = new _CompraAlmacen_Datos(); CompraAlmacenModels Resultado = Datos.ObtenerGridComprasAJAX(Conexion, _Start, _Length, _SearchValue, _OrderBy, _OrderDirection); resultSet.draw = req.Draw; resultSet.recordsTotal = Resultado.TotalRecords; resultSet.recordsFiltered = Resultado.SearchRecords; foreach (CompraAlmacenModels Item in Resultado.Lista) { var columns = new List <string>(); columns.Add(Item.Sucursal.NombreSucursal); columns.Add(Item.NumFacturaNota); columns.Add(Item.Proveedor.nombreProveedor); string estatus = string.Empty; switch (Item.IDEstatusCompra) { case 1: estatus = @"<td><span class='label label-warning'>" + Item.StatusCompra + @"</span></td>"; break; case 2: estatus = @"<td><span class='label label-primary'>" + Item.StatusCompra + @"</span></td>"; break; case 3: estatus = @"<td><span class='label label-success'>" + Item.StatusCompra + @"</span></td>"; break; } columns.Add(estatus); string acciones = @""; columns.Add(acciones); resultSet.data.Add(columns); } return(Json(resultSet.ToJSON())); } catch (Exception ex) { TempData["typemessage"] = "2"; TempData["message"] = "No se pudo borrar los datos. Por favor contacte a soporte técnico"; return(Json("")); } }
public static void GetData(object parameters) { try { // Initialization. var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); List <Book> data = getBookList(); resultSet.draw = req.Draw; resultSet.recordsTotal = data.Count(); string search = req.SearchValue; int order = req.Order.Values.ElementAt(0).Column; string orderDirection = req.Order.Values.ElementAt(0).Direction; int startRec = req.Start; int pageSize = req.Length; //Search if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search)) { // Apply search List <Book> searchResults = new List <Book>(); foreach (Book b in data) { if ( Utilities.containsStr(search, b.item_id.ToString()) || Utilities.containsStr(search, b.title) || Utilities.containsStr(search, b.author) || Utilities.containsStr(search, b.publisher) || Utilities.containsStr(search, b.publication_year.ToString()) || Utilities.containsStr(search, b.assn.ToString()) || Utilities.containsStr(search, b.isbn_10) || Utilities.containsStr(search, b.isbn_13) ) { searchResults.Add(b); } } data = searchResults; } resultSet.recordsFiltered = data.Count(); //Sorting data = SortByColumnWithOrder(order, orderDirection, data); // Apply pagination. data = data.Skip(startRec).Take(pageSize).ToList(); foreach (Book m in data) { var columns = new List <string>(); columns.Add(m.item_id.ToString()); columns.Add(m.assn.ToString()); columns.Add(m.title); columns.Add(m.author); columns.Add(m.category); columns.Add(m.publisher); columns.Add(m.publication_year.ToString()); columns.Add("<button id=" + m.item_id.ToString() + " class='mdl-button mdl-js-button mdl-button--icon' onClick='editBook(event); return false' title ='Edit'><i class= 'material-icons'>edit</i></button>" ); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); } catch (Exception ex) { // Info Console.Write(ex); } // Return info. }
public static void GetData(object parameters) { try { // Initialization. var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); List <Member> data = Utilities.getMemberList(); resultSet.draw = req.Draw; resultSet.recordsTotal = data.Count(); string search = req.SearchValue; int order = req.Order.Values.ElementAt(0).Column; string orderDirection = req.Order.Values.ElementAt(0).Direction; int startRec = req.Start; int pageSize = req.Length; //Search if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search)) { // Apply search List <Member> searchResults = new List <Member>(); foreach (Member m in data) { if ( Utilities.containsStr(search, m.member_id.ToString()) || Utilities.containsStr(search, m.last_name) || Utilities.containsStr(search, m.first_name) || Utilities.containsStr(search, m.guardian_name) || Utilities.containsStr(search, m.phone) || Utilities.containsStr(search, m.email) ) { searchResults.Add(m); } } data = searchResults; } resultSet.recordsFiltered = data.Count(); //Sorting data = SortByColumnWithOrder(order, orderDirection, data); // Apply pagination. data = data.Skip(startRec).Take(pageSize).ToList(); foreach (Member m in data) { var columns = new List <string>(); columns.Add(m.member_id.ToString()); columns.Add(m.last_name); columns.Add(m.first_name); columns.Add(m.phone); columns.Add(m.email); columns.Add(m.guardian_name); columns.Add(m.restricted_to_tech.ToString()); columns.Add("<button id=" + m.member_id.ToString() + " class='mdl-button mdl-js-button mdl-button--icon' onClick='editMember(event); return false' title ='Edit'><i class= 'material-icons'>edit</i></button>" ); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); } catch (Exception ex) { // Info Console.Write(ex); } // Return info. }