protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
base.Render(writer);
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
objAngajat.AngajatId = AngajatID;
objAngajat.LoadAngajat();
/* Description:Pentru a nu se permite introducerea unui tip de absenta cand angajatul este lichidat,
* este obtinuta data lichidarii si scrisa pe javascript pentru a se putea face validarile.
*/
string dataLichidare;
if ((DateTime.Equals(objAngajat.DataLichidare, System.DBNull.Value)) || (DateTime.Equals(objAngajat.DataLichidare, DateTime.MinValue)))
{
dataLichidare = DateTime.MaxValue.ToString("dd.MM.yyyy");
}
else
{
dataLichidare = objAngajat.DataLichidare.ToString("dd.MM.yyyy");
}
Response.Write("<script>DataLichidare = '" + dataLichidare + "'</script>");
DateTime DataAngajare = objAngajat.DataDeLa;
Response.Write("<script>AngajareDataStart = '" + DataAngajare.ToString("dd.MM.yyyy") + "'</script>");
//Response.Write( "<script>var CheckIntreruperi = '"+this.CheckInterval.ClientID+"';</script>");
// //Response.Write( "<script>var IntervIntreruperiID = '"+this.txtIntrerupereID.ClientID+"';</script>");
// Response.Write( "<script>var ObservatiiIDIntrerupere = '"+this.txtObservatii.ClientID+"';</script>");
// Response.Write( "<script>var ClientObservatiiID = '"+this.txtObservatii.ClientID+"';</script>");
//
//string valoare = "<script>var tmpIntreruperi = new CreateIntervalIntreruperiElement('"+this.ClientID+"','"+this.txtDataStart.ClientID+"','"+this.txtDataEnd.ClientID+"','"+this.txtRetinereID.ClientID+"',null,'"+this.txtObservatii.ClientID+"');</script>";
//Response.Write( valoare );
}
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
Utilities.CreateTableHeader(tableHeader, "Angajatii carora le expira contractul in luna curenta", "", "normal");
if (!IsPostBack)
{
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
/*Salaries.Business.AdminAngajator angajator = new Salaries.Business.AdminAngajator();
* DataSet dsAngajatori = angajator.LoadInfoAngajatori();
*
* Salaries.Business.Luni luna = new Salaries.Business.Luni(int.Parse(dsAngajatori.Tables[0].Rows[0]["AngajatorId"].ToString()));
*
* Salaries.Business.IstoricSchimbareDateAngajat dataPosibilaIndexare = new Salaries.Business.IstoricSchimbareDateAngajat();
* dataPosibilaIndexare.DataStart = luna.GetLunaActiva().Data;
* while (dataPosibilaIndexare.DataEsteZiSarbatoare())
* {
* dataPosibilaIndexare.DataStart = dataPosibilaIndexare.DataStart.AddDays(1);
* }
* DataSet ds = objAngajat.GetAngajatiExpiraContractLunaCurenta(dataPosibilaIndexare.DataStart);*/
DataSet ds = objAngajat.GetAngajatiExpiraContractLunaCurenta(DateTime.Now);
Session["SortBy"] = "";
Index = 1;
Session["DataSource_Contract"] = ds;
listDataGrid.DataSource = ds;
listDataGrid.DataBind();
}
}
/// <summary>
/// Stabileste valorile pentru tipul de nationalitate
/// </summary>
/// <param name="ang">Angajatul pentru care se stabilesc datele</param>
private void CreateVarTipNationalitateDomiciliu(Salaries.Business.Angajat ang)
{
int taraBazaID = 0;
try
{
Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
DataSet dsTaraBaza = tari.GetTaraDeBaza();
taraBazaID = int.Parse(dsTaraBaza.Tables[0].Rows[0]["TaraID"].ToString());
}
catch
{
taraBazaID = 0;
}
int tipNationalitateDomiciliu = 0;
if (ang.Nationalitate == taraBazaID)
{
if (ang.DTara == taraBazaID)
{
tipNationalitateDomiciliu = 0;
}
else
{
tipNationalitateDomiciliu = 1;
}
}
else
{
tipNationalitateDomiciliu = 2;
}
Response.Write("<script>tipNationalitateDomiciliu = " + tipNationalitateDomiciliu + ";</script>");
}
private void Page_Load(object sender, System.EventArgs e)
{
this.AngajatID = this.GetLoggedUserID();
objectAngajat = new Salaries.Business.Angajat();
objectAngajat.AngajatId = AngajatID;
objectAngajat.LoadAngajat();
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
try
{
labelError.Text = "";
DataSet dsAngajatiLichidati = new DataSet();
int angajatorId = this.GetAngajator();
Salaries.Business.Angajat angajat = new Salaries.Business.Angajat();
angajat.AngajatorId = angajatorId;
// Luna curenta.
Salaries.Business.Luni luna = new Salaries.Business.Luni(angajatorId);
Salaries.Data.LunaData lunaCurenta = luna.GetLunaActiva();
if (drpAngajatiLichidati.SelectedValue != "")
{
idAngajat = Int32.Parse(drpAngajatiLichidati.SelectedValue);
}
else
{
idAngajat = 0;
}
//if (!IsPostBack)
//{
// Lista caselor de asigurari ale unui angajator.
dsAngajatiLichidati = angajat.GetAllAngajatiLichidati(this.GetCurrentMonth());
drpAngajatiLichidati.DataSource = dsAngajatiLichidati;
drpAngajatiLichidati.DataTextField = "NumeIntreg";
drpAngajatiLichidati.DataValueField = "AngajatId";
drpAngajatiLichidati.DataBind();
//}
bool exista = false;
foreach (DataRow dr in dsAngajatiLichidati.Tables[0].Rows)
{
if (Int32.Parse(dr["AngajatId"].ToString()) == idAngajat)
{
exista = true;
}
}
if (idAngajat != 0 && exista)
{
drpAngajatiLichidati.SelectedValue = idAngajat.ToString();
}
this.raportDateLichidare.ServerUrl = Salaries.Configuration.CryptographyClass.getSettingsWithoutDecode(STRING_URL);
// Sunt setati parametrii raportului.
// ID-ul angajatorului pentru care se genereaza raportul.
this.raportDateLichidare.SetQueryParameter("AngajatorID", angajatorId.ToString());
// Id-ul angajatului pentru care se genereaza raportul.
this.raportDateLichidare.SetQueryParameter("AngajatID", drpAngajatiLichidati.SelectedItem.Value);
}
catch (Exception)
{
labelError.Text = "Pentru a putea genera raportul trebuie sa fie disponibile toate datele necesare!";
}
}
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;
}
}
/// <summary>
/// Procedura realizeaza autentificarea utilizatorului
/// </summary>
/// <param name="AngajatID">Id-ul angajatului</param>
public void DoQuickLogin(int AngajatID)
{
// ************************* obs 1 : to perform login ! - sp - return AngajatID
Salaries.Business.Angajat a = new Salaries.Business.Angajat();
a.AngajatId = AngajatID;
a.LoadAngajat();
this.SaveSessionKey(Definitions.UserKEY, AngajatID);
this.SaveSessionKey(Definitions.UserInstanceKEY, a);
}
/// <summary>
/// Procedura realizeaza autentificarea utilizatorului
/// </summary>
/// <param name="Firma">Firma</param>
/// <param name="Utilizator">Utilizatorul</param>
/// <param name="Parola">Parola</param>
public void DoLogin(string Firma, string Utilizator, string Parola)
{
// ************************* obs 1 : to perform login ! - sp - return AngajatID
int AngajatID = 1017;
Salaries.Business.Angajat a = new Salaries.Business.Angajat();
a.AngajatId = AngajatID;
a.LoadAngajat();
this.SaveSessionKey(Definitions.UserKEY, AngajatID);
this.SaveSessionKey(Definitions.UserInstanceKEY, a);
}
private void Page_Load(object sender, System.EventArgs e)
{
Utilities.CreateTableHeader(tableHeader, "Alerte speciale pentru angajati", "", "normal");
if (!IsPostBack)
{
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
DataSet ds = objAngajat.GetAngajatiAlerteSpeciale();
Session["SortBy"] = "";
Index = 1;
Session["DataSource_AlerteSpeciale"] = ds;
listDataGrid.DataSource = ds;
listDataGrid.DataBind();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
Utilities.CreateTableHeader(tableHeader, "Angajatii carora li se apropia ziua de negociere a majorarii", "", "normal");
if (!IsPostBack)
{
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
DataSet ds = objAngajat.GetAngajatiExpiraDataMajorare();
Session["SortBy"] = "";
Index = 1;
Session["DataSource_Majorare"] = ds;
listDataGrid.DataSource = ds;
listDataGrid.DataBind();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
Utilities.CreateTableHeader(tablePermisMuncaHeader, "Angajatii carora le expira permisul de munca in mai putin de 60 zile", "", "normal");
if (!IsPostBack)
{
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
DataSet ds = objAngajat.GetAngajatiExpiraPermisMunca();
Session["SortBy"] = "";
IndexM = 1;
Session["DataSource_PermisMunca"] = ds;
listDataGrid4.DataSource = ds;
listDataGrid4.DataBind();
}
}
/// <summary>
/// Procedura creaza lista cu angajati
/// </summary>
/// <param name="listObj">Lista care va contine angajatii</param>
public void CreateAngajatiSiVidSelectBox(DropDownList listObj)
{
Salaries.Business.Angajat objAngajati = new Salaries.Business.Angajat();
DataSet ds = objAngajati.GetAllAngajatiNumeIntregUnion();
DataTable myTable = new DataTable();
myTable = ds.Tables[0];
listObj.Items.Clear();
for (int i = 0; i < myTable.Rows.Count; i++)
{
DataRow myRow = myTable.Rows[i];
ListItem myItem = new ListItem(myRow["NumeIntreg"].ToString(), myRow["AngajatID"].ToString());
listObj.Items.Add(myItem);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
#region variabile javascript
string script_text = "<script>var ctrlID = \"" + this.UniqueID + "\"</script>";
Response.Write(script_text);
Response.Write("<script>var DateStartID = '" + this.DateStart.ClientID + "';</script>");
Response.Write("<script>var DateEndID = '" + this.DateEnd.ClientID + "';</script>");
Response.Write("<script>var ddlTipuriRetineriClient = '" + this.ddlTipuriRetineri.ClientID + "';</script>");
Response.Write("<script>var txtDenumireRetinereClient = '" + this.txtRetinere.ClientID + "';</script>");
Response.Write("<script>var txtDataStartClient = '" + this.txtDataStart.ClientID + "';</script>");
Response.Write("<script>var txtDataEndClient = '" + this.txtDataEnd.ClientID + "';</script>");
Response.Write("<script>var txtValoareClient = '" + this.txtValoare.ClientID + "';</script>");
Response.Write("<script>var chkAlertaClient = '" + this.chkAlerta.ClientID + "';</script>");
Response.Write("<script>var txtRetinereIdClient = '" + this.txtRetinereID.ClientID + "';</script>");
#endregion
string[] textTabs = { "Lista retineri angajat", "Adauga retinere angajat" };
LoadRetineriAngajat();
SiemensTM.utils.Utilities.CreateHeaderWithTabs(tableTabs, textTabs, "../", true);
Response.Write("<script> var TipUtilizator = ''; </script>");
#region angajat, luna activa
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
objAngajat.AngajatId = AngajatID;
objAngajat.LoadAngajat();
Salaries.Business.Luni luni = new Salaries.Business.Luni(objAngajat.AngajatorId);
Salaries.Data.LunaData lunaData = luni.GetLunaActiva();
lunaID = lunaData.LunaId;
dataStartLunaActiva = lunaData.Data;
#endregion
Response.Write("<script> LunaActivaDataStart = '" + dataStartLunaActiva.ToString("dd.MM.yyyy") + "'</script>");
actiuneRetinere = ((System.Web.UI.HtmlControls.HtmlInputHidden)Page.FindControl("txtActiuneRetinere")).Value;
if (IsPostBack)
{
TransferDateRetinereLaClient();
HandleActions();
}
else
{
LoadTipuriRetineri();
TransferDateRetinereLaClient();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
Utilities.CreateTableHeader(tablePasaportHeader, "Angajatii carora le expira pasaportul in mai putin de opt luni", "", "normal");
//idUtilizator = Int32.Parse(Session["IdUtilizator"].ToString());
if (!IsPostBack)
{
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
DataSet ds = objAngajat.GetAngajatiExpiraPasaport();
Session["SortBy"] = "";
Ind = 1;
Session["DataSource_Pasaport"] = ds;
listDataGrid2.DataSource = ds;
listDataGrid2.DataBind();
}
}
private void btnGenerati_Click(object sender, System.EventArgs e)
{
Salaries.Business.Angajat inspectorResurseUmane = new Salaries.Business.Angajat();
inspectorResurseUmane.AngajatId = long.Parse(drpInspectorResurseUmane.SelectedValue);
inspectorResurseUmane.LoadAngajat();
if (ExistaToateDatele())
{
//sunt introduse in sesiune tipul comunicarii, numarul acesteia si suma
Session["TipComunicare"] = "adeverinta_medic.xml";
Session["Numar"] = txtNrCom.Text;
Session["DataInregistrarii"] = txtDataInregistrarii.Text;
// Numele managerului general.
Session["ManagerGeneral"] = txtManagerGeneral.Text;
// Numele directorului economic.
Session["DirectorEconomic"] = txtDirectorEconomic.Text;
// Numele inspectorului de resurse umane.
Session["InspectorResurseUmane"] = drpInspectorResurseUmane.SelectedItem.Text;
// Email-ul inspectorului de resurse umane
Session["InspResUmaneMail"] = inspectorResurseUmane.Email;
// Telefonul inspectorului de resurse umane
Session["InspResUmaneNrTel"] = inspectorResurseUmane.Telefon;
Response.Redirect("Comunicari/comunicare.aspx?id=" + objAngajat.AngajatId);
//este generata comunicarea
lblEroare.Text = "Comunicarea a fost generata.";
}
else
{
char[] sep = { ':' }; //se stabileste separatorul
Array aDate = dateNecesare.Split(sep); //se face impartirea in functie de separator
string dateNecesareF = "";
for (int i = 0; i < aDate.Length - 2; i++)
{
dateNecesareF += aDate.GetValue(i).ToString() + ", ";
}
dateNecesareF += aDate.GetValue(aDate.Length - 2).ToString();
lblEroare.Text = "Pentru a genera adeverinta medicala a acestui angajat trebuie sa mai completati urmatoarele campuri: " + dateNecesareF;
}
}
/// <summary>
/// Initializeaza ore lucrate ale unui angajat
/// </summary>
private void InitializeOreLucrateLunaAngajati()
{
ErrHandler.MyErrHandler.WriteError("InitializareLuna.ascx - start - initializeOreLucrateLuna()");
Salaries.Business.Angajat angajat = new Salaries.Business.Angajat();
angajat.CategorieId = int.Parse(lstCategorii.SelectedValue);
angajat.AngajatorId = GetAngajator();
//Modificat:Muntean Raluca Cristina - am adaugat ca parametru si id-ul angajatorului
DataSet ds = angajat.GetAllAngajati();
foreach (DataRow dr in ds.Tables[0].Rows)
{
IntervaleAngajat ia = new IntervaleAngajat(long.Parse(dr["AngajatID"].ToString()));
//Modified: Ionel Popa
//Description: In loc de DataPanaLa se transmite DataLichidare ( pentru ca e posibil ca prelungirea contractului sa se faca mai greu )
ia.InitializeOreLucrateLunaAngajat(this.SelectedDate, (DateTime)dr["DataDeLa"], dr["DataLichidare"]);
}
ErrHandler.MyErrHandler.WriteError("InitializareLuna.ascx - end - initializeOreLucrateLuna()");
}
/// <summary>
/// Genereaza situatia lunara pentru toti angajatii
/// </summary>
private void SituatieLunaraTotiAngajatii()
{
SiemensTM.Classes.SituatieAngajat situatieLunaraAng;
//Modificat:Muntean Raluca Cristina - am adaugat ca parametru si id-ul angajatorului
Salaries.Business.Angajat angajat = new Salaries.Business.Angajat();
angajat.CategorieId = -1;
angajat.AngajatorId = GetAngajator();
DataSet ds = angajat.GetAllAngajati();
foreach (DataRow dr in ds.Tables[0].Rows)
{
//Modified: Cristina Raluca Muntean
//se genereaza situatia lunara a unui angajat
//se apeleaza aceasta metoda pentru ca in cazul in care nu a fost initializata luna, sa se faca si aceasta operatie
situatieLunaraAng = new SiemensTM.Classes.SituatieAngajat(long.Parse(dr["AngajatID"].ToString()));
situatieLunaraAng.GenerareSituatieLunaraAngajat();
}
}
/// <summary>
/// Angajatii care apar in dropdown-urile de la departamente sa contina toti angajatii( indiferent daca sunt lichidati sau nu, activi sau nu, sau daca data angajarii e ulterioara)
/// </summary>
/// <param name="listObj">Lista care va contine departamentele</param>
/// <param name="angajatorID">Id-ul angajatorului</param>
/// <remarks>
/// Adaugat: Ionel Popa
/// </remarks>
public void CreateDepartamentAngajatiSelectBox(DropDownList listObj, int angajatorID)
{
Salaries.Business.Angajat angajat = new Salaries.Business.Angajat();
angajat.AngajatorId = angajatorID;
angajat.CategorieId = -2;
DataSet ds = angajat.GetAllAngajati();
DataTable myTable = new DataTable();
myTable = ds.Tables[0];
listObj.Items.Clear();
for (int i = 0; i < myTable.Rows.Count; i++)
{
DataRow myRow = myTable.Rows[i];
ListItem myItem = new ListItem(myRow["NumeIntreg"].ToString(), myRow["AngajatID"].ToString());
listObj.Items.Add(myItem);
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
try
{
DataSet dsAngajati = new DataSet();
Salaries.Business.Angajat angajati = new Salaries.Business.Angajat();
// Luna curenta.
Salaries.Business.Luni luna = new Salaries.Business.Luni(this.GetAngajator());
Salaries.Data.LunaData lunaCurenta = luna.GetLunaActiva();
if (!IsPostBack)
{
// Lista angajatilor firmei pentru care se genereaza declaratia pentru sanatate.
angajati.AngajatorId = GetAngajator();
dsAngajati = angajati.GetAllAngajatiDinLuna(this.GetCurrentMonth());
drpReprezentantLegal.DataSource = dsAngajati;
drpReprezentantLegal.DataTextField = "NumeIntreg";
drpReprezentantLegal.DataValueField = "AngajatID";
drpReprezentantLegal.DataBind();
// Este setata data platii drepturilor salariale.
txtDataPlatii.Text = lunaCurenta.Data.ToShortDateString();
}
this.raportSanatate.ServerUrl = Salaries.Configuration.CryptographyClass.getSettingsWithoutDecode(STRING_URL);
// Sunt setati parametrii raportului.
// ID-ul angajatorului pentru care se genereaza declaratia.
this.raportSanatate.SetQueryParameter("AngajatorID", this.GetAngajator().ToString());
// Id-ul lunii pentru care se genereaza declaratia.
this.raportSanatate.SetQueryParameter("LunaID", this.GetCurrentMonth().ToString());
// ID-ul reprezentantului legal al firmei.
this.raportSanatate.SetQueryParameter("ReprezentantLegalID", drpReprezentantLegal.SelectedItem.Value);
// Suma restanta.
this.raportSanatate.SetQueryParameter("Restanta", txtSumaRestanta.Text);
// Data platii drepturilor salariale.
this.raportSanatate.SetQueryParameter("DataPlataSalarii", txtDataPlatii.Text);
}
catch (Exception)
{
labelError.Text = "Pentru a putea genera raportul trebuie sa fie disponibile toate datele necesare!";
}
}
private void Page_Load(object sender, System.EventArgs e)
{
SiemensTM.Classes.Login l = new SiemensTM.Classes.Login();
Salaries.Business.Angajat objAngajat = l.GetLoggedAngajat();
if (objAngajat != null)
{
int id = new SiemensTM.Classes.Login().GetLoggedUserID();
lblNume.Text = objAngajat.Nume + " " + objAngajat.Prenume;
lblTitlu.Text = objAngajat.TitluSimbol;
if (l.IsAdminUser())
{
lblTitlu.Text = " Administrator - " + lblTitlu.Text;
}
lblFunctie.Text = objAngajat.FunctieCurentaNume;
lblDepartament.Text = objAngajat.DepartamentCurentCod;
}
}
/// <summary>
/// Creeaza dropdownlist-ul cu angajatii care au avut contract in luna trimisa ca parametru
/// </summary>
/// <param name="listObj">Lista cu angajati</param>
/// <param name="angajatorID">Id-ul angajatorului</param>
/// <param name="lunaID">Id-ul lunii</param>
/// <remarks>
/// Added: Cristina Raluca Muntean
/// Date: 13.09.2005
/// </remarks>
public void CreateAngajatiSelectBoxPeLuna(DropDownList listObj, int angajatorID, int lunaID)
{
try
{
Salaries.Business.Angajat angajat = new Salaries.Business.Angajat();
angajat.AngajatorId = angajatorID;
DataSet ds = angajat.GetAllAngajatiDinLuna(lunaID);
DataTable myTable = new DataTable();
myTable = ds.Tables[0];
listObj.Items.Clear();
for (int i = 0; i < myTable.Rows.Count; i++)
{
DataRow myRow = myTable.Rows[i];
ListItem myItem = new ListItem(myRow["NumeIntreg"].ToString(), myRow["AngajatID"].ToString());
listObj.Items.Add(myItem);
}
}
catch {}
}
/// <summary>
/// Procedura creaza lista cu angajati
/// </summary>
/// <param name="listObj">Lista care va contine angajatii</param>
/// <param name="angajatorID">Id-ul angajatorului</param>
public void CreateAngajatiSelectBox(DropDownList listObj, int angajatorID)
{
/*Modificat:Muntean Raluca Cristina
* DataSet-ul contine numele intregi si id-urile angajatilor activi, care au fost angajati
* in luna curenta sau intr-o luna anterioara acesteia, angajatii apartin de angajatorul
* cu id-ul trimis ca parametru*/
Salaries.Business.Angajat angajat = new Salaries.Business.Angajat();
angajat.AngajatorId = angajatorID;
angajat.CategorieId = -1;
DataSet ds = angajat.GetAllAngajati();
DataTable myTable = new DataTable();
myTable = ds.Tables[0];
listObj.Items.Clear();
for (int i = 0; i < myTable.Rows.Count; i++)
{
DataRow myRow = myTable.Rows[i];
ListItem myItem = new ListItem(myRow["NumeIntreg"].ToString(), myRow["AngajatID"].ToString());
listObj.Items.Add(myItem);
}
}
/// <summary>
/// Procedura determina zilele imposibile din luna
/// </summary>
/// <param name="z"></param>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
private DataSet GetZileLunaImposibile(Zile z)
{
try
{
Salaries.Business.Angajat ang = new Salaries.Business.Angajat();
ang.AngajatId = GetAngajat();
ang.LoadAngajat();
//Modified: Ionel Popa
//Description: Nu se ia in considerare DataPanaLa si DataLichidare
if (ang.DataLichidare.Year == 1 && ang.DataLichidare.Month == 1 && ang.DataLichidare.Day == 1)
{
return(null);
}
DataSet ds = z.GetZileLunaImposibile(SelectedDate.Year, SelectedDate.Month, ang.DataLichidare);
return(ds);
}
catch
{
return(null);
}
}
/// <summary>
/// Este efectuat calculul final al salariilor
/// </summary>
public void ProcessSalariiFinal()
{
//sunt sterse din baza de date salariile calculate inainte de inchiderea lunii
Salaries.Data.Process processSalarii = new Data.Process(settings.ConnectionString);
Salaries.Business.Angajat angajat = new Salaries.Business.Angajat();
//sunt preluate toate id-urile angajatilor
angajat.AngajatorId = angajatorID;
ArrayList alAng = angajat.GetSal_SituatieLunaraAngajatiIDs(lunaID);
int tot = alAng.Count, prev = Parameters.Task_PercentDone, current = 0;
foreach (int angajatID in alAng)
{
//este sters salariul angajatului pe o anumita luna
current++;
Parameters.Task_PercentDone = prev + (int)(current * 10 / tot);
processSalarii.DeleteSalariuLuna(lunaID, angajatID);
}
//sunt calculate salariile si sunt introduse datele in baza de date
ProcessSalariiIntermediar();
}
private void Page_Load(object sender, System.EventArgs e)
{
long AngajatID = Convert.ToInt32(Request.QueryString["id"]);
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
objAngajat.AngajatId = AngajatID;
object obj = objAngajat.LoadPozaAngajat();
if (obj != null)
{
byte[] img = (byte[])obj;
Response.Clear();
Response.ContentType = "application/msexcel";
System.IO.MemoryStream stream = new System.IO.MemoryStream(img, true);
stream.Write(img, 0, img.Length);
Bitmap bitmap = new Bitmap(stream);
bitmap.Save(Response.OutputStream, ImageFormat.Jpeg);
Response.End();
}
else // no picture available
{
Bitmap bitmap = new Bitmap(150, 150);
Graphics gr = Graphics.FromImage(bitmap);
gr.Clear(Color.White);
gr.DrawString("NO", new Font("Arial", 12, FontStyle.Bold), System.Drawing.Brushes.Red, 60, 20);
gr.DrawString("PICTURE", new Font("Arial", 12, FontStyle.Bold), System.Drawing.Brushes.Red, 40, 70);
gr.DrawString("AVAILABLE", new Font("Arial", 12, FontStyle.Bold), System.Drawing.Brushes.Red, 30, 120);
Response.Clear();
Response.ContentType = "Image/";
bitmap.Save(Response.OutputStream, ImageFormat.Jpeg);
Response.End();
}
}
private void Page_Load(object sender, System.EventArgs e)
{
Utilities.CreateTableHeader(tableRetineriHeader, "Angajatii carora le expira diferite retineri in acesta luna", "", "normal");
int angajatorId = int.Parse(Session["AngajatorId"].ToString());
Salaries.Business.Luni luni = new Salaries.Business.Luni(angajatorId);
Salaries.Data.LunaData lunaData = luni.GetLunaActiva();
if (!IsPostBack)
{
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
DataSet ds = objAngajat.GetAngajatiExpiraRetineri(lunaData.LunaId);
Session["SortBy"] = "";
Ind = 1;
Session["DataSource_Retineri"] = ds;
listDataGridAngajati.DataSource = ds;
listDataGridAngajati.DataBind();
}
}
/// <summary>
/// Este efectuat calculul salariului pentru fiecare angajat in parte
/// </summary>
public void ProcessSalariiIntermediar()
{
Salaries.Data.Process processSalarii = new Salaries.Data.Process(settings.ConnectionString);
Salaries.Business.Angajat angajat = new Salaries.Business.Angajat();
angajat.AngajatorId = angajatorID;
//sunt preluate toate id-urile angajatilor
ArrayList alAng = angajat.GetSal_SituatieLunaraAngajatiIDs(lunaID);
processSalarii.DeleteSalarii(lunaID, angajatorID);
int total = alAng.Count, previous = Parameters.Task_PercentDone, current = 0;
foreach (int id in alAng)
{
current++;
Parameters.Task_PercentDone = previous + (int)(current * 33 / total);
//este sters salariul angajatului pe o anumita luna
//processSalarii.DeleteSalariuLuna(lunaID, id);
//este calculat salariul angajatului
ProcessSalariuAngajat(id);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
string script_text = "<script>var ctrlID = \"" + this.UniqueID + "\"</script>";
Response.Write(script_text);
if (objAngajat.IsLichidat)
{
btnGenerati.Enabled = false;
lstPerAngajarii.Disabled = true;
txtDataDeLa.Enabled = false;
txtDataPanaLa.Enabled = false;
lblEroare.Text = "Angajatul selectat este lichidat!";
}
else
{
Salaries.Business.Angajat dateAngajat = new Salaries.Business.Angajat();
dateAngajat.AngajatId = Convert.ToInt32(objAngajat.AngajatId);
DataTable dt = dateAngajat.GetDetaliiAngajat().Tables[0];
foreach (DataRow dr in dt.Rows)
{
lstPerAngajarii.SelectedIndex = dr["PerioadaDeterminata"].ToString().Equals("True")?0:1;
if (dr["DataDeLa"] != DBNull.Value)
{
txtDataDeLa.Text = Convert.ToDateTime(dr["DataDeLa"]).ToString("dd.MM.yyyy");
}
if (dr["DataPanaLa"] != DBNull.Value)
{
txtDataPanaLa.Text = Convert.ToDateTime(dr["DataPanaLa"]).ToString("dd.MM.yyyy");
}
txtDataGenerarii.Text = DateTime.Today.ToString("dd.MM.yyyy");
break;
}
}
//header de tabel
Utilities.CreateTableHeader(Table2, "Comunicare prelungire contract individual de munca", "", "normal");
}
private void Page_Load(object sender, System.EventArgs e)
{
//Modificat: Cristina Muntean ... se permite modificarea pontajului numai daca luna selectata de
//utilizator este luna activa a angajatorului sau daca exista situatie lunara pentru angajatul selectat
//luna selectata de utilizator
int lunaCurentaID = int.Parse(this.Session[SiemensHR.InterfataSalarii.Classes.Definitions.LunaCurentaKey].ToString());
//id-ul angajatului selectat in dropdownlist
int angajatID = this.GetAngajat();
Salaries.Business.Angajat objAngajat = new Salaries.Business.Angajat();
objAngajat.AngajatId = angajatID;
objAngajat.LoadAngajat();
//luna activa a angajatorului
Salaries.Business.Luni luna = new Salaries.Business.Luni(objAngajat.AngajatorId);
Salaries.Data.LunaData lunaData = luna.GetLunaActiva();
//se obtine situatie lunara a angajatului
Salaries.Business.SituatieLunaraAngajat situatieLunaraAng = new Salaries.Business.SituatieLunaraAngajat(objAngajat.AngajatId);
Salaries.Data.InfoSituatieLunara infoSituatieLunara = situatieLunaraAng.GetSituatieLunaraAngajat(objAngajat.AngajatId, lunaData.LunaId);
//daca luna selectata de utilizator nu este luna activa sau daca nu exista o situatie lunara pentru angajatul selectat
//atunci se permite doar vizualizarea pontajului,altfel se permite si modificarea acestuia
if ((lunaCurentaID != lunaData.LunaId) || (infoSituatieLunara.SituatieID == -1))
{
//HtmlTableCell IntervaleContainer este ascunsa
IntervaleContainer.Style.Add("display", "none");
}
else
{
//HtmlTableCell IntervaleContainer este facuta vizibila
IntervaleContainer.Style.Add("display", "");
}
ClientSelectedDate1 = (System.Web.UI.HtmlControls.HtmlInputHidden)Page.FindControl("ClientSelectedDate");
this.DoQuickLogin(this.GetAngajat());
}
/// <summary>
/// Procedura salveaza poza adaugata
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSalveaza_Click(object sender, System.EventArgs e)
{
try
{
if ((filePozaAngajat.PostedFile.FileName != "") || (filePozaAngajat.PostedFile.ContentLength != 0))
{
string contentFile = filePozaAngajat.PostedFile.ContentType.ToString();
if (contentFile.Substring(0, 5) == "image")
{
FileStream fp = new FileStream(filePozaAngajat.PostedFile.FileName, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fp);
byte[] buffer = br.ReadBytes((int)fp.Length);
br.Close();
fp.Close();
Salaries.Business.Angajat angajat = new Salaries.Business.Angajat();
angajat.AngajatId = AngajatID;
angajat.UpdatePoza(buffer);
}
else
{
throw new Exception("Se pot salva numai fisiere de tip image (gif, jpg, jpeg...)!");
}
}
else
{
throw new Exception("Invalid file name or file length zero!");
}
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
