public SalariuAngajatObiect SalariuAngajatAdaugare(SalariuAngajatObiect oSalariuAngajat)
{
if (GlobalClass.VerificareAccesOperatie("Angajati", "1", "Adaugare"))
{
Nullable <int> Id = null, IdEroare = null;
oSalariuAngajat.Eroare = VerificareDate(oSalariuAngajat);
if (oSalariuAngajat.Eroare == "")
{
DateTime DataSalariu = DateTime.ParseExact(oSalariuAngajat.DataSalariu, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None);
DataClassWbmOlimpias dcWbmOlimpias = new DataClassWbmOlimpias();
dcWbmOlimpias.SalariuAngajatAdaugare(Convert.ToInt32(oSalariuAngajat.IdAngajat), DataSalariu, oSalariuAngajat.MarireSalar, oSalariuAngajat.SalarActual, Convert.ToInt32("1"), ref Id, ref IdEroare);
oSalariuAngajat.Eroare = InterpretareEroare(IdEroare.ToString());
oSalariuAngajat.Id = Id.ToString();
}
if (oSalariuAngajat.Eroare != "")
{
oSalariuAngajat.Id = "";
}
}
else
{
oSalariuAngajat.Eroare = "Nu aveti drept de adaugare!";
}
return(oSalariuAngajat);
}
private string VerificareDate(SalariuAngajatObiect oSalariuAngajat)
{
string Eroare = "";
DateTime dateTime;
if (!DateTime.TryParseExact(oSalariuAngajat.DataSalariu, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out dateTime))
{
Eroare = InterpretareEroare("3");
}
return(Eroare);
}
public SalariiAngajatObiect SalariiAngajatLista(FiltruSalariiAngajatObiect oFiltruSalariiAngajat, int PaginaCurenta, string IdAngajat)
{
SalariiAngajatObiect oSalariiAngajat = new SalariiAngajatObiect();
if (GlobalClass.VerificareAcces("Angajati", "1"))
{
DataClassWbmOlimpias dcWbmOlimpias = new DataClassWbmOlimpias();
var query = from tSalariiAngajat in dcWbmOlimpias.SalariiAngajats
where tSalariiAngajat.IdAngajat.Equals(IdAngajat) && tSalariiAngajat.IdUtilizatorStergere.Equals(null)
orderby tSalariiAngajat.Id
select new { tSalariiAngajat.Id, tSalariiAngajat.DataSalariu, tSalariiAngajat.MarireSalar, tSalariiAngajat.SalarActual };
oSalariiAngajat.NumarPagini = (query.Count() - 1) / 5 + 1;
if (oFiltruSalariiAngajat.Find == "")
{
oSalariiAngajat.PaginaCurenta = PaginaCurenta;
oSalariiAngajat.IndexRand = 0;
}
else
{
int Pozitie = 0;
Pozitie = query.ToList().FindIndex(A => A.Id.Equals(Convert.ToInt32(oFiltruSalariiAngajat.Find)));
oSalariiAngajat.PaginaCurenta = Pozitie / 5 + 1;
oSalariiAngajat.IndexRand = Pozitie - (oSalariiAngajat.PaginaCurenta - 1) * 5;
}
if (oSalariiAngajat.NumarPagini < oSalariiAngajat.PaginaCurenta)
{
oSalariiAngajat.PaginaCurenta = oSalariiAngajat.NumarPagini;
}
if (oSalariiAngajat.PaginaCurenta < 1)
{
oSalariiAngajat.PaginaCurenta = 1;
}
foreach (var rezultat in query.Skip(5 * (oSalariiAngajat.PaginaCurenta - 1)).Take(5))
{
SalariuAngajatObiect oSalariuAngajat = new SalariuAngajatObiect();
oSalariuAngajat.Id = rezultat.Id.ToString();
oSalariuAngajat.DataSalariu = rezultat.DataSalariu.ToString("dd.MM.yyyy");
oSalariuAngajat.MarireSalar = rezultat.MarireSalar;
oSalariuAngajat.SalarActual = rezultat.SalarActual;
oSalariiAngajat.Tabela.Add(oSalariuAngajat);
}
}
else
{
oSalariiAngajat.Eroare = "Acces interzis!";
}
return(oSalariiAngajat);
}
public SalariuAngajatObiect SalariuAngajatProprietati(string Id)
{
SalariuAngajatObiect oSalariuAngajat = new SalariuAngajatObiect();
if (GlobalClass.VerificareAcces("Angajati", "1"))
{
DataClassWbmOlimpias dcWbmOlimpias = new DataClassWbmOlimpias();
var query = from tSalariiAngajat in dcWbmOlimpias.SalariiAngajats
where tSalariiAngajat.Id.Equals(Id)
select new { tSalariiAngajat.Id, tSalariiAngajat.DataSalariu, tSalariiAngajat.MarireSalar, tSalariiAngajat.SalarActual };
oSalariuAngajat.DataSalariu = query.First().DataSalariu.ToString("dd.MM.yyyy");
oSalariuAngajat.MarireSalar = query.First().MarireSalar;
oSalariuAngajat.SalarActual = query.First().SalarActual;
}
else
{
oSalariuAngajat.Eroare = "Acces interzis!";
}
return(oSalariuAngajat);
}
