/// <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>
/// Procedura insereaza primul angajator la rularea aplicatiei
/// </summary>
/// <param name="data">Luna activa pentru care se porneste aplicatia</param>
/// <returns>Returneaza id-ul angajatorului adaugat</returns>
public int InsertFirstAngajator(DateTime data, string denumire, int tipPersoana, string CUI_CNP, string nrInregORC, string nrInregITM,
string telefon, string fax, string paginaWeb, string email, int taraId, int judetSectorId,
int tipCompletareId, string localitate, string strada, string numar, string codPostal,
string bloc, string scara, string etaj, string apartament, string ziLichidareSalar, string sector)
{
SqlParameter[] parameters =
{
new SqlParameter("@AngajatorID", SqlDbType.Int, 4),
new SqlParameter("@Denumire", SqlDbType.NVarChar, 100),
new SqlParameter("@TipPersoana", SqlDbType.Bit, 1),
new SqlParameter("@CUI_CNP", SqlDbType.NVarChar, 25),
new SqlParameter("@NrInregORC", SqlDbType.NVarChar, 25),
new SqlParameter("@NrInregITM", SqlDbType.NVarChar, 25),
new SqlParameter("@Telefon", SqlDbType.NVarChar, 25),
new SqlParameter("@Fax", SqlDbType.NVarChar, 25,fax),
new SqlParameter("@PaginaWeb", SqlDbType.NVarChar, 25),
new SqlParameter("@Email", SqlDbType.NVarChar, 25),
new SqlParameter("@TaraID", SqlDbType.Int, 4),
new SqlParameter("@JudetSectorID", SqlDbType.Int, 4),
new SqlParameter("@Localitate", SqlDbType.NVarChar, 50,localitate),
new SqlParameter("@Strada", SqlDbType.NVarChar, 50),
new SqlParameter("@Numar", SqlDbType.NVarChar, 10),
new SqlParameter("@CodPostal", SqlDbType.NVarChar, 20),
new SqlParameter("@Bloc", SqlDbType.NVarChar, 5),
new SqlParameter("@Scara", SqlDbType.NVarChar, 5),
new SqlParameter("@Etaj", SqlDbType.NVarChar, 5),
new SqlParameter("@Apartament", SqlDbType.NVarChar, 5),
new SqlParameter("@ZiLichidareSalar", SqlDbType.NVarChar, 2),
new SqlParameter("@Sector", SqlDbType.NVarChar, 5),
new SqlParameter("@Data", SqlDbType.DateTime),
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = denumire;
parameters[2].Value = tipPersoana;
parameters[3].Value = CUI_CNP;
parameters[4].Value = nrInregORC;
parameters[5].Value = nrInregITM;
parameters[6].Value = telefon;
parameters[7].Value = fax;
parameters[8].Value = paginaWeb;
parameters[9].Value = email;
parameters[10].Value = taraId;
parameters[11].Value = judetSectorId;
parameters[12].Value = localitate;
parameters[13].Value = strada;
parameters[14].Value = numar;
parameters[15].Value = codPostal;
parameters[16].Value = bloc;
parameters[17].Value = scara;
parameters[18].Value = etaj;
parameters[19].Value = apartament;
parameters[20].Value = ziLichidareSalar;
parameters[21].Value = sector;
parameters[22].Value = data;
RunProcedure("spSetFirstAngajator", parameters);
int angajatorId = int.Parse(parameters[0].Value.ToString());
//Inseram in tm_zile zilele pentru luna activa ... daca aceastea nu exista deja
Luni l = new Luni(base.ConnectionString);
l.FillZileLuna(int.Parse(data.Month.ToString()), int.Parse(data.Year.ToString()));
return(angajatorId);
}