public HttpResponseMessage contact_page()
{
HttpResponseMessage message = null;
UserCities userCities = new UserCities();
var error_message = string.Empty;
userCities = _usr.contact_home();
if (userCities == null)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, userCities);
message.Headers.Date = DateTime.Now;
}
else if (userCities != null)
{
message = Request.CreateResponse(HttpStatusCode.OK, userCities);
message.Headers.Date = DateTime.Now;
}
else
{
error_message = "error, internal server error could not be processed further";
message = Request.CreateResponse(HttpStatusCode.InternalServerError, error_message);
message.Headers.Date = DateTime.Now;
return(message);
}
return(message);
}
public async Task <int> AddUser(UserRequestDto user)
{
using (var context = new CitiesUsersContext())
{
User newUser = new User()
{
Name = user.Name,
Email = user.Email,
Phone = user.Phone
};
context.Users.Add(newUser);
await context.SaveChangesAsync();
if (user.CitiesIds != null)
{
foreach (var item in user.CitiesIds)
{
UserCities userCities = new UserCities()
{
CityId = item,
UserId = newUser.Id
};
context.UserCities.Add(userCities);
}
await context.SaveChangesAsync();
}
return(newUser.Id);
}
}
public ActionResult Index()
{
UserCities userCities = new UserCities();
using (var api = new HttpClient())
{
api.BaseAddress = new Uri("https://localhost:44343/api/user/");
api.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var get_user = api.GetAsync("contact/page");
get_user.Wait();
var result = get_user.Result;
if (result.StatusCode == HttpStatusCode.OK)
{
var s = result.Content.ReadAsAsync <UserCities>();
s.Wait();
userCities = s.Result;
}
else if (result.StatusCode == HttpStatusCode.NotFound)
{
var s = result.Content.ReadAsAsync <UserCities>();
s.Wait();
userCities = s.Result;
}
}
return(View(userCities));
}
public UserCities contact_home()
{
UserCities userCities = new UserCities();
using (_context = new BlueContext())
{
using (var _transaction = _context.Database.BeginTransaction(IsolationLevel.Serializable))
{
try
{
if (_context.Database.Connection.State == ConnectionState.Closed || _context.Database.Connection.State == ConnectionState.Broken)
{
_context.Database.Connection.Open();
}
var users = (from u in _context.User
select u).ToList <User>();
_context.SaveChanges();
var countries = (from c in _context.Country
select(c)).ToList <Country>();
_context.SaveChanges();
if (users.Count() != 0)
{
userCities.Users = users;
}
if (countries.Count() != 0)
{
userCities.Countries = countries;
}
}
catch (Exception e)
{
_transaction.Rollback();
throw new Exception(e.Message);
}
}
}
return(userCities);
}
