public RaportMuncitorIMO(Persoana p, DateTime dataScanare, long numar, decimal greutate, string denumire)
{
this.Nume = p.Nume+" "+p.Prenume;
this.Numar = Convert.ToInt32(numar);
this.Greutate = greutate;
this.Denumire = denumire;
}
public Persoana SavePersoana(Persoana p)
{
BusinessPersoana bus = null;
//Persoana ret = null;
ITransaction tx = null;
try
{
tx = nHibernateUtil.BeginTransaction();
bus = new BusinessPersoana();
p = bus.SavePersoana(p);
tx.Commit();
}
catch (Exception ex)
{
LogMessage.Error(ex);
if (!nHibernateUtil.GetSession.Transaction.WasCommitted && !nHibernateUtil.GetSession.Transaction.WasRolledBack)
{
nHibernateUtil.GetSession.Transaction.Rollback();
}
throw ex;
}
finally
{
nHibernateUtil.CloseSession();
bus = null;
}
return p;
}
internal Persoana SavePersoana(Persoana p)
{
Persoana persoana = null;
p.CheckCanSave(dao);
if (p.Id == 0)
{
persoana = new Persoana();
}
else
{
persoana = GetPersoana(p.Id);
}
persoana.Nume = p.Nume;
persoana.Prenume = p.Prenume;
persoana.Anulat = p.Anulat;
persoana.Cod = p.Cod;
persoana.Functie = p.Functie;
persoana.Numar = p.Numar;
persoana.Firma = p.Firma;
persoana = dao.Save(persoana) as Persoana;
return persoana;
}
public ScanareIMO(Persoana p, Scanare s)
{
this.Nume = p.Nume;
this.Prenume = p.Prenume;
this.DataScanare = s.DataScanare;
this.Ambalaj = s.Ambalaj.Denumire;
this.Celula = s.Celula.Denumire;
this.Firma = p.Firma.Denumire;
this.Hala = s.Hala.Denumire;
this.SefEchipa = s.Sef.Nume + " " + s.Sef.Prenume;
}
public ScanareDetaliiIMO(Persoana p, Scanare s)
{
this.Nume = p.Nume;
this.Prenume = p.Prenume;
this.DataScanare = s.DataScanare;
this.Ambalaj = s.Ambalaj.Denumire;
this.Celula = s.Celula.Denumire;
this.Hala = s.Hala.Denumire;
this.Greutate = s.Ambalaj.Greutate;
this.AmbalajId = s.Ambalaj.Id;
this.Sef = s.Sef.Nume + " " + s.Sef.Prenume;
}
public PersoanaIMO(Persoana p)
{
this.Id = p.Id;
this.Nume = p.Nume;
this.Prenume = p.Prenume;
this.Anulat = p.Anulat;
this.Functie = p.Functie.Denumire;
this.Cod = p.Cod;
this.Numar = p.Numar;
this.Firma = p.Firma.Denumire;
this.NumeComplet = p.Nume + " " + p.Prenume;
}
private IList<ScanareIMO> GetScanareDetaliiIMO(Persoana p, DateTime dataStart, DateTime dataEnd)
{
IList<ScanareDetaliiIMO> list = null;
IList<ScanareIMO> scanari = null;
ScanareIMO scanare = null;
DateTime dataE = new DateTime();
DateTime dataS = new DateTime();
try
{
scanari = new List<ScanareIMO>();
for (DateTime date = dataStart.Date; date < dataEnd.Date.AddDays(1).AddMilliseconds(-1); date += TimeSpan.FromDays(1))
{
IList param = new ArrayList();
dataS = date;
dataE = dataS.Date.AddDays(1).AddMilliseconds(-1);
param.Add(new QueryParameter("xDataS", date.Date, "s.DataScanare", OperatorType.GreatherOrEquals, OperatorJoinType.AND));
param.Add(new QueryParameter("xDataE", dataE, "s.DataScanare", OperatorType.LessOrEquals, OperatorJoinType.AND));
param.Add(new QueryParameter("xPId", p.Id, "m.Id", OperatorType.Equals, OperatorJoinType.AND));
list = dao.ExecuteHql("select new ScanareDetaliiIMO(m, s) " +
" from Scanare s inner join s.Muncitor m ", param).Cast<ScanareDetaliiIMO>().ToList <ScanareDetaliiIMO>().AsReadOnly();
if (list.Count != 0)
{
scanare = new ScanareIMO();
scanare.Nume = p.Nume;
scanare.Prenume = p.Prenume;
scanare.DataScanare = date;
scanare.Detalii = list;
scanare.Firma = p.Firma.Denumire;
scanare.SefEchipa = list[0].Sef;
scanari.Add(scanare);
}
param = null;
}
}
catch (Exception ex)
{
throw ex;
}
return scanari;
}
private RaportMuncitorIMO GetRaportTotalDetaliiMuncitor(Persoana p, DateTime dataStart, DateTime dataEnd)
{
IList<RaportDetaliiMuncitorIMO> list = null;
RaportDataIMO dataScanare = null;
RaportMuncitorIMO ret = null;
decimal totalGreutate = 0;
decimal totalGreutatePerioada = 0;
try
{
ret = new RaportMuncitorIMO();
IList param = new ArrayList();
param.Add(new QueryParameter("xDataS", dataStart.Date, "s.DataScanare", OperatorType.GreatherOrEquals, OperatorJoinType.AND));
param.Add(new QueryParameter("xDataE", dataEnd.Date.AddDays(1).AddMilliseconds(-1), "s.DataScanare", OperatorType.LessOrEquals, OperatorJoinType.AND));
param.Add(new QueryParameter("xPId", p.Id, "m.Id", OperatorType.Equals, OperatorJoinType.AND));
list = dao.ExecuteHql("select new RaportDetaliiMuncitorIMO(count(s.Id),sum(a.Greutate),a.Denumire) " +
" from Scanare s inner join s.Muncitor m inner join s.Ambalaj a group by a.Denumire", param).Cast<RaportDetaliiMuncitorIMO>().ToList().AsReadOnly();
if (list.Count != 0)
{
ret.persoana = p;
ret.Numar = p.Numar;
ret.DataStart = dataStart;
ret.DataEnd = dataEnd;
dataScanare = new RaportDataIMO(dataStart);
foreach (RaportDetaliiMuncitorIMO det in list)
{
dataScanare.Detalii.Add(det);
totalGreutate += det.Greutate;
}
dataScanare.TotalGreutateZi = totalGreutate;
totalGreutatePerioada += totalGreutate;
ret.DataScanare.Add(dataScanare);
}
ret.TotalGreutatePerioada = totalGreutatePerioada;
param = null;
}
catch (Exception ex)
{
throw ex;
}
return ret;
}
private IList<RaportCumulatMuncitorIMO> GetRaportSefiEchipaDetalii(int firmaId, Persoana p, DateTime dataStart, DateTime dataEnd)
{
List<RaportCumulatMuncitorIMO> ret = null;
IList<RaportCumulatMuncitorIMO> list = null;
//DateTime dataE = new DateTime();
//DateTime dataS = new DateTime();
decimal totalGreutateZi;
try
{
ret = new List<RaportCumulatMuncitorIMO>();
//for (DateTime date = dataStart.Date; date < dataEnd.Date.AddDays(1).AddMilliseconds(-1); date += TimeSpan.FromDays(1))
//{
IList param = new ArrayList();
//dataS = date;
//dataE = dataS.Date.AddDays(1).AddMilliseconds(-1);
param.Add(new QueryParameter("xDataS", dataStart.Date, "s.DataScanare", OperatorType.GreatherOrEquals, OperatorJoinType.AND));
param.Add(new QueryParameter("xDataE", dataEnd.Date.AddDays(1).AddMilliseconds(-1), "s.DataScanare", OperatorType.LessOrEquals, OperatorJoinType.AND));
param.Add(new QueryParameter("xSefId", p.Id, "m.Id", OperatorType.Equals, OperatorJoinType.AND));
param.Add(new QueryParameter("xFirmaId", firmaId, "f.Id", OperatorType.Equals, OperatorJoinType.AND));
list = dao.ExecuteHql("select new RaportCumulatMuncitorIMO(s,a,count(s.Id),sum(a.Greutate)) " +
" from Scanare s inner join s.Sef m inner join m.Firma f " +
" inner join s.Ambalaj a group by a.Denumire",
param).Cast<RaportCumulatMuncitorIMO>().ToList<RaportCumulatMuncitorIMO>().AsReadOnly();
if (list.Count != 0)
{
totalGreutateZi = 0;
foreach (RaportCumulatMuncitorIMO det in list)
{
totalGreutateZi += det.Greutate;
det.TotalGreutatePerioada = totalGreutateZi;
det.DataEnd = dataEnd;
det.DataStart = dataStart;
}
ret.AddRange(list);
}
param = null;
//}
}
catch (Exception ex)
{
throw ex;
}
return ret;
}
private void SavePersoana(ManagerPersoana m)
{
Persoana p = new Persoana();
p.Id = Id;
p.Nume = Nume;
p.Prenume = Prenume;
p.Anulat = Anulat;
p.Functie = Functie;
p.Cod = Cod;
p.Numar=Numar;
p.Firma = Firma;
m.SavePersoana(p);
}
private void ConfirmareAnularePeroana(object sender, EventArgs e)
{
ManagerPersoana m = null;
ManagerFunctie m1 = null;
ManagerFirma m2 = null;
Persoana p = null;
try
{
if ((sender as Form).DialogResult != DialogResult.Yes)
{
return;
}
m = new ManagerPersoana();
m1 = new ManagerFunctie();
p = new Persoana();
persoanaCurenta.Anulat = true;
p.Id = persoanaCurenta.Id;
p.Nume = persoanaCurenta.Nume;
p.Prenume = persoanaCurenta.Prenume;
p.Cod = persoanaCurenta.Cod;
p.Anulat = persoanaCurenta.Anulat;
p.Numar = persoanaCurenta.Numar;
p.Functie = m1.GetFunctieByDenumire(persoanaCurenta.Functie);
p.Firma = m2.GetFirmaByDenumire(persoanaCurenta.Firma);
m.SavePersoana(p);
Init();
bindingSource1_PositionChanged(sender, e);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
m = null;
}
}
