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); }
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); } }
public utblMstActivity GetActivityByID(long id) { utblMstActivity obj = _db.utblMstActivities.FirstOrDefault(p => p.ActivityID == id); return(obj); }