コード例 #1
0
        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);
        }
コード例 #2
0
 public bool UpdateWorkTime( string userMail, IWorkTime workTime, string projectDescription )
 {
     return dataManagement.AssignWorkTimeToUser( userMail, workTime.Id, projectDescription );
 }
コード例 #3
0
ファイル: Address.cs プロジェクト: rusrc/discountapp_mvc
 public Address(IWorkTime workday, IWorkTime satuday, IWorkTime sunday)
 {
     this.WorkTime         = (WorkTime)workday;
     this.WorkTimeSaturday = (WorkTime)satuday;
     this.WorkTimeSunday   = (WorkTime)sunday;
 }
コード例 #4
0
 public WorkTime()
 {
     this.dataWorkTime = RoadFlow.Data.Factory.Factory.GetWorkTime();
 }
コード例 #5
0
 public WorkTime()
 {
     dataWorkTime = Factory.GetWorkTime();
 }
コード例 #6
0
        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;
        }
コード例 #7
0
 IWorkTime UpdateWorkTime(String userMail, IWorkTime workTime, String projectDescription);
コード例 #8
0
        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;
        }