public ResultModel DeleteUser(long UserID)
{
ResultModel resultModel = new ResultModel();
using (var context = new RealStateEntities())
{
try
{
var Result = (from e in context.UserMasters where e.UserID == UserID select e).FirstOrDefault();
if (Result != null)
{
context.UserMasters.Attach(Result);
context.UserMasters.Remove(Result);
context.SaveChanges();
resultModel.Message = "Record Has been Deleted";
}
else
{
resultModel.Message = "Record Not Found";
}
}
catch (Exception ex)
{
resultModel.Message = ex.Message;
return(resultModel);
}
}
return(resultModel);
}
public HttpResponseMessage PostProperty()
{
var request = HttpContext.Current.Request;
try
{
Property aProperty = new Property()
{
OwnerId = Convert.ToInt32(request.Form["OwnerId"]),
PropertyName = request.Form["PropertyName"],
Area = Convert.ToInt32(request.Form["Area"]),
Address = request.Form["Address"],
Longitude = request.Form["Longitude"],
Latitude = request.Form["Latitude"],
SalePrice = Convert.ToInt32(request.Form["SalePrice"]),
SubPropertyType = Convert.ToInt32(request.Form["SubPropertyType"]),
BedRoom = Convert.ToInt32(request.Form["BedRoom"]),
WashRoom = Convert.ToInt32(request.Form["WashRoom"]),
Varanda = Convert.ToInt32(request.Form["Varanda"]),
DrawingRoom = Convert.ToBoolean(request.Form["DrawingRoom"]),
Parking = Convert.ToBoolean(request.Form["Parking"]),
FlatSize = Convert.ToInt32(request.Form["FlatSize"]),
BulidingYear = Convert.ToInt32(request.Form["BulidingYear"]),
FloorLevel = Convert.ToInt32(request.Form["FloorLevel"]),
Preference = request.Form["Preference"],
Purpose = Convert.ToInt32(request.Form["Purpose"]),
PublishDate = DateTime.Now,
Status = 1
};
var coverPhoto = request.Files["CoverPhoto"];
if (coverPhoto != null)
{
aProperty.CoverUrl = Common.SaveImage(coverPhoto);
}
var saveProperty = _aRealStateEntities.Properties.Add(aProperty);
_aRealStateEntities.SaveChanges();
_response = Request.CreateResponse(HttpStatusCode.OK, saveProperty);
}
catch (Exception e)
{
_response = Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
return(_response);
}
public HttpResponseMessage Post(Booking aBooking)
{
try
{
if (!ModelState.IsValid)
{
_response = Request.CreateResponse(HttpStatusCode.NotAcceptable);
}
aBooking.Time = DateTime.Now;
var a = _aRealStateEntities.Bookings.Add(aBooking);
var b = _aRealStateEntities.SaveChanges();
_response = Request.CreateResponse(HttpStatusCode.OK, a);
}
catch (Exception e)
{
_response = Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
return(_response);
}
public ResultModel Adduser(AccountModel Model)
{
ResultModel resultModel = new ResultModel();
using (var context = new RealStateEntities())
{
try
{
var result = context.UserMasters.Where(x => x.Email == Model.Email).FirstOrDefault();
if (result != null)
{
resultModel.Message = "This Email Id is Already Exist";
}
else
{
var query = context.UserMasters.Create();
query.CreatedBy = 1;
query.CreatedDate = DateTime.Now;
query.Email = Model.Email;
query.FirstName = Model.FirstName;
query.LastName = Model.LastName;
query.MobileNo = Model.MobileNo;
query.password = Model.password;
query.Role = Model.Role;
query.Status = true;
context.UserMasters.Add(query);
int i = context.SaveChanges();
if (i > 0)
{
resultModel.Message = "Your Record is succuessfully inserted";
}
else
{
resultModel.Message = "Your Record is not inserted";
}
}
}
catch (Exception ex)
{
resultModel.Message = ex.Message;
return(resultModel);
}
//return Ok(false);
}
return(resultModel);
}
public HttpResponseMessage UpdateStatus(int id, int statusId)
{
var request = HttpContext.Current.Request;
try
{
var aProperty = _aRealStateEntities.Properties.Find(id);
if (aProperty != null)
{
aProperty.Status = statusId;
_aRealStateEntities.Properties.AddOrUpdate(aProperty);
// var saveProperty = _aRealStateEntities.Properties.Add(aProperty);
_aRealStateEntities.SaveChanges();
_response = Request.CreateResponse(HttpStatusCode.OK);
}
}
catch (Exception e)
{
_response = Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
return(_response);
}
public HttpResponseMessage PostOwner(Owner owner)
{
try
{
if (!ModelState.IsValid)
{
_response = Request.CreateResponse(HttpStatusCode.NotAcceptable);
}
if (!string.IsNullOrEmpty(owner.Password))
{
owner.Password = Common.Encrypt(owner.Password);
}
var a = _aRealStateEntities.Owners.Add(owner);
var b = _aRealStateEntities.SaveChanges();
_response = Request.CreateResponse(HttpStatusCode.OK, a);
}
catch (Exception e)
{
_response = Request.CreateResponse(HttpStatusCode.BadRequest, e);
}
return(_response);
}
public ResultModel UpdateUser(AccountModel model)
{
ResultModel resultModel = new ResultModel();
using (var context = new RealStateEntities())
{
try
{
var result = (from e in context.UserMasters where e.UserID == model.UserID select e).FirstOrDefault();
if (result != null)
{
result.FirstName = model.FirstName;
result.LastName = model.LastName;
result.MobileNo = model.MobileNo;
result.ModifiedDate = DateTime.Now;
result.Email = model.Email;
result.Status = true;
result.Role = model.Role;
result.ModifiedBy = Convert.ToInt32(model.UserID);
int i = context.SaveChanges();
if (i > 0)
{
resultModel.Message = "Your Record has been succuessfully Updated";
}
else
{
resultModel.Message = "Your Record Not Updated";
}
}
}
catch (Exception ex)
{
resultModel.Message = ex.Message;
}
}
return(resultModel);
}
