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); }