public ActionResult DeleteSave(string id)
{
phoneBookContext = new PhoneBookContext();
phoneBookContext.Delete(Guid.Parse(id));
ViewBag.PhoneBooks = phoneBookContext.PhoneBooks;
return(View("Index"));
}
public ActionResult UpdateSave(string id, string surname, string telephone)
{
phoneBookContext = new PhoneBookContext();
phoneBookContext.Update(Guid.Parse(id), surname, telephone);
ViewBag.PhoneBooks = phoneBookContext.PhoneBooks;
return(View("Index"));
}
public async Task <ResponseModel <IEnumerable <EntryOutputModel> > > GetByPhoneBookId(int phoneBookId)
{
try
{
using (var ctx = new PhoneBookContext())
{
var entries = ctx.Entries.Where(x => x.PhoneBookId == phoneBookId);
if (entries.Count() == 0)
{
return(new ResponseModel <IEnumerable <EntryOutputModel> > {
ResponseMessage = Constants.RecordsNotFound, IsSuccessful = false
});
}
return(new ResponseModel <IEnumerable <EntryOutputModel> >
{
DataSet = entries.Select(_mapper.Map <EntryOutputModel>).OrderBy(w => w.Name).ToList()
});
}
}
catch (Exception ex)
{
return(new ResponseModel <IEnumerable <EntryOutputModel> > {
ResponseMessage = Constants.UnexpectedError, IsSuccessful = false
});
}
}
public async Task <ResponseModel <IEnumerable <EntryOutputModel> > > Search(string searchString)
{
try
{
using (var ctx = new PhoneBookContext())
{
var entries = ctx.Entries.Where(x => x.Name.ToLower().Contains(searchString) || x.PhoneNumber.ToLower().Contains(searchString));
if (entries.Count() == 0)
{
return(new ResponseModel <IEnumerable <EntryOutputModel> > {
ResponseMessage = Constants.RecordsNotFound, IsSuccessful = false
});
}
return(new ResponseModel <IEnumerable <EntryOutputModel> >
{
DataSet = entries.Select(_mapper.Map <EntryOutputModel>).ToList()
});
}
}
catch (Exception ex)
{
return(new ResponseModel <IEnumerable <EntryOutputModel> > {
ResponseMessage = Constants.UnexpectedError, IsSuccessful = false
});
}
}
public Person GetById(int id)
{
using (PhoneBookContext context = new PhoneBookContext())
{
return(context.People.Find(id));
}
}
public async Task <ResponseModel <EntryOutputModel> > Edit(int entryId, EntryInputModel entryModel)
{
try
{
using (var ctx = new PhoneBookContext())
{
var existinEntry = ctx.Entries.FirstOrDefault(x => x.EntryId == entryId);
if (existinEntry.Name != existinEntry.Name || existinEntry.PhoneNumber != entryModel.PhoneNumber || existinEntry.PhoneBookId != entryModel.PhoneBookId)
{
existinEntry.Name = entryModel.Name;
existinEntry.PhoneNumber = entryModel.PhoneNumber;
existinEntry.PhoneBookId = entryModel.PhoneBookId;
await ctx.SaveChangesAsync();
}
return(new ResponseModel <EntryOutputModel> {
DataSet = _mapper.Map <Core.Entry, EntryOutputModel>(existinEntry)
});
}
}
catch (Exception ex)
{
return(new ResponseModel <EntryOutputModel> {
ResponseMessage = Constants.UnexpectedError, IsSuccessful = false
});
}
}
/// <summary>
///
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public GetAllEmployeeResponse GetAllEmployee(GetAllEmployeeRequest request)
{
try
{
// trong Store em đang để so sánh với điều kiện @keyword = '' nên có đoạn gắn giá trị trống này cho tham số Keyword
if (String.IsNullOrEmpty(request.Keyword))
{
request.Keyword = "";
}
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@keyword", request.Keyword);
parameters.Add("@pageindex", request.PageIndex);
parameters.Add("@pagesize", request.PageSize);
using (var context = new PhoneBookContext())
{
List <ContactObject> result = context.Contacts.Select(c => new ContactObject {
ContactId = c.ContactId,
Email = c.Email
}).ToList();
return(new GetAllEmployeeResponse
{
Status = ResponseStatus.Susscess,
Contacts = result
});
}
}
catch (Exception ex)
{
return(new GetAllEmployeeResponse
{
Status = ResponseStatus.Fail,
Message = ex.Message
});
}
}
public ActionResult AddSave(string surname, string telephone)
{
phoneBookContext = new PhoneBookContext();
phoneBookContext.Add(surname, telephone);
ViewBag.PhoneBooks = phoneBookContext.PhoneBooks;
return(View("Index"));
}
public ActionResult DeleteSave(string id)
{
phoneBookContext = new PhoneBookContext(Server.MapPath("~/Models/Data.json"));
phoneBookContext.Delete(Guid.Parse(id));
ViewBag.PhoneBooks = phoneBookContext.PhoneBooks;
return(View("Index"));
}
public Fixture()
{
var services = new ServiceCollection();
// Initilized in memory database
services
.AddDbContext <PhoneBookContext>(options => options.UseInMemoryDatabase(Guid.NewGuid().ToString()));
// configurations of IMapper that map data transfer objects to domain models
var mapper = new MapperConfiguration(cfg => {
cfg.CreateMissingTypeMaps = true;
}).CreateMapper();
services.AddScoped(x => mapper);
// register repositories
services.AddScoped <ICompanyRepository, CompanyRepository>();
services.AddScoped <IPersonRepository, PersonRepository>();
// register services
services.AddTransient <ICompanyService, CompanyService>();
services.AddTransient <IPersonService, PersonService>();
services.AddTransient <ICompanyPersonAggrigateService, CompanyPersonAggrigateService>();
// string parsers
services.RegisterStringParseFactory("PhoneBook.Infrastructure");
services.AddTransient <IParser, CsvParser>();
// IOC container
ServiceProvider = services.BuildServiceProvider();
Context = ServiceProvider.GetService <PhoneBookContext>();
}
public ActionResult UpdateSave(string id, string surname, string telephone)
{
phoneBookContext = new PhoneBookContext(Server.MapPath("~/Models/Data.json"));
phoneBookContext.Update(Guid.Parse(id), surname, telephone);
ViewBag.PhoneBooks = phoneBookContext.PhoneBooks;
return(View("Index"));
}
public ActionResult Update(string idSelectedItem)
{
ViewBag.Id = idSelectedItem;
phoneBookContext = new PhoneBookContext(Server.MapPath("~/Models/Data.json"));
ViewBag.PhoneBooks = phoneBookContext.PhoneBooks;
return(View());
}
public ActionResult AddSave(string surname, string telephone)
{
phoneBookContext = new PhoneBookContext(Server.MapPath("~/Models/Data.json"));
phoneBookContext.Add(surname, telephone);
ViewBag.PhoneBooks = phoneBookContext.PhoneBooks;
return(View("Index"));
}
private Contact FindById(long id)
{
using (PhoneBookContext db = new PhoneBookContext())
{
return(db.Contacts.Find(id));
}
}
public ResponseModel <PhoneBookOutputModel> GetById(int id)
{
try
{
using (var ctx = new PhoneBookContext())
{
var phoneBookModel = ctx.PhoneBooks.Include(c => c.Entries).FirstOrDefault(x => x.PhoneBookId == id);
if (phoneBookModel == null)
{
return(new ResponseModel <PhoneBookOutputModel> {
ResponseMessage = Constants.UnexpectedError, IsSuccessful = false
});
}
return(new ResponseModel <PhoneBookOutputModel> {
DataSet = _mapper.Map <Core.PhoneBook, PhoneBookOutputModel>(phoneBookModel)
});
}
}
catch (Exception ex)
{
return(new ResponseModel <PhoneBookOutputModel> {
ResponseMessage = Constants.UnexpectedError, IsSuccessful = false
});
}
}
public ActionResult Update(string idSelectedItem)
{
ViewBag.Id = idSelectedItem;
phoneBookContext = new PhoneBookContext();
ViewBag.PhoneBooks = phoneBookContext.PhoneBooks;
return(View());
}
public ContactDTO GetContactWithFeilds(int id)
{
try
{
using (var dbContext = new PhoneBookContext())
{
var contact = dbContext.Contact.FirstOrDefault(f => f.Id == id);
var contactfeilds = dbContext.ContactField.Where(w => w.ContactId == id);
if (contact != null)
{
return(new ContactDTO
{
Id = id,
Name = contact.Name,
ContactFields = contactfeilds.Select(s => new ContactFieldDTO
{
Id = s.Id,
ContactId = id,
Field = s.Field,
Value = s.Value
}).ToList()
});
}
else
{
return(new ContactDTO());
}
}
}
catch (Exception ex)
{
return(new ContactDTO());
}
}
public List <Person> GetAll()
{
using (PhoneBookContext context = new PhoneBookContext())
{
return(context.People.ToList());
}
}
public bool EditContact(ContactDTO model)
{
try
{
using (var dbContext = new PhoneBookContext())
{
var contact = new Contact();
contact.Id = model.Id;
contact.Name = model.Name;
foreach (var field in model.ContactFields)
{
var cf = new ContactField();
cf.Id = field.Id;
cf.Field = field.Field;
cf.Value = field.Value;
cf.ContactId = field.ContactId;
dbContext.ContactField.AddOrUpdate(cf);
}
dbContext.Contact.AddOrUpdate(contact);
dbContext.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
private List <Contact> ReadPhoneBook()
{
using (PhoneBookContext db = new PhoneBookContext())
{
List <Contact> contacts = db.Contacts.ToList();
return(contacts.OrderBy(c => c.Name).ToList());
}
}
public void DeleteUser()
{
PhoneBookContext _phoneBookContext = new PhoneBookContext();
UserController userController = new UserController(_phoneBookContext);
var result = userController.DeleteUser(5);
Assert.IsNotNull(result);
}
public void GetUserList()
{
PhoneBookContext _phoneBookContext = new PhoneBookContext();
UserController userController = new UserController(_phoneBookContext);
var result = userController.GetUserList();
Assert.IsTrue(result.Count > 0);
Assert.IsNotNull(result);
}
} // Unit of work
public TestBase(Fixture fixture)
{
Services = fixture.ServiceProvider;
Context = Services.GetService <PhoneBookContext>();
if (Context.Database.EnsureCreated())
{
Context.SeedSampleData();
}
}
public void Add(Person person)
{
using (PhoneBookContext context = new PhoneBookContext())
{
var addedObject = context.Entry(person);
addedObject.State = EntityState.Added;
context.SaveChanges();
}
}
public void GetUserDetail()
{
PhoneBookContext _phoneBookContext = new PhoneBookContext();
UserController userController = new UserController(_phoneBookContext);
var result = userController.GetUserDetail(3);
Assert.IsNotNull(result);
}
public void Delete(Person person)
{
using (PhoneBookContext context = new PhoneBookContext())
{
var deletedObject = context.Entry(person);
deletedObject.State = EntityState.Deleted;
context.SaveChanges();
}
}
public User GetById(int id)
{
using (var context = new PhoneBookContext())
{
user = context.Users.Where(x => x.Id == id).FirstOrDefault();
};
return(user);
}
public User GetByUserNameAndPassword(string userName, string password)
{
using (var context = new PhoneBookContext())
{
user = context.Users.Where(x => x.UserName == userName && x.Password == password).FirstOrDefault();
};
return(user);
}
public void GetListTest()
{
PhoneBookContext _phonecontext = new PhoneBookContext();
ProducerConfig _config = new ProducerConfig();
ValuesController valuesController = new ValuesController(_config, _phonecontext);
var result = valuesController.GetList();
Assert.IsTrue(result.Count > 0);
}
public void Update(Person person)
{
using (PhoneBookContext context = new PhoneBookContext())
{
var updatedObject = context.Entry(person);
updatedObject.State = EntityState.Modified;
context.SaveChanges();
}
}
