public HttpResponseMessage UpdateApartmentDetail(int id, [FromBody] ApartmentDetail apartmentDetail)
{
try
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
var result = entities.ApartmentDetails.FirstOrDefault(x => x.ApartmentId == id);
if (result != null)
{
result.ApartmentId = apartmentDetail.ApartmentId;
result.ApartmentName = apartmentDetail.ApartmentName;
result.NoOfFloors = apartmentDetail.NoOfFloors;
result.Address1 = apartmentDetail.Address1;
result.Address2 = apartmentDetail.Address2;
result.City = apartmentDetail.City;
result.State = apartmentDetail.State;
result.PinCode = apartmentDetail.PinCode;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Item Updated!"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occured"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occured"));
}
}
public HttpResponseMessage UpdateCityName(string name, [FromBody] CityMaster cityMaster)
{
try
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
var result = entities.CityMasters.FirstOrDefault(x => x.CityName == name);
if (result != null)
{
result.CityName = cityMaster.CityName;
result.CityState = cityMaster.CityState;
result.CityId = cityMaster.CityId;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Updated the city " + name + "to " + cityMaster.CityName));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No city found with name : " + name));
}
}
}catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occured!"));
}
}
public HttpResponseMessage SaveNewApartmentDetail([FromBody] ApartmentDetail apartmentDetail)
{
try
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
entities.ApartmentDetails.Add(apartmentDetail);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, "Item Created"));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Bad Request"));
}
}
public HttpResponseMessage GetApartments()
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
var result = entities.ApartmentDetails.ToList();
var test = entities.getApartmentDetails().ToList();
if (result == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No Data Found"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
}
}
public HttpResponseMessage GetCityById(int id)
{
try
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
var result = entities.CityMasters.FirstOrDefault(x => x.CityId == id);
if (result != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No city found for id: " + id));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occured!"));
}
}
public HttpResponseMessage GetCityByCityName(string name)
{
try
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
var result = entities.CityMasters.FirstOrDefault(x => x.CityName == name);
if (result != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "City " + name + "not found in database"));;
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occured!"));
}
}
public HttpResponseMessage GetCityByState(string name)
{
try
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
var result = entities.CityMasters.Where(t => t.CityState == name);
if (result != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No city found for state: " + name));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occured!"));
}
}
public HttpResponseMessage GetCities()
{
try
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
var result = entities.CityMasters.ToList();
if (result != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NoContent, "No Result Found"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occured!"));
}
}
public HttpResponseMessage GetApartmentById(int id)
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
try
{
var result = entities.ApartmentDetails.FirstOrDefault(x => x.ApartmentId == id);
if (result == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Result found for the same Id"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occered"));
}
}
}
public HttpResponseMessage DeleteApartmentDetail(int id)
{
try
{
using (ApartmentsEntities entities = new ApartmentsEntities())
{
var result = entities.ApartmentDetails.FirstOrDefault(x => x.ApartmentId == id);
if (result != null)
{
entities.ApartmentDetails.Remove(result);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "Item Removed Successfully!"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NoContent, "Item not found!"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error Occured!"));
}
}
