public ActionResult TeamStandings(jQueryDataTableParamModel param)
{
int matchRound = param.MatchRound;
if (matchRound <= 0)
{
matchRound = DEFAULT_MATCH_ROUND;
}
var seriesStandings = _repository.GetSeriesStandingsWithResults(param.SeriesId, param.Season, matchRound);
var result = from c in seriesStandings
select new[]
{
Convert.ToString(c.Position), c.TeamName,
c.Played.ToString(), c.Won.ToString(), c.Drawn.ToString(), c.Lost.ToString(),
c.GoalsScored.ToString(), c.GoalsConceded.ToString(), c.GoalDifference.ToString(),
c.TotalPoints.ToString(), GetForm(c.Results)
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = seriesStandings.Count,
iTotalDisplayRecords = seriesStandings.Count,
aaData = result
},
JsonRequestBehavior.AllowGet);
}
/// <summary>
/// Implements the ajax call to populate the dinners grid.
/// </summary>
/// <param name="param">
/// The param.
/// </param>
/// <returns>
/// JSON data for the grid
/// </returns>
public ActionResult AjaxHandlerDinner(jQueryDataTableParamModel param)
{
var sortDirection = Request["sSortDir_0"];
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
var sortColumn = param.sColumns.Split(',')[sortColumnIndex];
if (sortColumnIndex == 0)
{
sortColumn = "DinnerId";
}
var filter = param.sSearch;
var dinnerSet = this._nerdDinnerService.GetFilteredDinners(
param.iDisplayStart, param.iDisplayLength, sortDirection, sortColumn, filter);
var dinnersToReturn = from d in dinnerSet.Dinners
select
new[]
{
Convert.ToString(d.DinnerId), this.AttendButtonHtml(d.DinnerId), d.Title, d.Address, d.EventDate.ToShortDateString(), d.Country,
};
var result =
Json(
new
{
sEcho = param.sEcho,
iTotalRecords = dinnerSet.TotalDinnerCount,
iTotalDisplayRecords = dinnerSet.FilteredDinnerCount,
aaData = dinnersToReturn,
},
JsonRequestBehavior.AllowGet);
return result;
}
public static object GetExchangeCompanies()
{
jQueryDataTableParamModel param = new jQueryDataTableParamModel();
HttpContext Context = HttpContext.Current;
param.sEcho = String.IsNullOrEmpty(Context.Request["sEcho"]) ? 0 : Convert.ToInt32(Context.Request["sEcho"]);
param.sSearch = String.IsNullOrEmpty(Context.Request["sSearch"]) ? "" : Context.Request["sSearch"];
param.iDisplayStart = String.IsNullOrEmpty(Context.Request["iDisplayStart"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayStart"]);
param.iDisplayLength = String.IsNullOrEmpty(Context.Request["iDisplayLength"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayLength"]);
var sortColumnIndex = Convert.ToInt32(Context.Request["iSortCol_0"]);
var sortDirection = Context.Request["sSortDir_0"]; // asc or desc
List <ExchangeCompanies_SelectRowResult> categoryList = new List <ExchangeCompanies_SelectRowResult>();
IEnumerable <ExchangeCompanies_SelectRowResult> filtereExchangeCompanies;
categoryList = new ExchangeCompaniesManager().GetExchangeCompanies("");
HttpContext.Current.Cache.Insert("ExchangeCompanies", categoryList, null, Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(10));
// check for search param
if (!String.IsNullOrEmpty(param.sSearch))
{
filtereExchangeCompanies = categoryList.Where(c => c.ExchangeCompanyNameEn.ToLower().Contains(param.sSearch.ToLower()) ||
c.ExchangeCompanyNameAr.ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filtereExchangeCompanies = categoryList;
}
// handle asc and desc operation
Func <ExchangeCompanies_SelectRowResult, string> orderingFunction = (c => sortColumnIndex == 1 ? c.ExchangeCompanyNameEn :
sortColumnIndex == 2 ? c.ExchangeCompanyNameAr.ToString() : "");
if (sortDirection == "asc")
{
filtereExchangeCompanies = filtereExchangeCompanies.OrderBy(orderingFunction);
}
else
{
filtereExchangeCompanies = filtereExchangeCompanies.OrderByDescending(orderingFunction);
}
//paginate our result
var result = filtereExchangeCompanies.Select(c => new
{
ExchangeCompanyID = c.ExchangeCompanyID,
ExchangeCompanyNameEn = c.ExchangeCompanyNameEn,
ExchangeCompanyNameAr = c.ExchangeCompanyNameAr,
Rate = c.Rate
}).Skip(param.iDisplayStart).Take(param.iDisplayLength);
// Our last
var data = new
{
sEcho = param.sEcho,
iTotalRecords = categoryList.Count(),
iTotalDisplayRecords = filtereExchangeCompanies.Count(),
aaData = result
};
return(data);
}
/// <summary>
/// Implements the ajax call to populate the rsvp grid.
/// </summary>
/// <param name="param">
/// The param.
/// </param>
/// <param name="dinnerId">
/// The o containing dinnerid.
/// </param>
/// <returns>
/// JSON data for the grid
/// </returns>
public ActionResult AjaxHandlerRsvp(jQueryDataTableParamModel param, int dinnerId)
{
var sortDirection = Request["sSortDir_0"];
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
var sortColumn = param.sColumns.Split(',')[sortColumnIndex];
if (sortColumnIndex == 0)
{
sortColumn = "AttendeeEmail";
}
var filter = param.sSearch;
var rsvpSet = this._nerdDinnerService.GetRsvps(dinnerId, param.iDisplayStart, param.iDisplayLength, sortDirection, sortColumn, filter);
var rsvpsToReturn = from d in rsvpSet.Rsvps
select
new[]
{
d.AttendeeEmail,
};
var result =
Json(
new
{
sEcho = param.sEcho,
iTotalRecords = rsvpSet.TotalRsvpCount,
iTotalDisplayRecords = rsvpSet.FilteredRsvpCount,
aaData = rsvpsToReturn,
},
JsonRequestBehavior.AllowGet);
return result;
}
public ActionResult IndexAjax(jQueryDataTableParamModel param)
{
var list = db.Korisnik.ToList();
IEnumerable <Korisnik> filteredList;
var FIdKorisnik = Convert.ToString(Request["sSearch_0"]).ToLower();
var FKorisnickoIme = Convert.ToString(Request["sSearch_1"]).ToLower();
var FDatumKreiranja = Convert.ToString(Request["sSearch_2"]).ToLower();
var FPoslednjaPrijava = Convert.ToString(Request["sSearch_3"]).ToLower();
var FIPAdresa = Convert.ToString(Request["sSearch_4"]).ToLower();
var FZapisAktivan = Convert.ToString(Request["sSearch_5"]).ToLower();
var FRole = Convert.ToString(Request["sSearch_6"]).ToLower();
filteredList = list.Where(c =>
(String.IsNullOrEmpty("" + c.IdKorisnik) ? "" : "" + c.IdKorisnik).ToLower().Contains(FIdKorisnik) &&
(String.IsNullOrEmpty("" + c.KorisnickoIme) ? "" : "" + c.KorisnickoIme).ToLower().Contains(FKorisnickoIme) &&
(String.IsNullOrEmpty("" + c.DatumKreiranja) ? "" : "" + c.DatumKreiranja).ToLower().Contains(FDatumKreiranja) &&
(String.IsNullOrEmpty("" + c.PoslednjaPrijava) ? "" : "" + c.PoslednjaPrijava).ToLower().Contains(FPoslednjaPrijava) &&
(String.IsNullOrEmpty("" + c.IPAdresa) ? "" : "" + c.IPAdresa).ToLower().Contains(FIPAdresa) &&
((c.ZapisAktivan ?? false) ? "DA" : "NE").ToLower().Contains(FZapisAktivan) &&
(String.IsNullOrEmpty("" + c.Ime) ? "" : "" + c.Ime).ToLower().Contains(FRole)
);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredList = filteredList.Where(c =>
(String.IsNullOrEmpty("" + c.IdKorisnik) ? "" : "" + c.IdKorisnik).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.KorisnickoIme) ? "" : "" + c.KorisnickoIme).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.DatumKreiranja) ? "" : "" + c.DatumKreiranja).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.PoslednjaPrijava) ? "" : "" + c.PoslednjaPrijava).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.IPAdresa) ? "" : "" + c.IPAdresa).ToLower().Contains(param.sSearch.ToLower()) ||
((c.ZapisAktivan ?? false) ? "DA" : "NE").ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.Ime) ? "" : "" + c.Ime).ToLower().Contains(param.sSearch.ToLower())
);
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <Korisnik, object> orderingFunction = c =>
{
switch (sortColumnIndex)
{
case 0: return(c.IdKorisnik);
case 1: return(c.KorisnickoIme);
case 2: return(c.DatumKreiranja);
case 3: return(c.PoslednjaPrijava);
case 4: return(c.IPAdresa);
case 5: return(c.ZapisAktivan);
case 6: return(c.Ime);
default: return(c.IdKorisnik);
}
};
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredList = filteredList.OrderBy(orderingFunction);
}
else
{
filteredList = filteredList.OrderByDescending(orderingFunction);
}
var displayedList = filteredList.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedList select new object[] {
c.IdKorisnik,
c.KorisnickoIme,
String.IsNullOrEmpty("" + c.DatumKreiranja) ? "" : DateTime.Parse(c.DatumKreiranja.ToString()).ToString("dd.MM.yyyy"),
String.IsNullOrEmpty("" + c.PoslednjaPrijava) ? "" : DateTime.Parse(c.PoslednjaPrijava.ToString()).ToString("dd.MM.yyyy"),
c.IPAdresa,
(c.ZapisAktivan ?? false) ? "DA" : "NE",
c.Ime,
""
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = filteredList.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public BaseResponse <List <CustomerDto> > GetAll(jQueryDataTableParamModel filters)
{
IEnumerable <CustomerDto> customersList = new List <CustomerDto>();
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("Usp_GetAllCustomers", con))
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
var dt = new DataTable();
dt.Load(cmd.ExecuteReader());
customersList = (from DataRow row in dt.Rows
select new CustomerDto
{
CustomerName = row["CustomerName"].ToString(),
ContributionNumber = row["ContributionNumber"].ToString(),
StartCreditPeriod = Convert.ToDateTime(row["StartCreditPeriod"].ToString()),
EndCreditPeriod = Convert.ToDateTime(row["EndCreditPeriod"].ToString()),
CompanyName = row["CompanyName"].ToString(),
Address = row["Address"].ToString(),
Id = Convert.ToInt32(row["Id"].ToString()),
PhoneNumber = Int32.Parse(row["PhoneNumber"].ToString()),
DGEApproved = Convert.ToBoolean(row["DGEApproved"].ToString())
});
var d = dt;
con.Close();
}
}
IEnumerable <CustomerDto> filteredCustomers;
#region Searching
if (!string.IsNullOrEmpty(filters.sSearch))
{
filteredCustomers = customersList
.Where(c => c.CompanyName.ToLower().Contains(filters.sSearch.ToLower()) ||
c.CustomerName.ToLower().Contains(filters.sSearch.ToLower()) ||
c.ContributionNumber.ToLower().Contains(filters.sSearch.ToLower()) ||
c.StartCreditPeriod.ToString().Contains(filters.sSearch.ToLower()) ||
c.EndCreditPeriod.ToString().Contains(filters.sSearch.ToLower()) ||
c.Address.ToLower().Contains(filters.sSearch.ToLower()) ||
c.DGEApproved.ToString().Contains(filters.sSearch.ToLower()) ||
c.PhoneNumber.ToString().Contains(filters.sSearch));
}
else
{
filteredCustomers = customersList;
}
#endregion
#region Sorting
Func <CustomerDto, string> orderingFunction = (c => filters.iSortColIndx == 0 ? c.CustomerName :
filters.iSortColIndx == 1 ? c.ContributionNumber :
filters.iSortColIndx == 2 ? c.StartCreditPeriod.ToString() :
filters.iSortColIndx == 3 ? c.EndCreditPeriod.ToString() :
filters.iSortColIndx == 4 ? c.Address :
filters.iSortColIndx == 5 ? c.CompanyName :
filters.iSortColIndx == 6 ? c.PhoneNumber.ToString() :
c.DGEApproved.ToString()
);
if (filters.iSortColDir == "asc")
{
filteredCustomers = filteredCustomers.OrderBy(orderingFunction);
}
else
{
filteredCustomers = filteredCustomers.OrderByDescending(orderingFunction);
}
#endregion
return(new BaseResponse <List <CustomerDto> >
{
Message = "Success",
Success = true,
Data = filteredCustomers.Skip(filters.iDisplayStart).Take(filters.iDisplayLength).ToList()
});
}
public JsonResult DataTable_SelectGroups(jQueryDataTableParamModel param, List <String> SubjectID = null, List <String> Class = null, List <int> Group = null, String Search = null)
{
if (SubjectID != null && Class != null && Group != null)
{
OutputHelper.SaveGroups(SubjectID, Class, Group, false);
}
Dictionary <String, Group> dbGroups = Clone.Dictionary <String, Group>((Dictionary <String, Group>)(CurrentSession.Get("Groups") ?? InputHelper.Groups));
var Groups = from m in dbGroups.Values.Where(g => !g.IsIgnored) select m;
var total = Groups.Count();
if (!string.IsNullOrEmpty(Search))
{
Groups = Groups.Where(m => m.MaMonHoc.ToLower().Contains(Search.ToLower()) || m.TenMonHoc.ToLower().Contains(Search.ToLower()));
}
var Result = new List <string[]>();
foreach (var su in Groups.OrderBy(m => m.TenMonHoc).Skip(param.iDisplayStart).Take(param.iDisplayLength))
{
Result.Add(new string[] {
su.MaMonHoc,
su.TenMonHoc,
su.TenBoMon,
su.TenKhoa,
su.Nhom.ToString(),
su.SoLuongDK.ToString(),
su.GroupID.ToString(),
//"Xoá"
}
);
}
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = total,
iTotalDisplayRecords = Groups.Count(),
//iTotalDisplayedRecords = Subjects.Count(),
aaData = Result
},
JsonRequestBehavior.AllowGet
));
//if (SubjectID != null && Class != null && Group != null)
//{
// OutputHelper.SaveGroups(SubjectID, Class, Group, false);
//}
//Dictionary<String, Group> dbGroups = Clone.Dictionary<String, Group>((Dictionary<String, Group>)(CurrentSession.Get("Groups") ?? InputHelper.Groups));
//var Groups = from m in dbGroups.Values.Where(g => !g.IsIgnored) select m;
//var total = Groups.Count();
//if (!string.IsNullOrEmpty(Search))
//{
// Groups = Groups.Where(m => m.MaMonHoc.ToLower().Contains(Search.ToLower()) || m.TenMonHoc.ToLower().Contains(Search.ToLower()));
//}
//var Result = new List<string[]>();
//var MH = (from m in InputHelper.db.This
// select new
// {
// MaMonHoc = m.MaMonHoc,
// Nhom = m.Nhom,
// });
//Dictionary<String, List<String>> CheckMH = new Dictionary<string, List<string>>();
//foreach (var m in MH)
//{
// if (CheckMH.ContainsKey(m.MaMonHoc))
// CheckMH[m.MaMonHoc].Add(m.Nhom);
// else
// CheckMH.Add(m.MaMonHoc, new List<String> { m.Nhom });
//}
//foreach (var su in Groups.OrderBy(m => m.TenMonHoc))
//{
// if (CheckMH.ContainsKey(su.MaMonHoc))
// {
// if (!CheckGroup(CheckMH[su.MaMonHoc], su.Nhom.ToString()))
// {
// Result.Add(new string[] {
// su.MaMonHoc,
// su.TenMonHoc,
// su.TenBoMon,
// su.TenKhoa,
// su.Nhom.ToString(),
// su.SoLuongDK.ToString(),
// su.GroupID.ToString(),
// }
// );
// }
// }
// else
// {
// Result.Add(new string[] {
// su.MaMonHoc,
// su.TenMonHoc,
// su.TenBoMon,
// su.TenKhoa,
// su.Nhom.ToString(),
// su.SoLuongDK.ToString(),
// su.GroupID.ToString(),
// }
// );
// }
//}
//return Json(new
// {
// sEcho = param.sEcho,
// iTotalRecords = total,
// iTotalDisplayRecords = Result.Count(),
// //iTotalDisplayedRecords = Subjects.Count(),
// aaData = Result.Skip(param.iDisplayStart).Take(param.iDisplayLength)
// },
// JsonRequestBehavior.AllowGet
// );
}
public ActionResult AjaxGetAllClaimNosLookUp(jQueryDataTableParamModel param)
{
ClaimTeamLoginModel login = Session[SessionHelper.claimTeamLogin] as ClaimTeamLoginModel;
claimServices = new ClaimServices();
List <CRMPicklistItem> items = new List <CRMPicklistItem>();
if (!string.IsNullOrEmpty(param.sSearch))
{
items = claimServices.GetAllOpenClaims(param.sSearch, login.Teams);
//if (items != null)
// items = items.Where(x => x.Text.ToLower().Contains(param.sSearch.ToLower())).ToList();
}
IEnumerable <CRMPicklistItem> filteredRecords = items;
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <CRMPicklistItem, string> orderingFunction = (c => sortColumnIndex == 1 ? c.Code :
sortColumnIndex == 2 ? c.Text :
sortColumnIndex == 3 ? c.Order :
c.Text);
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredRecords = filteredRecords.OrderBy(orderingFunction);
}
else
{
filteredRecords = filteredRecords.OrderByDescending(orderingFunction);
}
//if (!string.IsNullOrEmpty(param.sSearch))
//{
// filteredRecords = filteredRecords
// .Where(c => c.Text.ToUpper().Contains(param.sSearch.ToUpper()));
// // ||
// // c.Town.Contains(param.sSearch));
//}
List <string[]> aData = new List <string[]>();
foreach (CRMPicklistItem item in filteredRecords)
{
string[] arry = new string[] { item.Code, item.Text };
aData.Add(arry);
}
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = 97,
iTotalDisplayRecords = 3,
aaData = aData
},
JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxHandlerCategory(jQueryDataTableParamModel param)
{
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]); // sort column index
Func <Category, string> orderingFunction = (c => sortColumnIndex == 0 ? c.CategoryName.TrimEnd().TrimStart().ToLower() :
sortColumnIndex == 1 ? ((c.CategoryDescription != null) ? c.CategoryDescription.TrimEnd().TrimStart().ToLower() : "-") :
sortColumnIndex == 2 ? (c.Status.ToString()) :
c.CategoryName.ToLower());
var sortDirection = Request["sSortDir_0"]; // sort column direction
IEnumerable <Category> filterCategory = null;
/// search action
if (!string.IsNullOrEmpty(param.sSearch))
{
filterCategory = from cat in db.Categories
where cat.CategoryName.ToLower().Contains(param.sSearch.ToLower()) ||
cat.CategoryDescription.ToLower().Contains(param.sSearch.ToLower())
select cat;
}
else
{
filterCategory = from cat in db.Categories
orderby cat.CategoryName.ToLower()
select cat;
}
// ordering action
if (sortColumnIndex == 3)
{
filterCategory = (sortDirection == "asc") ? filterCategory.OrderBy(grp => grp.CreationDate) : filterCategory.OrderByDescending(grp => grp.CreationDate);
}
else
if (sortDirection == "asc")
{
filterCategory = filterCategory.OrderBy(orderingFunction);
}
else if (sortDirection == "desc")
{
filterCategory = filterCategory.OrderByDescending(orderingFunction);
}
filterCategory = filterCategory.Where(x => x.IsDeleted == false).ToList();
// records to display
var displayedCategory = filterCategory.Skip(param.iDisplayStart).Take(param.iDisplayLength);
if (param.iDisplayLength == -1)
{
displayedCategory = filterCategory;
}
var ActiveStatus = LMSResourse.Common.Common.lblActiveStatus;
var InactiveStatus = LMSResourse.Common.Common.lblInactiveStatus;
var result = from obj in displayedCategory.ToList()
select new[] {
obj.CategoryName,
((obj.CategoryDescription == null)?"-": obj.CategoryDescription),
((obj.Status)?ActiveStatus :InactiveStatus),
string.Format("{0:dd/MM/yyyy HH:mm}", obj.CreationDate),
Convert.ToString(obj.CategoryId)
};
//return json data.
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = filterCategory.Count(),
iTotalDisplayRecords = filterCategory.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public ActionResult RetornarUsuarios(jQueryDataTableParamModel param)
{
var listGrupo = _grupoAppService.GetAll();
IEnumerable <Usuario> list;
if (string.IsNullOrEmpty(param.sSearch))
{
list = _usuarioAppService.GetAll();
}
else
{
list = _usuarioAppService.GetByFilter(p => p.NomeUsuario.ToUpper().Contains(param.sSearch.ToUpper()));
}
IEnumerable <Usuario> filteredCompanies = list;
Func <Usuario, string> orderingFunctionString;
Func <Usuario, decimal> orderingFunctionDecimal;
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
var sortDirection = Request["sSortDir_0"];
if (sortColumnIndex == 4)
{
orderingFunctionDecimal = (c => sortColumnIndex == 4 ? c.IdGrupo : c.IdUsuario);
if (sortDirection == "asc")
{
filteredCompanies = filteredCompanies.OrderBy(orderingFunctionDecimal);
}
else
{
filteredCompanies = filteredCompanies.OrderByDescending(orderingFunctionDecimal);
}
}
else
{
orderingFunctionString = (c => sortColumnIndex == 0 ? c.NomeUsuario :
sortColumnIndex == 1 ? c.EmailUsuario :
sortColumnIndex == 2 ? c.EmailUsuario :
sortColumnIndex == 4 ? listGrupo.FirstOrDefault(p => p.GrupoID == c.IdGrupo).Descricao :
sortColumnIndex == 5 ? c.FlAtivo ? "Sim" : "Não" : c.NomeUsuario);
if (sortDirection == "asc")
{
filteredCompanies = filteredCompanies.OrderBy(orderingFunctionString);
}
else
{
filteredCompanies = filteredCompanies.OrderByDescending(orderingFunctionString);
}
}
var displayedCompanies = filteredCompanies;
var result = from c in displayedCompanies
select
new[]
{
c.NomeUsuario //0
, c.LoginUsuario //1
, listGrupo.FirstOrDefault(p => p.GrupoID == c.IdGrupo).Descricao //2
, c.EmailUsuario //3
, c.SenhaUsuario.ToString() //4
//, listEmpresa.FirstOrDefault(p => p.IdUsuarioEmpresa == c.IdUsuarioEmpresa).NomeEmpresa
, c.FlAtivo ? "Sim" : "Não" //5
, c.IdUsuario.ToString() //6
, c.IdGrupo.ToString() //7
//,c.IdUsuarioEmpresa.ToString()
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = filteredCompanies.Count(),
aaData = result.Skip(param.iDisplayStart).Take(param.iDisplayLength)
}, JsonRequestBehavior.AllowGet));
}
//
public ActionResult IndexAjax(jQueryDataTableParamModel param)
{
var list = db.Ponuda.Include(d => d.Subjekt).Include(c => c.Valuta).ToList();
IEnumerable <Ponuda> filteredList = list;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredList = filteredList.Where(c =>
(
(String.IsNullOrEmpty("" + c.SerijskiBroj) ? "" : "" + c.SerijskiBroj).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.DatumDnevnika) ? "" : "" + c.DatumDnevnika.Value.ToShortDateString()).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.Subjekt.Naziv) ? "" : "" + c.Subjekt.Naziv).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.UtovarGrad) ? "" : "" + c.UtovarGrad + c.UtovarPTT + c.UtovarDrzava).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.IstovarGrad) ? "" : "" + c.IstovarGrad + c.IstovarPTT + c.IstovarDrzava).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.CijenaPrevoza) ? "" : "" + c.CijenaPrevoza + c.Valuta.OznakaValute).ToLower().Contains(param.sSearch.ToLower())
));
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <Ponuda, object> orderingFunction = c =>
{
switch (sortColumnIndex)
{
case 0: return(c.SerijskiBroj.Length == 10 ? c.SerijskiBroj.Replace("-", "-0") : c.SerijskiBroj);
case 1: return(c.DatumDnevnika.Value.ToShortDateString());
case 2: return(c.Subjekt.Naziv);
case 3: return(c.UtovarPTT + " " + c.UtovarGrad + " / " + c.UtovarDrzava);
case 4: return(c.IstovarPTT + " " + c.IstovarGrad + " / " + c.IstovarDrzava);
case 5: return(c.CijenaPrevoza + " " + c.Valuta.OznakaValute);
default: return(c.IdDnevnik);
}
};
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredList = filteredList.OrderBy(orderingFunction);
}
else
{
filteredList = filteredList.OrderByDescending(orderingFunction);
}
var displayedList = filteredList.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedList select new object[] {
c.SerijskiBroj,
c.DatumDnevnika.Value.ToShortDateString(),
c.Subjekt.Naziv,
c.UtovarPTT + " " + c.UtovarGrad + " / " + c.UtovarDrzava,
c.IstovarPTT + " " + c.IstovarGrad + " / " + c.IstovarDrzava,
c.CijenaPrevoza + " " + c.Valuta.OznakaValute,
c.IdDnevnik
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = filteredList.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public ActionResult IndexAjax(jQueryDataTableParamModel param)
{
var list = db.KorisnikUpit.ToList();
IEnumerable <KorisnikUpit> filteredList;
var FUtovar = Convert.ToString(Request["sSearch_0"]).ToLower();
var FIstovar = Convert.ToString(Request["sSearch_1"]).ToLower();
var FKolicinaRobe = Convert.ToString(Request["sSearch_2"]).ToLower();
var FVrijednostRobe = Convert.ToString(Request["sSearch_3"]).ToLower();
var FVrstaRobe = Convert.ToString(Request["sSearch_4"]).ToLower();
var FDatumUtovara = Convert.ToString(Request["sSearch_5"]).ToLower();
var FDatumIstovara = Convert.ToString(Request["sSearch_6"]).ToLower();
var FImeKorisnika = Convert.ToString(Request["sSearch_7"]).ToLower();
var FEmail = Convert.ToString(Request["sSearch_8"]).ToLower();
var FTelefon = Convert.ToString(Request["sSearch_9"]).ToLower();
filteredList = list.Where(c =>
(String.IsNullOrEmpty("" + c.Utovar) ? "" : "" + c.Utovar).ToLower().Contains(FUtovar) &&
(String.IsNullOrEmpty("" + c.Istovar) ? "" : "" + c.Istovar).ToLower().Contains(FIstovar) &&
(String.IsNullOrEmpty("" + c.KolicinaRobe) ? "" : "" + c.KolicinaRobe).ToLower().Contains(FKolicinaRobe) &&
(String.IsNullOrEmpty("" + c.VrijednostRobe) ? "" : "" + c.VrijednostRobe).ToLower().Contains(FVrijednostRobe) &&
(String.IsNullOrEmpty("" + c.VrstaRobe) ? "" : "" + c.VrstaRobe).ToLower().Contains(FVrstaRobe) &&
(String.IsNullOrEmpty("" + c.DatumUtovara) ? "" : "" + c.DatumUtovara).ToLower().Contains(FDatumUtovara) &&
(String.IsNullOrEmpty("" + c.DatumIstovara) ? "" : "" + c.DatumIstovara).ToLower().Contains(FDatumIstovara) &&
(String.IsNullOrEmpty("" + c.ImeKorisnika) ? "" : "" + c.ImeKorisnika).ToLower().Contains(FImeKorisnika) &&
(String.IsNullOrEmpty("" + c.Email) ? "" : "" + c.Email).ToLower().Contains(FEmail) &&
(String.IsNullOrEmpty("" + c.Telefon) ? "" : "" + c.Telefon).ToLower().Contains(FTelefon)
);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredList = filteredList.Where(c =>
(String.IsNullOrEmpty("" + c.Utovar) ? "" : "" + c.Utovar).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.Istovar) ? "" : "" + c.Istovar).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.KolicinaRobe) ? "" : "" + c.KolicinaRobe).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.VrijednostRobe) ? "" : "" + c.VrijednostRobe).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.VrstaRobe) ? "" : "" + c.VrstaRobe).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.DatumUtovara) ? "" : "" + c.DatumUtovara).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.DatumIstovara) ? "" : "" + c.DatumIstovara).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.ImeKorisnika) ? "" : "" + c.ImeKorisnika).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.Email) ? "" : "" + c.Email).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.Telefon) ? "" : "" + c.Telefon).ToLower().Contains(param.sSearch.ToLower())
);
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <KorisnikUpit, object> orderingFunction = c =>
{
switch (sortColumnIndex)
{
case 0: return(c.Utovar);
case 1: return(c.Istovar);
case 2: return(c.KolicinaRobe);
case 3: return(c.VrijednostRobe);
case 4: return(c.VrstaRobe);
case 5: return(c.DatumUtovara);
case 6: return(c.DatumIstovara);
case 7: return(c.ImeKorisnika);
case 8: return(c.Email);
case 9: return(c.Telefon);
default: return(c.Utovar);
}
};
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredList = filteredList.OrderBy(orderingFunction);
}
else
{
filteredList = filteredList.OrderByDescending(orderingFunction);
}
var displayedList = filteredList.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedList select new object[] {
c.Utovar,
c.Istovar,
c.KolicinaRobe,
c.VrijednostRobe,
c.VrstaRobe,
c.DatumUtovara.HasValue ? c.DatumUtovara.Value.ToShortDateString() : "",
c.DatumIstovara.HasValue ? c.DatumIstovara.Value.ToShortDateString() : "",
c.ImeKorisnika,
c.Email,
c.Telefon,
c.IdKorisnikUpit
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = filteredList.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult RetornarDadosRecepcao(jQueryDataTableParamModel param)
{
var listTipoDocumento = _tipoDocumentoServiceAppService.GetAll();
var listTipoOperacao = _tipoOperacaoServiceAppService.GetAll();
var listProduto = _produtoserviceAppService.GetAll();
IEnumerable <Operacao> list;
//if (string.IsNullOrEmpty(param.sSearch))
list = _operacaoServiceAppService.GetAll();
//else
// list = _operacaoServiceAppService.GetByFilter(p => p.NomeUsuario.ToUpper().Contains(param.sSearch.ToUpper()));
int tamanho = list.Count();
Func <Operacao, string> orderingFunctionString;
Func <Operacao, decimal> orderingFunctionDecimal;
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
var sortDirection = Request["sSortDir_0"];
if (sortColumnIndex == 4)
{
orderingFunctionDecimal = (c => sortColumnIndex == 4 ? c.CodigoEtapa ?? 0 : c.CodigoOperacaoEtapa);
if (sortDirection == "asc")
{
list = list.OrderBy(orderingFunctionDecimal);
}
else
{
list = list.OrderByDescending(orderingFunctionDecimal);
}
}
else
{
orderingFunctionString = (c => sortColumnIndex == 0 ? c.Data.ToString("dd/mm/yyyy") :
sortColumnIndex == 1 ? c.SEDEX_AR :
sortColumnIndex == 2 ? c.Colaborador :
sortColumnIndex == 3 ? c.Contrato.ToString() :
sortColumnIndex == 4 ? listTipoOperacao.FirstOrDefault(f => f.CodigoOperacao == c.CodigoOperacao).Documento :
sortColumnIndex == 5 ? listTipoDocumento.FirstOrDefault(f => f.CodigoDocumento == c.CodigoDocumento).Documento :
sortColumnIndex == 6 ? listProduto.FirstOrDefault(f => f.CodigoProduto == c.CodigoProduto).Descricao :
c.Data.ToString("dd/mm/yyyy"));
if (sortDirection == "asc")
{
list = list.OrderBy(orderingFunctionString);
}
else
{
list = list.OrderByDescending(orderingFunctionString);
}
}
var displayedCompanies = list;
var result = from c in displayedCompanies
select
new[]
{
c.Data.ToString("dd/MM/yyyy HH:mm:ss") //0
, c.SEDEX_AR.ToString() //1
, c.Colaborador.ToString() //2
, c.Contrato.ToString() //3
, listTipoOperacao.FirstOrDefault(p => p.CodigoOperacao == c.CodigoOperacao).Documento //4
, listTipoDocumento.FirstOrDefault(p => p.CodigoDocumento == c.CodigoDocumento).Documento //5
, listProduto.FirstOrDefault(f => f.CodigoProduto == c.CodigoProduto).Descricao //6
, c.CodigoOperacaoEtapa.ToString() //7
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = tamanho,
aaData = result.Skip(param.iDisplayStart).Take(param.iDisplayLength)
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GenIndAjaxHandler(jQueryDataTableParamModel param)
{
var allCompanies = da.GetAllTypeDevice();
var result = from c in allCompanies
select new DTypeDeviceModel {
Id = c.Id,
code = c.code,
name = c.name
};
return Json(new
{
data = result
}, JsonRequestBehavior.AllowGet);
}
public BaseResponse <List <CompanyDto> > GetAll(jQueryDataTableParamModel filters)
{
IEnumerable <CompanyDto> companyList = new List <CompanyDto>();
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("uspGetAllCompany", con))
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
var dt = new DataTable();
dt.Load(cmd.ExecuteReader());
companyList = (from DataRow row in dt.Rows
select new CompanyDto
{
CompanyName = row["CompanyName"].ToString(),
Address = row["Address"].ToString(),
Email = row["Email"].ToString(),
Id = Convert.ToInt32(row["Id"].ToString()),
IsActive = Convert.ToBoolean(row["IsActive"].ToString()),
Phone = row["Phone"].ToString()
});
var d = dt;
con.Close();
}
}
IEnumerable <CompanyDto> filteredCompanies;
#region Searching
if (!string.IsNullOrEmpty(filters.sSearch))
{
filteredCompanies = companyList
.Where(c => c.CompanyName.ToLower().Contains(filters.sSearch.ToLower()) ||
c.Address.ToLower().Contains(filters.sSearch.ToLower()) ||
c.Email.ToLower().Contains(filters.sSearch.ToLower()) ||
c.Phone.Contains(filters.sSearch));
}
else
{
filteredCompanies = companyList;
}
#endregion
#region Sorting
Func <CompanyDto, string> orderingFunction = (c => filters.iSortColIndx == 0 ? c.CompanyName :
filters.iSortColIndx == 1 ? c.Email :
filters.iSortColIndx == 2 ? c.Address :
c.Phone
);
if (filters.iSortColDir == "asc")
{
filteredCompanies = filteredCompanies.OrderBy(orderingFunction);
}
else
{
filteredCompanies = filteredCompanies.OrderByDescending(orderingFunction);
}
#endregion
return(new BaseResponse <List <CompanyDto> >
{
Message = "Success",
Success = true,
Data = filteredCompanies.Skip(filters.iDisplayStart).Take(filters.iDisplayLength).ToList()
});
}
public ActionResult getCustomerList(jQueryDataTableParamModel param)
{
List <CustomerModel> listdetails = new List <CustomerModel>();
int a_id = Convert.ToInt32(Session["ApartmentID"]);
int p_id = Convert.ToInt32(Session["userType"]);
try
{
var StudentList = objCustDAL.getAllTableDetails(a_id, p_id);
TempData["Data"] = StudentList;
IEnumerable <CustomerModel> filteredItems;
if (!string.IsNullOrEmpty(param.sSearch))
{
var isRetSearchable = Convert.ToBoolean(Request["bSearchable_1"]);
var isStoreInvSearchable = Convert.ToBoolean(Request["bSearchable_2"]);
var isFromStoreSearchable = Convert.ToBoolean(Request["bSearchable_2"]);
filteredItems = StudentList
.Where(c => isRetSearchable && c.firstName.ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filteredItems = StudentList;
}
var isRetSortable = Convert.ToBoolean(Request["bSortable_1"]);
var isStoreInvSortable = Convert.ToBoolean(Request["bSortable_2"]);
var isFromStoreSortable = Convert.ToBoolean(Request["bSortable_3"]);
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <CustomerModel, string> orderingFunction = (c => sortColumnIndex == 2 && isRetSortable ? c.firstName :
"");
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredItems = filteredItems.OrderBy(orderingFunction);
}
else
{
filteredItems = filteredItems.OrderByDescending(orderingFunction);
}
var displayedCompanies = filteredItems.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedCompanies select new[] { Convert.ToString(c.id), c.firstName, c.lastName, Convert.ToString(c.mobileNo), c.houseNo, c.blockNo, c.lastLoginDate, Convert.ToString(c.id) };
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = StudentList.Count(),
iTotalDisplayRecords = filteredItems.Count(),
aaData = result,
},
JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
log.Error(ex);
return(Json("Something went wrong..Try after some Time", JsonRequestBehavior.AllowGet));
}
}
public ActionResult IndexAjax(jQueryDataTableParamModel param)
{
var list = db.Subjekt.Where(c => c.ZapisAktivan).ToList();
IEnumerable <Subjekt> filteredList;
var FIdSubjekt = Convert.ToString(Request["sSearch_0"]).ToLower();
var FNaziv = Convert.ToString(Request["sSearch_1"]).ToLower();
var FAdresa = Convert.ToString(Request["sSearch_2"]).ToLower();
var FTelefon = Convert.ToString(Request["sSearch_3"]).ToLower();
var FEmail = Convert.ToString(Request["sSearch_4"]).ToLower();
var FKontaktOsoba = Convert.ToString(Request["sSearch_5"]).ToLower();
var FTimocom = Convert.ToString(Request["sSearch_6"]).ToLower();
var FDatumKreiranja = Convert.ToString(Request["sSearch_7"]).ToLower();
var FPIB = Convert.ToString(Request["sSearch_8"]).ToLower();
filteredList = list.Where(c =>
(String.IsNullOrEmpty("" + c.RedniBroj) ? "" : "" + c.RedniBroj).ToLower().Contains(FIdSubjekt) &&
(String.IsNullOrEmpty("" + c.Naziv) ? "" : "" + c.Naziv).ToLower().Contains(FNaziv) &&
(String.IsNullOrEmpty("" + c.Adresa) ? "" : "" + c.Adresa).ToLower().Contains(FAdresa) &&
(String.IsNullOrEmpty("" + c.Telefon) ? "" : "" + c.Telefon).ToLower().Contains(FTelefon) &&
(String.IsNullOrEmpty("" + c.Email) ? "" : "" + c.Email).ToLower().Contains(FEmail) &&
(String.IsNullOrEmpty("" + c.KontaktOsoba) ? "" : "" + c.KontaktOsoba).ToLower().Contains(FKontaktOsoba) &&
(String.IsNullOrEmpty("" + c.Timocom) ? "" : "" + c.Timocom).ToLower().Contains(FTimocom) &&
(String.IsNullOrEmpty("" + c.DatumKreiranja) ? "" : "" + c.DatumKreiranja).ToLower().Contains(FDatumKreiranja) &&
(String.IsNullOrEmpty("" + c.PIB) ? "" : "" + c.PIB).ToLower().Contains(FPIB)
);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredList = filteredList.Where(c =>
(String.IsNullOrEmpty("" + c.RedniBroj) ? "" : "" + c.RedniBroj).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.Naziv) ? "" : "" + c.Naziv).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.Adresa) ? "" : "" + c.Adresa).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.Telefon) ? "" : "" + c.Telefon).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.Email) ? "" : "" + c.Email).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.KontaktOsoba) ? "" : "" + c.KontaktOsoba).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.Timocom) ? "" : "" + c.Timocom).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.DatumKreiranja) ? "" : "" + c.DatumKreiranja).ToLower().Contains(param.sSearch.ToLower()) ||
(String.IsNullOrEmpty("" + c.PIB) ? "" : "" + c.PIB).ToLower().Contains(param.sSearch.ToLower())
);
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <Subjekt, object> orderingFunction = c =>
{
switch (sortColumnIndex)
{
case 0: return(c.RedniBroj);
case 1: return(c.Naziv);
case 2: return(c.Adresa);
case 3: return(c.Telefon);
case 4: return(c.Email);
case 5: return(c.KontaktOsoba);
case 6: return(c.Timocom);
case 7: return(c.DatumKreiranja);
case 8: return(c.PIB);
default: return(c.RedniBroj);
}
};
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredList = filteredList.OrderBy(orderingFunction);
}
else
{
filteredList = filteredList.OrderByDescending(orderingFunction);
}
var displayedList = filteredList.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedList select new object[] {
c.RedniBroj,
c.Naziv,
c.Adresa + " - " + c.PTT + " " + c.Grad,
c.Telefon,
c.Email,
c.KontaktOsoba,
c.Timocom,
String.IsNullOrEmpty("" + c.DatumKreiranja) ? "" : DateTime.Parse(c.DatumKreiranja.ToString()).ToString("dd.MM.yyyy"),
c.PIB,
c.IdSubjekt
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = filteredList.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public static List <eServiceChargeM> GetServiceCharges(jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eServiceChargeM> macroarea = new List <eServiceChargeM>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var objTblMacroArea =
(from m in db.tblServiceChargeMs
join u in db.tblUserMs on m.iActionBy equals u.iUserId into S1
from user in S1.DefaultIfEmpty()
select new eServiceChargeM
{
ServiceChargeId = m.iServiceChargeId,
dtFrom = m.dtFrom,
dtTo = m.dtTo,
Status = m.cStatus,
ServiceCharge = m.dServiceCharge,
GstValueType = m.cGstValueType,
GstValue = m.dGstValue,
ActionById = m.iActionBy,
ActionByName = user.sFirstName + " " + user.sLastName,
ActionDate = m.dtActionDate
}).Where(u => u.GstValue.ToString().Contains(param.sSearch) ||
u.GstValueType.Contains(param.sSearch) ||
u.ActionByName.Contains(param.sSearch) ||
u.ServiceCharge.ToString().Contains(param.sSearch)).AsQueryable();
TotalCount = objTblMacroArea.Count();
switch (param.iSortingCols)
{
case 0:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.ServiceChargeId) : objTblMacroArea.OrderByDescending(u => u.ServiceChargeId);
break;
case 1:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.ServiceCharge) : objTblMacroArea.OrderByDescending(u => u.ServiceCharge);
break;
case 2:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.GstValueType) : objTblMacroArea.OrderByDescending(u => u.GstValueType);
break;
case 3:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.GstValue) : objTblMacroArea.OrderByDescending(u => u.GstValue);
break;
case 4:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.From) : objTblMacroArea.OrderByDescending(u => u.From);
break;
case 5:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.To) : objTblMacroArea.OrderByDescending(u => u.To);
break;
case 6:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.ActionDate) : objTblMacroArea.OrderByDescending(u => u.ActionDate);
break;
default:
objTblMacroArea = objTblMacroArea.OrderBy(u => u.ActionByName);
break;
}
var data = objTblMacroArea.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
foreach (var item in data)
{
item.From = item.dtFrom.Value.ToString("dd/MM/yyyy");
item.To = item.dtTo.Value.ToString("dd/MM/yyyy");
}
return(data);
}
}
public JsonResult GetAllUserListJSON(jQueryDataTableParamModel param)
{
string sortOrder = string.Empty;
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
if (sortColumnIndex == 0)
{
sortOrder = "UserId";
}
else if (sortColumnIndex == 1)
{
sortOrder = "FullName";
}
else if (sortColumnIndex == 2)
{
sortOrder = "Email";
}
string search = "||"; //It's indicate blank filter
if (!string.IsNullOrEmpty(param.sSearch))
{
search = param.sSearch;
}
//var sortDirection = Request["sSortDir_0"]; // asc or desc
var sortDirection = "desc";
int pageNo = 1;
int recordPerPage = param.iDisplayLength;
//Find page number from the logic
if (param.iDisplayStart > 0)
{
pageNo = (param.iDisplayStart / recordPerPage) + 1;
}
DataTableProperty DataTableProperty = new DataTableProperty();
DataTableProperty.PageNo = pageNo;
DataTableProperty.RecordPerPage = recordPerPage;
DataTableProperty.Filter = search == "||" ? null : search;
DataTableProperty.SortField = sortOrder;
DataTableProperty.SortOrder = sortDirection;
if (param.sSearch_1 != null)
{
DataTableProperty.FullName = param.sSearch_1;
}
if (param.sSearch_2 != null)
{
DataTableProperty.Email = param.sSearch_2;
}
var result1 = objAccessDB.GetUserList(DataTableProperty);
dynamic result = "";
if (result1.EmployeeInfoList == null)
{
result = new List <EmployeeInfo>();
}
else
{
result = from c in result1.EmployeeInfoList
select new[] { c.UserId.ToString(), c.FullName.ToString(), c.Email.ToString(), c.ProfileImage.ToString() };
}
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = result1.totalNumberofRecord,
iTotalDisplayRecords = result1.filteredRecord,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
//
public ActionResult IndexAjax(jQueryDataTableParamModel param)
{
var list = db.TipUsluge.ToList();
IEnumerable <TipUsluge> filteredList;
var FIdTipUsluge = Convert.ToString(Request["sSearch_0"]).ToLower();
var FNaziv = Convert.ToString(Request["sSearch_1"]).ToLower();
filteredList = list.Where(c =>
(String.IsNullOrEmpty("" + c.IdTipUsluge) ? "" : "" + c.IdTipUsluge).ToLower().Contains(FIdTipUsluge) &&
(String.IsNullOrEmpty("" + c.Naziv) ? "" : "" + c.Naziv).ToLower().Contains(FNaziv)
);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredList = filteredList.Where(c =>
(String.IsNullOrEmpty("" + c.IdTipUsluge) ? "" : "" + c.IdTipUsluge).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.Naziv) ? "" : "" + c.Naziv).ToLower().Contains(param.sSearch.ToLower())
);
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <TipUsluge, object> orderingFunction = c =>
{
switch (sortColumnIndex)
{
case 0: return(c.IdTipUsluge);
case 1: return(c.Naziv);
default: return(c.IdTipUsluge);
}
};
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredList = filteredList.OrderBy(orderingFunction);
}
else
{
filteredList = filteredList.OrderByDescending(orderingFunction);
}
var displayedList = filteredList.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedList select new object[] {
c.IdTipUsluge,
c.Naziv,
""
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = filteredList.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult ListaBoletos(jQueryDataTableParamModel param, string cancelado, string recebido, string descricao, string vInicio, string vFim, string rInicio, string rFim, int codigo = 0, int id = 0)
{
var data = (from x in db.Movimentacao.Where(x => x.Boleto && x.GeradoBoleto).ToList()
select new
{
Codigo = x.CodigoDoTitulo,
x.CodigoDoCliente,
x.DescricaoDoTitulo,
x.DataDoVencimento,
x.DataDoRecebimento,
x.ValorDoTitulo,
x.Cancelado
});
if (id != 0)
{
data = data.Where(x => x.CodigoDoCliente == id);
}
else
{
return(Json(""));
}
//buscas
if (data.Any())
{
if (codigo != 0)
{
data = data.Where(x => x.Codigo == codigo);
}
if (descricao != "")
{
data = data.Where(x => x.DescricaoDoTitulo.Contains(descricao));
}
if (cancelado != "")
{
if (cancelado == "S")
{
data = data.Where(x => x.Cancelado);
}
if (cancelado == "N")
{
data = data.Where(x => !x.Cancelado);
}
}
if (recebido != "")
{
if (recebido == "S")
{
data = data.Where(x => x.DataDoRecebimento != null);
}
if (recebido == "N")
{
data = data.Where(x => x.DataDoRecebimento == null);
}
}
if (rInicio != "")
{
var datas = Convert.ToDateTime(rInicio);
data = data.Where(x => x.DataDoRecebimento >= datas);
}
if (rFim != "")
{
var datas = Convert.ToDateTime(rFim);
data = data.Where(x => x.DataDoRecebimento <= datas);
}
if (vInicio != "")
{
var datas = Convert.ToDateTime(vInicio);
data = data.Where(x => x.DataDoVencimento >= datas);
}
if (vFim != "")
{
var datas = Convert.ToDateTime(vFim);
data = data.Where(x => x.DataDoVencimento <= datas);
}
}
data = param.sSortDir_0 == "desc" ? data.OrderBy(x => x.Codigo) : data.OrderByDescending(x => x.Codigo);
var result = data;
if (param.iDisplayLength != -1)
{
result = result.Skip(param.iDisplayStart).Take(param.iDisplayLength);
}
return(Json(new
{
param.sEcho,
iTotalRecords = db.Movimentacao.Count(x => x.Boleto && x.GeradoBoleto && x.CodigoDoCliente == id),
iTotalDisplayRecords = data.Count(),
aaData = from x in result
select new[]
{
x.Codigo.ToString(),
x.Codigo.ToString(),
x.DescricaoDoTitulo,
x.DataDoVencimento.ToShortDateString(),
x.DataDoRecebimento?.ToShortDateString() ?? "",
x.ValorDoTitulo.ToString(CultureInfo.CurrentCulture),
x.Cancelado ? "S" : "N"
}
},
JsonRequestBehavior.AllowGet));
}
public JsonResult DataTable_IgnoreGroups(jQueryDataTableParamModel param, List <String> SubjectID = null, List <String> Class = null, List <String> Check = null, String Search = null, String ShowIgnore = null, String ShowNotIgnore = null)
{
if (SubjectID != null && Class != null && Check != null)
{
OutputHelper.SaveIgnoreGroups(SubjectID, Class, Check, false);
}
Dictionary <String, Group> dbGroups = Clone.Dictionary <String, Group>((Dictionary <String, Group>)(CurrentSession.Get("IgnoreGroups") ?? InputHelper.Groups));
//Dictionary<String, Group> dbGroups = InputHelper.Groups;
var Groups = from m in dbGroups.Values select m;
var total = Groups.Count();
if (!string.IsNullOrEmpty(Search))
{
Groups = Groups.Where(m => m.MaMonHoc.ToLower().Contains(Search.ToLower()) || m.TenMonHoc.ToLower().Contains(Search.ToLower()));
}
if (ShowIgnore != null && ShowNotIgnore != null)
{
if (ShowIgnore == "checked" && ShowNotIgnore != "checked")
{
Groups = Groups.Where(m => m.IsIgnored == true);
}
if (ShowIgnore != "checked" && ShowNotIgnore == "checked")
{
Groups = Groups.Where(m => m.IsIgnored == false);
}
if (ShowIgnore != "checked" && ShowNotIgnore != "checked")
{
Groups = Groups.Where(m => false);
}
}
var Result = new List <string[]>();
var MH = (from m in InputHelper.db.This
select new
{
MaMonHoc = m.MaMonHoc,
Nhom = m.Nhom,
}).Distinct();
Dictionary <String, List <String> > CheckMH = new Dictionary <string, List <string> >();
foreach (var m in MH)
{
if (CheckMH.ContainsKey(m.MaMonHoc))
{
CheckMH[m.MaMonHoc].Add(m.Nhom);
}
else
{
CheckMH.Add(m.MaMonHoc, new List <String> {
m.Nhom
});
}
}
foreach (var su in Groups.OrderBy(m => m.TenMonHoc))
{
if (CheckMH.ContainsKey(su.MaMonHoc))
{
if (!CheckGroup(CheckMH[su.MaMonHoc], su.Nhom.ToString()))
{
Result.Add(new string[] {
su.MaMonHoc,
su.TenMonHoc,
su.TenBoMon,
su.TenKhoa,
su.Nhom.ToString(),
su.SoLuongDK.ToString(),
su.IsIgnored ? "checked" : "",
}
);
}
}
else
{
Result.Add(new string[] {
su.MaMonHoc,
su.TenMonHoc,
su.TenBoMon,
su.TenKhoa,
su.Nhom.ToString(),
su.SoLuongDK.ToString(),
su.IsIgnored ? "checked" : "",
}
);
}
}
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = Result.Count(),
iTotalDisplayRecords = Result.Count(),
//iTotalDisplayedRecords = Subjects.Count(),
aaData = Result.Skip(param.iDisplayStart).Take(param.iDisplayLength)
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult IndexData(int?RegionId, int?CountryId, int?AgencyGroupId, int?AgencyId, jQueryDataTableParamModel p)
{
var usersModel = new UsersModel();
var source = usersModel.GetUsers(db, this.Permissions);
var sSortCol_0 = Request["mDataProp_" + p.iSortCol_0];
var bSortAsc_0 = p.sSortDir_0 == "asc";
var filtered = source;
if (RegionId.HasValue)
{
filtered = filtered.Where(f => f.RegionId == RegionId);
}
if (CountryId.HasValue)
{
filtered = filtered.Where(f => f.CountryId == CountryId);
}
if (AgencyGroupId.HasValue)
{
filtered = filtered.Where(f => f.AgencyGroupId == AgencyGroupId);
}
if (AgencyId.HasValue)
{
filtered = filtered.Where(f => f.AgencyId == AgencyId);
}
if (!string.IsNullOrEmpty(p.sSearch))
{
filtered = filtered.Where(f => System.Data.Objects.SqlClient.SqlFunctions.StringConvert((decimal)f.Id).Trim().Equals(p.sSearch) ||
f.Username.Contains(p.sSearch) ||
f.Role.Contains(p.sSearch) ||
f.RoleEnd.Contains(p.sSearch)
);
}
var data = filtered.OrderByField(sSortCol_0, bSortAsc_0).Skip(p.iDisplayStart).Take(p.iDisplayLength);
var result = new CC.Web.Models.jQueryDataTableResult()
{
aaData = data,
sEcho = p.sEcho,
iTotalRecords = source.Count(),
iTotalDisplayRecords = filtered.Count()
};
return(this.MyJsonResult(result));
}
public static object GetCustomspaymentsmaster()
{
var param = new jQueryDataTableParamModel();
HttpContext Context = HttpContext.Current;
param.sEcho = String.IsNullOrEmpty(Context.Request["sEcho"]) ? 0 : Convert.ToInt32(Context.Request["sEcho"]);
param.sSearch = String.IsNullOrEmpty(Context.Request["sSearch"]) ? "" : Context.Request["sSearch"];
param.iDisplayStart = String.IsNullOrEmpty(Context.Request["iDisplayStart"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayStart"]);
param.iDisplayLength = String.IsNullOrEmpty(Context.Request["iDisplayLength"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayLength"]);
var sortColumnIndex = Convert.ToInt32(Context.Request["iSortCol_0"]);
var sortDirection = Context.Request["sSortDir_0"]; // asc or desc
SqlCommand command = DataAccess.CreateCommand();
command.CommandText = "Customspaymentsmaster_SelectList";
try
{
command.Connection.Open();
command.Parameters.AddWithValue("@DisplayStart", param.iDisplayStart);
command.Parameters.AddWithValue("@DisplayLength", param.iDisplayLength);
command.Parameters.AddWithValue("@SearchParam", param.sSearch);
command.Parameters.AddWithValue("@SortColumn", sortColumnIndex);
command.Parameters.AddWithValue("@SortDirection", sortDirection);
var adp = new SqlDataAdapter(command);
var ds = new DataSet();
adp.Fill(ds);
var rows = new List <Dictionary <string, object> >();
Dictionary <string, object> row;
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
var data = new
{
sEcho = param.sEcho,
iTotalRecords = ds.Tables[1].Rows[0][0],
iTotalDisplayRecords = ds.Tables[1].Rows[0][0],
aaData = rows.ToList()
};
return(data);
}
catch (Exception ex)
{
throw ex;
}
finally
{
command.Connection.Close();
}
}
/// <summary>
/// Brings The DataBack to Borrowers Table Based on Filter
/// </summary>
/// <param> Table Parameters</param>
/// <param> Search Criteria</param>
/// <returns>JqDataTable</returns>
public JqDataTable <object[]> Post_SearchBorrowerTable(jQueryDataTableParamModel param, string searchCriteria)
{
return(SearchInBorrowers(param, searchCriteria));
}
public static List <eCorporateCompanyM> GetCorporateCompanies(jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eCorporateCompanyM> macroarea = new List <eCorporateCompanyM>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var objTblMacroArea = (from m in db.tblCorporateCompanyMs
join c in db.tblCorporateDomainMaps on m.iCompanyId equals c.iCompanyId into ccm
join u in db.tblUserMs on m.iActionBy equals u.iUserId into S1
from user in S1.DefaultIfEmpty()
select new eCorporateCompanyM
{
iCompanyId = m.iCompanyId,
sCompanyName = m.sCompanyName,
sDomainNameList = ccm.Select(y => y.sDomainName),
sDomainNames = ccm.Select(y => y.sDomainName).FirstOrDefault(),
sEmailAddress = m.sEmailAddress,
sMobileNumber = m.sMobileNumber,
sPrimaryContact = m.sPrimaryContact,
sTelephoneNumber = m.sTelephoneNumber,
cStatus = m.cStatus,
dtActionDate = m.dtActionDate,
iActionBy = m.iActionBy,
sActionBy = user.sFirstName + " " + user.sLastName,
GstnEntityType = m.sEntityType,
GstnEntityName = m.sRegisteredEntityName,
GstnNumber = m.sGstinNumber
}
)
.Where(u => u.sCompanyName.Contains(param.sSearch) ||
u.sDomainNameList.Contains(param.sSearch) ||
u.sEmailAddress.Contains(param.sSearch) ||
u.sMobileNumber.Contains(param.sSearch) ||
u.sPrimaryContact.Contains(param.sSearch) ||
u.sActionBy.Contains(param.sSearch)).AsQueryable();
TotalCount = objTblMacroArea.Count();
switch (param.iSortingCols)
{
case 0:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sCompanyName) : objTblMacroArea.OrderByDescending(u => u.sCompanyName);
break;
case 1:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sPrimaryContact) : objTblMacroArea.OrderByDescending(u => u.sPrimaryContact);
break;
case 2:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sTelephoneNumber) : objTblMacroArea.OrderByDescending(u => u.sTelephoneNumber);
break;
case 3:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sMobileNumber) : objTblMacroArea.OrderByDescending(u => u.sMobileNumber);
break;
case 4:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sEmailAddress) : objTblMacroArea.OrderByDescending(u => u.sEmailAddress);
break;
case 5:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.sDomainNames) : objTblMacroArea.OrderByDescending(u => u.sDomainNames);
break;
case 6:
objTblMacroArea = param.sortDirection == "asc" ? objTblMacroArea.OrderBy(u => u.cStatus) : objTblMacroArea.OrderByDescending(u => u.cStatus);
break;
default:
objTblMacroArea = objTblMacroArea.OrderBy(u => u.sCompanyName);
break;
}
var data = objTblMacroArea.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
foreach (var item in data)
{
item.sDomainNames = string.Join("<br/>", item.sDomainNameList);
}
return(data);
}
}
/// <summary>
/// Brings The DataBack to Borrowers Table Based on Filter
/// </summary>
/// <param> Table Parameters</param>
/// <param> Search Criteria</param>
/// <returns>JqDataTable</returns>
private JqDataTable <object[]> SearchInBorrowers(jQueryDataTableParamModel param, string searchCriteria)
{
try
{
SearchCriteria criteria = ConvertFromJsonToObject <SearchCriteria>(searchCriteria);
int startIndex = 0;
if (param.iDisplayStart > 0)
{
startIndex = param.iDisplayStart + 1;
}
else
{
startIndex = param.iDisplayStart;
}
criteria.StartIndex = startIndex;
criteria.EndIndex = param.iDisplayStart + param.iDisplayLength;
criteria.SortOrder = param.sSortDir_0;
criteria.SortingCol = param.iSortCol_0;
if (String.IsNullOrWhiteSpace(criteria.Text))
{
criteria.Text = String.Empty;
}
BorrowersModel obj = new BorrowersModel();
int count = obj.TotalBorrowers(criteria);
var data = new List <object[]>();
IList <BorrowersModel> bModels = new List <BorrowersModel>();
bModels = obj.GetAllBorrowers(criteria);
foreach (BorrowersModel item in bModels)
{
var array = new object[3];
array[0] = item.ID;
array[1] = item.FirstName;
array[2] = item.LastName;
data.Add(array);
}
return(new JqDataTable <object[]>
{
sEcho = param.sEcho,
iTotalRecords = count,
iTotalDisplayRecords = count,
aaData = data
});
}
catch (Exception ex)
{
Logging.Error(ex.Message);
return(null);
}
}
public ActionResult AjaxHandler(jQueryDataTableParamModel param)
{
var allResult = db.getLoaiHinh().ToList();
IEnumerable <getLoaiHinh_Result> filteredResult;
//Check whether the companies should be filtered by keyword
if (!string.IsNullOrEmpty(param.sSearch))
{
//Optionally check whether the columns are searchable at all
var Searchable_0 = Convert.ToBoolean(Request["bSearchable_0"]);
var Searchable_1 = Convert.ToBoolean(Request["bSearchable_1"]);
var Searchable_2 = Convert.ToBoolean(Request["bSearchable_2"]);
int tmp = int.TryParse(param.sSearch, out tmp) ? tmp : 0;
filteredResult = allResult
.Where(c => Searchable_1 && c.MA.ToLower().Contains(param.sSearch.ToLower()) ||
Searchable_2 && c.TEN.ToLower().Contains(param.sSearch.ToLower()) ||
Searchable_0 && c.STT.Equals(tmp)
);
}
else
{
filteredResult = allResult;
}
var Sortable_0 = Convert.ToBoolean(Request["bSortable_0"]);
var Sortable_1 = Convert.ToBoolean(Request["bSortable_1"]);
var Sortable_2 = Convert.ToBoolean(Request["bSortable_2"]);
var sortColumnIndex = Convert.ToInt64(Request["iSortCol_0"]);
Func <getLoaiHinh_Result, string> orderingFunction = (c => sortColumnIndex == 1 && Sortable_1 ? c.MA :
sortColumnIndex == 2 && Sortable_2 ? c.TEN : "");
Func <getLoaiHinh_Result, Int64> orderingFunction2 = (c => sortColumnIndex == 0 && Sortable_0 ? c.STT : 0);
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredResult = filteredResult.OrderBy(orderingFunction).ThenBy(orderingFunction2);
}
else
{
filteredResult = filteredResult.OrderByDescending(orderingFunction).ThenByDescending(orderingFunction2);
}
var displayed = filteredResult.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = displayed.Select(c => new
{
col0 = c.STT,
col1 = c.MA,
col2 = c.TEN
});
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = allResult.Count(),
iTotalDisplayRecords = filteredResult.Count(),
aaData = result
}, JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxHandler(jQueryDataTableParamModel param)
{
var allResult = db.getDonVi(null, "").ToList();
IEnumerable <getDonVi_Result> filteredResult;
//Check whether the companies should be filtered by keyword
if (!string.IsNullOrEmpty(param.sSearch))
{
//Optionally check whether the columns are searchable at all
var Searchable_0 = Convert.ToBoolean(Request["bSearchable_0"]);
var Searchable_1 = Convert.ToBoolean(Request["bSearchable_1"]);
var Searchable_2 = Convert.ToBoolean(Request["bSearchable_2"]);
int tmp = int.TryParse(param.sSearch, out tmp) ? tmp : 0;
filteredResult = allResult
.Where(c => Searchable_1 && c.MaDonVi.ToLower().Contains(param.sSearch.ToLower()) ||
Searchable_2 && c.TenDonVi.ToLower().Contains(param.sSearch.ToLower()) ||
Searchable_0 && c.STT.Equals(tmp)
);
}
else
{
filteredResult = allResult;
}
var Sortable_0 = Convert.ToBoolean(Request["bSortable_0"]);
var Sortable_1 = Convert.ToBoolean(Request["bSortable_1"]);
var Sortable_2 = Convert.ToBoolean(Request["bSortable_2"]);
var sortColumnIndex = Convert.ToInt64(Request["iSortCol_0"]);
Func <getDonVi_Result, string> orderingFunction = (c => sortColumnIndex == 1 && Sortable_1 ? c.MaDonVi :
sortColumnIndex == 2 && Sortable_2 ? c.TenDonVi : "");
Func <getDonVi_Result, Int64> orderingFunction2 = (c => sortColumnIndex == 0 && Sortable_0 ? c.STT : 0);
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredResult = filteredResult.OrderBy(orderingFunction).ThenBy(orderingFunction2);
}
else
{
filteredResult = filteredResult.OrderByDescending(orderingFunction).ThenByDescending(orderingFunction2);
}
var displayed = filteredResult.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = displayed.Select(c => new
{
col0 = c.STT,
col1 = c.MaDonVi,
col2 = c.TenDonVi,
col3 = c.CanAudit ? "<span class='btn btn-md btn-success glyphicon glyphicon-ok-circle'></span>" : "<span class='btn btn-md btn-warning glyphicon glyphicon-remove-circle'></span>",
col4 = (c.BeginDate != null) ? String.Format("{0: dd/MM/yyyy}", c.BeginDate) : "",
col5 = (c.EndDate != null) ? String.Format("{0: dd/MM/yyyy}", c.EndDate) : "Đang hoạt động",
});
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = allResult.Count(),
iTotalDisplayRecords = filteredResult.Count(),
aaData = result
}, JsonRequestBehavior.AllowGet));
}
public static object GetShipCompanies()
{
var param = new jQueryDataTableParamModel();
HttpContext Context = HttpContext.Current;
param.sEcho = String.IsNullOrEmpty(Context.Request["sEcho"]) ? 0 : Convert.ToInt32(Context.Request["sEcho"]);
param.sSearch = String.IsNullOrEmpty(Context.Request["sSearch"]) ? "" : Context.Request["sSearch"];
param.iDisplayStart = String.IsNullOrEmpty(Context.Request["iDisplayStart"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayStart"]);
param.iDisplayLength = String.IsNullOrEmpty(Context.Request["iDisplayLength"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayLength"]);
var sortColumnIndex = Convert.ToInt32(Context.Request["iSortCol_0"]);
var sortDirection = Context.Request["sSortDir_0"]; // asc or desc
var categoryList = new List <ShippingCompanies_SelectListResult>();
IEnumerable <ShippingCompanies_SelectListResult> filtereShippingCompanies;
categoryList = new ShippingCompaniesManager().GetShippingCompanies();
// check for search param
if (!String.IsNullOrEmpty(param.sSearch))
{
filtereShippingCompanies = categoryList.Where(c => c.ShipCompanyNameAr.ToLower().Contains(param.sSearch.ToLower()) ||
c.ShipCompanyNameEn.ToLower().Contains(param.sSearch.ToLower()) ||
c.ShipCompanyID.ToString().Contains(param.sSearch.ToLower()) ||
c.ShipMainCompanyNameAr.ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filtereShippingCompanies = categoryList;
}
// handle asc and desc operation
Func <ShippingCompanies_SelectListResult, string> orderingFunction = (c => sortColumnIndex == 1 ? c.ShipCompanyNameEn :
sortColumnIndex == 2 ? c.ShipCompanyNameAr : c.ShipCompanyID.ToString());
if (sortDirection == "asc")
{
filtereShippingCompanies = filtereShippingCompanies.OrderBy(orderingFunction);
}
else
{
filtereShippingCompanies = filtereShippingCompanies.OrderByDescending(orderingFunction);
}
//paginate our result
var result = filtereShippingCompanies.Select(c => new
{
ShipCompanyID = c.ShipCompanyID,
ShipCompanyNameAr = c.ShipCompanyNameAr,
ShipCompanyNameEn = c.ShipCompanyNameEn,
ShipMainCompanyID = c.ShipMainCompanyID,
ShipMainCompanyNameAr = c.ShipMainCompanyNameAr
}).Skip(param.iDisplayStart).Take(param.iDisplayLength);
// Our last
var data = new
{
sEcho = param.sEcho,
iTotalRecords = categoryList.Count(),
iTotalDisplayRecords = filtereShippingCompanies.Count(),
aaData = result
};
return(data);
}
public ActionResult AjaxHandler(jQueryDataTableParamModel param)
{
var seasonSummary = _seriesRepository.GetSeriesFixtureForSeason(param.SeriesId, param.Season);
IEnumerable<SeriesFixture> filteredMatches;
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredMatches = seasonSummary.Where(m => m.HomeTeam.TeamName.ToLower().Contains(param.sSearch.ToLower())
|| m.AwayTeam.TeamName.ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filteredMatches = seasonSummary;
}
var displayedMatches = filteredMatches.OrderByDescending(m => m.MatchRound);
var result = from c in displayedMatches
select new[]
{
Convert.ToString(c.HtMatchId), c.MatchDate.ToString("dd/MM/yyyy"),
c.MatchRound.ToString(), c.HomeTeam.TeamName, c.AwayTeam.TeamName, c.IsMatchMigrated.ToString()
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = seasonSummary.Count,
iTotalDisplayRecords = seasonSummary.Count,
aaData = result
},
JsonRequestBehavior.AllowGet);
}
///<summary>
///All Issued books History
///</summary>
///<param> jQueryDataTableParamModel</param>
///<param> searchCriteria</param>
///<returns>bool<BorrowersModel> </returns>
public JqDataTable <object[]> Post_AllAssignedBooks(jQueryDataTableParamModel param, string searchCriteria, string type)
{
try
{
SearchCriteria criteria = ConvertFromJsonToObject <SearchCriteria>(searchCriteria);
int startIndex = 0;
if (param.iDisplayStart > 0)
{
startIndex = param.iDisplayStart + 1;
}
else
{
startIndex = param.iDisplayStart;
}
criteria.StartIndex = startIndex;
criteria.EndIndex = param.iDisplayStart + param.iDisplayLength;
criteria.SortOrder = param.sSortDir_0;
criteria.SortingCol = param.iSortCol_0;
if (String.IsNullOrWhiteSpace(criteria.Text))
{
criteria.Text = String.Empty;
}
AssignBookModel obj = new AssignBookModel();
int count = obj.TotalAssigned(criteria);
var data = new List <object[]>();
IList <AssignBookModel> bModel = new List <AssignBookModel>();
bModel = obj.GetAllAssignedBooks(criteria);
foreach (AssignBookModel item in bModel)
{
var array = new object[8];
array[0] = item.Title;
array[1] = item.FirstName + "," + item.LastName;
array[2] = Convert.ToDateTime(item.AssignedDate).ToString("MMMM d, yyyy");
array[3] = Convert.ToDateTime(item.DueDate).ToString("MMMM d, yyyy");;
array[4] = (item.isCurrentlyAssigned == true) ? "N" : "Y";
array[5] = (DateTime.Now - item.DueDate).TotalDays > 0 && item.isCurrentlyAssigned == true ? "Y" : "N";
array[6] = item.BorrowerID;
array[7] = item.BookID;
data.Add(array);
}
return(new JqDataTable <object[]>
{
sEcho = param.sEcho,
iTotalRecords = count,
iTotalDisplayRecords = count,
aaData = data
});
}
catch (Exception e)
{
return(null);
}
}
public ActionResult DnevnikIstekleValute(jQueryDataTableParamModel param)
{
var list = db.DnevnikPrevoza.Include(d => d.Subjekt1).Where(c => (!(c.Uplaceno ?? false))).ToList()
.Where(c => ((c.DatumSlanjaFakture ?? DateTime.Today.AddHours(7)).AddDays(c.ValutaPlacanja ?? 999999) < DateTime.Today.AddHours(7))).ToList();
IEnumerable <DnevnikPrevoza> filteredList;
var FSerijskiBroj = Convert.ToString(Request["sSearch_0"]).ToLower();
var FSubjekt = Convert.ToString(Request["sSearch_1"]).ToLower();
var FUI = Convert.ToString(Request["sSearch_2"]).ToLower();
var FCijenaPrevoza = Convert.ToString(Request["sSearch_3"]).ToLower();
var FDatumSlanjaFakture = Convert.ToString(Request["sSearch_4"]).ToLower();
var FValutaPlacanja = Convert.ToString(Request["sSearch_5"]).ToLower();
var FValutaIstekla = Convert.ToString(Request["sSearch_6"]).ToLower();
filteredList = list.Where(c =>
(c.SerijskiBroj).ToLower().Contains(FSerijskiBroj) &&
(c.DatumSlanjaFakture.Value.ToString("dd.MM.yyyy")).ToLower().Contains(FDatumSlanjaFakture) &&
(c.Subjekt1.Naziv).ToLower().Contains(FSubjekt) &&
(c.UtovarGrad + c.IstovarGrad).ToLower().Contains(FUI) &&
(c.CijenaPrevoza.ToString()).ToLower().Contains(FCijenaPrevoza) &&
(c.ValutaPlacanja.ToString()).ToLower().Contains(FValutaPlacanja) &&
(c.DatumSlanjaFakture.Value.AddDays(c.ValutaPlacanja ?? 0).ToString("dd.MM.yyyy")).ToLower().Contains(FValutaIstekla)
);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredList = filteredList.Where(c =>
(c.SerijskiBroj).ToLower().Contains(param.sSearch) ||
(c.DatumSlanjaFakture.Value.ToString("dd.MM.yyyy")).ToLower().Contains(param.sSearch) ||
(c.Subjekt1.Naziv).ToLower().Contains(param.sSearch) ||
(c.UtovarGrad + c.IstovarGrad).ToLower().Contains(param.sSearch) ||
(c.CijenaPrevoza.ToString()).ToLower().Contains(param.sSearch) ||
(c.ValutaPlacanja.ToString()).ToLower().Contains(param.sSearch) ||
(c.DatumSlanjaFakture.Value.AddDays(c.ValutaPlacanja ?? 0).ToString("dd.MM.yyyy")).ToLower().Contains(param.sSearch)
);
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <DnevnikPrevoza, object> orderingFunction = c =>
{
switch (sortColumnIndex)
{
case 0: return(c.SerijskiBroj);
case 1: return(c.Subjekt1.Naziv);
case 2: return(c.UtovarGrad + c.IstovarGrad);
case 3: return(c.CijenaPrevoza + " " + c.Valuta.OznakaValute);
case 4: return(c.DatumSlanjaFakture.Value.ToString("yyyy-MM-dd"));
case 5: return(c.ValutaPlacanja);
case 6: return(c.DatumSlanjaFakture.Value.AddDays(c.ValutaPlacanja ?? 0).ToString("yyyy-MM-dd"));
default: return(c.SerijskiBroj);
}
};
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredList = filteredList.OrderBy(orderingFunction);
}
else
{
filteredList = filteredList.OrderByDescending(orderingFunction);
}
var displayedList = filteredList.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedList
select new object[] {
c.SerijskiBroj,
c.Subjekt1.Naziv,
c.UtovarGrad + " / " + c.IstovarGrad,
c.CijenaPrevoza + " " + c.Valuta.OznakaValute,
c.DatumSlanjaFakture.Value.ToString("dd.MM.yyyy"),
c.ValutaPlacanja,
c.DatumSlanjaFakture.Value.AddDays(c.ValutaPlacanja ?? 0).ToString("dd.MM.yyyy"),
c.IdDnevnik
};
return(Json(new
{
position = 25,
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = filteredList.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
//
public ActionResult IndexAjax(jQueryDataTableParamModel param)
{
var list = db.DnevnikValute.Include(d => d.DnevnikPrevoza).ToList();
IEnumerable <DnevnikValute> filteredList;
var FIdDnevnikValute = Convert.ToString(Request["sSearch_0"]).ToLower();
var FIdDnevnik = Convert.ToString(Request["sSearch_1"]).ToLower();
var FDatumAktivnosti = Convert.ToString(Request["sSearch_2"]).ToLower();
var FAktivnost = Convert.ToString(Request["sSearch_3"]).ToLower();
var FDetalji = Convert.ToString(Request["sSearch_4"]).ToLower();
filteredList = list.Where(c =>
(String.IsNullOrEmpty("" + c.IdDnevnikValute) ? "" : "" + c.IdDnevnikValute).ToLower().Contains(FIdDnevnikValute) &&
(String.IsNullOrEmpty("" + c.IdDnevnik) ? "" : "" + c.IdDnevnik).ToLower().Contains(FIdDnevnik) &&
(String.IsNullOrEmpty("" + c.DatumAktivnosti) ? "" : "" + c.DatumAktivnosti).ToLower().Contains(FDatumAktivnosti) &&
(String.IsNullOrEmpty("" + c.Aktivnost) ? "" : "" + c.Aktivnost).ToLower().Contains(FAktivnost) &&
(String.IsNullOrEmpty("" + c.Detalji) ? "" : "" + c.Detalji).ToLower().Contains(FDetalji)
);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredList = filteredList.Where(c =>
(String.IsNullOrEmpty("" + c.IdDnevnikValute) ? "" : "" + c.IdDnevnikValute).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.IdDnevnik) ? "" : "" + c.IdDnevnik).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.DatumAktivnosti) ? "" : "" + c.DatumAktivnosti).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.Aktivnost) ? "" : "" + c.Aktivnost).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.Detalji) ? "" : "" + c.Detalji).ToLower().Contains(param.sSearch.ToLower())
);
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <DnevnikValute, object> orderingFunction = c =>
{
switch (sortColumnIndex)
{
case 0: return(c.IdDnevnikValute);
case 1: return(c.IdDnevnik);
case 2: return(c.DatumAktivnosti);
case 3: return(c.Aktivnost);
case 4: return(c.Detalji);
default: return(c.IdDnevnikValute);
}
};
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredList = filteredList.OrderBy(orderingFunction);
}
else
{
filteredList = filteredList.OrderByDescending(orderingFunction);
}
var displayedList = filteredList.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedList select new object[] {
c.IdDnevnikValute,
c.IdDnevnik,
String.IsNullOrEmpty("" + c.DatumAktivnosti) ? "" : DateTime.Parse(c.DatumAktivnosti.ToString()).ToString("dd.MM.yyyy"),
c.Aktivnost,
c.Detalji,
""
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = filteredList.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public ActionResult IndexAjax(jQueryDataTableParamModel param)
{
var list = db.Troskovi.Include(t => t.DnevnikPrevoza).Include(t => t.Valuta).ToList();
IEnumerable <Troskovi> filteredList;
var FIdTroskovi = Convert.ToString(Request["sSearch_0"]).ToLower();
var FIdDnevnik = Convert.ToString(Request["sSearch_1"]).ToLower();
var FIznos = Convert.ToString(Request["sSearch_2"]).ToLower();
var FIdValuta = Convert.ToString(Request["sSearch_3"]).ToLower();
var FVrsta = Convert.ToString(Request["sSearch_4"]).ToLower();
filteredList = list.Where(c =>
(String.IsNullOrEmpty("" + c.IdTroskovi) ? "" : "" + c.IdTroskovi).ToLower().Contains(FIdTroskovi) &&
(String.IsNullOrEmpty("" + c.IdDnevnik) ? "" : "" + c.IdDnevnik).ToLower().Contains(FIdDnevnik) &&
(String.IsNullOrEmpty("" + c.Iznos) ? "" : "" + c.Iznos).ToLower().Contains(FIznos) &&
(String.IsNullOrEmpty("" + c.IdValuta) ? "" : "" + c.IdValuta).ToLower().Contains(FIdValuta) &&
(String.IsNullOrEmpty("" + c.Vrsta) ? "" : "" + c.Vrsta).ToLower().Contains(FVrsta)
);
if (!string.IsNullOrEmpty(param.sSearch))
{
filteredList = filteredList.Where(c =>
(String.IsNullOrEmpty("" + c.IdTroskovi) ? "" : "" + c.IdTroskovi).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.IdDnevnik) ? "" : "" + c.IdDnevnik).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.Iznos) ? "" : "" + c.Iznos).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.IdValuta) ? "" : "" + c.IdValuta).ToLower().Contains(param.sSearch.ToLower())
|| (String.IsNullOrEmpty("" + c.Vrsta) ? "" : "" + c.Vrsta).ToLower().Contains(param.sSearch.ToLower())
);
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func <Troskovi, object> orderingFunction = c =>
{
switch (sortColumnIndex)
{
case 0: return(c.IdTroskovi);
case 1: return(c.IdDnevnik);
case 2: return(c.Iznos);
case 3: return(c.IdValuta);
case 4: return(c.Vrsta);
default: return(c.IdTroskovi);
}
};
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
{
filteredList = filteredList.OrderBy(orderingFunction);
}
else
{
filteredList = filteredList.OrderByDescending(orderingFunction);
}
var displayedList = filteredList.Skip(param.iDisplayStart).Take(param.iDisplayLength);
var result = from c in displayedList select new object[] {
c.IdTroskovi,
c.IdDnevnik,
c.Iznos,
c.IdValuta,
c.Vrsta,
""
};
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = filteredList.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet));
}
