public Select2Model ObtenerInstituciones(string term_search, int page)
{
Select2Model result = new Select2Model();
var lista = this.Context.Set <institutions>();
IQueryable <institutions> queryFilters = lista;
if (!String.IsNullOrEmpty(term_search))
{
queryFilters = lista.Where(a => a.name.Contains(term_search));
}
result.total_count = queryFilters.Count();
var query = queryFilters.Select(a => new Select2ItemModel
{
id = a.institution_id.ToString(),
text = a.name
});
string sortExpression = "text asc";
if (sortExpression.Trim() != "")
{
query = OrderByDinamic.OrderBy <Select2ItemModel>(query, sortExpression.Trim());
}
result.items = query.Skip((page - 1) * 10).Take(10).ToList();
return(result);
}
public JsonResult PrelevaMesiAnniElab(string search)
{
List <Select2Model> ls2 = new List <Select2Model>();
List <MeseAnnoElaborazioneModel> lmaem = new List <MeseAnnoElaborazioneModel>();
try
{
using (dtElaborazioni dte = new dtElaborazioni())
{
lmaem = dte.PrelevaAnniMesiElaborati().ToList();
foreach (var mae in lmaem)
{
Select2Model s2 = new Select2Model()
{
id = mae.idMeseAnnoElab.ToString(),
text = CalcoloMeseAnnoElaborazione.NomeMese((EnumDescrizioneMesi)mae.mese) + "-" + mae.anno.ToString(),
};
ls2.Add(s2);
}
}
if (search != null && search != string.Empty)
{
ls2 = ls2.Where(a => a.text.ToUpper().Contains(search.ToUpper())).ToList();
}
}
catch (Exception ex)
{
return(Json(new { results = new List <Select2Model>(), err = ex.Message }));
}
return(Json(new { results = ls2, err = "" }));
}
public IActionResult GetUserInfo(string term, string value, int page = 0)
{
var query = this._userService.GetAll();
if (!string.IsNullOrEmpty(term))
{
query = query.Where(p => p.UserName.Contains(term) || p.Tel.Contains(term)); //同时使用用户名和手机号码查询
}
if (!string.IsNullOrEmpty(value))
{
int m_value = 0;
if (int.TryParse(value, out m_value))
{
query = query.Where(p => p.Id == m_value);
}
}
Select2Model sm = new Select2Model();
sm.incomplete_results = true;
sm.total_count = query.Count();
var data = query.OrderBy(o => o.UserName).Skip(page * 30).Take(30).Select(s => new { id = s.Id, text = s.UserName });
sm.items = data.ToList();
return(Json(sm));
}
public JsonResult PrelevaVoci(string search)
{
List <Select2Model> ls2 = new List <Select2Model>();
List <VociManualiModel> lvm = new List <VociManualiModel>();
try
{
using (dtVoci dtvm = new dtVoci())
{
lvm = dtvm.GetVociManuali().ToList();
foreach (var vm in lvm)
{
Select2Model s2 = new Select2Model()
{
id = vm.idVoci.ToString(),
text = vm.DescVoce
};
ls2.Add(s2);
}
}
}
catch (Exception ex)
{
return(Json(new { results = new List <Select2Model>(), err = ex.Message }));
}
return(Json(new { results = ls2, err = "" }));
}
public JsonResult ListaRuoliDipendente(string search, DateTime dtRif, decimal idTrasferimento)
{
try
{
using (ModelDBISE db = new ModelDBISE())
{
using (dtTrasferimento dtt = new dtTrasferimento())
{
using (dtRuoloUfficio dtru = new dtRuoloUfficio())
{
using (dtLivelliDipendente dtld = new dtLivelliDipendente())
{
var t = dtt.GetTrasferimentoById(idTrasferimento);
var livelloDipendenteValido = dtld.GetLivelloDipendente(t.idDipendente, dtRif);
var lru = dtru.GetListRuoloUfficioByLivello(livelloDipendenteValido.idLivello);
VariazioneRuoloDipendenteModel vrdm = new VariazioneRuoloDipendenteModel();
List <Select2Model> lRuoli = new List <Select2Model>();
var r = new List <Select2Model>();
if (lru != null && lru.Count > 0)
{
foreach (var ru in lru)
{
Select2Model s2 = new Select2Model()
{
id = ru.idRuoloUfficio.ToString(),
text = ru.DescrizioneRuolo.ToString()
};
r.Add(s2);
}
}
lRuoli = r;
ViewBag.lRuoli = lRuoli;
return(Json(new { results = lRuoli, err = "" }));
}
}
}
}
}
catch (Exception ex)
{
return(Json(new { results = new List <Select2Model>(), err = ex.Message }));
}
}
public ActionResult GetStudentList(string q)
{
var list = new List <Select2Model>();
List <Student> schoolList = new List <Student>();
using (var dbcontext = new SchoolERPDBContext())
{
if (!(string.IsNullOrEmpty(q) || string.IsNullOrWhiteSpace(q)))
{
string newLine = ((char)13).ToString() + ((char)10).ToString();;
schoolList = (from stu in dbcontext.Student
join cls in dbcontext.Class on stu.Class_Id equals cls.Id
join sec in dbcontext.Section on stu.Section_Id equals sec.Id
where stu.First_Name.Contains(q.ToLower())
select new
{
Text = stu.First_Name + " " + stu.Last_Name + " " +
Environment.NewLine
+ "[" + stu.Roll_No + "]" + " - " + cls.Name + " " + sec.Name,
Id = stu.Student_Id
}).ToList().
Select(x => new Student
{
First_Name = x.Text,
Student_Id = x.Id
}).ToList();
}
}
for (int i = 0; i < schoolList.Count(); i++)
{
Select2Model oSelect2Model = new Select2Model();
oSelect2Model.text = schoolList[i].First_Name;
oSelect2Model.id = schoolList[i].Student_Id.ToString();
list.Add(oSelect2Model);
}
if (!(string.IsNullOrEmpty(q) || string.IsNullOrWhiteSpace(q)))
{
list = list.Where(x => x.text.ToLower().Contains(q.ToLower())).ToList();
}
//return Json(new { data = schoolList }, JsonRequestBehavior.AllowGet);
return(Json(new { items = list }, JsonRequestBehavior.AllowGet));
}
public JsonResult ObtenerInstituciones(/*string q, int page*/)
{
UserBL oUserBL = new UserBL();
string term_search = Request.Form["q"];
string qpage = Request.Form["page"];
int page = 0;
int.TryParse(qpage, out page);
// var resultado = oUserBL.VerificarDuplicado(user_id, email);
Select2Model results = oUserBL.ObtenerInstituciones(term_search, page);
return(Json(results));
}
public ActionResult GetEmployeeList(string q)
{
var list = new List <Select2Model>();
List <School> schoolList = new List <School>();
using (var dbcontext = new SchoolERPDBContext())
{
if (!(string.IsNullOrEmpty(q) || string.IsNullOrWhiteSpace(q)))
{
schoolList = (from school in dbcontext.School
where school.Name.Contains(q.ToLower())
select new
{
Text = school.Name,
Id = school.Id
}).ToList().
Select(x => new School
{
Name = x.Text,
Id = x.Id
}).ToList();
}
}
for (int i = 0; i < schoolList.Count(); i++)
{
Select2Model oSelect2Model = new Select2Model();
oSelect2Model.text = schoolList[i].Name;
oSelect2Model.id = schoolList[i].Id.ToString();
list.Add(oSelect2Model);
}
if (!(string.IsNullOrEmpty(q) || string.IsNullOrWhiteSpace(q)))
{
list = list.Where(x => x.text.ToLower().Contains(q.ToLower())).ToList();
}
//return Json(new { data = schoolList }, JsonRequestBehavior.AllowGet);
return(Json(new { items = list }, JsonRequestBehavior.AllowGet));
}
public JsonResult PrelevaAnni(string search)
{
List <Select2Model> ls2 = new List <Select2Model>();
int numeroAnniVociManuali = Convert.ToInt16(System.Configuration.ConfigurationManager.AppSettings["NumeroAnniVociManuali"]);
try
{
var anni = new List <dynamic>();
int i = DateTime.Now.Year - numeroAnniVociManuali;
int fine = DateTime.Now.Year + numeroAnniVociManuali;
for (var j = i; j <= fine; j++)
{
var anno = new { id = j.ToString(), DescAnno = j.ToString() };
anni.Add(anno);
}
foreach (var a in anni)
{
Select2Model s2 = new Select2Model()
{
id = a.id.ToString(),
text = a.DescAnno.ToString(),
};
ls2.Add(s2);
}
if (search != null && search != string.Empty)
{
ls2 = ls2.Where(a => a.text.ToUpper().Contains(search.ToUpper())).ToList();
}
}
catch (Exception ex)
{
return(Json(new { results = new List <Select2Model>(), err = ex.Message }));
}
return(Json(new { results = ls2, err = "" }));
}
public JsonResult GetCustomers(string searchTerm, int pageSize = 0, int pageNum = 0)
{
List <Customer> customers;
if (searchTerm == null)
{
customers = _customerService.GetAllCustomers(take: pageSize, skip: (pageNum * pageSize) - 100);
}
else
{
customers = _customerService.GetAllCustomers(k => k.DisplayName.Contains(searchTerm), take: pageSize, skip: (pageNum * pageSize) - 100);
}
var result = new
{
Total = customers.Count(),
Results = Select2Model.CustomerSelect2Model(customers)
};
return(new JsonResult(result));
}
public JsonResult GetCountries(string searchTerm, int pageSize = 0, int pageNum = 0)
{
List <Country> countries;
if (searchTerm == null)
{
countries = _addressService.GetCountries(take: pageSize, skip: (pageNum * pageSize) - 100);
}
else
{
countries = _addressService.GetCountries(k => k.Name.Contains(searchTerm), take: pageSize, skip: (pageNum * pageSize) - 100);
}
var result = new
{
Total = countries.Count(),
Results = Select2Model.CountrySelect2Model(countries)
};
return(new JsonResult(result));
}
public JsonResult GetDistricts(string searchTerm, int pageSize = 0, int pageNum = 0, int cityId = 0)
{
List <District> districts;
if (searchTerm == null)
{
districts = _addressService.GetDistricts(k => k.CityId == cityId, take: pageSize, skip: (pageNum * pageSize) - 100);
}
else
{
districts = _addressService.GetDistricts(k => k.CityId == cityId && k.Name.Contains(searchTerm),
take: pageSize, skip: (pageNum * pageSize) - 100);
}
var result = new
{
Total = districts.Count(),
Results = Select2Model.DistrictSelect2Model(districts)
};
return(new JsonResult(result));
}
public JsonResult PrelevaMesi(string search)
{
List <Select2Model> ls2 = new List <Select2Model>();
try
{
var mesi = new List <dynamic>();
for (int i = 1; i <= 12; i++)
{
var mese = new { id = i.ToString(), DescMese = (EnumDescrizioneMesi)i };
mesi.Add(mese);
}
foreach (var m in mesi)
{
Select2Model s2 = new Select2Model()
{
id = m.id.ToString(),
text = m.DescMese.ToString(),
};
ls2.Add(s2);
}
if (search != null && search != string.Empty)
{
ls2 = ls2.Where(a => a.text.ToUpper().Contains(search.ToUpper())).ToList();
}
}
catch (Exception ex)
{
return(Json(new { results = new List <Select2Model>(), err = ex.Message }));
}
return(Json(new { results = ls2, err = "" }));
}
public JsonResult PrelevaMatricole(string search)
{
List <Select2Model> ls2 = new List <Select2Model>();
List <DipendentiModel> ldipm = new List <DipendentiModel>();
try
{
using (dtDipendenti dtd = new dtDipendenti())
{
ldipm = dtd.GetDipendentiAnyTrasf().ToList();
foreach (var dipm in ldipm)
{
Select2Model s2 = new Select2Model()
{
id = dipm.idDipendente.ToString(),
text = dipm.Nominativo + " (" + dipm.matricola + ")",
};
ls2.Add(s2);
}
if (search != null && search != string.Empty)
{
ls2 = ls2.Where(a => a.text.ToUpper().Contains(search.ToUpper())).ToList();
}
}
}
catch (Exception ex)
{
return(Json(new { results = new List <Select2Model>(), err = ex.Message }));
}
return(Json(new { results = ls2, err = "" }));
}
