public string AngajatiImport(AngajatiObiect oAngajati)
{
string Eroare = "";
//Nullable<int> IdEroare = null, Id = null;
DateTime DataAngajarii = DateTime.Now;
Nullable <DateTime> DataNedeterminata = null;
DateTime DataNasterii = DateTime.Now;
DataClassWbmOlimpias dcWbmOlimpias = new DataClassWbmOlimpias();
foreach (AngajatObiect oAngajat in oAngajati.Tabela)
{
DataAngajarii = DateTime.ParseExact(oAngajat.DataAngajarii, "yyyyMMdd", null, System.Globalization.DateTimeStyles.None);
if (oAngajat.DataNedeterminat != "00000")
{
DataNedeterminata = DateTime.ParseExact(oAngajat.DataNedeterminat, "yyyyMMdd", null, System.Globalization.DateTimeStyles.None);
}
if (!DateTime.TryParseExact(oAngajat.NumarIdentificarePersonala.Substring(0, 4) + "1" + oAngajat.NumarIdentificarePersonala.Substring(4, 3), "ddMMyyyy", null, System.Globalization.DateTimeStyles.None, out DataNasterii))
{
DataNasterii = DateTime.Now;
}
dcWbmOlimpias.AngajatImport(Convert.ToString(oAngajat.CodAngajat), oAngajat.Nume, oAngajat.Prenume, Convert.ToInt32(oAngajat.CodSistem), oAngajat.Marca, oAngajat.NumarIdentificarePersonala, oAngajat.Sex, DataAngajarii, oAngajat.oLocalitate.Localitate, oAngajat.Strada, oAngajat.oPostDeLucru.CodPostDeLucru, oAngajat.oPostDeLucru.PostDeLucru, oAngajat.oDepartament.CodDepartament, oAngajat.oDepartament.Departament, oAngajat.oIncadrare.CodIncadrare, oAngajat.oIncadrare.Incadrare, DataNedeterminata, oAngajat.CC, "nu are cod tip post de lucru", oAngajat.oTipPostDeLucru.TipPostDeLucru, DataNasterii, oAngajat.oLoculNasterii.Localitate, 1);
}
return(Eroare);
}
public AngajatiObiect AngajatiLista(FiltruAngajatiObiect oFiltruAngajat, int PaginaCurenta)
{
AngajatiObiect oAngajati = new AngajatiObiect();
if (GlobalClass.VerificareAcces("Angajati", "1"))
{
DataClassWbmOlimpias dcWbmOlimpias = new DataClassWbmOlimpias();
var query = from tAngajati in dcWbmOlimpias.AngajatiViews
orderby tAngajati.Nume, tAngajati.Id
select new { tAngajati.Id, tAngajati.CodAngajat, tAngajati.CodSistem, tAngajati.Marca, tAngajati.Nume, tAngajati.Prenume, tAngajati.Departament, tAngajati.Echipa, tAngajati.Linie };
if (!String.IsNullOrEmpty(oFiltruAngajat.FiltruCodAngajat))
{
query = query.Where(x => x.CodAngajat.Contains(oFiltruAngajat.FiltruCodAngajat));
}
if (!String.IsNullOrEmpty(oFiltruAngajat.FiltruCodSistem))
{
query = query.Where(x => x.CodSistem.ToString().Contains(oFiltruAngajat.FiltruCodSistem));
}
if (!String.IsNullOrEmpty(oFiltruAngajat.FiltruMarca))
{
query = query.Where(x => x.Marca.Contains(oFiltruAngajat.FiltruMarca));
}
if (!String.IsNullOrEmpty(oFiltruAngajat.FiltruNume))
{
query = query.Where(x => x.Nume.Contains(oFiltruAngajat.FiltruNume));
}
if (!String.IsNullOrEmpty(oFiltruAngajat.FiltruDepartament))
{
query = query.Where(x => x.Departament.Contains(oFiltruAngajat.FiltruDepartament));
}
if (!String.IsNullOrEmpty(oFiltruAngajat.FiltruEchipa))
{
query = query.Where(x => x.Echipa.Contains(oFiltruAngajat.FiltruEchipa));
}
if (!String.IsNullOrEmpty(oFiltruAngajat.FiltruLinie))
{
query = query.Where(x => x.Linie.Contains(oFiltruAngajat.FiltruLinie));
}
oAngajati.NumarPagini = (query.Count() - 1) / 5 + 1;
if (oFiltruAngajat.Find == "")
{
oAngajati.PaginaCurenta = PaginaCurenta;
oAngajati.IndexRand = 0;
}
else
{
int Pozitie = 0;
Pozitie = query.ToList().FindIndex(A => A.Id.Equals(Convert.ToInt32(oFiltruAngajat.Find)));
oAngajati.PaginaCurenta = Pozitie / 5 + 1;
oAngajati.IndexRand = Pozitie - (oAngajati.PaginaCurenta - 1) * 5;
}
if (oAngajati.NumarPagini < oAngajati.PaginaCurenta)
{
oAngajati.PaginaCurenta = oAngajati.NumarPagini;
}
if (oAngajati.PaginaCurenta < 1)
{
oAngajati.PaginaCurenta = 1;
}
foreach (var rezultat in query.Skip(5 * (oAngajati.PaginaCurenta - 1)).Take(10))
{
AngajatObiect oAngajat = new AngajatObiect();
oAngajat.Id = rezultat.Id.ToString();
oAngajat.CodAngajat = rezultat.CodAngajat;
oAngajat.CodSistem = rezultat.CodSistem.ToString();
oAngajat.Marca = rezultat.Marca;
oAngajat.Nume = rezultat.Nume;
oAngajat.Prenume = rezultat.Prenume;
oAngajat.oDepartament.Departament = rezultat.Departament;
oAngajati.Tabela.Add(oAngajat);
}
}
else
{
oAngajati.Eroare = "Acces interzis!";
}
return(oAngajati);
}
