public int CreateActivity(ActivityModel am) { int result = DaoUtilities.NO_CHANGES; ACTIVITY a = db.ACTIVITY.Create(); a.ACTIVITY_ID = am.ActivityId; a.ACTIVITY_NAME = am.Name; a.ACTIVITY_SHORTDESC = am.ShortDesc; a.ACTIVITY_LONGDESC = am.LongDesc; a.ACTIVITY_MANAGER = am.ManagerId; db.ACTIVITY.Add(a); try { int saveResult = db.SaveChanges(); if (saveResult == 1) result = DaoUtilities.SAVE_SUCCESSFUL; } catch (DbUpdateConcurrencyException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION; } catch (DbUpdateException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_EXCEPTION; } catch (DbEntityValidationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION; } catch (NotSupportedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UNSUPPORTED_EXCEPTION; } catch (ObjectDisposedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.DISPOSED_EXCEPTION; } catch (InvalidOperationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.INVALID_OPERATION_EXCEPTION; } return result; }
public int DeleteActivity(ActivityModel am) { int result = DaoUtilities.NO_CHANGES; ACTIVITY a = db.ACTIVITY.Find(am.ActivityId); if(a != null) { db.ACTIVITY.Remove(a); try { int saveResult = db.SaveChanges(); if (saveResult == 1) result = DaoUtilities.SAVE_SUCCESSFUL; } catch (DbUpdateConcurrencyException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_CONCURRENCY_EXCEPTION; } catch (DbUpdateException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UPDATE_EXCEPTION; } catch (DbEntityValidationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.ENTITY_VALIDATION_EXCEPTION; } catch (NotSupportedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.UNSUPPORTED_EXCEPTION; } catch (ObjectDisposedException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.DISPOSED_EXCEPTION; } catch (InvalidOperationException e) { Console.WriteLine(e.GetBaseException().ToString()); result = DaoUtilities.INVALID_OPERATION_EXCEPTION; } } return result; }
/// <summary> /// Convert an activity from the database to an ActivityModel /// </summary> /// <param name="a"></param> /// <returns></returns> public ActivityModel ConvertActivityToActivityModel(ACTIVITY a) { ActivityModel am = new ActivityModel(); if (a != null) { am.ActivityId = a.ACTIVITY_ID; am.Name = a.ACTIVITY_NAME; am.ShortDesc = a.ACTIVITY_SHORTDESC; am.LongDesc = a.ACTIVITY_LONGDESC; am.ManagerId = a.ACTIVITY_MANAGER; } else am = null; return am; }