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));
}
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
ListItem myItem = new ListItem("", "-1");
lstDepartamentSearch.Items.Add(myItem);
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
utilDb.CreateDepartamenteSelectBox(0, 0, lstDepartamentSearch);
BindNationalitateCombo();
BindTaraDeOrigineCombo();
BindTitulaturaCombo();
BindStudiiCombo();
BindFunctieCombo();
BindCategorieCombo();
BindBancaCombo();
BindDataAngajareCombo();
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();
}
//Lungu Andreea - 16.11.2009
public bool CheckExistaIntervalAbsenta(DateTime dataInceput, DateTime dataSfarsit, int idTipAbs, int idBoala)
{
SqlCommand myCommand = new SqlCommand("tm_CheckIntervaleAbsenta", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataInceput", SqlDbType.DateTime, 8, dataInceput));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataSfarsit", SqlDbType.DateTime, 8, dataSfarsit));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@IdTipAbs", SqlDbType.Int, 4, idTipAbs));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@IdBoala", SqlDbType.Int, 4, idBoala));
DataSet ds = new DataSet();
dAdapt.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Prcoedura sterge un interval de absenta
/// </summary>
/// <param name="IntervalAbsenteAngajatID">Id-ul intervalului de absenta</param>
public void DeleteIntervalAbsenteAngajat(int IntervalAbsenteAngajatID)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_InsertUpdateDeleteIntervalAbsenta", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@tip_actiune", SqlDbType.Int, 4, 2));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@IntervalAbsentaID", SqlDbType.Int, 4, IntervalAbsenteAngajatID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@TipAbsentaID", SqlDbType.Int, 4, 0));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataStart", SqlDbType.DateTime, 8, DateTime.Now));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataEnd", SqlDbType.DateTime, 8, DateTime.Now));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Observatii", SqlDbType.NText, 16, ""));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@BoalaID", SqlDbType.Int, 4, -1));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Serie", SqlDbType.NVarChar, 10, ""));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Numar", SqlDbType.NVarChar, 50, ""));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@SerieCertificatInitial", SqlDbType.NVarChar, 10, ""));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@NumarCertificatInitial", SqlDbType.NVarChar, 50, ""));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@ContinuareAbsenta", SqlDbType.Bit, 1, 0));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@MedieZilnica", SqlDbType.Real, 4, 0));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@EsteCertificat", SqlDbType.Bit, 1, 0));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataAcordariiCertificat", SqlDbType.DateTime, 8, DateTime.Now));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@CnpCopil", SqlDbType.NVarChar, 13, ""));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@LocPrescriereCertificat", SqlDbType.NVarChar, 50, ""));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@CodUrgenta", SqlDbType.NVarChar, 50, ""));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@NrAvizMedicExpert", SqlDbType.NVarChar, 50, ""));
m_con.Open();
myCommand.ExecuteNonQuery();
m_con.Close();
}
catch {}
}
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());
}
}
/// <summary>
/// Procedura actualizeaza un interval de absenta
/// </summary>
/// <param name="IntervalAbsentaID">Id-ul intervalului de absenta</param>
/// <param name="TipAbsentaID">Id-ul tipului de absenta</param>
/// <param name="DataStart">Data se inceput</param>
/// <param name="DataEnd">Data de sfarsit</param>
/// <param name="Observatii">Observatii</param>
/// <param name="boalaID">Id-ul bolii</param>
/// <param name="continuareAbsenta">Continuare absenta sau nu</param>
/// <param name="medieZilnica">Media zilnica asociata</param>
/// <param name="serie">Seriea</param>
/// <param name="numar">Numarul</param>
public void UpdateIntervalAbsenteAngajat(int IntervalAbsentaID, int TipAbsentaID, DateTime DataStart, DateTime DataEnd, string Observatii, int BoalaID, bool continuareAbsenta, double medieZilnica, string serie, string numar, bool certificatInitial, string serieCertificat, string numarCertificat, DateTime dataAcordarii, string cnpCopil, string locPrescriere, string codUrgenta, string nrAvizMedical)
{
try
{
//Oprescu Claudia
//se verifica daca nu este continuare de concediu medical. Daca este atunci se copiaza seria si numarul de la concediu medical altfel se adauga null
string SerieCertificatInitial = null, NumarCertificatInitial = null;
UtilitiesDb ut = new UtilitiesDb(settings.ConnectionString);
if (TipAbsentaID == ut.GetContinuareConcediuMedicalID())
{
//se apeleaza procedura stocata pentru a se afla seria si numarul pentru concediul medical asociat
SqlCommand cmd = new SqlCommand("tm_IntervaleAbsentaContinuareConcediuMedical", m_con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
cmd.Parameters.Add(UtilitiesDb.AddOutputParameter("@SerieCertificatInitial", SqlDbType.NVarChar, 10, ""));
cmd.Parameters.Add(UtilitiesDb.AddOutputParameter("@NumarCertificatInitial", SqlDbType.NVarChar, 50, ""));
m_con.Open();
cmd.ExecuteNonQuery();
m_con.Close();
SerieCertificatInitial = cmd.Parameters[1].Value.ToString().TrimEnd();
NumarCertificatInitial = cmd.Parameters[2].Value.ToString().TrimEnd();
}
SqlCommand myCommand = new SqlCommand("tm_InsertUpdateDeleteIntervalAbsenta", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@tip_actiune", SqlDbType.Int, 4, 1));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@IntervalAbsentaID", SqlDbType.Int, 4, IntervalAbsentaID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@TipAbsentaID", SqlDbType.Int, 4, TipAbsentaID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataStart", SqlDbType.DateTime, 8, DataStart));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataEnd", SqlDbType.DateTime, 8, DataEnd));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Observatii", SqlDbType.NText, 16, Observatii));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@BoalaID", SqlDbType.Int, 4, BoalaID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Serie", SqlDbType.NVarChar, 10, serie));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Numar", SqlDbType.NVarChar, 50, numar));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@SerieCertificatInitial", SqlDbType.NVarChar, 10, serieCertificat));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@NumarCertificatInitial", SqlDbType.NVarChar, 50, numarCertificat));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@ContinuareAbsenta", SqlDbType.Bit, 1, continuareAbsenta));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@MedieZilnica", SqlDbType.Real, 4, medieZilnica));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@EsteCertificat", SqlDbType.Bit, 1, certificatInitial));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataAcordariiCertificat", SqlDbType.DateTime, 8, dataAcordarii));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@CnpCopil", SqlDbType.NVarChar, 13, cnpCopil));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@LocPrescriereCertificat", SqlDbType.NVarChar, 50, locPrescriere));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@CodUrgenta", SqlDbType.NVarChar, 50, codUrgenta));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@NrAvizMedicExpert", SqlDbType.NVarChar, 50, nrAvizMedical));
m_con.Open();
myCommand.ExecuteNonQuery();
m_con.Close();
}
catch (Exception e)
{
string x = e.Message;
}
}
/// <summary>
/// Adauga un departament
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, System.EventArgs e)
{
try
{
this.lstDeptParinte.Enabled = true;
AdminDepartament newDepartament = new AdminDepartament();
newDepartament.DepartamentId = -1;
newDepartament.Denumire = txtDenumire.Text;
newDepartament.CentruCostId = int.Parse(lstCentruCost.SelectedValue);
if (this.lstSef.Items.Count != 0)
{
newDepartament.SefId = int.Parse(this.lstSef.SelectedValue);
}
else
{
newDepartament.SefId = -1;
}
newDepartament.InlocSefId = int.Parse(this.lstInlocSef.SelectedValue);
//newDepartament.SecretaraId = int.Parse(lstSecretara.SelectedValue);
newDepartament.Secretariat = txtSecretariat.Text;
if (lstDeptParinte.Items.Count > 0)
{
newDepartament.DeptParinte = int.Parse(this.lstDeptParinte.SelectedValue);
}
else
{
newDepartament.DeptParinte = 0;
}
if (newDepartament.CheckIfAdminDepartamentCanBeAdded())
{
newDepartament.InsertDepartament();
}
else
{
Response.Write("<script> alert('Mai exista un departament cu aceste date!'); </script>");
}
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
lstDeptParinte.Items.Clear();
utilDb.CreateDepartamenteSelectBox(0, 0, this.lstDeptParinte);
//Daca pagina de administrare a fost deschisa din alta pagina cream functia care va face refresh la combo-ul cu departamente
CreateRefreshFunction();
ListareDepartamente();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
//this.ListareDepartamente();
}
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 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;
}
}
/// <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>
/// Sterge un departament
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, System.EventArgs e)
{
try
{
int departamentId = Convert.ToInt32(txtDeptID.Value);
AdminDepartament departament = new AdminDepartament();
departament.DepartamentId = departamentId;
int sePoateSterge = departament.CheckIfDepartamentCanBeDeleted();
if (sePoateSterge == 1)
{
Response.Write("<script> alert('Departamentul nu poate fi sters! Este inca asociat unor angajati!'); </script>");
FillEditForm();
//Daca pagina de administrare a fost deschisa din alta pagina cream functia care va face refresh la combo-ul cu departamente
CreateRefreshFunction();
}
if (sePoateSterge == 2)
{
Response.Write("<script> alert('Departamentul nu poate fi sters! Contine alte departamente!'); </script>");
FillEditForm();
//Daca pagina de administrare a fost deschisa din alta pagina cream functia care va face refresh la combo-ul cu departamente
CreateRefreshFunction();
}
if (sePoateSterge == 3)
{
Response.Write("<script> alert('Operatiunea nu a fost efectuata deoarece nomenclatoul trebuie sa contina cel putin un departament.'); </script>");
FillEditForm();
//Daca pagina de administrare a fost deschisa din alta pagina cream functia care va face refresh la combo-ul cu departamente
CreateRefreshFunction();
}
if (sePoateSterge == 0)
{
departament.DeleteDepartament();
UtilitiesDb utilDb = new UtilitiesDb(settings.ConnectionString);
lstDeptParinte.Items.Clear();
utilDb.CreateDepartamenteSelectBox(0, 0, this.lstDeptParinte);
//Daca pagina de administrare a fost deschisa din alta pagina cream functia care va face refresh la combo-ul cu departamente
CreateRefreshFunction();
ListareDepartamente();
}
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
/// <summary>
/// Procedura selecteaza absentele unei luni
/// </summary>
/// <param name="An">Anul</param>
/// <param name="Luna">Luna</param>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
public DataSet GetAbsenteLuna(int An, int Luna)
{
SqlCommand myCommand = new SqlCommand("tm_GetAbsenteLuna", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@An", SqlDbType.Int, 4, An));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Luna", SqlDbType.Int, 4, Luna));
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return(ds);
}
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>
/// Procedura adauga un interval de absenta medicala
/// </summary>
/// <param name="DataStart">Data de inceput</param>
/// <param name="DataEnd">Data de sfarsit</param>
/// <param name="Observatii">Observatii</param>
/// <param name="boalaID">Id-ul bolii</param>
public void InsertIntervalAbsenteMedicaleContinuare(DateTime DataStart, DateTime DataEnd, string Observatii, int boalaID)
{
SqlCommand myCommand = new SqlCommand("tm_InsertUpdateDeleteIntervalAbsentaMedicalaContinuare", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@tip_actiune", SqlDbType.Int, 4, 0));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AbsentaContinuareID", SqlDbType.Int, 4, -1));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AbsentaID", SqlDbType.Int, 4, this.AbsentaID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataStart", SqlDbType.DateTime, 8, DataStart));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataEnd", SqlDbType.DateTime, 8, DataEnd));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Observatii", SqlDbType.NText, 16, Observatii));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@BoalaID", SqlDbType.Int, 4, boalaID));
m_con.Open();
myCommand.ExecuteNonQuery();
m_con.Close();
}
/// <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;
}
}
/// <summary>
/// Procedura adauga un interval de absenta
/// </summary>
/// <param name="Data">Data absentei</param>
/// <param name="TipAbsentaID">Tipul absentei</param>
public void InsertAbsentaAngajat(DateTime Data, int TipAbsentaID)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_InsertUpdateDeleteAbsentaAngajat", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@tip_actiune", SqlDbType.Int, 4, 0));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AbsentaAngajatID", SqlDbType.Int, 4, -1));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Data", SqlDbType.DateTime, 8, Data));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@TipAbsentaID", SqlDbType.Int, 4, TipAbsentaID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
m_con.Open();
myCommand.ExecuteNonQuery();
m_con.Close();
}
catch {}
}
/// <summary>
/// Procedura selecteaza intervalele de absenta medicale continuare de concediu medical
/// </summary>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
public DataSet GetIntervaleAbsentaMedicaleContinuare()
{
try
{
SqlCommand myCommand = new SqlCommand("tm_GetIntervaleAbsentaMedicalaContinuare", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AbsentaID", SqlDbType.Int, 4, this.AbsentaID));
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return(ds);
}
catch
{
return(null);
}
}
/// <summary>
/// Procedura adauga o zi
/// </summary>
/// <param name="Data">Data</param>
/// <param name="Sarbatoare">Este sarbatoare sau nu</param>
/// <param name="Denumire">Denumirea</param>
/// <param name="Descriere">Descriearea</param>
public void InsertZi(DateTime Data, bool Sarbatoare, string Denumire, string Descriere)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_InsertUpdateDeleteZi", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@tip_actiune", SqlDbType.Int, 4, 0));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Data", SqlDbType.DateTime, 8, Data.ToShortDateString()));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Sarbatoare", SqlDbType.Bit, 1, Sarbatoare));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Denumire", SqlDbType.NVarChar, 255, Denumire));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Descriere", SqlDbType.NText, 4000, Descriere));
m_con.Open();
myCommand.ExecuteNonQuery();
m_con.Close();
}
catch {}
}
/// <summary>
/// Procedura selecteaza un tip de interval
/// </summary>
/// <param name="TipIntervalID">Id-ul tipului de interval</param>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
public DataSet GetTipInterval(int TipIntervalID)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_GetTipInterval", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@TipIntervalID", SqlDbType.Int, 4, TipIntervalID));
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return(ds);
}
catch
{
return(null);
}
}
/// <summary>
/// Procedura verifica daca o zi este zi de sarbatoare
/// </summary>
/// <param name="dt">Data verificata</param>
/// <returns>Returneaza true daca este sarbatoare si false altfel</returns>
public bool IsSarbatoare(DateTime dt)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_GetZiDetaliu", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Data", SqlDbType.DateTime, 8, dt));
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return((bool)ds.Tables[0].Rows[0]["Sarbatoare"]);
}
catch
{
return(false);
}
}
/// <summary>
/// Daca expira contractul in luna data ca parametru retrneaza doar zilele dupa data expirarii
/// </summary>
/// <param name="An">Anul</param>
/// <param name="Luna">Luna</param>
/// <param name="DataExpirare">Data de sfarsit</param>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
public DataSet GetZileLunaImposibile(int An, int Luna, DateTime DataExpirare)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_GetZileLunaImposibile", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@An", SqlDbType.Int, 4, An));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Luna", SqlDbType.Int, 4, Luna));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataExpirare", SqlDbType.DateTime, 8, DataExpirare));
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return(ds);
}
catch
{
return(null);
}
}
/// <summary>
/// Procedura calculeaza nr de ore pe zi
/// </summary>
/// <param name="Data">Data</param>
/// <returns>Returneaza nr de ore pe zi</returns>
public float GetOreZi(DateTime Data)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_GetOreZi", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Data", SqlDbType.DateTime, 8, Data));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return(float.Parse(ds.Tables[0].Rows[0][0].ToString()));
}
catch
{
return(-1);
}
}
/// <summary>
/// Preia datele specifice (prog lucru, sal baza, etc) din intervalul de care apartine ziua data ca param
/// </summary>
/// <param name="Data">Data</param>
/// <returns>Returneaza o inregistrare din tabela</returns>
public DataRow GetZiApartenentaIntervalDateAngajare(DateTime Data)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_GetZiIntervalApartenentaInfo", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Data", SqlDbType.DateTime, 8, Data));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return(ds.Tables[0].Rows[0]);
}
catch
{
return(null);
}
}
/// <summary>
/// Procedura selecteaza un interval de intrerupere
/// </summary>
/// <param name="IntrerupereID">Id-ul intervalului</param>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
public DataSet GetIntervalIntreruperiAngajatByID(int IntrerupereID)
{
try
{
SqlCommand myCommand = new SqlCommand("GetIntervalAngajatIntrerupereByID", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@IntrerupereID", SqlDbType.Int, 4, IntrerupereID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return(ds);
}
catch
{
return(null);
}
}
/// <summary>
/// Procedura selecteaza intervalele de absenta al angajatului
/// </summary>
/// <param name="Data">Data</param>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
public DataSet GetIntervaleAbsentaAngajatLunaByDataInside(DateTime Data)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_GetIntervaleAbsentaSiEmergencyLuna", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataCurenta", SqlDbType.DateTime, 8, Data));
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return(ds);
}
catch
{
return(null);
}
}
/// <summary>
/// Procedura actualizeaza un interval de intrerupere
/// </summary>
/// <param name="AngajatIntrerupereID">Id-ul intreruperii</param>
/// <param name="DataStart">Data de inceput</param>
/// <param name="DataEnd">Data de sfarsit</param>
/// <param name="Descriere">Descrierea</param>
public void UpdateIntervalIntreruperiAngajat(int AngajatIntrerupereID, DateTime DataStart, DateTime DataEnd, string Descriere)
{
try
{
SqlCommand myCommand = new SqlCommand("InsertUpdateDeleteAngajatIntreruperi", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@tip_actiune", SqlDbType.Int, 4, 1));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatIntrerupereID", SqlDbType.Int, 4, AngajatIntrerupereID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataStart", SqlDbType.DateTime, 8, DataStart));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataEnd", SqlDbType.DateTime, 8, DataEnd));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Descriere", SqlDbType.NText, 16, Descriere));
m_con.Open();
myCommand.ExecuteNonQuery();
m_con.Close();
}
catch {}
}
/// <summary>
/// Procedura calculeaza nr de ore pe zi pentru fiecare zi din luna
/// </summary>
/// <param name="Data">Data</param>
/// <returns>Returneaza un dataset</returns>
//Lungu Andreea - 08.09.2008
//Descriere - se creaza un dataset ce contine nr de ore pentru fiecare zi a lunii
public DataSet GetOreZiLuna(DateTime dataStart, DateTime dataEnd)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_GetOreZi_Luna", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter dAdapt = new SqlDataAdapter(myCommand);
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AngajatID", SqlDbType.Int, 4, this.AngajatID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataStart", SqlDbType.DateTime, 8, dataStart));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataEnd", SqlDbType.DateTime, 8, dataEnd));
DataSet ds = new DataSet();
dAdapt.Fill(ds);
return(ds);
}
catch
{
return(null);
}
}
/// <summary>
/// Procedura sterge un interval de absenta medicala
/// </summary>
/// <param name="AbsentaContinuareID">Id-ul absentei care se sterge</param>
public void DeleteIntervalAbsenteMedicaleContinuare(int AbsentaContinuareID)
{
try
{
SqlCommand myCommand = new SqlCommand("tm_InsertUpdateDeleteIntervalAbsentaMedicalaContinuare", m_con);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@tip_actiune", SqlDbType.Int, 4, 2));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AbsentaContinuareID", SqlDbType.Int, 4, AbsentaContinuareID));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@AbsentaID", SqlDbType.Int, 4, -1));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataStart", SqlDbType.DateTime, 8, DateTime.Now));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@DataEnd", SqlDbType.DateTime, 8, DateTime.Now));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@Observatii", SqlDbType.NText, 16, ""));
myCommand.Parameters.Add(UtilitiesDb.AddInputParameter("@BoalaID", SqlDbType.Int, 4, -1));
m_con.Open();
myCommand.ExecuteNonQuery();
m_con.Close();
}
catch {}
}
