/// <summary> /// Daca pagina de administrare a fost deschisa din ConturiBanci cream functia care va face refresh la combo-ul cu banci /// </summary> private void CreateRefreshFunction() { string outStr = ""; //cream scriptul care va contine functia de refresh //ne bazam pe faptul ca se cunoaste numele selectului care contine bancile //initial se sterg toate intrarile din combo outStr += "<script> \r\n function RefreshParentPage() \r\n" + "{ \r\n" + "window.opener.DeleteBanciCombo(); \r\n" + " FillBanciCOmbo(); \r\n" + "} \r\n"; //acum se creeaza functie care adauga functiile din recordset //se foloseste o functie din Conturi_Banca ... FillBancaCombo Salaries.Business.AdminBanci objAdminBanci = new Salaries.Business.AdminBanci(); outStr += " function FillBanciCOmbo() \r\n" + "{ \r\n"; foreach (DataRow dataRow in objAdminBanci.LoadInfoBanci().Tables[0].Rows) { outStr += "window.opener.FillBancaCombo('" + dataRow["Nume"].ToString() + "'," + dataRow["BancaID"].ToString() + ");"; } outStr += "} \r\n" + "</script>"; Response.Write(outStr); }
/// <summary> /// Populeaza lista cu tari /// </summary> public void PopulareTabela() { Index = listDataGrid.CurrentPageIndex * 30 + 1; Salaries.Business.AdminBanci objAdminBanci = new Salaries.Business.AdminBanci(); listDataGrid.DataSource = objAdminBanci.LoadInfoBanci(); listDataGrid.DataBind(); }
private void Page_Load(object sender, System.EventArgs e) { string script_text = "<script>var ctrlID = \"" + this.UniqueID + "\"</script>"; Response.Write(script_text); Response.Write("<script>var requiredDenumireClientID = \"" + requiredDenumire.ClientID + "\"</script>"); Response.Write("<script>var requiredCodClientID = \"" + requiredCod.ClientID + "\"</script>"); Response.Write("<script>var requiredFilialaClientID = \"" + requiredFiliala.ClientID + "\"</script>"); Response.Write("<script>var regExprVldDenumireClientID = \"" + regExprVldDenumire.ClientID + "\"</script>"); Response.Write("<script>var regularCodClientID = \"" + regularCod.ClientID + "\"</script>"); Response.Write("<script>var regularFilialaClientID = \"" + regularFiliala.ClientID + "\"</script>"); litError.Text = ""; Salaries.Business.AdminBanci banci = new Salaries.Business.AdminBanci(); Response.Write("<script>" + banci.GetJSArrays() + "</script>"); btnDeleteBanca.Attributes.Add("onclick", "return CheckDeleteBanca('Doriti sa stergeti aceasta banca?')"); Utilities.CreateTableHeader(headerTable, "Date identificare banca", "../", "small"); if (!IsPostBack) { //ListareBanci(); CompletareTitlu(); PopulareTabela(); } }
/// <summary> /// Modifica o banca /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnModifyBanca_Click(object sender, System.EventArgs e) { try { Salaries.Business.AdminBanci banca = new Salaries.Business.AdminBanci(); banca.BancaId = Convert.ToInt32(Request.Form["txtBancaID"]); banca.Cod = txtCodBanca.Text; banca.Nume = txtDenumireBanca.Text; banca.Filiala = txtFilialaBanca.Text; if (!banca.VerificaExistentaBanca()) { banca.UpdateBanca(); // Daca pagina de administrare a fost deschisa din AddAngajat cream functia care // va face refresh la combo-ul cu banci CreateRefreshFunction(); } else { Response.Write("<script>alert('Exista in baza de date o banca ce are aceleasi caracteristici cu cea pe care doriti sa o introduceti!');</script>"); } } catch (Exception ex) { litError.Text = "The following error occurred: <br>"; litError.Text += ex.Message; } //ListareBanci(); CompletareTitlu(); PopulareTabela(); }
/// <summary> /// Sterge o banca /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDeleteBanca_Click(object sender, System.EventArgs e) { try { Salaries.Business.AdminBanci banca = new Salaries.Business.AdminBanci(); banca.BancaId = Convert.ToInt32(Request.Form["txtBancaID"]); int sePoateSterge = banca.VerificaStergereBanca(); if (sePoateSterge == 0) { banca.DeleteBanca(); // Daca pagina de administrare a fost deschisa din AddAngajat cream functia // care va face refresh la combo-ul cu banci CreateRefreshFunction(); } if (sePoateSterge == 1) { Response.Write("<script>alert('Banca nu poate fi stearsa deoarece exista conturi asociate acesteia!');</script>"); } if (sePoateSterge == 2) { Response.Write("<script>alert('Operatiunea nu a fost efectuata deoarece nomenclatoul trebuie sa contina cel putin o banca.');</script>"); } } catch (Exception ex) { litError.Text = "The following error occurred: <br>"; litError.Text += ex.Message; } //ListareBanci(); CompletareTitlu(); PopulareTabela(); }
private void BindBancaCombo() { Salaries.Business.AdminBanci banci = new Salaries.Business.AdminBanci(); lstBancaSearch.DataSource = banci.LoadInfoBanciUnion(); lstBancaSearch.DataValueField = "BancaID"; lstBancaSearch.DataTextField = "Nume"; lstBancaSearch.DataBind(); }
/// <summary> /// Se trece la urmatoarea pagina in lista /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void listDataGrid_PageIndexChanged(Object sender, DataGridPageChangedEventArgs e) { Salaries.Business.AdminBanci banci = new Salaries.Business.AdminBanci(); DataSet dt = banci.LoadInfoBanci(); CompletareTitlu(); listDataGrid.CurrentPageIndex = e.NewPageIndex; DataView dv = dt.Tables[0].DefaultView; listDataGrid.DataSource = dv; Index = (e.NewPageIndex * listDataGrid.PageSize) + 1; listDataGrid.DataBind(); }
/// <summary> /// Adauga un cont /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdaugaDate_Click(object sender, System.EventArgs e) { try { Salaries.Business.ConturiAngajat cont = new Salaries.Business.ConturiAngajat(); cont.AngajatId = AngajatID; cont.ContId = Convert.ToInt32(Request.Form["txtContID"]); cont.BancaId = Convert.ToInt32(lstBanca.SelectedValue); cont.NumarCont = txtNumarCont.Text; cont.Moneda = lstMoneda.SelectedValue; //Lungu Andreea if (listTable.Rows.Count > 2) { cont.Activ = chkActiv.Checked; } else { cont.Activ = true; } //Lungu Andreea - 09.08.2011 //se verifica validitatea contului IBAN Salaries.Business.AdminBanci banca = new Salaries.Business.AdminBanci(); banca.LoadInfoBanca(cont.BancaId); string mesaj = Utilities.ValidareIBAN(cont.NumarCont, banca.Cod); if (mesaj.Equals("")) { if (cont.CheckIfContAngajatCanBeAdded()) { cont.InsertCont(); } else { Response.Write("<script> alert('Acest cont nu poate fi adaugat deoarece este deja asociat altui angajat al firmei.'); </script>"); } } else { Response.Write("<script> alert('" + mesaj + "'); </script>"); } } catch (Exception ex) { litError.Text = "The following error occurred: <br>"; litError.Text += ex.Message; } LoadConturiList(); }
private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here string script_text = "<script>var ctrlID = \"" + this.UniqueID + "\"</script>"; Response.Write(script_text); LoadConturiList(); Salaries.Business.AdminBanci banci = new Salaries.Business.AdminBanci(); lstBanca.DataSource = banci.GetBanci(); lstBanca.DataValueField = "BancaID"; lstBanca.DataTextField = "NumeBanca"; lstBanca.DataBind(); btnStergeDate.Attributes.Add("onclick", "return CheckDelete('Doriti sa stergeti acest cont?')"); string[] textTabs = { "Lista conturi", "Adauga cont nou" }; Utilities.CreateHeaderWithTabs(tableTabs, textTabs, "", true); }
private void Page_Load(object sender, System.EventArgs e) { // Tipurile de completare ale carnetelor de munca. Salaries.Business.AdminTipuriCompletareCarnete tipCompletareCarnete = new Salaries.Business.AdminTipuriCompletareCarnete(); tipCompletareCarnete.AngajatorId = GetAngajator(); // Lista bancilor. Salaries.Business.AdminBanci banci = new Salaries.Business.AdminBanci(); string[] textTabs = { "Date angajator", "Conturi bancare", "Adresa angajator", "Domenii de activitate", "Punct de lucru" }; Utilities.CreateHeaderWithTabsForAdminAngajator(tableTabs, textTabs, "../", true); settings = Salaries.Configuration.ModuleConfig.GetSettings(); UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString); // Sunt facute invizibile textbox-urile txtHiddenDomDeActPpID.Style.Add("display", "none"); txtHiddenDomDeActListID.Style.Add("display", "none"); txtHiddenPunctLucru.Style.Add("display", "none"); //Lungu Andreea 28.05.2008 //este populat dropdownlist-ul ce contine casele de asigurari DataSet dsCaseDeAsig = new DataSet(); Salaries.Business.CasaDeAsigurari casaAsig = new Salaries.Business.CasaDeAsigurari(); // Lista caselor de asigurari ale unui angajator. dsCaseDeAsig = casaAsig.GetAllCasaDeAsigurari(); drpCaseDeAsigurari.DataSource = dsCaseDeAsig; drpCaseDeAsigurari.DataTextField = "Denumire"; drpCaseDeAsigurari.DataValueField = "CasaDeAsigurariID"; drpCaseDeAsigurari.DataBind(); //tara Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari(); lstDTara.DataSource = tari.LoadInfoTariCuJudete(); lstDTara.DataTextField = "NumeTara"; lstDTara.DataValueField = "TaraID"; lstDTara.DataBind(); if (txtTaraHidden.Value != "") { lstDTara.SelectedValue = txtTaraHidden.Value; } //judetul Salaries.Business.AdminJudete judete = new Salaries.Business.AdminJudete(); judete.TaraId = int.Parse(lstDTara.SelectedValue); lstDJudet.DataSource = judete.GetAllJudeteTara(); lstDJudet.DataTextField = "NumeCompus"; lstDJudet.DataValueField = "JudetID"; lstDJudet.DataBind(); if (txtJudetSectorHidden.Value != "") { lstDJudet.SelectedValue = txtJudetSectorHidden.Value; } // Listarea tipurilor de completare a carnetelor de munca. lstTipCompletare.DataSource = tipCompletareCarnete.GetTipuriCompletareCarnete(); lstTipCompletare.DataTextField = "ModCompletare"; lstTipCompletare.DataValueField = "CompletareCarneteValoriID"; lstTipCompletare.DataBind(); if (txtTipCompletareHidden.Value != "") { lstTipCompletare.SelectedValue = txtTipCompletareHidden.Value; } // Listare banci. drpBanci.DataSource = banci.GetBanci(); drpBanci.DataTextField = "NumeBanca"; drpBanci.DataValueField = "BancaID"; drpBanci.DataBind(); // Listare domenii de activitate ale angajatorului ListareDomeniiDeActivitate(); txtTaraHidden.Value = txtTaraHidden.Value == "" ? lstDTara.SelectedValue : txtTaraHidden.Value; txtJudetSectorHidden.Value = txtJudetSectorHidden.Value == "" ? lstDJudet.SelectedValue : txtJudetSectorHidden.Value; txtTipCompletareHidden.Value = txtTipCompletareHidden.Value == "" ? lstTipCompletare.SelectedValue : txtTipCompletareHidden.Value; ListareAngajatori(); }
private void Page_Load(object sender, System.EventArgs e) { /*if(!IsPostBack) * { * //se obtine tipul de autentificare la aplicatie * string authentication = Salaries.Configuration.CryptographyClass.getSettingsWithoutDecode("authentication"); * * //virtual path * string path = Page.Request.FilePath; * char separator = '/'; * string [] pathArr = path.Split(separator); * int nr = pathArr.Length; * * //autentificare de tip windows * if (authentication == "1") * { * //user-ul loginat * user = new WindowsPrincipal(WindowsIdentity.GetCurrent()); * * //user-ul loginat nu are dreptul sa acceseze aceasta pagina este redirectat catre o pagina care sa il instiinteze de acest lucru * if(!Salaries.Business.Authentication.HasUserRightsOnPage(pathArr[nr-1],user)) * { * Response.Redirect("../Unauthorized.aspx"); * } * } * //autentificare cu user si parola * else * { * string nume = Session["Nume"].ToString(); * string parola = Session["Parola"].ToString(); * int angajatorId = int.Parse(Session["AngajatorId"].ToString()); * * //user-ul loginat nu are dreptul sa acceseze aceasta pagina este redirectat catre o pagina care sa il instiinteze de acest lucru * if(!Salaries.Business.Authentication.HasUserRightsOnPage(pathArr[nr-1], nume, parola, angajatorId)) * { * Response.Redirect("../Unauthorized.aspx"); * } * } * }*/ Salaries.Business.AdminSalariiLuni salarii = new Salaries.Business.AdminSalariiLuni(); DataSet ds = salarii.LoadInfoLuniSalariiUnion(); ds.Tables[0].Rows.RemoveAt(0); lstLuna.DataSource = ds; lstLuna.DataTextField = "Denumire"; lstLuna.DataValueField = "LunaTextID"; lstLuna.DataBind(); int an = DateTime.Now.Year; for (int i = an - 5; i <= an + 5; i++) { lstAn.Items.Add(new ListItem(i + "", i + "")); } // Lista bancilor. Salaries.Business.AdminBanci banci = new Salaries.Business.AdminBanci(); string[] textTabs = { "Date angajator", "Conturi angajator", "Adresa angajator", "Domenii de activitate", "Punct de lucru", "Reprezentanti legali" }; Utilities.CreateHeaderWithTabsForAdminAngajator(tableTabs, textTabs, "../", true); settings = Salaries.Configuration.ModuleConfig.GetSettings(); UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString); // Sunt facute invizibile textbox-urile txtHiddenDomDeActPpID.Style.Add("display", "none"); txtHiddenDomDeActListID.Style.Add("display", "none"); txtHiddenPunctLucru.Style.Add("display", "none"); //tara Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari(); lstDTara.DataSource = tari.LoadInfoTariCuJudete(); lstDTara.DataTextField = "NumeTara"; lstDTara.DataValueField = "TaraID"; lstDTara.DataBind(); if (txtTaraHidden.Value != "") { lstDTara.SelectedValue = txtTaraHidden.Value; } //judetul Salaries.Business.AdminJudete judete = new Salaries.Business.AdminJudete(); judete.TaraId = int.Parse(lstDTara.SelectedValue); lstDJudet.DataSource = judete.GetAllJudeteTara(); lstDJudet.DataTextField = "NumeCompus"; lstDJudet.DataValueField = "JudetID"; lstDJudet.DataBind(); if (txtJudetSectorHidden.Value != "") { lstDJudet.SelectedValue = txtJudetSectorHidden.Value; } // Listare banci. drpBanci.DataSource = banci.GetBanci(); drpBanci.DataTextField = "NumeBanca"; drpBanci.DataValueField = "BancaID"; drpBanci.DataBind(); // Listare domenii de activitate ale angajatorului ListareDomeniiDeActivitate(); txtTaraHidden.Value = txtTaraHidden.Value == "" ? lstDTara.SelectedValue : txtTaraHidden.Value; txtJudetSectorHidden.Value = txtJudetSectorHidden.Value == "" ? lstDJudet.SelectedValue : txtJudetSectorHidden.Value; txtHiddenLuna.Value = txtHiddenLuna.Value == "" ? lstLuna.SelectedValue : txtHiddenLuna.Value; txtHiddenAn.Value = txtHiddenAn.Value == "" ? lstAn.SelectedValue : txtHiddenAn.Value; //Lungu Andreea 28.05.2008 //este populat dropdownlist-ul ce contine casele de asigurari DataSet dsCaseDeAsig = new DataSet(); Salaries.Business.CasaDeAsigurari casaAsig = new Salaries.Business.CasaDeAsigurari(); // Lista caselor de asigurari ale unui angajator. dsCaseDeAsig = casaAsig.GetAllCasaDeAsigurari(); drpCaseDeAsigurari.DataSource = dsCaseDeAsig; drpCaseDeAsigurari.DataTextField = "Denumire"; drpCaseDeAsigurari.DataValueField = "CasaDeAsigurariID"; drpCaseDeAsigurari.DataBind(); //Lungu Andreea 19.08.2008 //este populat dropdownlist-ul ce contine functiile reprzentantilor legali DataSet dsFunctiiReprez = new DataSet(); //Lista functiilor reprezentantilor legali ale unui angajator. Salaries.Business.AdminAngajator angajator = new Salaries.Business.AdminAngajator(); dsFunctiiReprez = angajator.GetAllFunctiiReprez(); drpFunctiiReprez.DataSource = dsFunctiiReprez; drpFunctiiReprez.DataTextField = "NumeFunctie"; drpFunctiiReprez.DataValueField = "FunctieReprezID"; drpFunctiiReprez.DataBind(); txtHiddenNrFunctii.Value = drpFunctiiReprez.Items.Count.ToString(); }