/// <summary>
/// Procedura selecteaza o anumita retinere
/// </summary>
/// <param name="angajatId">Id-ul angajatului</param>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
public RetinereRecurentaAngajat GetRetinere(int idRetinere)
{
SqlParameter[] parameters =
{
new SqlParameter("@IdRetinere", SqlDbType.BigInt, 10)
};
parameters[0].Value = idRetinere;
RetinereRecurentaAngajat ret = new RetinereRecurentaAngajat();
using (DataSet ds = RunProcedure("GetRetinereRecurenta", parameters, "GetRetinereRecurenta"))
{
if (ds.Tables["GetRetinereRecurenta"].Rows.Count == 1)
{
DataRow dr = ds.Tables["GetRetinereRecurenta"].Rows[0];
ret.IdRetinere = int.Parse(dr["IdRetinere"].ToString());
ret.AngajatID = int.Parse(dr["AngajatID"].ToString());
ret.TipRetinere = dr["TipRetinere"].ToString();
ret.DenumireRetinere = dr["DenumireRetinere"].ToString();
ret.DataInceput = (DateTime)dr["DataInceput"];
ret.DataSfarsit = (DateTime)dr["DataSfarsit"];
ret.Valoare = decimal.Parse(dr["Valoare"].ToString());
ret.Alerta = (bool)dr["Alerta"];
}
else
{
ret.IdRetinere = -1;
}
}
return(ret);
}
/// <summary>
/// Stergerea unei retineri recurente
/// </summary>
/// <param name="retAng"></param>
public void DeleteRetinereRecurentaAngajat(RetinereRecurentaAngajat retAng)
{
SqlParameter[] parameters =
{
new SqlParameter("@tip_actiune", SqlDbType.Int, 4),
new SqlParameter("@IdRetinere", SqlDbType.BigInt, 10),
new SqlParameter("@AngajatID", SqlDbType.Int, 4),
new SqlParameter("@TipRetinere", SqlDbType.NVarChar, 50),
new SqlParameter("@DenumireRetinere", SqlDbType.NVarChar, 30),
new SqlParameter("@DataInceput", SqlDbType.DateTime, 8),
new SqlParameter("@DataSfarsit", SqlDbType.DateTime, 8),
new SqlParameter("@Valoare", SqlDbType.Float, 8),
new SqlParameter("@Alerta", SqlDbType.Bit, 1)
};
parameters[0].Value = 2;
parameters[1].Value = retAng.IdRetinere;
parameters[2].Value = retAng.AngajatID;
parameters[3].Value = retAng.TipRetinere;
parameters[4].Value = retAng.DenumireRetinere;
parameters[5].Value = retAng.DataInceput;
parameters[6].Value = retAng.DataSfarsit;
parameters[7].Value = retAng.Valoare;
parameters[8].Value = retAng.Alerta;
RunProcedure("InsertUpdateDeleteRetineriAngajat", parameters);
}