/// <summary>
/// Procedura determina zilele din luna cu intreruperi
/// </summary>
/// <param name="z"></param>
/// <returns>Returneaza un DataSet care contine aceste date</returns>
private DataSet GetZileLunaIntreruperi(Zile z)
{
try
{
DataSet ds = new IntervaleIntreruperiAngajat(this.GetAngajat()).GetIntervaleIntreruperiAngajatLuna(this.SelectedDate);
DataSet dsZile = z.GetZileIntrerupereContract(this.SelectedDate.Year, this.SelectedDate.Month, (DateTime)ds.Tables[0].Rows[0]["DataStart"], (DateTime)ds.Tables[0].Rows[0]["DataEnd"]);
for (int i = 1; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
dsZile.Merge(z.GetZileIntrerupereContract(this.SelectedDate.Year, this.SelectedDate.Month, (DateTime)dr["DataStart"], (DateTime)dr["DataEnd"]));
}
return(dsZile);
}
catch (Exception)
{
return(null);
}
}
/// <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);
}
}
static void Main(string[] args)
{
Zile z = Zile.Miercuri;
switch (z)
{
case Zile.Luni:
break;
case Zile.Marti:
break;
case Zile.Miercuri:
break;
case Zile.Joi:
break;
case Zile.Vineri:
break;
case Zile.Sambata:
break;
case Zile.Duminica:
break;
default:
break;
}
Zile z2 = (Zile)3;
Console.WriteLine(z2);
DataC.DataCalendaristica dc = new DataC.DataCalendaristica();
dc.SetZi(7);
dc.SetLuna(LunileAnului.Mai);
dc.SetAn(2018);
}
protected void CreateTimeStamp()
{
Table t = new Table();
TableRow r_days = new TableRow();
TableRow r_stamps = new TableRow();
Zile z = new Zile();
DataSet ds = z.GetLuna(this.SelectedDate.Year, this.SelectedDate.Month);
SituatieAngajat sa = new SituatieAngajat(this.AngajatID);
//Lungu Andreea - 08.09.2008
//Se folosesc doua dataset-uri pentru a aduce datele necesare
//Pentru a incerca sa optimizam timpul
DateTime dataStart = DateTime.Parse(ds.Tables[0].Rows[0]["Data"].ToString());
DateTime dataEnd = DateTime.Parse(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["Data"].ToString());
DataSet ds_ore = sa.GetOreZiLuna(dataStart, dataEnd);
DataSet ds_norma = sa.GetNormaZiLuna(dataStart, dataEnd);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TableCell tc = new TableCell();
tc.CssClass = "tabBackground";
tc.Width = 40;
tc.Attributes["align"] = "center";
tc.Font.Size = FontUnit.Small;
tc.Font.Name = "arial";
tc.Attributes["style"] = "cursor:hand";
tc.Attributes["onmouseover"] = "Light(this)";
tc.Attributes["onmouseout"] = "Delight(this)";
System.Drawing.Color back;
DateTime dt = DateTime.Parse(dr["Data"].ToString());
if (dt.ToShortDateString() == this.SelectedDate.ToShortDateString())
{
back = Definitions.Color_ZiSelected;
}
else
{
back = z.IsSarbatoare(dt) ? Definitions.Color_ZiSarbatoare : Definitions.Color_ZiLucru;
}
tc.BackColor = back;
tc.Text = "<b>" + dt.Day + "</b>";
tc.Attributes["onclick"] = "SelectZiLuna(" + dt.Day + ")";
r_days.Cells.Add(tc);
tc = new TableCell();
tc.CssClass = "tabBackground";
tc.Width = 40;
tc.Attributes["align"] = "center";
tc.Font.Size = FontUnit.Small;
tc.Font.Name = "arial";
tc.Attributes["style"] = "cursor:hand";
tc.Attributes["onmouseover"] = "Light(this)";
tc.Attributes["onmouseout"] = "Delight(this)";
tc.Attributes["onclick"] = "SelectZiLuna(" + dt.Day + ")";
dt = DateTime.Parse(dr["Data"].ToString());
back = Definitions.Color_StampNecompletat;
//Lungu Andreea - 08.09.2008
//sunt luate din dataset datele corespunzatoare unei anumite zile
float oreZi = 0;
if (ds_ore != null)
{
foreach (DataRow dr_ore in ds_ore.Tables[0].Rows)
{
if (dr_ore["Data"].ToString().Equals(dr["Data"].ToString()))
{
oreZi = (float)Double.Parse(dr_ore["OreZi"].ToString());
}
}
}
int normaZi = 0;
if (ds_norma != null)
{
foreach (DataRow dr_norma in ds_norma.Tables[0].Rows)
{
if (dr_norma["Data"].ToString().Equals(dr["Data"].ToString()))
{
normaZi = (int)Double.Parse(dr_norma["ProgramLucru"].ToString());
}
}
}
//float oreZi = sa.GetOreZi(dt);
//int normaZi = sa.GetNormaZi( dt );
if (oreZi > 0)
{
if (z.IsSarbatoare(dt))
{
back = Definitions.Color_StampCompletat;
}
else
{
back = (oreZi < normaZi) ? Definitions.Color_StampCompletatPartial : Definitions.Color_StampCompletat;
}
}
tc.BackColor = back;
tc.Text = " " + oreZi;
r_stamps.Cells.Add(tc);
}
DataSet myDs = GetZileLunaImposibile(z);
if (myDs != null)
{
foreach (DataRow dr in myDs.Tables[0].Rows)
{
//completeaza zilele cu -
r_stamps.Cells[((DateTime)dr["Data"]).Day - 1].Text = Definitions.TextZileLunaImposibile;
r_stamps.Cells[((DateTime)dr["Data"]).Day - 1].BackColor = Definitions.Color_StampZileLunaImposibile;
}
}
myDs = GetZileLunaIntreruperi(z);
if (myDs != null)
{
foreach (DataRow dr in myDs.Tables[0].Rows)
{
//completeaza zilele cu -
r_stamps.Cells[((DateTime)dr["Data"]).Day - 1].Text = Definitions.TextZileLunaImposibile;
r_stamps.Cells[((DateTime)dr["Data"]).Day - 1].BackColor = Definitions.Color_StampZileLunaIntreruperi;
}
}
myDs = sa.GetIntervaleAbsentaAngajatLunaByDataInside(this.SelectedDate);
for (int i = 0; i < r_stamps.Cells.Count; i++)
{
DateTime time = new DateTime(this.SelectedDate.Year, this.SelectedDate.Month, i + 1);
string cod = CompleteazaZiAbsentaLuna(myDs, i, sa);
if (cod != "")
{
r_stamps.Cells[i].Text = cod;
if (cod == Salaries.Business.SituatieLunaraAngajat.codAbsente[8] || cod == Salaries.Business.SituatieLunaraAngajat.codAbsente[9])
{
r_stamps.Cells[i].BackColor = Definitions.Color_StampDelegatie;
}
else
{
float oreZi = 0;
if (ds_ore != null)
{
foreach (DataRow dr_ore in ds_ore.Tables[0].Rows)
{
if (dr_ore["Data"].ToString().Equals(time.ToString()))
{
oreZi = (float)Double.Parse(dr_ore["OreZi"].ToString());
}
}
}
//if( cod==Salaries.Business.SituatieLunaraAngajat.codAbsente[ 10 ]+" "+sa.GetOreZi( time ).ToString())
if (cod == Salaries.Business.SituatieLunaraAngajat.codAbsente[10] + " " + oreZi.ToString())
{
r_stamps.Cells[i].BackColor = Definitions.Color_StampEmergencyService;
}
else
{
r_stamps.Cells[i].BackColor = Definitions.Color_StampAbsenta;
}
}
}
}
t.Rows.Add(r_days);
t.Rows.Add(r_stamps);
this.cell_container.Controls.Add(t);
}
