public static void AddWorkTime(IWorkTime workTime, ConnectionToDB disconnect = ConnectionToDB.disconnect) { string select = String.Empty; if (workTime is Work) // if (typeof(Work).IsInstanceOfType(workTime)) { Work work = (Work)workTime; select = "insert into praca values('" + work.Date.ToString("d", DateFormat.TakeDateFormat()) + "'" + ",'" + work.IdEmployee + "','" + work.StartTime.ToString("d", DateFormat.TakeDateFormat()) + " " + work.StartTime.ToString("T", DateFormat.TakeDateFormat()) + "','" + work.StopTime.ToString("d", DateFormat.TakeDateFormat()) + " " + work.StopTime.ToString("T", DateFormat.TakeDateFormat()) + "')"; } if (workTime is Illness) { Illness illness = (Illness)workTime; select = "insert into choroba values('" + illness.IdEmployee + "'" + ",'" + illness.Date.ToString("d", DateFormat.TakeDateFormat()) + "','" + illness.IdIllnessType + "')"; } if (workTime is DayOff) { DayOff dayOff = (DayOff)workTime; select = "insert into urlop values('" + dayOff.IdEmployee + "'" + ",'" + dayOff.Date.ToString("d", DateFormat.TakeDateFormat()) + "','" + dayOff.IdTypeDayOff + "')"; } Database.Save(select, disconnect); //log LogSys.DodanieLoguSystemu(new LogSys(Polaczenia.idUser, RodzajZdarzenia.dodawanie, DateTime.Now, Polaczenia.ip, NazwaTabeli.praca, select), disconnect == ConnectionToDB.disconnect ? true : false); }
public bool UpdateWorkTime( string userMail, IWorkTime workTime, string projectDescription ) { return dataManagement.AssignWorkTimeToUser( userMail, workTime.Id, projectDescription ); }
public Address(IWorkTime workday, IWorkTime satuday, IWorkTime sunday) { this.WorkTime = (WorkTime)workday; this.WorkTimeSaturday = (WorkTime)satuday; this.WorkTimeSunday = (WorkTime)sunday; }
public WorkTime() { this.dataWorkTime = RoadFlow.Data.Factory.Factory.GetWorkTime(); }
public WorkTime() { dataWorkTime = Factory.GetWorkTime(); }
public bool WriteWorkTime(IWorkTime workTime) { if( File.Exists(pathWorkTime) ) { File.Delete(pathWorkTime); } var sw = File.CreateText(pathWorkTime); sw.Write(Jsonizer<List<WorkTime>>.Serialize(WorkTimeList)); sw.Flush(); sw.Close(); return true; }
IWorkTime UpdateWorkTime(String userMail, IWorkTime workTime, String projectDescription);
public bool WriteWorkTime( IWorkTime workTime ) { var wt = database.WorkTimes.Where( o => o.Id == workTime.Id ).FirstOrDefault(); if ( wt != null ) { wt.IstAbrechenbar = workTime.IstAbrechenbar; wt.IstReisezeit = workTime.IstReisezeit; wt.Anfang = workTime.Anfang; wt.Ende = workTime.Ende; } database.WorkTimes.Add( ( WorkTime )workTime ); database.SaveChanges(); return true; }