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; } }