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