/// <summary> /// Get contact types /// </summary> /// <returns></returns> public List<ContactTypeViewModel> GetContactTypes() { List<ContactTypeViewModel> contactTypeList = new List<ContactTypeViewModel>(); try { string sql = "SP_GetContactTypes"; using ( SqlConnection connection = new SqlConnection( _connectionString ) ) { SqlCommand command = new SqlCommand( sql, connection ); connection.Open(); using ( SqlDataReader dataReader = command.ExecuteReader() ) { while ( dataReader.Read() ) { ContactTypeViewModel contactType = new ContactTypeViewModel(); contactType.Id = Convert.ToInt32( dataReader["id"] ); contactType.ContactType = dataReader["description"].ToString(); contactTypeList.Add( contactType ); } } } } catch ( Exception ex ) { throw; } return contactTypeList; }
public ActionResult DeleteConfirmed(ContactTypeViewModel viewModel) { ContactType contactType = unitOfWork.ContactTypeRepository.FindById(viewModel.Id); unitOfWork.ContactTypeRepository.Delete(contactType); return(Redirect(viewModel.ReturnUrl)); }
public ContactTypeViewModel InsertType(ContactTypeViewModel model) { ContactType contactType = new ContactType { Id = model.Id, Name = model.Name }; db.ContactTypes.Add(contactType); db.SaveChanges(); return(model); }
public ActionResult Edit(ContactTypeViewModel viewModel) { ContactType contactType = unitOfWork.ContactTypeRepository.FindById(viewModel.Id); contactType.Name = viewModel.Name; if (ModelState.IsValid) { unitOfWork.ContactTypeRepository.Update(contactType); return(Redirect(viewModel.ReturnUrl)); } return(View(viewModel)); }
/// <summary> /// To the view model. /// </summary> /// <param name="model">The model.</param> /// <returns></returns> public static ContactTypeViewModel ToViewModel(this ContactTypeModel model) { if (model == null) { return(null); } var entity = new ContactTypeViewModel { ContactTypeID = model.ContactTypeID, ContactType = model.ContactType }; return(entity); }
/// <summary> /// To the model. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public static ContactTypeModel ToModel(this ContactTypeViewModel entity) { if (entity == null) { return(null); } var model = new ContactTypeModel { ContactTypeID = entity.ContactTypeID, ContactType = entity.ContactType }; return(model); }
public ActionResult Create(ContactTypeViewModel viewModel) { //ContactType contactType = db.ContactTypeRepository.FindById(viewModel.Id); ContactType contactType = new ContactType { Name = viewModel.Name }; if (ModelState.IsValid) { unitOfWork.ContactTypeRepository.Add(contactType); return(Redirect(viewModel.ReturnUrl)); } return(View(viewModel)); }
// GET: ContactRecords/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ContactType contactType = unitOfWork.ContactTypeRepository.FindById(id); if (contactType == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var viewModel = new ContactTypeViewModel { Name = contactType.Name, Id = contactType.Id }; return(View(viewModel)); }