/// <summary> /// Tari /// </summary> /// <returns></returns> private string GetSirTari() { string sirTari = ""; string sirTariText = "["; string sirTariValue = "["; Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari(); DataSet ds = tari.LoadInfoTari(); for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++) { DataRow dr = ds.Tables[0].Rows[i]; sirTariText += "'" + dr["NumeTara"].ToString() + "', "; sirTariValue += dr["TaraID"].ToString() + ", "; } if (ds.Tables[0].Rows.Count > 0) { sirTariText += "'" + ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["NumeTara"].ToString() + "']"; sirTariValue += ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["TaraID"].ToString() + "]"; sirTari = "[" + sirTariText + "," + sirTariValue + "]"; } else { sirTari = "[[],[]]"; } return(sirTari); }
/// <summary> /// Populeaza lista cu tari /// </summary> public void PopulareTabela() { Index = listDataGrid.CurrentPageIndex * 30 + 1; Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari(); listDataGrid.DataSource = tari.LoadInfoTari(); listDataGrid.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.AdminTari tari = new Salaries.Business.AdminTari(); DataSet dt = tari.LoadInfoTari(); CompletareTitlu(); listDataGrid.CurrentPageIndex = e.NewPageIndex; DataView dv = dt.Tables[0].DefaultView; listDataGrid.DataSource = dv; Index = (e.NewPageIndex * listDataGrid.PageSize) + 1; listDataGrid.DataBind(); }
/// <summary> /// Valorile judetelor /// </summary> /// <returns></returns> private string GetSirJudeteValue() { string sirJudVal = ""; string sirJudValFinal = ""; Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari(); DataSet dsTari = tari.LoadInfoTari(); foreach (DataRow drTari in dsTari.Tables[0].Rows) { Salaries.Business.AdminJudete judete = new Salaries.Business.AdminJudete(); judete.TaraId = int.Parse(drTari["TaraID"].ToString()); DataSet ds = judete.GetAllJudeteTara(); if (ds.Tables[0].Rows.Count > 0) { sirJudVal = "["; for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++) { DataRow dr = ds.Tables[0].Rows[i]; sirJudVal += dr["JudetID"].ToString() + ", "; } sirJudVal += ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["JudetID"].ToString() + "]"; } else { sirJudVal = "[]"; } sirJudValFinal += sirJudVal + ", "; } if (sirJudValFinal == "") { sirJudValFinal += "[[]]"; } else { sirJudValFinal = sirJudValFinal.Substring(0, sirJudValFinal.Length - 2); sirJudValFinal = "[" + sirJudValFinal + "]"; } return(sirJudValFinal); }
/// <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 = ""; //tb resetate sirurile cu tari si judete din AddAngajat din cauza actualizarii tarilor string sirTari = GetSirTari(); string sirJudeteText = GetSirJudeteText(); string sirJudeteValue = GetSirJudeteValue(); Response.Write("<script>var tari1 = " + sirTari + ";</script>"); Response.Write("<script>var judeteText1 = " + sirJudeteText + ";</script>"); Response.Write("<script>var judeteValue1 = " + sirJudeteValue + ";</script>"); //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.RecreateArray_TariJudete( 'tari', tari1.length); \r\n" + "for(i=0;i<tari1.length;i++) \r\n" + " window.opener.RecreateLine_TariJudete( 'tari', i, tari1[i].length); \r\n" + "for(i=0;i<tari1.length;i++) \r\n" + "for(j=0;j<tari1[i].length;j++) \r\n" + "window.opener.SetTari( i, j, tari1[i][j]); \r\n" + "window.opener.RecreateArray_TariJudete('judeteText',judeteText1.length); \r\n" + "for(i=0;i<judeteText1.length;i++) \r\n" + " window.opener.RecreateLine_TariJudete( 'judeteText' ,i, judeteText1[i].length); \r\n" + "for(i=0;i<judeteText1.length;i++) \r\n" + "{ \r\n" + " if ( judeteText1[i].length == 0) \r\n" + " window.opener.SetJudeteText( i, 0, null); \r\n"+ " else \r\n" + " for(j=0;j<judeteText1[i].length;j++) \r\n"+ " window.opener.SetJudeteText( i, j, judeteText1[i][j]); \r\n"+ "} \r\n" + "window.opener.RecreateArray_TariJudete('judeteValue',judeteValue1.length); \r\n" + "for(i=0;i<judeteValue1.length;i++) \r\n" + " window.opener.RecreateLine_TariJudete( 'judeteValue' ,i, judeteValue1[i].length); \r\n" + "for(i=0;i<judeteValue1.length;i++) \r\n" + "for(j=0;j<judeteValue1[i].length;j++) \r\n" + "window.opener.SetJudeteValue( i, j, judeteValue1[i][j]); \r\n" + "window.opener.DeleteTariCombo(); \r\n" + " FillTariCOmbo(); \r\n" + "} \r\n"; //acum se creeaza functie care adauga titlurile din recordset //se foloseste o functie din AddAngajat ... FillTaraCombo Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari(); outStr += " function FillTariCOmbo() \r\n" + "{ \r\n"; foreach (DataRow dataRow in tari.LoadInfoTari().Tables[0].Rows) { outStr += "window.opener.FillTaraCombo('" + dataRow["NumeTara"].ToString() + "'," + dataRow["TaraID"].ToString() + ");"; } outStr += " window.opener.SyncronizeTaraJudete(); \r\n"; outStr += "} \r\n" + "</script>"; Response.Write(outStr); }
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"); //daca utilizatorul nu are acces la aplicatie atunci este redirectat catre o pagina in care este afisat un mesaj de avertizare if (authentication == "0") { ErrHandler.MyErrHandler.WriteError("Index.aspx - utilizatorul nu are acces la aplicatie"); Response.Redirect("Unauthorized.aspx"); } //este sters tot din sesine Session.RemoveAll(); try { //se preia stringul de conexiune din web.config settings = Salaries.Configuration.ModuleConfig.GetSettings(); UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString); //daca lipseste una din datele strinct necesare pentru conectare la baza, //utilizatorul este redirectat catre pagina pentru introducerea acestor valori string[] s = settings.ConnectionString.Split(';'); if ((s[2] == "data source=") || (s[4] == "initial catalog=") || (s[5] == "user id=") || (s[6] == "pwd=")) { Response.Redirect("AdminSetari.aspx"); } //se verifica daca se pot obtine date din baza de date int angajatorId = 0; try { //daca nu se pot atunci stringul de conexiune nu este corect si utilizatorul este redirectat pentru //introducerea unui string de conexiune corect Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari(); int TaraID = int.Parse(tari.LoadInfoTari().Tables[0].Rows[0]["TaraID"].ToString()); } catch (Exception e1) { Response.Redirect("AdminSetari.aspx"); string msg = e1.Message; } //se selecteaza un angajator Salaries.Business.AdminAngajator angajator = new Salaries.Business.AdminAngajator(); try { //daca nu se poate face acest lucru atunci in baza nu exista angajatori si utilizatorul este //redirectat catre pagina pentru introducerea primului angajator angajatorId = int.Parse(angajator.LoadInfoAngajatori().Tables[0].Rows[0]["AngajatorID"].ToString()); } catch { Response.Redirect("Administrare/AdminPrimulAngajator.aspx"); } Session["AngajatorID"] = angajatorId.ToString(); Session["AngajatorDenumire"] = angajator.LoadInfoAngajatori().Tables[0].Rows[0]["Denumire"].ToString(); //autentificarea este de tip windows prin Active Directory if (authentication == "1") { //este preluat user-ul loginat user = new WindowsPrincipal(WindowsIdentity.GetCurrent()); //daca utilizatorul face parte din grupul HR if (Salaries.Business.Authentication.IsUserInHRgroup(user)) { Session["administrare_departamente"] = ""; Response.Redirect("Home.aspx"); } else { //daca user-ul faca parte din grupul de manageri if (Salaries.Business.Authentication.IsUserInManagersGroup(user)) { Response.Redirect("Managers/Managers.aspx"); } else { //daca user-ul faca parte din grupul de recrutori if (Salaries.Business.Authentication.IsUserInRecrutoriGroup(user)) { Response.Redirect("Recrutori/Recrutori.aspx"); } else { ErrHandler.MyErrHandler.WriteError("Index.aspx - autentificare windows fara drepturi - " + user.Identity.Name); Response.Redirect("Unauthorized.aspx"); } } } } //autentificarea este cu user si parola else { Response.Redirect("AdminUserParola.aspx"); } } catch (Exception ex) { string msg = ex.Message; } } }