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.
}
