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