public void UpdateContact(ContactModel contact)
{
using (ContactDBEntities db = new ContactDBEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
ContactView CT = db.ContactViews.Find(contact.ContactID);
CT.FirstName = contact.FirstName;
CT.LastName = contact.LastName;
CT.Phone = contact.Phone;
CT.Email = contact.Email;
CT.Street = contact.Street;
CT.City = contact.City;
CT.State = contact.State;
CT.PostalCode = contact.PostalCode;
CT.DisplayName = contact.DisplayName;
db.SaveChanges();
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
// POST api/Contacts
public HttpResponseMessage PostContact([FromBody] Contact contact)
{
if (ModelState.IsValid)
{
try
{
using (ContactDBEntities entities = new ContactDBEntities())
{
entities.Contacts.Add(contact);
entities.SaveChanges();
}
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, contact);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = contact.Id }));
return(response);
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public override string[] GetRolesForUser(string username)
{
ContactDBEntities db = new ContactDBEntities();
string data = db.tblLogins.Where(x => x.Username == username).FirstOrDefault().Role;
string[] result = { data };
return(result);
}
public ActionResult Index()
{
ContactDBEntities db = new ContactDBEntities();
var personList = (from p in db.People
join c in db.Contacts
on p.PersonID equals c.PersonID
select new PersonContactViewModel
{
Person = p,
Contact = c
}).ToList();
return(View(personList));
}
public HttpResponseMessage Contact(int id)
{
Contact contact = new Contact();
using (ContactDBEntities entities = new ContactDBEntities())
{
contact = entities.Contacts.FirstOrDefault(e => e.Id == id);
}
if (contact != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, contact));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with id= " + id.ToString() + " not found"));
}
}
public void AddContact(ContactModel contact)
{
using (ContactDBEntities db = new ContactDBEntities())
{
ContactView CT = new ContactView();
CT.FirstName = contact.FirstName;
CT.LastName = contact.LastName;
CT.Phone = contact.Phone;
CT.Email = contact.Email;
CT.Street = contact.Street;
CT.City = contact.City;
CT.State = contact.State;
CT.PostalCode = contact.PostalCode;
db.ContactViews.Add(CT);
db.SaveChanges();
}
}
// GET: ContactModels/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ContactModel contactModel = db.Contact.Find(id);
ContactDBEntities contactDBEntities = new ContactDBEntities();
TempData["numberOfChanges"] = contactDBEntities.Audit_Retrieve(id).Select(s => s.numberOfChanges).ToList().FirstOrDefault();
TempData["LastUpdateDateTime"] = contactDBEntities.Audit_Retrieve(id).Select(s => s.LastUpdateDateTime).ToList().FirstOrDefault();
if (contactModel == null)
{
return(HttpNotFound());
}
return(View(contactModel));
}
// PUT api/Contacts/5
public HttpResponseMessage PutContact(int id, Contact contact)
{
if (ModelState.IsValid && id == contact.Id)
{
try
{
using (ContactDBEntities entities = new ContactDBEntities())
{
var contactEntity = entities.Contacts.FirstOrDefault(e => e.Id == id);
if (contactEntity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Contact with id= " + id.ToString() + " not found"));
}
else
{
contactEntity.FirstName = contact.FirstName;
contactEntity.LastName = contact.LastName;
contactEntity.Email = contact.Email;
contactEntity.PhoneNumber = contact.PhoneNumber;
contactEntity.Status = contact.Status;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, contactEntity));
}
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public ActionResult Login(tblLogin model, string returnUrl)
{
ContactDBEntities db = new ContactDBEntities();
var dataItem = db.tblLogins.Where(x => x.Username == model.Username && x.Password == model.Password).First();
if (dataItem != null)
{
FormsAuthentication.SetAuthCookie(dataItem.Username, false);
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") &&
!returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\"))
{
return(Redirect(returnUrl));
}
else
{
return(RedirectToAction("Index"));
}
}
else
{
ModelState.AddModelError("", "Invalid user/pass");
return(View());
}
}
public void DeleteUser(int contactID)
{
using (ContactDBEntities db = new ContactDBEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
var CT = db.ContactViews.Where(o => o.ContactID == contactID);
if (CT.Any())
{
db.ContactViews.Remove(CT.FirstOrDefault());
db.SaveChanges();
}
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="MainWindowViewModel"/> class.
/// </summary>
public MainWindowViewModel()
{
m_DbContext = new ContactDBEntities();
}
public UnitOfWork()
{
_db = new ContactDBEntities();
}
public ContactRepository(ContactDBEntities context)
{
db = context;
}
// Constructor
public ContactAPIController()
{
// create instance of an object
dbContext = new ContactDBEntities();
}
public UnitOfWork()
{
_context = new ContactDBEntities();
}
/// <summary>
/// Public Constructor,initializes privately declared local variables.
/// </summary>
/// <param name="context"></param>
public GenericRepository(ContactDBEntities context)
{
this.Context = context;
this.DbSet = context.Set <TEntity>();
}
