예제 #1
0
        public int Save(utblMstActivity activity)
        {
            int result = 0;

            if (activity.ActivityID == 0)
            {
                try
                {
                    _db.utblMstActivities.Add(activity);
                    _db.SaveChanges();
                    result = 1;
                }
                catch (Exception ex)
                {
                    result = 0;
                }
            }
            else
            {
                utblMstActivity dbEntry = _db.utblMstActivities.Find(activity.ActivityID);
                if (dbEntry != null)
                {
                    dbEntry.ActivityTitle        = activity.ActivityTitle;
                    dbEntry.ActivityDetails      = activity.ActivityDetails;
                    dbEntry.DefaultDestinationID = activity.DefaultDestinationID;
                }
                _db.SaveChanges();
                result = 1;
            }
            return(result);
        }
예제 #2
0
        public int Delete(long id)
        {
            int             result = 0;
            utblMstActivity obj    = _db.utblMstActivities.Find(id);

            try
            {
                _db.utblMstActivities.Remove(obj);
                _db.SaveChanges();
                result = 1;
                return(result);
            }
            catch (Exception ex)
            {
                return(result);
            }
        }
예제 #3
0
        public utblMstActivity GetActivityByID(long id)
        {
            utblMstActivity obj = _db.utblMstActivities.FirstOrDefault(p => p.ActivityID == id);

            return(obj);
        }