/// <summary>
/// Lista tipurilor de completare carnete
/// </summary>
public void ListareTipuriCompletareCarnete()
{
try
{
TableRow myRow = new TableRow();
TableCell myCell = new TableCell();
//titlul de la listare
myCell.CssClass = "BigBlueBold";
myCell.HorizontalAlign = HorizontalAlign.Center;
myCell.VerticalAlign = VerticalAlign.Middle;
myCell.Text = "Lista tipurilor de completare a carnetelor de munca";
myCell.Height = new Unit(50);
myRow.Cells.Add(myCell);
mainTable.Rows.Add(myRow);
// lista de banci existente
myRow = new TableRow();
myCell = new TableCell();
myCell.Attributes.Add("width", "100%");
myCell.HorizontalAlign = HorizontalAlign.Center;
myCell.VerticalAlign = VerticalAlign.Top;
Table listTable = new Table();
string[] tableHeader = { "Descriere", "Cod", "Procent" };
string[] tableCols = { "ModCompletare", "Cod", "Procent" };
Salaries.Business.AdminTipuriCompletareCarnete objAdminTipuriCompletare = new Salaries.Business.AdminTipuriCompletareCarnete();
objAdminTipuriCompletare.AngajatorId = GetAngajator();
ListTable objListTable = new ListTable(listTable, objAdminTipuriCompletare.LoadInfoTipuriCompletare(), tableHeader, tableCols);
string[] ar_OnClickParam = { "CompletareCarneteValoriID" };
string[] ar_OnClickParamType = { "dataset" };
objListTable.OnclickJSMethod = "SelectLine";
objListTable.OnclickParams = ar_OnClickParam;
objListTable.OnclickParamsType = ar_OnClickParamType;
objListTable.DrawListTableWithDigits(4);
myCell.Controls.Add(listTable);
myRow.Cells.Add(myCell);
mainTable.Rows.Add(myRow);
td_editLine.Visible = false;
add_form.Style.Add("display", "none");
btnEdit.Style.Add("display", "none");
td_addLine.Visible = true;
add_buttonLine.Visible = true;
tdTitle.InnerText = "Adaugare tip completare carnete de munca";
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
public void ListareInvaliditati()
{
try
{
TableRow myRow = new TableRow();
TableCell myCell = new TableCell();
//titlul de la listare
myCell.CssClass = "BigBlueBold";
myCell.HorizontalAlign = HorizontalAlign.Center;
myCell.VerticalAlign = VerticalAlign.Middle;
myCell.Text = "Lista invaliditatilor existente";
myCell.Height = new Unit(50);
myRow.Cells.Add(myCell);
mainTable.Rows.Add(myRow);
// lista de invaliditati existente
myRow = new TableRow();
myCell = new TableCell();
myCell.Attributes.Add("width", "100%");
myCell.HorizontalAlign = HorizontalAlign.Center;
myCell.VerticalAlign = VerticalAlign.Top;
Table listTable = new Table();
string[] tableHeader = { "Denumire", "Coeficient", "Descriere" };
string[] tableCols = { "Nume", "Coeficient", "Descriere" };
Salaries.Business.AdminInvaliditati objAdminInvaliditati = new Salaries.Business.AdminInvaliditati();
ListTable objListTable = new ListTable(listTable, objAdminInvaliditati.LoadInfoInvaliditati(), tableHeader, tableCols);
string[] ar_OnClickParam = { "InvaliditateID" };
string[] ar_OnClickParamType = { "dataset" };
objListTable.OnclickJSMethod = "SelectLine";
objListTable.OnclickParams = ar_OnClickParam;
objListTable.OnclickParamsType = ar_OnClickParamType;
objListTable.DrawListTableWithDigits();
myCell.Controls.Add(listTable);
myRow.Cells.Add(myCell);
mainTable.Rows.Add(myRow);
td_editLine.Visible = false;
add_form.Style.Add("display", "none");
btnEdit.Style.Add("display", "none");
td_addLine.Visible = true;
add_buttonLine.Visible = true;
tdTitle.InnerText = "Adaugare invaliditate";
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
/// <summary>
/// Cu ajutorul metodei ListTipAbsente se genereaza tabelul ce va fi afisat.
/// Acest tabel contine toate tipurile de absente existente in baza de date.
/// </summary>
private void ListTipAbsente()
{
try
{
list_form.Style.Add("display", "");
add_form.Style.Add("display", "none");
btnSalveaza.Visible = false;
btnInapoi.Visible = false;
txtTipAbsentaID.Text = "0";
TableRow myRow = new TableRow();
TableCell myCell = new TableCell();
//titlul de la listare
myCell.CssClass = "BigBlueBold";
myCell.HorizontalAlign = HorizontalAlign.Center;
myCell.VerticalAlign = VerticalAlign.Middle;
myCell.Text = "Nomenclator tipuri absente";
myCell.Height = new Unit(50);
myRow.Cells.Add(myCell);
mainTable.Rows.Add(myRow);
// lista de impozite existente
myRow = new TableRow();
myCell = new TableCell();
myCell.Attributes.Add("width", "100%");
myCell.HorizontalAlign = HorizontalAlign.Center;
myCell.VerticalAlign = VerticalAlign.Top;
Table listTable = new Table();
string[] tableHeader = { "Denumire", "Cod", "Procent", "Descriere", "Absenta medicala", "Modificabila ulterior", "Folosire curenta", "Absenta lucratoare" };
string[] tableCols = { "Denumire", "CodAbsenta", "Procent", "Descriere", "Medical", "Modificare", "Folosire", "Lucratoare" };
ListTable objListTable = new ListTable(listTable, new Salaries.Business.NomenclatorTipAbsente().GetTipuriAbsente(), tableHeader, tableCols);
objListTable.textForEmptyDataSet = "Nu exista date in nomenclatorul de tipuri de absente!";
string[] ar_OnClickParam = { "TipAbsentaID" };
string[] ar_OnClickParamType = { "dataset" };
objListTable.OnclickJSMethod = "SelectTipAbsenta";
objListTable.OnclickParams = ar_OnClickParam;
objListTable.OnclickParamsType = ar_OnClickParamType;
objListTable.DrawListTableWithDigits();
myCell.Controls.Add(listTable);
myRow.Cells.Add(myCell);
mainTable.Rows.Add(myRow);
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
/// <summary>
/// Este obtinuta lista lunilor(denumire, procent inflatie,..) pentru anul selectat in dropdownlist
/// </summary>
private void LoadInflatieList()
{
try
{
listTable.Rows.Clear();
listTable.Attributes.Add("width", "100%");
listTable.Style.Add("border", "1px solid #20b2aa");
listTable.Attributes.Add("cellpadding", "0");
listTable.Attributes.Add("cellspacing", "1");
string[] arHeader = { "Denumire", "ProcentInflatie" };
string[] arCols = { "Denumire", "ProcentInflatie" };
lunaId = this.GetCurrentMonth(); //id-ul lunii curente
Salaries.Business.Luni luni = new Salaries.Business.Luni(this.AngajatorID, lunaId);
//anul selectat de utilizator
int an = int.Parse(drpAni.SelectedItem.Text);
//returneaza lunile din anul dat ca parametru pentru care sunt calculate salariile
//in baza de date
//DataSet ds=luni.GetLuniSal_Salarii(an);
DataSet ds = luni.GetLuniSal_Luni(an, this.AngajatorID);
ListTable objListTable = new ListTable(listTable, ds, arHeader, arCols);
objListTable.textForEmptyDataSet = "Nu exista date!";
string[] ar_OnClickParam = { "Denumire", "ProcentInflatie" };
string[] ar_OnClickParamType = new string[ar_OnClickParam.Length];
for (int i = 0; i < ar_OnClickParamType.Length; i++)
{
ar_OnClickParamType[i] = "dataset";
}
objListTable.OnclickParams = ar_OnClickParam;
objListTable.OnclickParamsType = ar_OnClickParamType;
objListTable.DrawListTableWithDigits(4);
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
/// <summary>
/// Listarea valorilor pentru variabilele globale
/// </summary>
private void LoadVariabileGlobaleList()
{
try
{
list_form.Style.Add("display", "");
add_form.Style.Add("display", "none");
btnSalveaza.Visible = false;
btnInapoi.Visible = false;
txtVariabilaGlobalaID.Text = "0";
TableRow myRow = new TableRow();
TableCell myCell = new TableCell();
//titlul de la listare
myCell.CssClass = "BigBlueBold";
myCell.HorizontalAlign = HorizontalAlign.Center;
myCell.VerticalAlign = VerticalAlign.Middle;
myCell.Text = "Lista variabile salarizare";
myCell.Height = new Unit(50);
myRow.Cells.Add(myCell);
mainTable.Rows.Add(myRow);
// lista de impozite existente
myRow = new TableRow();
myCell = new TableCell();
myCell.Attributes.Add("width", "100%");
myCell.HorizontalAlign = HorizontalAlign.Center;
myCell.VerticalAlign = VerticalAlign.Top;
Table listTable = new Table();
string[] arHeader = { "Tip constanta", "Valoare" };
string[] arCols = { "Denumire", "Valoare" };
//id-ul lunii curente
lunaId = this.GetCurrentMonth();
Salaries.Business.Luni luni = new Salaries.Business.Luni(this.AngajatorID, lunaId);
//anul selectat de utilizator
int luna = int.Parse(drpPerioada.SelectedItem.Value);
//returneaza lunile din anul dat ca parametru pentru care sunt calculate salariile
Salaries.Business.VariabileGlobaleValori objVariabilaGlobala = new Salaries.Business.VariabileGlobaleValori();
DataSet ds = objVariabilaGlobala.GetAllVariabileGlobaleValoriPeLuna(luna);
ListTable objListTable = new ListTable(listTable, ds, arHeader, arCols);
objListTable.textForEmptyDataSet = "Nu exista date!";
string[] ar_OnClickParam = { "ID" };
string[] ar_OnClickParamType = { "dataset" };
objListTable.OnclickJSMethod = "SelectVariabilaGlobala";
objListTable.OnclickParams = ar_OnClickParam;
objListTable.OnclickParamsType = ar_OnClickParamType;
objListTable.DrawListTableWithDigits();
myCell.Controls.Add(listTable);
myRow.Cells.Add(myCell);
mainTable.Rows.Add(myRow);
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}