C# (CSharp) DBLayer.UserVisits.UserVisits_Details Examples

Example #1

File: UserVisits.cs Project: ArtemenkoArt/fitness-app

        public static void Insert(DBLayer.UserVisits.UserVisits_Details det)
        {
            string sql = "INSERT INTO UserVisits (UserId, [Date], [TimeOn], [TimeOff]) ";

            sql += " VALUES (" + det.UserId.ToString() + ", '" + det.Date.Date.ToString("yyyyMMdd") + "', '" + det.TimeOn + "', '" + det.TimeOff + "')";

            ZFort.DB.Execute.ExecuteString_void(sql);
        }

Example #2

File: UserVisits.cs Project: ArtemenkoArt/fitness-app

        public static void Update(DBLayer.UserVisits.UserVisits_Details det)
        {
            ZFort.DB.Execute.ExecuteString_void("UPDATE UserVisits SET [UserId] = " + det.UserId.ToString() + " WHERE [Id] = " + det.Id.ToString());

            ZFort.DB.Execute.ExecuteString_void("UPDATE UserVisits SET [Date] = '" + det.Date.Date.ToString("yyyyMMdd") + "' WHERE [Id] = " + det.Id.ToString());

            ZFort.DB.Execute.ExecuteString_void("UPDATE UserVisits SET [TimeOn] = '" + det.TimeOn + "' WHERE [Id] = " + det.Id.ToString());

            ZFort.DB.Execute.ExecuteString_void("UPDATE UserVisits SET [TimeOff] = '" + det.TimeOff + "' WHERE [Id] = " + det.Id.ToString());
        }