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