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