/// <summary>
/// Procedura selecteaza detaliile unor coeficienti
/// </summary>
private void LoadCoeficientiID()
{
Data.Coeficienti coeficienti = new Data.Coeficienti(settings.ConnectionString);
Data.DetaliiCoeficienti detalii = coeficienti.GetDetalii(setID);
deLa = detalii.DeLa;
deducere = detalii.Deducere;
coefInvalidGrd1 = detalii.CoefInvalidGrd1;
coefInvalidGrd2 = detalii.CoefInvalidGrd2;
coefCopil12 = detalii.CoefCopil12;
coefCopil3 = detalii.CoefCopil3;
coefUrmCopil = detalii.CoefUrmCopil;
coefSot = detalii.CoefSot;
coefTotal = detalii.CoefTotal;
coefSanatate = detalii.CoefSanatate;
coefPensie = detalii.CoefPensie;
coefSomaj = detalii.CoefSomaj;
coefCheltProf = detalii.CoefCheltProf;
cASAngajator = detalii.CASAngajator;
sanatateAngajator = detalii.SanatateAngajator;
somajAngajator = detalii.SomajAngajator;
fondRiscAngajator = detalii.FondRiscAngajator;
cartiCameraMunca = detalii.CartiCameraMunca;
cartiCamera = detalii.CartiCamera;
cartiAngajator = detalii.CartiAngajator;
}
/// <summary>
/// Procedura actualizeaza o categorie de coeficienti
/// </summary>
/// <returns>Returneaza true daca s-a facut actualizarea si false altfel</returns>
public bool Update()
{
Data.Coeficienti coeficienti = new Data.Coeficienti(settings.ConnectionString);
return(coeficienti.Update(setID, deLa, deducere, coefInvalidGrd1, coefInvalidGrd2, coefCopil12,
coefCopil3, coefUrmCopil, coefSot, coefTotal, coefSanatate, coefPensie, coefSomaj,
coefCheltProf, cASAngajator, sanatateAngajator, somajAngajator, fondRiscAngajator,
cartiCameraMunca, cartiCamera, cartiAngajator));
}
/// <summary>
/// Procdura creaza o categorie de coeficienti
/// </summary>
/// <param name="deLa"></param>
/// <param name="deducere"></param>
/// <param name="coefInvalidGrd1"></param>
/// <param name="coefInvalidGrd2"></param>
/// <param name="coefCopil12"></param>
/// <param name="coefCopil3"></param>
/// <param name="coefUrmCopil"></param>
/// <param name="coefSot"></param>
/// <param name="coefTotal"></param>
/// <param name="coefSanatate"></param>
/// <param name="coefPensie"></param>
/// <param name="coefSomaj"></param>
/// <param name="coefCheltProf"></param>
/// <param name="casAngajator"></param>
/// <param name="sanatateAngajator"></param>
/// <param name="somajAngajator"></param>
/// <param name="fondRiscAngajator"></param>
/// <param name="cartiCameraMunca"></param>
/// <param name="cartiCamera"></param>
/// <param name="cartiAngajator"></param>
/// <returns></returns>
public int Create(DateTime deLa, decimal deducere, decimal coefInvalidGrd1,
decimal coefInvalidGrd2, decimal coefCopil12, decimal coefCopil3, decimal coefUrmCopil,
decimal coefSot, decimal coefTotal, decimal coefSanatate, decimal coefPensie,
decimal coefSomaj, decimal coefCheltProf, decimal casAngajator,
decimal sanatateAngajator, decimal somajAngajator, decimal fondRiscAngajator,
bool cartiCameraMunca, decimal cartiCamera, decimal cartiAngajator)
{
Data.Coeficienti coeficienti = new Data.Coeficienti(settings.ConnectionString);
setID = coeficienti.Add(deLa, deducere, coefInvalidGrd1,
coefInvalidGrd2, coefCopil12, coefCopil3, coefUrmCopil,
coefSot, coefTotal, coefSanatate, coefPensie,
coefSomaj, coefCheltProf, casAngajator,
sanatateAngajator, somajAngajator, fondRiscAngajator,
cartiCameraMunca, cartiCamera, cartiAngajator);
LoadCoeficientiID();
return(setID);
}
/// <summary>
/// Procedura selecteaza coeficienti
/// </summary>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
public DataSet GetCoeficienti()
{
Data.Coeficienti coeficienti = new Data.Coeficienti(settings.ConnectionString);
return(coeficienti.GetCoeficienti());
}