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