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