/// <summary>
/// Procedura verifica daca o data este in luna activa
/// </summary>
/// <param name="dt">Data care se verifica</param>
/// <returns>Returneaza true daca e in interval si false altfel</returns>
public bool DataInLunaActiva(DateTime dt)
{
AdminAngajator ang = new AdminAngajator(this.ConnectionString);
int angajatorId = int.Parse(ang.LoadInfoAngajatori().Tables[0].Rows[0]["AngajatorId"].ToString());
Luni l = new Luni(ConnectionString);
LunaData ld = l.GetLunaActiva(angajatorId);
return((dt.Month == ld.Data.Month && dt.Year == ld.Data.Year) ? true : false);
}
/// <summary>
/// Returneaza id-ul categoriei
/// </summary>
/// <param name="categorieId">Id-ul categoriei</param>
/// <param name="angajatId">Id-ul angajatului</param>
/// <returns>Returneaza id-ul categoriei</returns>
public int GetCategorieCorspunzatoareDinLunaActiva(int categorieId, long angajatId)
{
SqlParameter[] parameters =
{
new SqlParameter("@CategorieID", SqlDbType.Int, 4)
};
parameters[0].Value = categorieId;
DataSet dsCategorie = RunProcedure("salarii_GetCategorie", parameters, "salarii_GetCategorie");
AdminAngajator ang = new AdminAngajator(this.ConnectionString);
int angajatorId = int.Parse(ang.LoadInfoAngajatori().Tables[0].Rows[0]["AngajatorId"].ToString());
SqlParameter[] parameters1 =
{
new SqlParameter("@AngajatorID", SqlDbType.Int, 4)
};
parameters1[0].Value = angajatorId;
DataSet ds = RunProcedure("salarii_GetAngajatiCategoriiLunaActiva", parameters1, "salarii_GetAngajatiCategoriiLunaActiva");
string categText = "";
if (dsCategorie != null && dsCategorie.Tables[0].Rows.Count > 0)
{
categText = dsCategorie.Tables[0].Rows[0]["Denumire"].ToString();
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["Denumire"].ToString() == categText)
{
return(int.Parse(dr["CategorieID"].ToString()));
}
}
}
return(-1);
}
