/// <summary> /// Procedura verifica daca functia aleasa coincide cu incadrarea angajatului (scutit/nescutit) de impozit la momentul respectiv /// </summary> /// <returns>Procedura returneaza true sau false daca functia coincide cu incadrare </returns> // Lungu Andreea - 24.07.2008 // se verifica daca functia care se doreste coincide cu incadrarea angajatului (scutit/nescutit) public bool CheckIfFunctiaCoincideCuIncadrarea() { //sunt aduse toate schimbarile angajatului Salaries.Data.IstoricSchimbareDateAngajat istSch = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); DataSet dsSch = istSch.LoadIstoricSchimbari(angajatId); DataTable dt = dsSch.Tables[0]; DataRow myRow = null; //se cauta schimbarea corespunzatoare datei introduse foreach (DataRow dr in dt.Rows) { if (((DateTime)dr["DataStart"] <= dataStartNoua) && (dataStartNoua <= (DateTime)dr["DataEnd"])) { myRow = dr; break; } } if (myRow != null) { //se aduc informatii despre categoria aflata in istoric schimbari Salaries.Data.AdminSalariiCategoriiAngajati adminCateg = new Salaries.Data.AdminSalariiCategoriiAngajati(settings.ConnectionString); DataSet dsCateg = adminCateg.GetCategorie(Int32.Parse(myRow["CategorieId"].ToString())); bool scutireImpozit = (bool)dsCateg.Tables[0].Rows[0]["ScutireImpozit"]; //se aduc informatii despre functia care se doreste a fi introdusa Salaries.Data.AdminFunctii admFunct = new Salaries.Data.AdminFunctii(settings.ConnectionString); DataSet dsFunct = admFunct.GetFunctieInfo(functieId); bool suportaImpozit = (bool)dsFunct.Tables[0].Rows[0]["PosibilaScutireImpozit"]; if (scutireImpozit && !suportaImpozit) //daca categoria din istoric schimbari are scutire impozit si noua functie nu suporta scutire { return(false); } } return(true); }
/// <summary> /// Procedura selecteaza ultimul interval /// </summary> /// <returns>Returneaza un obiect IstoricSchimbareDateAngajat care contine aceste date</returns> public IstoricSchimbareDateAngajat GetLastIntervalSchimbare() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); DataRow dr = istSchimbare.GetLastIntervalSchimbare(angajatId); IstoricSchimbareDateAngajat ints = new IstoricSchimbareDateAngajat(); if (dr != null) { ints.DataStart = (DateTime)dr["DataStart"]; ints.DataEnd = (DateTime)dr["DataEnd"]; ints.AngajatId = angajatId; ints.ProgramLucru = int.Parse(dr["ProgramLucru"].ToString()); ints.SalariuBaza = decimal.Parse(dr["SalariuBaza"].ToString()); ints.IndemnizatieConducere = decimal.Parse(dr["IndemnizatieConducere"].ToString()); ints.InvaliditateId = int.Parse(dr["Invaliditate"].ToString()); ints.CategorieId = int.Parse(dr["CategorieID"].ToString()); } return(ints); }
/// <summary> /// Procedura verifica daca o anumita data este specificata ca si sarbatoare /// </summary> /// <returns>Returneaza true daca este sarbatoare si false altfel</returns> public bool DataEsteZiSarbatoare() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); return(istSchimbare.DataEsteZiSarbatoare(dataStart)); }
/// <summary> /// Procedura verifica daca o data este in luna activa /// </summary> /// <returns>Returneaza true daca e in interval si false altfel</returns> public bool DataInLunaActiva() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); return(istSchimbare.DataInLunaActiva(dataStart)); }
/// <summary> /// Procedura sterge o schimbare /// </summary> public void DeleteSchimbare() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); istSchimbare.DeleteSchimbare(dataStart, dataEnd, angajatId); }
/// <summary> /// Returneaza id-ul categoriei /// </summary> /// <returns>Returneaza id-ul categoriei</returns> public int GetCategorieCorspunzatoareDinLunaActiva() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); return(istSchimbare.GetCategorieCorspunzatoareDinLunaActiva(categorieId, angajatId)); }
/// <summary> /// Procedura selecteaza capatul de interval pentru o data a unui angajat /// </summary> /// <returns>Returneaza un DataSet care contine aceste date</returns> public DataSet GetCapatIntervalAngajatZi() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); return(istSchimbare.GetCapatIntervalAngajatZi(dataStart, angajatId)); }
/// <summary> /// Procedura adauga o schimbare pentru indemnizatia de conducere /// </summary> public void InsertSchimbareCategorie() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); istSchimbare.InsertSchimbareCategorie(angajatId, categorieId, dataStart, dataEnd); }
/// <summary> /// Procedura actualizeaza un capat de interval /// </summary> public void UpdateCapatIntervalSchimbareAngajat() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); istSchimbare.UpdateCapatIntervalSchimbareAngajat(intervalAngajatId, dataStart, dataEnd, angajatId, programLucru, salariuBaza, indemnizatieConducere, invaliditateId, categorieId); }
/// <summary> /// Procedura adauga o schimbare pentru indemnizatia de conducere /// </summary> public void InsertSchimbareIndemnizatieConducere() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); istSchimbare.InsertSchimbareIndemnizatieConducere(angajatId, indemnizatieConducere, dataStart, dataEnd); }
/// <summary> /// Procedura adauga o schimbare pentru salariul de baza /// </summary> public void InsertSchimbareSalariuBaza() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); istSchimbare.InsertSchimbareSalariuBaza(angajatId, salariuBaza, dataStart, dataEnd); }
/// <summary> /// Procedura adauga o schimbare pentru programul de lucru /// </summary> public void InsertSchimbareProgramLucru() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); istSchimbare.InsertSchimbareProgramLucru(angajatId, programLucru, dataStart, dataEnd); }
/// <summary> /// Procedura selecteaza toate tipurile de invaliditati /// </summary> /// <returns>Returneaza un DataSet care contine aceste date</returns> public DataSet GetAllInvaliditati() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); return(istSchimbare.GetAllInvaliditati()); }
/// <summary> /// Procedura selectaza schimbarile unui angajat /// </summary> /// <returns>Returneaza un DataSet care contine aceste date</returns> public DataSet LoadIstoricSchimbari() { Salaries.Data.IstoricSchimbareDateAngajat istSchimbare = new Salaries.Data.IstoricSchimbareDateAngajat(settings.ConnectionString); return(istSchimbare.LoadIstoricSchimbari(angajatId)); }