コード例 #1
0
        public override int insert(object obj)
        {
            try
            {
                UserShiftEntity   newUserShift = obj as UserShiftEntity;
                ShiftRegistration shift        = newUserShift.Cast <ShiftRegistration>();

                using (StoreManagementEntities context = new StoreManagementEntities())
                {
                    context.ShiftRegistrations.Add(shift);

                    ShiftTime regShift = context.ShiftTimes.Find(shift.WeekDay, shift.Shift);
                    regShift.Status = 0;

                    context.SaveChanges();
                }

                return(shift.Week);
            }
            catch (Exception e)
            {
                CustomException ex = new CustomException(GetType().Name + " : Insert " + obj.ToString() + "\n" + e.Message);
                ex.showPopupError();
            }

            return(-1);
        }
コード例 #2
0
        public override void delete(object obj)
        {
            try
            {
                UserShiftEntity entity = obj as UserShiftEntity;

                using (StoreManagementEntities context = new StoreManagementEntities())
                {
                    ShiftRegistration delete = (from u in context.ShiftRegistrations
                                                where entity.Week == u.Week && entity.Shift == u.Shift &&
                                                entity.WeekDay == u.WeekDay
                                                select u).Single();

                    context.ShiftRegistrations.Remove(delete);

                    ShiftTime shift = context.ShiftTimes.Find(entity.WeekDay, entity.Shift);
                    shift.Status = 1;

                    context.SaveChanges();
                }
            }
            catch (Exception e)
            {
                CustomException ex = new CustomException(GetType().Name + " : Delete " + obj.ToString() + "\n" + e.Message);
                ex.showPopupError();
            }
        }