private void Page_Load(object sender, System.EventArgs e)
{
actionGenerareSituatieLunara = ((System.Web.UI.HtmlControls.HtmlInputHidden)Page.FindControl("ActionGenerareSituatieLunaraValue")).Value;
settings = Salaries.Configuration.ModuleConfig.GetSettings();
if (this.Page.Request.Params["idAng"] != null)
{
this.SetAngajat(long.Parse(this.Page.Request.Params["idAng"]));
Session["AngajatID"] = long.Parse(this.Page.Request.Params["idAng"]);
string cale = Request.Url.AbsoluteUri;
int poz1 = cale.IndexOf("Salarii.aspx");
int poz2 = cale.IndexOf("&idAng=");
string caleFinala = cale.Substring(poz1, poz2 - poz1);
Response.Redirect(caleFinala);
//Response.Redirect("Salarii.aspx?Tab=Pontaj&Option=retineri_recurente_angajat&node=Element_025");
}
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
utilDb.CreateAngajatiSelectBoxPeLuna(this.angajatDDL, this.GetAngajator(), this.GetCurrentMonth());
try
{
this.angajatDDL.SelectedValue = this.GetAngajat().ToString();
}
catch (Exception ex)
{
if (this.angajatDDL.Items.Count > 0)
{
this.SetAngajat(long.Parse(this.angajatDDL.SelectedValue));
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
string script_text = "<script>var ctrlID = \"" + this.UniqueID + "\"</script>";
Response.Write(script_text);
litError.Text = "";
btnDelete.Attributes.Add("onclick", "return CheckDelete('Doriti sa stergeti aceasta tara?')");
Utilities.CreateTableHeader(headerTable, "Date identificare tara", "../", "small");
txtTaraID.Style.Add("display", "none");
Response.Write("<script>var requiredDenumire = \"" + requiredDenumire.ClientID + "\"</script>");
Response.Write("<script>var regularDenumire = \"" + regularDenumire.ClientID + "\"</script>");
Response.Write("<script>var requiredSimbol = \"" + requiredSimbol.ClientID + "\"</script>");
Response.Write("<script>var requiredNationalitate = \"" + requiredNationalitate.ClientID + "\"</script>");
Response.Write("<script>var listDataGrid = \"" + listDataGrid.ClientID + "\"</script>");
if (!IsPostBack)
{
//ListareTari();
CompletareTitlu();
PopulareTabela();
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
settings = Salaries.Configuration.ModuleConfig.GetSettings();
if (tipuriOreAdaugare)
{
new UtilitiesDb(settings.ConnectionString).CreateTipIntervaleSelectBox(this.TipInterval, this.AngajatID, this.SelectedDate, true);
DeleteElementsUnusableFromTipIntervalAddCombo();
}
else
{
new UtilitiesDb(settings.ConnectionString).CreateTipIntervaleSelectBox(this.TipInterval, this.AngajatID, this.SelectedDate, false);
DeleteElementsUnusableFromTipIntervalModifyCombo();
}
if (TipIntervalID != -1)
{
this.TipInterval.SelectedValue = TipIntervalID.ToString();
}
try
{
TipIntervalID = Convert.ToInt32(this.TipInterval.SelectedItem.Value);
}
catch {}
((System.Web.UI.HtmlControls.HtmlInputHidden)Page.FindControl("TipInterval1")).Value = TipIntervalID.ToString();
if (!this.Selectable)
{
this.CheckInterval.Visible = false;
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
if (!IsPostBack)
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
//Modificat:Muntean Raluca Cristina - am adaugat ca parametru si id-ul angajatorului
utilDb.CreateAngajatiSelectBox(this.lstAngajati, this.GetAngajator());
this.lstAngajati.Items.Insert(0, new ListItem("[listare completa]", "[listare completa]"));
}
this.rapFluturas.ServerUrl = Salaries.Configuration.CryptographyClass.getSettingsWithoutDecode(STRING_URL);
if (this.lstAngajati.SelectedIndex > 0)
{
this.rapFluturas.ReportPath = this.SingleFluturasPath;
this.rapFluturas.SetQueryParameter("AngajatorID", this.GetAngajator().ToString());
this.rapFluturas.SetQueryParameter("AngajatID", this.lstAngajati.SelectedValue);
this.rapFluturas.SetQueryParameter("LunaID", this.GetCurrentMonth().ToString());
}
else
{
this.rapFluturas.ReportPath = this.AllFluturasPath;
this.rapFluturas.SetQueryParameter("AngajatorID", this.GetAngajator().ToString());
this.rapFluturas.SetQueryParameter("LunaID", this.GetCurrentMonth().ToString());
}
}
private void LoadPersoaneList()
{
try
{
listTable.Rows.Clear();
settings = Salaries.Configuration.ModuleConfig.GetSettings();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
ddlInvaliditate.DataSource = utilDb.CreateDataSet("Select InvaliditateID, Nume from Invaliditati order by Nume");
ddlInvaliditate.DataValueField = "InvaliditateID";
ddlInvaliditate.DataTextField = "Nume";
ddlInvaliditate.DataBind();
listTable.Attributes.Add("width", "100%");
listTable.Style.Add("border", "1px solid #20b2aa");
listTable.Attributes.Add("cellpadding", "0");
listTable.Attributes.Add("cellspacing", "1");
/*
* Changed: Ionel Popa
* - S-au scos coloanele calitate, invaliditate si coeficient
* string[] arHeader = {"Nume","Prenume","CNP", "Calitate", "Invaliditate","Coeficient"};
* string[] arCols = {"Nume","Prenume","CNP", "Calitat", "Invalid","Coeficient"};
*/
string[] arHeader = { "Nume", "Prenume", "CNP" };
string[] arCols = { "Nume", "Prenume", "CNP" };
Salaries.Business.Angajat angajatCurent = new Salaries.Business.Angajat((int)this.AngajatID);
DataSet ds = angajatCurent.PersoaneInIntretinere();
//Din cauza scoaterii coloanelor de mai sus se scoate si acest coeficient
//this.lCoefTotalPersIntret.Text="Coeficientul pt toate persoanele aflate in intretinere este: "+angajatCurent.CoefTotalPtPersInIntretinere;
ListTable objListTable = new ListTable(listTable, ds, arHeader, arCols);
objListTable.textForEmptyDataSet = "Nu exista nici o persoana in intretinerea angajatului!";
string[] ar_OnClickParam = { "ID", "Nume", "Prenume", "CNP", "Calitate", "Invaliditate", "Coeficient" };
string[] ar_OnClickParamType = new string[ar_OnClickParam.Length];
for (int i = 0; i < ar_OnClickParamType.Length; i++)
{
ar_OnClickParamType[i] = "dataset";
}
objListTable.OnclickParams = ar_OnClickParam;
objListTable.OnclickParamsType = ar_OnClickParamType;
objListTable.OnclickJSMethod = "SelectPersoana";
objListTable.DrawListTable();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
private void LoadInfoGrupeMunca()
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
SqlConnection m_con = new SqlConnection(settings.ConnectionString);
SqlCommand myCommand = new SqlCommand("select * from GrupeMunca", m_con);
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
m_ds = new DataSet();
dAdapt.Fill(m_ds);
}
private void Page_Load(object sender, System.EventArgs e)
{
//se populeaza combobox cu toate perioadele existente din care utilizatorul selecteaza
Salaries.Business.VariabileGlobaleValori objVariabilaGlobala = new Salaries.Business.VariabileGlobaleValori();
DataSet ds = objVariabilaGlobala.GetLuniVariabileGlobale();
if (drpPerioada.Items.Count == 0)
{
foreach (DataRow row in ds.Tables["GetLuniVariabileGlobale"].Rows)
{
ListItem NewItem = new ListItem();
NewItem.Text = row["Luna"].ToString();
NewItem.Value = row["LunaID"].ToString();
drpPerioada.Items.Add(NewItem);
//se selecteaza ultima valoare pentru ca aceasta este luna curenta si se vor incarca implicit valorile
//variabilelor globale din luna curenta
drpPerioada.SelectedIndex = drpPerioada.Items.Count - 1;
}
}
string script_text = "<script>var ctrlID = \"" + this.ClientID + "\"</script>";
Response.Write(script_text);
litError.Text = "";
btnEdit.Style.Add("display", "none");
txtVariabilaGlobalaID.Style.Add("display", "none");
settings = Salaries.Configuration.ModuleConfig.GetSettings();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
if (!IsPostBack)
{
this.btnSalveaza.Enabled = true;
//daca nu este modul editabil, se selecteaza toate tipurile da variabile globale care nu au fost inca adaugate pentru luna curenta
if (!EditMode)
{
//se populeaza combobox-ul
LoadTipVariabile();
drpPerioada.Enabled = true;
//daca exista cel putin un tip de variabila care nu a fost adaugat apare butonul pentru adaugare
if (drpTipVariabila.Items.Count > 0)
{
drpTipVariabila.SelectedIndex = 0;
btnAdaugaVariabilaGlobala.Visible = true;
}
//altfel butonul pentru adaugare nu apare si deci nu se pot adauga valori pentru variabile
else
{
btnAdaugaVariabilaGlobala.Visible = false;
}
}
}
}
private void Page_Load(object sender, System.EventArgs e)
{
lstAngajati.Visible = false;
if (!IsPostBack)
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
utilDb.CreateAngajatiSiVidSelectBox(this.lstAngajati);
this.SetAngajat(long.Parse(this.lstAngajati.SelectedValue));
}
}
/// <summary>
/// Listeaza referintele unui angajat
/// </summary>
private void LoadFormReferinte()
{
try
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
listTable.Rows.Clear();
listTable.Attributes.Add("width", "100%");
listTable.Style.Add("border", "1px solid #20b2aa");
listTable.Attributes.Add("cellpadding", "0");
listTable.Attributes.Add("cellspacing", "1");
Salaries.Business.IstoricReferinte ReferinteList = new Salaries.Business.IstoricReferinte();
ReferinteList.AngajatId = AngajatID;
string[] arHeader = { "Titlu", "Descriere", "Data" };
string[] arCols = { "Titlu", "Descriere", "Data" };
ListTable objListTable = new ListTable(listTable, ReferinteList.LoadReferinte(), arHeader, arCols);
objListTable.textForEmptyDataSet = "Nu exista nici o referinta asociata acestui angajat!";
string[] ar_OnClickParam = { "ReferintaID", "Titlu", "Data", "Descriere" };
string[] ar_OnClickParamType = { "dataset", "dataset", "dataset", "dataset" };
objListTable.OnclickParams = ar_OnClickParam;
objListTable.OnclickParamsType = ar_OnClickParamType;
objListTable.OnclickJSMethod = "SelectReferinta";
objListTable.DrawListTableWithoutDigits();
for (int i = 1; i < listTable.Rows.Count - 1; i++)
{
TableRow r = listTable.Rows[i];
if (r.Cells.Count == 4)
{
string Descriere = r.Cells[2].Text;
if (Descriere.Length > this.MaxDescriere)
{
Descriere = Descriere.Substring(0, MaxDescriere) + "...";
}
r.Cells[2].Text = Descriere;
r.Cells[2].Attributes["alt"] = Descriere;
}
}
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
private void Page_Load(object sender, System.EventArgs e)
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
Utilities.CreateTableHeader(tableCautareRapida, "Cautare rapida", "../", "normal");
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))
{
ErrHandler.MyErrHandler.WriteError("Recrutori.aspx - autentificare windows fara drepturi - " + user.Identity.Name);
Server.Transfer("../Unauthorized.aspx");
}
}
//autentificare cu user si parola
else
{
try
{
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))
{
ErrHandler.MyErrHandler.WriteError("Recrutori.aspx - autentificare user parola fara drepturi - " + nume + ", " + angajatorId);
Server.Transfer("../Unauthorized.aspx");
}
}
catch (Exception exc)
{
Response.Redirect("../index.aspx");
}
}
}
}
/// <summary>
/// Evenimentul aparut la incarcarea paginii.
/// </summary>
/// <param name="sender">obiectul care a declansat evenimentul</param>
/// <param name="e">argumentele evenimentului</param>
private void Page_Load(object sender, System.EventArgs e)
{
//Adaugat: Oprescu Claudia
//Data: 09.02.2007
//Descriere: Daca nu exista angajati in baza de date, o parte din optiunile din meniul Pontaj vor fi ascunse.
// Daca nu exista angajati se va ascunde si meniul Rapoarte.
// Daca nu exista conturi pentru angajati, se va ascunde optiunea Fisier Multicache
// Daca este autentificare windows, atunci modulul pentru gestiunea utilizatorilor nu se va afisa.
existaAngajati = true;
existaConturi = true;
//daca se genereaza meniul pentru modulul de salarii, trebuie sa se verifice daca exista angajati in baza de date sau nu
if (numeXmlSursa == "../Navigare/Salarii_Navigare.xml")
{
//se creaza o lista in care se vor pune angajatii selectati
DropDownList angajatDDL = new DropDownList();
Salaries.Configuration.ModuleSettings settings = Salaries.Configuration.ModuleConfig.GetSettings();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
//se determina id-ul angajatorului curent
Salaries.Business.AdminAngajator angajator = new Salaries.Business.AdminAngajator();
int angajatorID = int.Parse(angajator.LoadInfoAngajatori().Tables[0].Rows[0]["AngajatorID"].ToString());
//se determina id-ul lunii curente
Salaries.Business.Luni luna = new Salaries.Business.Luni(angajatorID);
Salaries.Data.LunaData ld = luna.GetLunaActiva();
int lunaId = ld.LunaId;
//se selecteaza angajatii existenti in baza de date
utilDb.CreateAngajatiSelectBoxPeLuna(angajatDDL, angajatorID, lunaId);
//daca nu exista angajati in lista, se vor ascunde o serie de optiuni din meniul aplicatiei
if (angajatDDL.Items.Count == 0)
{
existaAngajati = false;
}
Salaries.Business.ConturiAngajator conturi = new Salaries.Business.ConturiAngajator();
conturi.AngajatorId = angajatorID;
//daca nu exista conturi pentru angajati, se va ascunde optiunea Fisier multicache
if (conturi.GetMonedaConturiAngajati().Tables[0].Rows.Count == 0)
{
existaConturi = false;
}
}
// se construieste script-ul ce va permite navigarea prin meniu
scriptNavigare = ScriptMeniu("MenuContainer");
}
/// <summary>
/// Procedura determina luna selectata
/// </summary>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
private DataSet GetLunaSelectata()
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
System.Data.SqlClient.SqlConnection myConn = new System.Data.SqlClient.SqlConnection(settings.ConnectionString);
System.Data.SqlClient.SqlCommand searchCommand = new System.Data.SqlClient.SqlCommand("sal_GetLunaInflById ", myConn);
searchCommand.CommandType = System.Data.CommandType.StoredProcedure;
searchCommand.Parameters.Add("@LunaID", Convert.ToInt32(Session["LunaCurenta"].ToString()));
System.Data.SqlClient.SqlDataAdapter myDa = new System.Data.SqlClient.SqlDataAdapter(searchCommand);
DataSet myDs = new DataSet();
myDa.Fill(myDs);
return(myDs);
}
private void Page_Load(object sender, System.EventArgs e)
{
this.numeDept.Text = Parameters.NumeDepartament;
this.settings = Salaries.Configuration.ModuleConfig.GetSettings();
if (!this.IsPostBack)
{
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
utilDb.CreateAngajatiPeDeptSelectBox(this.lstAngajati, Parameters.NumeDepartament);
if (lstAngajati.Items.Count != 0)
{
Parameters.DataAngajat = lstAngajati.Items[0];
}
else
{
Table t = new Table();
t.Attributes.Add("class", "tabBackground");
t.Attributes.Add("borderColor", "green");
t.Attributes.Add("cellSpacing", "6");
TableRow tr = new TableRow();
TableCell tc = new TableCell();
t.Rows.Add(new TableRow());
t.Rows[0].Cells.Add(new TableCell());
t.Rows[0].Cells[0].Text = " ";
t.Rows[0].Cells[0].Attributes.Add("class", "NormalBlackBold");
tc.Text = "<font size='3'>Nu exista angajati asignati direct acestui departament!</font>";
tc.Font.Size = 3;
tc.Attributes.Add("class", "NormalBlackBold");
tc.Attributes.Add("align", "center");
tr.Cells.Add(tc);
t.Rows.Add(tr);
t.Rows.Add(new TableRow());
t.Rows[2].Cells.Add(new TableCell());
t.Rows[2].Cells[0].Text = "<font size='3'>Va rugam incercati in subdepartamentele asociate.</font>";
t.Rows[2].Cells[0].Attributes.Add("class", "NormalBlackBold");
t.Rows[2].Cells[0].Attributes.Add("align", "center");
this.PlaceHolder1.Controls.Add(t);
this.lstAngajati.Enabled = false;
this.DropDownList1.Enabled = false;
return;
}
this.lstAngajati.Enabled = true;
this.DropDownList1.Enabled = true;
}
System.Web.UI.WebControls.Image img = new System.Web.UI.WebControls.Image();
img.ImageUrl = "MakeChart.aspx";
this.PlaceHolder1.Controls.Add(img);
}
/// <summary>
/// Se initializeaza datele specifice paginii
/// </summary>
private void Page_Load(object sender, System.EventArgs e)
{
string script_text = "<script>var ctrlID = \"" + this.ClientID + "\"</script>";
Response.Write(script_text);
litError.Text = "";
btnEdit.Style.Add("display", "none");
txtBoalaID.Style.Add("display", "none");
settings = Salaries.Configuration.ModuleConfig.GetSettings();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
if (!IsPostBack)
{
this.btnSalveaza.Enabled = true;
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
if (Parameters.DataAngajat == null)
{
return;
}
settings = Salaries.Configuration.ModuleConfig.GetSettings();
Conn.ConnectionString = settings.ConnectionString;
this.sqlSelectCommand1.Parameters["@dept"].Value = Parameters.NumeDepartament;
this.sqlSelectCommand1.Parameters["@angid"].Value = Parameters.DataAngajat.Value;
this.sqlSelectCommand1.Parameters["@tspan"].Value = Parameters.TimeSpan;
DataSet ds = new DataSet("Salarii");
DataAdapter.Fill(ds);
Parameters.Chart_SetData(ds.Tables[0], "data", "VenitNet", "Evolutia salariului angajatului " + Parameters.DataAngajat.Text, "Timp", "Salariu");
Response.BinaryWrite(Parameters.Chart_MakePicture("gif", 512, 400));
}
private void Page_Load(object sender, System.EventArgs e)
{
Response.Write("<script>\n\tvar ctrlID='" + this.UniqueID + "'\n\tvar toggle=1\n</script>");
settings = Salaries.Configuration.ModuleConfig.GetSettings();
this.Conn.ConnectionString = settings.ConnectionString;
this.numeDept.Text = Parameters.NumeDepartament;
if (!IsPostBack)
{
div2.Style.Add("display", "none");
}
else
{
if (this.Hidden1.Value == "")
{
div2.Style.Clear();
div2.Style.Add("DISPLAY", "none");
}
}
}
/// <summary>
/// ID-urile judetelor din fiecare tara.
/// </summary>
/// <returns> Returneaza id-urile judetelor din fiecare tara.</returns>
private string GetSirJudeteValue()
{
string sirJudVal = "";
string sirJudValFinal = "";
settings = Salaries.Configuration.ModuleConfig.GetSettings();
Salaries.Business.AdminJudete judete = new Salaries.Business.AdminJudete();
DataSet dsTari = (DataSet)lstDTara.DataSource;
foreach (DataRow drTari in dsTari.Tables[0].Rows)
{
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>
/// Listeaza departamentele angajatului
/// </summary>
private void LoadFormIstoricDepartamente()
{
try
{
listTable.Rows.Clear();
lstDepartament.Items.Clear();
settings = Salaries.Configuration.ModuleConfig.GetSettings();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
utilDb.CreateDepartamenteSelectBox(0, 0, lstDepartament);
listTable.Attributes.Add("width", "100%");
listTable.Style.Add("border", "1px solid #20b2aa");
listTable.Attributes.Add("cellpadding", "0");
listTable.Attributes.Add("cellspacing", "1");
Salaries.Business.IstoricDepartament istDept = new Salaries.Business.IstoricDepartament();
istDept.AngajatId = AngajatID;
string[] arHeader = { "Departament", "Data start" };
string[] arCols = { "DenumireCompleta", "DataStart" };
ListTable objListTable = new ListTable(listTable, istDept.LoadIstoricDepartament(), arHeader, arCols);
objListTable.textForEmptyDataSet = "Nu exista nici un departament asociat acestui angajat!";
string[] ar_OnClickParam = { "DepartamentID", "DataStart", AngajatID.ToString() };
string[] ar_OnClickParamType = { "dataset", "dataset", "const" };
objListTable.OnclickParams = ar_OnClickParam;
objListTable.OnclickParamsType = ar_OnClickParamType;
objListTable.OnclickJSMethod = "SelectDepartament";
objListTable.DrawListTableWithoutDigits();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
/// <summary>
/// Se initializeaza datele specifice paginii
/// </summary>
private void Page_Load(object sender, System.EventArgs e)
{
string script_text = "<script>var ctrlID = \"" + this.ClientID + "\"</script>";
Response.Write(script_text);
litError.Text = "";
btnEdit.Style.Add("display", "none");
txtSerieID.Style.Add("display", "none");
settings = Salaries.Configuration.ModuleConfig.GetSettings();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
Salaries.Business.Luni luni = new Salaries.Business.Luni(this.GetAngajator());
lunaActiva = luni.GetLunaActiva();
BindComboLstLunaSerie(luni);
BindPunctLucru();
if (!IsPostBack)
{
this.btnSalveaza.Enabled = true;
}
}
private void Page_Load(object sender, System.EventArgs e)
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
string script_text = "<script>var ctrlID = \"" + this.ClientID + "\"</script>";
Response.Write(script_text);
script_text = "<script>var DeptParinteIDClient = '" + this.DeptParinteID.ClientID + "';</script>";
Response.Write(script_text);
litError.Text = "";
this.lstDeptParinte.Enabled = true;
btnDelete.Attributes.Add("onclick", "return CheckDelete('Doriti sa stergeti acest departament?')");
Utilities.CreateTableHeader(headerTable, "Date identificare departament", "../", "small");
Response.Write("<script>var requiredDenumire = \"" + requiredDenumire.ClientID + "\"</script>");
Response.Write("<script>var regularDenumire = \"" + regularDenumire.ClientID + "\"</script>");
if (!IsPostBack)
{
this.ListareDepartamente();
}
}
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)
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
Utilities.CreateTableHeader(tableCautareRapida, "Cautare rapida", "", "normal");
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))
{
ErrHandler.MyErrHandler.WriteError("SearchAngajati.aspx - autentificare windows fara drepturi - " + user.Identity.Name);
Response.Redirect("Unauthorized.aspx");
}
}
//autentificare cu user si parola
else
{
try
{
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))
{
ErrHandler.MyErrHandler.WriteError("SearchAngajati.aspx - autentificare user parola fara drepturi - " + nume + ", " + angajatorId);
Response.Redirect("Unauthorized.aspx");
}
}
catch (Exception exc)
{
Response.Redirect("index.aspx");
}
}
ListItem myItem = new ListItem("", "-1");
lstDepartamentSearch.Items.Add(myItem);
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
utilDb.CreateDepartamenteSelectBox(0, 0, lstDepartamentSearch);
BindNationalitateCombo();
BindTaraDeOrigineCombo();
BindStudiiCombo();
BindTitulaturaCombo();
BindFunctieCombo();
BindCategorieCombo();
BindBancaCombo();
BindDataAngajareCombo();
BindPunctLucruCombo();
tableCautareAvansataVisible.Style.Add("display", "none");
//nu e niciunul vizibil
tdDataFixaSearch.Style.Add("display", "none");
tdLunaSearch.Style.Add("display", "none");
tdIntervalSearch.Style.Add("display", "none");
lblBanca.Style.Add("display", "none");
lstBancaSearch.Style.Add("display", "none");
lblCopii.Style.Add("display", "none");
lstDeducereCopiiSearch.Style.Add("display", "none");
CreazaVarJavaScript();
}
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="st"></param>
public Zile(Salaries.Configuration.ModuleSettings st)
{
settings = st;
m_con = new SqlConnection(settings.ConnectionString);
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
settings = Salaries.Configuration.ModuleConfig.GetSettings();
new UtilitiesDb(settings.ConnectionString).CreateTipAbsenteSelectBox(this.TipAbsentaDDL);
new UtilitiesDb(settings.ConnectionString).CreateTipBoliSelectBox(this.TipBoalaDDL);
int ConcediuOdihnaID = new UtilitiesDb(settings.ConnectionString).GetConcediuOdihnaID();
int ConcediuOdihnaAnulPrecedentID = new UtilitiesDb(settings.ConnectionString).GetConcediuOdihnaAnulPrecedentID();
LabelDataStart.Visible = LabelDataEnd.Visible = LabelsVisible;
if (Selectable)
{
if (TipIntervalID != -1)
{
this.TipAbsentaDDL.SelectedValue = TipIntervalID.ToString();
if ((this.TipAbsentaDDL.Items[this.TipAbsentaDDL.SelectedIndex].Text == "Concediu Medical") || (this.TipAbsentaDDL.Items[this.TipAbsentaDDL.SelectedIndex].Text == "Continuare Concediu Medical"))
{
if (TipBoalaID == -1)
{
TipBoalaID = int.Parse(this.TipBoalaDDL.Items[0].Value);
}
}
}
if (TipBoalaID != -1)
{
this.TipBoalaDDL.SelectedValue = TipBoalaID.ToString();
//devine vizibila tabela in functie de optiunea selectate
this.tableCM.Style.Add("display", "");
trMedieZilnica.Style.Add("display", "");
}
else
{
this.tableCM.Style.Add("display", "none");
if ((TipIntervalID != ConcediuOdihnaID) && (TipIntervalID != ConcediuOdihnaAnulPrecedentID))
{
trMedieZilnica.Style.Add("display", "none");
}
else
{
trMedieZilnica.Style.Add("display", "");
}
}
TipIntervalID = Convert.ToInt32(this.TipAbsentaDDL.SelectedItem.Value);
((System.Web.UI.HtmlControls.HtmlInputHidden)Page.FindControl("TipIntervalAbsente1")).Value = TipIntervalID.ToString();
TipBoalaID = Convert.ToInt32(this.TipBoalaDDL.SelectedItem.Value);
((System.Web.UI.HtmlControls.HtmlInputHidden)Page.FindControl("TipBoalaAbsente1")).Value = TipBoalaID.ToString();
}
else
{
TipIntervalID = Convert.ToInt32(this.TipAbsentaDDL.Items[0].Value);
((System.Web.UI.HtmlControls.HtmlInputHidden)Page.FindControl("TipIntervalAbsente1")).Value = TipIntervalID.ToString();
TipBoalaID = Convert.ToInt32(this.TipBoalaDDL.Items[0].Value);
((System.Web.UI.HtmlControls.HtmlInputHidden)Page.FindControl("TipBoalaAbsente1")).Value = TipBoalaID.ToString();
trMedieZilnica.Style.Add("display", "none");
this.tableCM.Style.Add("display", "none");
this.CheckInterval.Visible = false;
}
observatiiTA.Value = textObservatii;
if (TipIntervalID != -1)
{
if (this.CertificatInitial.Value != "Nu")
{
this.tabelCertificat.Style["display"] = "none";
this.tabelCertificat.Style["float"] = "left";
}
}
if (TipBoalaID != 7 && TipBoalaID != 5)
{
codUrgentaTr.Style["display"] = "none";
codUrgentaTr.Style["float"] = "left";
}
else
{
codUrgentaTr.Style["display"] = "";
}
if (TipBoalaID != 10)
{
cnpCopilTr.Style["display"] = "none";
cnpCopilTr.Style["float"] = "left";
}
else
{
cnpCopilTr.Style["display"] = "";
}
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="_AbsentaID"></param>
public IntervalAbsenteMedicaleContinuareAngajat(int _AbsentaID)
{
this.AbsentaID = _AbsentaID;
settings = Salaries.Configuration.ModuleConfig.GetSettings();
m_con = new SqlConnection(settings.ConnectionString);
}
private void Page_Load(object sender, System.EventArgs e)
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
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))
{
ErrHandler.MyErrHandler.WriteError("SearchAngajatiList_Recrutori.aspx - autentificare windows fara drepturi - " + user.Identity.Name);
Server.Transfer("../Unauthorized.aspx");
}
}
//autentificare cu user si parola
else
{
try
{
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))
{
ErrHandler.MyErrHandler.WriteError("SearchAngajatiList_Recrutori.aspx - autentificare user parola fara drepturi - " + nume + ", " + angajatorId);
Server.Transfer("../Unauthorized.aspx");
}
}
catch (Exception exc)
{
Response.Redirect("../index.aspx");
}
}
string searchTipCautare = Session["txtTipCautareHidden"].ToString();
string searchNume = Session["txtNumeSearch"].ToString();
string searchPrenume = Session["txtPrenumeSearch"].ToString();
int searchNationalitate = Convert.ToInt32(Session["lstNationalitateSearch"]);
int searchTaraOrigine = Convert.ToInt32(Session["lstTaraOrigineSearch"]); //tara de origine
int searchStareCivila = Convert.ToInt32(Session["lstStareCivilaSearch"]);
int searchCopii = Convert.ToInt32(Session["lstCopiiSearch"]); //copii
string searchSex = Session["lstSexSearch"].ToString();
int searchTitulatura = Convert.ToInt32(Session["lstTitulaturaSearch"]);
int searchStudii = Convert.ToInt32(Session["lstStudiiSearch"]);
string searchMarca = Session["txtMarcaSearch"].ToString();
int searchDepartament = Convert.ToInt32(Session["lstDepartamentSearch"]);
int searchFunctie = Convert.ToInt32(Session["lstFunctieSearch"]); //functie
int searchModIncadrare = Convert.ToInt32(Session["lstModIncadrareSearch"]);
int searchIndemnizatieConducere = Convert.ToInt32(Session["lstIndemnizatieConducereSearch"]); //indemnizatie conducere
//categorie angajat : scutit impozit/categorii
int searchScutitImpozit = Convert.ToInt32(Session["lstScutitImpozitSearch"]); //scutit impozit |
int searchCategorii = Convert.ToInt32(Session["lstCategorieAngajatSearch"]); //categorii |
//deducere+copii
int searchDeducere = Convert.ToInt32(Session["lstDeducereSearch"]); //deducere |
int searchDeducereCopii = Convert.ToInt32(Session["lstDeducereCopiiSearch"]); // copii |
//conturi bancare: are conturi/banca
int searchContBancarExistenta = Convert.ToInt32(Session["lstContBancarExistentaSearch"]); //are conturi |
int searchBanca = Convert.ToInt32(Session["lstBancaSearch"]); //banca |
//Data angajarii: tip data angajare/data fixa - data/luna - luna+an/interval - dataSt+dataEnd/blank - nimic/
int searchTipDataAngajare = Convert.ToInt32(Session["lstTipDataAngajareSearch"]);
DateTime searchDataFixa = DateTime.MinValue;
DateTime searchIntervalDataStart = DateTime.MinValue;
DateTime searchIntervalDataEnd = DateTime.MinValue;
int searchAnData = -1;
int searchLunaData = -1;
switch (searchTipDataAngajare)
{
case 0:
try
{
searchDataFixa = Utilities.ConvertText2DateTime(Session["txtDataAngajatiSearch"].ToString());
Session.Remove("txtDataAngajatiSearch");
}
catch {}
break;
case 1:
try
{
searchAnData = Convert.ToInt32(Session["lstAnAngajatiSearch"]);
searchLunaData = Convert.ToInt32(Session["lstLunaAngajatiSearch"]);
Session.Remove("lstAnAngajatiSearch");
Session.Remove("lstLunaAngajatiSearch");
}
catch {}
break;
case 2:
try
{
searchIntervalDataStart = Utilities.ConvertText2DateTime(Session["txtDataStartAngajatiSearch"].ToString());
searchIntervalDataEnd = Utilities.ConvertText2DateTime(Session["txtDataEndAngajatiSearch"].ToString());
Session.Remove("txtDataStartAngajatiSearch");
Session.Remove("txtDataEndAngajatiSearch");
}
catch {}
break;
case -1:
break;
}
int searchPerioadaDeterminata = Convert.ToInt32(Session["lstPerioadaDeterminataSearch"]); //Contract pe perioada determinata
//stergerea variabilelor de sesiune
stergeVariabile();
//comanda de cautare
SqlConnection m_con = new SqlConnection(settings.ConnectionString);
SqlCommand searchCommand = new SqlCommand("tmp_CautareAngajat", m_con);
searchCommand.CommandType = CommandType.StoredProcedure;
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_TipCautare", SqlDbType.NVarChar, 50, searchTipCautare));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_Nume", SqlDbType.NVarChar, 50, searchNume));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_Prenume", SqlDbType.NVarChar, 50, searchPrenume));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_Nationalitate", SqlDbType.Int, 4, searchNationalitate));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_TaraOrigineID", SqlDbType.Int, 4, searchTaraOrigine)); //tara de origine
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_StareCivila", SqlDbType.Int, 4, searchStareCivila));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_Copii", SqlDbType.Int, 4, searchCopii)); //copii
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_Sex", SqlDbType.Char, searchSex.Length, searchSex));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_TitluID", SqlDbType.Int, 4, searchTitulatura));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_StudiuID", SqlDbType.Int, 4, searchStudii));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_Marca", SqlDbType.NVarChar, 8, searchMarca));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_DepartamentID", SqlDbType.Int, 5, searchDepartament));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_FunctieID", SqlDbType.Int, 4, searchFunctie)); //functie
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_ModIncadrare", SqlDbType.Int, 4, searchModIncadrare));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_IndemnizatieConducere", SqlDbType.Int, 4, searchIndemnizatieConducere)); //indemnizatie de conducere
//categorie angajat
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_ScutitImpozit", SqlDbType.Int, 4, searchScutitImpozit));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_CategorieID", SqlDbType.Int, 4, searchCategorii));
//deducere
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_Deducere", SqlDbType.Int, 4, searchDeducere));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_DeducereCopii", SqlDbType.Int, 4, searchDeducereCopii));
//conturi bancare
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_ContBancarExistenta", SqlDbType.Int, 4, searchContBancarExistenta));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_BancaID", SqlDbType.Int, 4, searchBanca));
//data angajarii
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_TipDataAngajare", SqlDbType.Int, 4, searchTipDataAngajare));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_DataFixa", SqlDbType.DateTime, 8, searchDataFixa));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_LunaData", SqlDbType.Int, 4, searchLunaData));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_AnData", SqlDbType.Int, 4, searchAnData));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_IntervalDataStart", SqlDbType.DateTime, 8, searchIntervalDataStart));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_IntervalDataEnd", SqlDbType.DateTime, 8, searchIntervalDataEnd));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_DataMinValue", SqlDbType.DateTime, 8, DateTime.MinValue));
searchCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@in_PerioadaDeterminata", SqlDbType.Int, 4, searchPerioadaDeterminata)); //Contract pe perioada determinata
SqlDataAdapter dAdapt = new SqlDataAdapter(searchCommand);
DataSet ds = new DataSet();
dAdapt.Fill(ds);
Session["SortBy"] = "";
Index = 1;
Session["DataSource_searchList"] = ds;
listDataGrid.DataSource = ds;
listDataGrid.DataBind();
}
}
/// <summary>
/// Constructor
/// </summary>
public TipuriIntervale()
{
settings = Salaries.Configuration.ModuleConfig.GetSettings();
m_con = new SqlConnection(settings.ConnectionString);
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="_AngajatID">Id-ul angajatului</param>
/// <param name="st"></param>
public SituatieAngajat(long _AngajatID, Salaries.Configuration.ModuleSettings st)
{
this.AngajatID = _AngajatID;
settings = st;
m_con = new SqlConnection(settings.ConnectionString);
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="_AngajatID">Id-ul angajatului</param>
public SituatieAngajat(long _AngajatID)
{
this.AngajatID = _AngajatID;
settings = Salaries.Configuration.ModuleConfig.GetSettings();
m_con = new SqlConnection(settings.ConnectionString);
}
/// <summary>
/// Constructor
/// Adaugat: Alex Ciobanu
/// Data: 14.09.2005
/// </summary>
/// <param name="AngajatorID">Id-ul angajatorului</param>
/// <param name="st"></param>
public SituatieLunaraAngajator(long AngajatorID, Salaries.Configuration.ModuleSettings st)
{
this.m_AngajatorID = AngajatorID;
m_settings = st;
m_ConnectionString = m_settings.ConnectionString;
}
