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