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;
}
