public JsonResult SaveHotel(HotelVM model)
{
if (!ModelState.IsValid)
{
return(base.JSonModelStateHandle());
}
ServiceResultModel <HotelVM> serviceResult = _hotelService.SaveHotel(model);
if (!serviceResult.IsSuccess)
{
base.UIResponse = new UIResponse
{
Message = string.Format("Operation Is Not Completed, {0}", serviceResult.Message),
ResultType = serviceResult.ResultType,
Data = serviceResult.Data
};
}
else
{
base.UIResponse = new UIResponse
{
Data = serviceResult.Data,
ResultType = serviceResult.ResultType,
Message = "Success"
};
}
return(Json(base.UIResponse, JsonRequestBehavior.AllowGet));
}
public IActionResult Edit(long id)
{
Hotel hotel = this.db.Hoteis
.Include(m => m.Cidade)
.Where(x => x.Id == id)
.FirstOrDefault();
if (hotel == null)
{
return(NotFound());
}
HotelVM vm = new HotelVM();
vm.Nome = hotel.Nome;
vm.Descricao = hotel.Descricao;
vm.Preco = hotel.Preco;
var cidades = db.Cidades.ToList();
foreach (var cidade in cidades)
{
vm.Cidades.Add(new SelectListItem
{
Value = cidade.Id.ToString(),
Text = cidade.Nome
});
}
vm.IdCidadeSelecionada = hotel.Cidade.Id;
return(View(vm));
}
public async Task <HotelVM> GetHotelsAsync(int pageno, int pagesize, string sterm)
{
HotelVM model = new HotelVM();
var parStart = new SqlParameter("@Start", (pageno - 1) * pagesize);
var parEnd = new SqlParameter("@PageSize", pagesize);
var parSearchTerm = new SqlParameter("@SearchTerm", DBNull.Value);
if (!(sterm == null || sterm == ""))
{
parSearchTerm.Value = sterm;
}
// setting stored procedure OUTPUT value
// This return total number of rows, and avoid two database call for data and total number of rows
var spOutput = new SqlParameter
{
ParameterName = "@TotalCount",
SqlDbType = System.Data.SqlDbType.BigInt,
Direction = System.Data.ParameterDirection.Output
};
model.Hotels = await db.Database.SqlQuery <HotelView>("udspMstHotelPaged @Start, @PageSize,@SearchTerm, @TotalCount out",
parStart, parEnd, parSearchTerm, spOutput).ToListAsync();
model.TotalRecords = int.Parse(spOutput.Value.ToString());
return(model);
}
public JsonResult UpdateHotel(HotelVM model)
{
if (model.Id <= 0)
{
RedirectToAction(nameof(HotelList)); // ErrorHandle eklenecek
}
if (!ModelState.IsValid)
{
return(base.JSonModelStateHandle());
}
ServiceResultModel <HotelVM> serviceResult = _hotelService.UpdateHotel(model);
if (!serviceResult.IsSuccess)
{
base.UIResponse = new UIResponse
{
Message = string.Format("Operation Is Not Completed, {0}", serviceResult.Message),
ResultType = serviceResult.ResultType,
Data = serviceResult.Data
};
}
else
{
base.UIResponse = new UIResponse
{
Data = serviceResult.Data,
ResultType = serviceResult.ResultType,
Message = "Success"
};
}
return(Json(base.UIResponse, JsonRequestBehavior.AllowGet));
}
public ServiceResultModel <HotelVM> UpdateHotel(HotelVM model)
{
using (EFBookingContext context = new EFBookingContext())
{
var currentItem = context.Hotels.FirstOrDefault(p => p.Id == model.Id);
if (currentItem != null)
{
if (context.Hotels.Any(p => p.Id != model.Id && p.Title.Equals(model.Title)))
{
return(new ServiceResultModel <HotelVM>
{
Code = ServiceResultCode.Duplicate,
Data = currentItem.MapProperties <HotelVM>(),
ResultType = OperationResultType.Warn,
Message = "This title using other records "
});
}
currentItem.Title = model.Title;
currentItem.HotelTypeId = model.HotelTypeId;
context.Entry <Hotel>(currentItem).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
return(ServiceResultModel <HotelVM> .OK(currentItem.MapProperties <HotelVM>()));
}
}
public IActionResult Create(HotelVM vm)
{
if (ModelState.IsValid)
{
Hotel hotel = new Hotel();
hotel.Nome = vm.Nome;
hotel.Descricao = vm.Descricao;
hotel.Preco = vm.Preco;
hotel.CaminhoImagem = this.UploadImagem(vm.Imagem);
hotel.Cidade = db.Cidades.Find(vm.IdCidadeSelecionada);
hotel.Suite = db.Suites.Find(vm.IdSuiteSelecionada);
hotel.Gastronomia = db.Gastronomias.Find(vm.IdGastronomiaSelecionada);
this.db.Hoteis.Add(hotel);
this.db.SaveChanges();
return(RedirectToAction("Index"));
}
var cidades = db.Cidades.ToList();
foreach (var cidade in cidades)
{
vm.Cidades.Add(new SelectListItem
{
Value = cidade.Id.ToString(),
Text = cidade.Nome
});
}
var suites = db.Suites.ToList();
foreach (var suite in suites)
{
vm.Suites.Add(new SelectListItem
{
Value = suite.Id.ToString(),
Text = suite.Tipo
});
}
var gastronomias = db.Gastronomias.ToList();
foreach (var gastronomia in gastronomias)
{
vm.Gastronomias.Add(new SelectListItem
{
Value = gastronomia.Id.ToString(),
Text = gastronomia.Nome
});
}
return(View(vm));
}
public async Task <ActionResult <HotelVM> > GetHotel(int id)
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString =
"Server=localhost;Database=PaymentDetailDB;Trusted_Connection=True;MultipleActiveResultSets=True;";
connection.Open();
string procedureName = "[dbo].[GetHotels]";
var result = new List <HotelVM>();
using (SqlCommand command = new SqlCommand(procedureName, connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@HotelId", id));
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
int HotelId = int.Parse(reader[0].ToString());
string HotelName = reader[1].ToString();
int CityId = int.Parse(reader[2]?.ToString());
string? Address = reader[3].ToString();
string? Description = reader[4].ToString();
string CityName = reader[5]?.ToString();
int CountryId = int.Parse(reader[6]?.ToString());
string CountryName = reader[7]?.ToString();
HotelVM tmpRecord = new HotelVM()
{
HotelId = HotelId,
HotelName = HotelName,
CityId = CityId,
Adddress = Address,
Description = Description,
CityName = CityName,
CountryID = CountryId,
CountryName = CountryName
};
result.Add(tmpRecord);
}
}
}
if (result == null)
{
return(NotFound());
}
return(result.FirstOrDefault());
}
public ServiceResultModel <HotelVM> GetHotel(int id)
{
if (id <= 0)
{
return(null);
}
HotelVM currentItem = null;
using (EFBookingContext context = new EFBookingContext())
{
currentItem = context.Hotels.FirstOrDefault(p => p.Id == id).MapProperties <HotelVM>();
}
return(ServiceResultModel <HotelVM> .OK(currentItem));
}
public IActionResult Edit(long id, HotelVM vm)
{
if (ModelState.IsValid)
{
Hotel hotelDb = this.db.Hoteis.Find(id);
hotelDb.Nome = vm.Nome;
hotelDb.Descricao = vm.Descricao;
hotelDb.Preco = vm.Preco;
hotelDb.CaminhoImagem = this.UploadImagem(vm.Imagem);
hotelDb.Cidade = db.Cidades.Find(vm.IdCidadeSelecionada);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vm));
}
public HttpResponseMessage Post([FromBody] HotelVM HotelObject)
{
try
{
HotelObject.CreatedDate = DateTime.Today;
HotelObject.UpdatedDate = DateTime.Today;
int id = _hotelBL.PostHotel(HotelObject);
var message = Request.CreateResponse(HttpStatusCode.Created, HotelObject);
message.Headers.Location = new Uri(Request.RequestUri + id.ToString());
return(message);
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public int PostHotel(HotelVM HotelObject)
{
using (var context = new DbWebAPIEntities())
{
//Create Mapper configuration
var config = new MapperConfiguration(cfg => {
cfg.CreateMap <HotelVM, tblHotel>();
});
//Map the objects
var mapper = new Mapper(config);
tblHotel record = mapper.Map <HotelVM, tblHotel>(HotelObject);
context.tblHotels.Add(record);
context.SaveChanges();
return(record.HotelId);
}
}
public IActionResult Create()
{
HotelVM vm = new HotelVM();
var cidades = db.Cidades.ToList();
foreach (var cidade in cidades)
{
vm.Cidades.Add(new SelectListItem
{
Value = cidade.Id.ToString(),
Text = cidade.Nome
});
}
var suites = db.Suites.ToList();
foreach (var suite in suites)
{
vm.Suites.Add(new SelectListItem
{
Value = suite.Id.ToString(),
Text = suite.Tipo
});
}
var gastronomias = db.Gastronomias.ToList();
foreach (var gastronomia in gastronomias)
{
vm.Gastronomias.Add(new SelectListItem
{
Value = gastronomia.Id.ToString(),
Text = gastronomia.Nome
});
}
return(View(vm));
}
public ActionResult Index(int PageNo = 1, int PageSize = 10, string SearchTerm = "")
{
try
{
string query = "PageNo=" + PageNo + "&PageSize=" + PageSize + "&SearchTerm=" + SearchTerm;
HotelAPIVM apiModel = objAPI.GetRecordByQueryString <HotelAPIVM>("hotelconfig", "hotels", query);
HotelVM model = new HotelVM();
model.Hotels = apiModel.Hotels;
model.PagingInfo = new PagingInfo {
CurrentPage = PageNo, ItemsPerPage = PageSize, TotalItems = apiModel.TotalRecords
};
if (Request.IsAjaxRequest())
{
return(PartialView("_pvHotelList", model));
}
return(View(model));
}
catch (AuthorizationException)
{
TempData["ErrMsg"] = "Your Login Session has expired. Please Login Again";
return(RedirectToAction("Login", "Account", new { Area = "" }));
}
}
public ServiceResultModel <HotelVM> SaveHotel(HotelVM model)
{
using (EFBookingContext context = new EFBookingContext())
{
bool isAlreadyExists = context.Hotels.Any(p => p.Title == model.Title);
if (isAlreadyExists)
{
return new ServiceResultModel <HotelVM>
{
Code = ServiceResultCode.Duplicate,
Data = null,
ResultType = OperationResultType.Warn,
Message = "This record already exists"
}
}
;
var recordItem = context.Hotels.Add(model.MapProperties <Hotel>());
context.SaveChanges();
return(ServiceResultModel <HotelVM> .OK(recordItem.MapProperties <HotelVM>()));
}
}
public HotelHandler(HotelVM hotelVm)
{
_hotelVm = hotelVm;
_consumer = _hotelVm.ConsumerHotel;
}
public int PostHotel(HotelVM HotelObject)
{
int id = HotelDAL.PostHotel(HotelObject);
return(id);
}