/// <summary>
/// Procedura adauga o retinere recurenta pentur angajat
/// </summary>
public void InsertRetinereRecurentaAngajat()
{
//se adauga retinerea in baza de date
Salaries.Data.RetineriRecurenteAngajat retineri = new Salaries.Data.RetineriRecurenteAngajat(settings.ConnectionString);
retineri.InsertRetinereRecurentaAngajat(retAng);
}
/// <summary>
/// Verifica daca se poate face o anuita operatie
/// </summary>
public int VerificaIntersectieNrRetineri()
{
Salaries.Data.RetineriRecurenteAngajat retineri = new Salaries.Data.RetineriRecurenteAngajat(settings.ConnectionString);
return(retineri.VerificaIntersectieNrRetineri((int)retAng.AngajatID, retAng.TipRetinere, retAng.DataInceput, retAng.DataSfarsit));
}
/// <summary>
/// Procedura aduce datele unei retineri
/// </summary>
public void GetRetinere(int idRetinere)
{
Salaries.Data.RetineriRecurenteAngajat retineri = new Salaries.Data.RetineriRecurenteAngajat(settings.ConnectionString);
retAng = retineri.GetRetinere(idRetinere);
}
/// <summary>
/// Procedura selecteaza retinerile recurente unui angajat
/// </summary>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
public DataSet LoadRetineriAngajat()
{
Salaries.Data.RetineriRecurenteAngajat retineri = new Salaries.Data.RetineriRecurenteAngajat(settings.ConnectionString);
return(retineri.LoadRetineriAngajat(retAng.AngajatID));
}
/// <summary>
/// Procedura sterge o retinere recurenta
/// </summary>
public void DeleteRetinereRecurentaAngajat()
{
Salaries.Data.RetineriRecurenteAngajat retineri = new Salaries.Data.RetineriRecurenteAngajat(settings.ConnectionString);
retineri.DeleteRetinereRecurentaAngajat(retAng);
}
private void Page_Load(object sender, System.EventArgs e)
{
Luni l = new Luni(int.Parse(Session["AngajatorID"].ToString()));
int LunaID = GetCurrentMonth();
DataSet dsRestraints = new TypesOfRestraints().GetLabels(LunaID);
if (l.GetLunaActiva().LunaId == LunaID)
{
butSaveData.Visible = true;
}
else
{
butSaveData.Visible = false;
}
Table restraintsTable = new Table();
TableRow tr = null;
TableCell tc = null;
System.Web.UI.Control ctl = null;
int lunaActivaId = l.GetLunaActiva().LunaId;
Salaries.Business.Luni lunaActiva = new Salaries.Business.Luni(this.GetAngajator(), lunaActivaId);
DateTime dataStartLunaActiva = lunaActiva.Data;
DateTime dataEndLunaActiva = dataStartLunaActiva.AddMonths(1).AddDays(-1);
Center.Controls.Clear();
foreach (DataRow dr in dsRestraints.Tables[0].Rows)
{
tr = new TableRow();
ctl = new Label();
((Label)ctl).Text = dr[0].ToString();
string tipRetinere = dr[0].ToString();
((Label)ctl).CssClass = "NormalGreenBold";
ctl.ID = dr[0].ToString() + "Label";
tc = new TableCell();
tc.Controls.Add(ctl);
tr.Cells.Add(tc);
ctl = new TextBox();
ctl.ID = dr[0].ToString() + ";" + LunaID;
if (dr[1] != System.DBNull.Value)
{
((TextBox)ctl).Text = dr[1].ToString();
}
Salaries.Configuration.ModuleSettings settings = Salaries.Configuration.ModuleConfig.GetSettings();
Salaries.Data.RetineriRecurenteAngajat retineri = new Salaries.Data.RetineriRecurenteAngajat(settings.ConnectionString);
int nr = retineri.VerificaIntersectieNrRetineri(0, tipRetinere, dataStartLunaActiva, dataEndLunaActiva);
if (l.GetLunaActiva().LunaId != LunaID || nr != 0)
{
((TextBox)ctl).ReadOnly = true;
}
if (l.GetLunaActiva().LunaId == LunaID)
{
((TextBox)ctl).TextChanged += new System.EventHandler(this.TextBox_TextChanged);
}
tc = new TableCell();
tc.Controls.Add(ctl);
tr.Cells.Add(tc);
restraintsTable.Rows.Add(tr);
Center.Controls.Add(restraintsTable);
}
}