/// <summary> /// Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu titluri /// </summary> private void CreateRefreshFunctionForAddAngajat() { string outStr = ""; //cream scriptul care va contine functia de refresh //ne bazam pe faptul ca se cunoaste numele selectului care contine titlurile //initial se sterg toate intrarile din combo outStr += "<script> \r\n function RefreshAddAngajatPage() \r\n" + "{ \r\n" + "window.opener.DeleteTitluCombo(); \r\n" + " FillTitluriCOmbo(); \r\n" + "} \r\n"; //acum se creeaza functie care adauga titlurile din recordset //se foloseste o functie din AddAngajat ... FillTitluCombo Salaries.Business.AdminTitluriAngajati objAdminTitluriAngajati = new Salaries.Business.AdminTitluriAngajati(); outStr += " function FillTitluriCOmbo() \r\n" + "{ \r\n"; foreach (DataRow dataRow in objAdminTitluriAngajati.LoadInfoTitluriAngajati().Tables[0].Rows) { outStr += "window.opener.FillTitluCombo('" + dataRow["Simbol"].ToString() + " - " + dataRow["Denumire"].ToString() + "'," + dataRow["TitluID"].ToString() + ");"; } outStr += "} \r\n" + "</script>"; Response.Write(outStr); }
/// <summary> /// Completeaza campurile pentru un titlu /// </summary> private void FillEditForm() { try { int titluAngajatId = Convert.ToInt32(txtTitluAngajatID.Text); Salaries.Business.AdminTitluriAngajati titluri = new Salaries.Business.AdminTitluriAngajati(); titluri.TitluId = titluAngajatId; DataRow rowTitlu = titluri.GetTitluAngajatInfo().Tables[0].Rows[0]; txtDenumire.Text = rowTitlu["Denumire"].ToString(); txtSimbol.Text = rowTitlu["Simbol"].ToString(); txtTitluAngajatID.Text = titluAngajatId.ToString(); td_addLine.Visible = false; td_editLine.Visible = true; add_form.Style.Add("display", ""); add_buttonLine.Visible = false; tdTitle.InnerText = "Editare titlu angajat"; //lblMessage.Visible = false; //Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu titluri //In acest caz va fi goala ... CreateEmptyRefreshFunctionForAddAngajat(); } catch (Exception ex) { litError.Text = "The following error occurred: <br>"; litError.Text += ex.Message; } }
/// <summary> /// Sterge un titlu pentru angajati /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, System.EventArgs e) { try { int titluAngajatId = Convert.ToInt32(txtTitluAngajatID.Text); Salaries.Business.AdminTitluriAngajati titluri = new Salaries.Business.AdminTitluriAngajati(); titluri.TitluId = titluAngajatId; int sePoateSterge = titluri.CheckIfTitluAngajatCanBeDeleted(); if (sePoateSterge == 1) { Response.Write("<script> alert('Titlul nu poate fi sters! Este inca asociat unor angajati!'); </script>"); FillEditForm(); } if (sePoateSterge == 2) { Response.Write("<script> alert('Operatiunea nu a fost efectuata deoarece nomenclatoul trebuie sa contina cel putin un titlu.'); </script>"); FillEditForm(); } if (sePoateSterge == 0) { titluri.DeleteTitluAngajat(); ListareTitluriAngajati(); } //Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu titluri CreateRefreshFunctionForAddAngajat(); } catch (Exception ex) { litError.Text = "The following error occurred: <br>"; litError.Text += ex.Message; } }
/// <summary> /// Modifica un titlu pentru angajati /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnModify_Click(object sender, System.EventArgs e) { try { int titluAngajatId = Convert.ToInt32(txtTitluAngajatID.Text); Salaries.Business.AdminTitluriAngajati objTitluAngajat = new Salaries.Business.AdminTitluriAngajati(); objTitluAngajat.TitluId = titluAngajatId; objTitluAngajat.Denumire = txtDenumire.Text; objTitluAngajat.Simbol = txtSimbol.Text; if (objTitluAngajat.CheckIfTitluAngajatCanBeAdded()) { objTitluAngajat.UpdateTitluAngajat(); } else { Response.Write("<script> alert('Mai exista un titlu cu aceste date!'); </script>"); } //Daca pagina de administrare a fost deschisa din AddAngajat cream functia care va face refresh la combo-ul cu titluri CreateRefreshFunctionForAddAngajat(); } catch (Exception ex) { litError.Text = "The following error occurred: <br>"; litError.Text += ex.Message; } ListareTitluriAngajati(); }
private void BindTitulaturaCombo() { Salaries.Business.AdminTitluriAngajati titluri = new Salaries.Business.AdminTitluriAngajati(); lstTitulaturaSearch.DataSource = titluri.LoadInfoTitluriAngajatiUnion(); lstTitulaturaSearch.DataValueField = "TitluID"; lstTitulaturaSearch.DataTextField = "DenCompusa"; lstTitulaturaSearch.DataBind(); }
/// <summary> /// Listarea titlurilor angajatilor /// </summary> public void ListareTitluriAngajati() { 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 titlurilor existente"; 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 = { "Denumire", "Simbol" }; string[] tableCols = { "Denumire", "Simbol" }; Salaries.Business.AdminTitluriAngajati objAdminTitluriAngajati = new Salaries.Business.AdminTitluriAngajati(); ListTable objListTable = new ListTable(listTable, objAdminTitluriAngajati.LoadInfoTitluriAngajati(), tableHeader, tableCols); string[] ar_OnClickParam = { "TitluID" }; string[] ar_OnClickParamType = { "dataset" }; objListTable.OnclickJSMethod = "SelectLine"; objListTable.OnclickParams = ar_OnClickParam; objListTable.OnclickParamsType = ar_OnClickParamType; objListTable.DrawListTableWithoutDigits(); 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 titlu angajat"; lblMessage.Text = ""; } catch (Exception ex) { litError.Text = "The following error occurred: <br>"; litError.Text += ex.Message; } }
/// <summary> /// Procedura incarca datele unui angajat /// </summary> private void LoadAngajatDates() { // Titlurile ce le pot avea angajatii. Salaries.Business.AdminTitluriAngajati titluri = new Salaries.Business.AdminTitluriAngajati(); // Studiile pe care le pot avea angajatii. Salaries.Business.AdminStudii studii = new Salaries.Business.AdminStudii(); // Tarile din sistem. Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari(); try { // Se completeaza formularul de editare cu datele din baza de date lstTitlu.DataSource = titluri.LoadInfoTitluriAngajati(); lstTitlu.DataValueField = "TitluID"; lstTitlu.DataTextField = "Denumire"; lstTitlu.DataBind(); lstStudiu.DataSource = studii.LoadInfoStudii(); lstStudiu.DataValueField = "StudiuID"; lstStudiu.DataTextField = "Nume"; lstStudiu.DataBind(); lstTaraNastere.DataSource = tari.LoadInfoTariCuJudete(); lstTaraNastere.DataTextField = "NumeTara"; lstTaraNastere.DataValueField = "TaraID"; lstTaraNastere.DataBind(); lstDTara.DataSource = tari.LoadInfoTariCuJudete(); lstDTara.DataTextField = "NumeTara"; lstDTara.DataValueField = "TaraID"; lstDTara.DataBind(); lstRTara.DataSource = tari.LoadInfoTariCuJudete(); lstRTara.DataTextField = "NumeTara"; lstRTara.DataValueField = "TaraID"; lstRTara.DataBind(); BindLstDJudetDDL(); BindLstRJudetDDL(); BindLstJudetNastereDDL(); BindLstNationalitateDDL(); if (!IsPostBack) { BindInvaliditateDDL(); } this.chkLstInvalid.SelectedValue = objAngajat.Invaliditate.ToString(); txtNume.Text = objAngajat.Nume; txtPrenume.Text = objAngajat.Prenume; txtNumeAnterior.Text = objAngajat.NumeAnterior.ToString(); txtDataSchimbariiNumelui.Text = Utilities.ConvertDateTime2Text(objAngajat.DataSchimbariiNumelui); lstStareCivila.SelectedValue = objAngajat.StareCivila.ToString(); txtNrCopii.Text = objAngajat.NrCopii.ToString(); lstSex.SelectedValue = objAngajat.Sex.ToString(); lstNationalitate.SelectedValue = objAngajat.Nationalitate.ToString(); lstTitlu.SelectedValue = objAngajat.TitluId.ToString(); lstStudiu.SelectedValue = objAngajat.StudiuId.ToString(); txtAnAbsolvire.Text = objAngajat.AnAbsolvire.ToString(); txtNrDiploma.Text = objAngajat.NrDiploma; txtTelefon.Text = objAngajat.Telefon; txtDescriere.Text = objAngajat.Descriere; txtCNP.Text = objAngajat.CNP.ToString(); txtCNPAnterior.Text = objAngajat.CNPAnterior.ToString(); txtDataNasterii.Text = Utilities.ConvertDateTime2Text(objAngajat.DataNasterii); if (objAngajat.TaraNastereId != 0) { lstTaraNastere.SelectedValue = TaraNastereHidden.Value == "" ? objAngajat.TaraNastereId.ToString() : TaraNastereHidden.Value; } if (objAngajat.JudetNastereId != 0) { BindLstJudetNastereDDL(); lstJudetNastere.SelectedValue = JudetNastereHidden.Value == "" ? objAngajat.JudetNastereId.ToString() : JudetNastereHidden.Value; } txtLocalitateNastere.Text = objAngajat.LocalitateNastere; txtPrenumeMama.Text = objAngajat.PrenumeMama; txtPrenumeTata.Text = objAngajat.PrenumeTata; if (objAngajat.DTara != 0) { lstDTara.SelectedValue = DTaraHidden.Value == "" ? objAngajat.DTara.ToString() : DTaraHidden.Value; } if (objAngajat.DJudetSectorId != 0) { BindLstDJudetDDL(); lstDJudetSector.SelectedValue = DJudetSectorHidden.Value == "" ? objAngajat.DJudetSectorId.ToString() : DJudetSectorHidden.Value; } txtDLocalitate.Text = objAngajat.DLocalitate; txtDStrada.Text = objAngajat.DStrada; txtDNumar.Text = objAngajat.DNumar; txtDCodPostal.Text = objAngajat.DCodPostal.ToString(); txtDBloc.Text = objAngajat.DBloc; txtDScara.Text = objAngajat.DScara; txtDEtaj.Text = objAngajat.DEtaj; txtDApartament.Text = objAngajat.DApartament; if (objAngajat.RTara != 0) { lstRTara.SelectedValue = RTaraHidden.Value == "" ? objAngajat.RTara.ToString() : RTaraHidden.Value; } if (objAngajat.RJudetSectorId != 0) { BindLstRJudetDDL(); lstRJudetSector.SelectedValue = RJudetSectorHidden.Value == "" ? objAngajat.RJudetSectorId.ToString() : RJudetSectorHidden.Value; } txtRLocalitate.Text = objAngajat.RLocalitate; txtRStrada.Text = objAngajat.RStrada; txtRNumar.Text = objAngajat.RNumar; txtRCodPostal.Text = objAngajat.RCodPostal.ToString(); txtRBloc.Text = objAngajat.RBloc; txtRScara.Text = objAngajat.RScara; txtREtaj.Text = objAngajat.REtaj; txtRApartament.Text = objAngajat.RApartament; DTaraHidden.Value = DTaraHidden.Value == "" ? lstDTara.SelectedValue : DTaraHidden.Value; RTaraHidden.Value = RTaraHidden.Value == "" ? lstRTara.SelectedValue : RTaraHidden.Value; TaraNastereHidden.Value = TaraNastereHidden.Value == "" ? lstTaraNastere.SelectedValue : TaraNastereHidden.Value; DJudetSectorHidden.Value = DJudetSectorHidden.Value == "" ? lstDJudetSector.SelectedValue : DJudetSectorHidden.Value; RJudetSectorHidden.Value = RJudetSectorHidden.Value == "" ? lstRJudetSector.SelectedValue : RJudetSectorHidden.Value; JudetNastereHidden.Value = JudetNastereHidden.Value == "" ? lstJudetNastere.SelectedValue : JudetNastereHidden.Value; CreateVarJavaScript(); } catch (Exception ex) { litError.Text = "The following error occurred: <br>"; litError.Text += ex.Message; } }