/// <summary>
/// Populeaza tabela cu judete
/// </summary>
public void PopulareTabela()
{
Index = listDataGrid.CurrentPageIndex * 30 + 1;
Salaries.Business.AdminFunctii objAdminFunctii = new Salaries.Business.AdminFunctii();
listDataGrid.DataSource = objAdminFunctii.LoadInfoFunctii();
listDataGrid.DataBind();
}
private void BindFunctieCombo()
{
Salaries.Business.AdminFunctii functie = new Salaries.Business.AdminFunctii();
lstFunctieSearch.DataSource = functie.LoadInfoFunctiiUnion();
lstFunctieSearch.DataValueField = "FunctieID";
lstFunctieSearch.DataTextField = "DenCompusa";
lstFunctieSearch.DataBind();
}
/// <summary>
/// Se trece la pagina urmatoare in lista cu judete
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void listDataGrid_PageIndexChanged(Object sender, DataGridPageChangedEventArgs e)
{
Salaries.Business.AdminFunctii objAdminFunctii = new Salaries.Business.AdminFunctii();
DataSet dt = objAdminFunctii.LoadInfoFunctii();
CompletareTitlu();
listDataGrid.CurrentPageIndex = e.NewPageIndex;
DataView dv = dt.Tables[0].DefaultView;
listDataGrid.DataSource = dv;
Index = (e.NewPageIndex * listDataGrid.PageSize) + 1;
listDataGrid.DataBind();
}
/// <summary>
/// Listeaza functiile unui angajat
/// </summary>
private void LoadIstoricFunctii()
{
try
{
listTable.Rows.Clear();
//daca toate functiile au cod Siemens atasat
Salaries.Business.AdminFunctii functie = new Salaries.Business.AdminFunctii();
if (functie.CheckIfToateFunctiileAuCodSiemens())
{
//este afisat in dropdownlist codul Siemens - numele functiei
lstFunctie.DataSource = functie.LoadInfoCodSiemensNumeFunctie();
}
//altfel
else
{
//este afisat in dropdownlist codul COR - numele functiei
lstFunctie.DataSource = functie.LoadInfoCodCORNumeFunctie();
}
lstFunctie.DataValueField = "FunctieID";
lstFunctie.DataTextField = "CodNume";
lstFunctie.DataBind();
listTable.Attributes.Add("width", "100%");
listTable.Style.Add("border", "1px solid #20b2aa");
listTable.Attributes.Add("cellpadding", "0");
listTable.Attributes.Add("cellspacing", "1");
Salaries.Business.IstoricFunctie istFunctie = new Salaries.Business.IstoricFunctie();
istFunctie.AngajatId = AngajatID;
string[] arHeader = { "Functie", "Norma lucru", "Data start" };
string[] arCols = { "Nume", "NormaLucru", "DataStart" };
ListTable objListTable = new ListTable(listTable, istFunctie.LoadIstoricFunctii(), arHeader, arCols);
objListTable.textForEmptyDataSet = "Nu exista nici o functie asociata acestui angajat!";
string[] ar_OnClickParam = { "FunctieID", "DataStart", AngajatID.ToString() };
string[] ar_OnClickParamType = { "dataset", "dataset", "const" };
objListTable.OnclickParams = ar_OnClickParam;
objListTable.OnclickParamsType = ar_OnClickParamType;
objListTable.OnclickJSMethod = "SelectFunctie";
objListTable.DrawListTableWithoutDigits();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
/// <summary>
/// Modifica o functie
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnModify_Click(object sender, System.EventArgs e)
{
try
{
int functieId = Convert.ToInt32(txtFunctieID.Text);
Salaries.Business.AdminFunctii infoFunctie = new Salaries.Business.AdminFunctii();
infoFunctie.FunctieId = functieId;
infoFunctie.Nume = txtDenumire.Text;
infoFunctie.Cod = Convert.ToInt64(txtCod.Text);
infoFunctie.CodSiemens = txtCodSiemens.Text;
infoFunctie.JobFamilyId = int.Parse(txtHiddenJobFamily.Value);
infoFunctie.TipDeFunctieId = int.Parse(txtHiddenTipDeFunctie.Value);
infoFunctie.TipDeSegmentId = int.Parse(txtHiddenTipDeSegment.Value);
infoFunctie.Pozitie = int.Parse(txtHiddenPozitie.Value);
infoFunctie.Descriere = txtDescriere.Text;
infoFunctie.NormaLucru = Convert.ToInt32(txtNormaLucru.Text);
infoFunctie.PosibilaScutireImpozit = chkPosibilaScutire.Checked;
if (infoFunctie.CheckIfFunctieCanBeAdded())
{
infoFunctie.UpdateFunctie();
//ListareFunctii();
CompletareTitlu();
PopulareTabela();
}
else
{
lblMessage.Text = "Mai exista o functie cu acelasi cod si nume!";
lblMessage.Visible = true;
td_addLine.Visible = false;
td_editLine.Visible = true;
add_form.Style.Add("display", "");
add_buttonLine.Visible = false;
tdTitle.InnerText = "Editare functie";
}
//Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu functii
CreateRefreshFunctionForAddAngajat();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
//Lungu Andreea - 28.07.2008
private string GetSirFunctiiScutireImpozit()
{
Salaries.Business.AdminFunctii functii = new Salaries.Business.AdminFunctii();
DataSet ds = functii.LoadInfoFunctii();
string sirFunctii = "[";
string sirFunctiiUnic = "";
for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
string suportaScutire = "";
if ((bool)dr["PosibilaScutireImpozit"])
{
suportaScutire = "Da";
}
else
{
suportaScutire = "Nu";
}
sirFunctiiUnic = "[" + dr["FunctieId"].ToString() + "," + dr["Cod"].ToString() + " - " + dr["Nume"].ToString() + "," + suportaScutire + "]";
sirFunctii += sirFunctiiUnic + ";"; //era cu ","
}
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1];
string suportaScutire = "";
if ((bool)dr["PosibilaScutireImpozit"])
{
suportaScutire = "Da";
}
else
{
suportaScutire = "Nu";
}
sirFunctiiUnic = "[" + dr["FunctieId"].ToString() + "," + dr["Cod"].ToString() + " - " + dr["Nume"].ToString() + "," + suportaScutire + "]";
sirFunctii += sirFunctiiUnic + "]";
}
else
{
sirFunctii = "[]";
}
return(sirFunctii);
}
/// <summary>
/// Completeaza campurile unei functii
/// </summary>
private void FillEditForm()
{
try
{
int functieId = Convert.ToInt32(txtFunctieID.Text);
Salaries.Business.AdminFunctii infoFunctie = new Salaries.Business.AdminFunctii();
infoFunctie.FunctieId = functieId;
DataRow rowFunctie = infoFunctie.GetFunctieInfo().Tables[0].Rows[0];
txtDenumire.Text = rowFunctie["Nume"].ToString();
txtCod.Text = rowFunctie["Cod"].ToString();
txtCodSiemens.Text = rowFunctie["CodSiemens"].ToString();
txtDescriere.Text = rowFunctie["Descriere"].ToString();
lstJobFamily.SelectedValue = rowFunctie["JobFamilyId"].ToString();
lstTipDeFunctie.SelectedValue = rowFunctie["TipDeFunctieId"].ToString();
lstTipDeSegment.SelectedValue = rowFunctie["TipDeSegmentId"].ToString();
lstPozitie.SelectedValue = rowFunctie["Pozitie"].ToString();
txtHiddenJobFamily.Value = rowFunctie["JobFamilyId"].ToString();
txtHiddenTipDeFunctie.Value = rowFunctie["TipDeFunctieId"].ToString();
txtHiddenTipDeSegment.Value = rowFunctie["TipDeSegmentId"].ToString();
txtHiddenPozitie.Value = rowFunctie["Pozitie"].ToString();
txtNormaLucru.Text = rowFunctie["NormaLucru"].ToString();
txtFunctieID.Text = functieId.ToString();
chkPosibilaScutire.Checked = (bool)rowFunctie["PosibilaScutireImpozit"];
td_addLine.Visible = false;
td_editLine.Visible = true;
add_form.Style.Add("display", "");
add_buttonLine.Visible = false;
tdTitle.InnerText = "Editare functie";
listDataGrid.Visible = false;
//Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu functii
//In acest caz va fi goala ...
CreateEmptyRefreshFunctionForAddAngajat();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
/// <summary>
/// Adauga o functie
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, System.EventArgs e)
{
try
{
Salaries.Business.AdminFunctii newFunctie = new Salaries.Business.AdminFunctii();
newFunctie.FunctieId = 0;
newFunctie.Nume = txtDenumire.Text;
newFunctie.Cod = Convert.ToInt64(txtCod.Text);
newFunctie.CodSiemens = txtCodSiemens.Text;
newFunctie.JobFamilyId = int.Parse(txtHiddenJobFamily.Value);
newFunctie.TipDeFunctieId = int.Parse(txtHiddenTipDeFunctie.Value);
newFunctie.TipDeSegmentId = int.Parse(txtHiddenTipDeSegment.Value);
newFunctie.Pozitie = int.Parse(txtHiddenPozitie.Value);
newFunctie.Descriere = txtDescriere.Text;
newFunctie.NormaLucru = Convert.ToInt32(txtNormaLucru.Text);
newFunctie.PosibilaScutireImpozit = chkPosibilaScutire.Checked;
if (newFunctie.CheckIfFunctieCanBeAdded())
{
newFunctie.InsertFunctie();
}
else
{
lblMessage.Text = "Mai exista o functie cu acelasi cod si nume!";
lblMessage.Visible = true;
//pentru ca nu se poate adauga o functie cu acest cod se ramane la formularul pentru adaugare si nu se afiseaza lista cu functii
Response.Write("<script> var eroare = '1' </script>");
}
//Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu functii
CreateRefreshFunctionForAddAngajat();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
//ListareFunctii();
CompletareTitlu();
PopulareTabela();
}
/// <summary>
/// Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu functii
/// </summary>
private void CreateRefreshFunctionForAddAngajat()
{
string outStr = "";
//Lungu Andreea - 28.07.2008
string sirFunctii = GetSirFunctiiScutireImpozit();
sirFunctii = sirFunctii.Substring(1);
sirFunctii = sirFunctii.Substring(0, sirFunctii.Length - 1);
//Response.Write("<script>var window.opener.sirFunctii = "+sirFunctii+";</script>");
Response.Write("<script>window.opener.CreazaSirFunctii('" + sirFunctii + "');</script>");
//cream scriptul care va contine functia de refresh
//ne bazam pe faptul ca se cunoaste numele selectului care contine functiile
//initial se sterg toate intrarile din combo
outStr += "<script> \r\n function RefreshAddAngajatPage() \r\n" +
"{ \r\n" +
"window.opener.DeleteFunctiiCombo(); \r\n" +
" FillFunctiiCOmbo(); \r\n" +
"} \r\n";
//acum se creeaza functie care adauga functiile din recordset
//se foloseste o functie din AddAngajat ... FillFunctieCombo
Salaries.Business.AdminFunctii objAdminFunctii = new Salaries.Business.AdminFunctii();
outStr += " function FillFunctiiCOmbo() \r\n" +
"{ \r\n";
for (int i = 0; i < objAdminFunctii.LoadInfoFunctii().Tables[0].Rows.Count; i++)
//for (int i=objAdminFunctii.LoadInfoFunctii().Tables[0].Rows.Count-1; i>=0; i--)
{
DataRow dataRow = objAdminFunctii.LoadInfoFunctii().Tables[0].Rows[i];
outStr += "window.opener.FillFunctieCombo('" +
dataRow["Cod"].ToString() + " - " + dataRow["Nume"].ToString() + "'," +
dataRow["FunctieID"].ToString() + ");";
}
outStr += "} \r\n" +
"</script>";
Response.Write(outStr);
}
/// <summary>
/// Sterge o functie
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, System.EventArgs e)
{
try
{
int functieId = Convert.ToInt32(txtFunctieID.Text);
Salaries.Business.AdminFunctii functie = new Salaries.Business.AdminFunctii();
functie.FunctieId = functieId;
int sePoateSterge = functie.CheckIfFunctieCanBeDeleted();
if (sePoateSterge == 1)
{
Response.Write("<script> alert('Functia nu poate fi stearsa! Este inca asociata unor angajati!'); </script>");
FillEditForm();
}
if (sePoateSterge == 2)
{
Response.Write("<script> alert('Operatiunea nu a fost efectuata deoarece nomenclatoul trebuie sa contina cel putin o functie.'); </script>");
FillEditForm();
}
if (sePoateSterge == 0)
{
functie.DeleteFunctie();
//ListareFunctii();
CompletareTitlu();
PopulareTabela();
}
//Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu functii
CreateRefreshFunctionForAddAngajat();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
