public int CreateContributor(ContributorModel cm) { int result = DaoUtilities.NO_CHANGES; CONTRIBUTOR c = db.CONTRIBUTOR.Create(); c.CONTRIBUTOR_ID = cm.UserId; c.CONTRIBUTOR_SHORTDESC = cm.ShortDesc; c.CONTRIBUTOR_LONGDESC = cm.LongDesc; db.CONTRIBUTOR.Add(c); 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 DeleteContributor(ContributorModel cm) { int result = DaoUtilities.NO_CHANGES; CONTRIBUTOR c = db.CONTRIBUTOR.Find(cm.UserId); if (c != null) { db.CONTRIBUTOR.Remove(c); 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 a contributor from the database to a ContributorModel /// </summary> /// <param name="c"></param> /// <returns></returns> public ContributorModel ConvertContributorToContributorModel(CONTRIBUTOR c) { USER1 u = db.USER1.Find(c.CONTRIBUTOR_ID); ContributorModel cm = new ContributorModel(); if (c != null && u != null) { cm.UserId = u.USER_ID; cm.Password = u.USER_PASSWORD; cm.FirstName = u.USER_FIRSTNAME; cm.LastName = u.USER_LASTNAME; cm.Adress1 = u.USER_ADR1; cm.Adress2 = u.USER_ADR2; cm.PC = u.USER_PC; cm.Town = u.USER_TOWN; cm.Phone = u.USER_PHONE; cm.Mail = u.USER_MAIL; cm.ShortDesc = c.CONTRIBUTOR_SHORTDESC; cm.LongDesc = c.CONTRIBUTOR_LONGDESC; } else cm = null; return cm; }