public HttpResponseMessage SaveMstHouseModel(MstHouseModel housemodel) { try { var MstHouseModelData = from d in db.MstHouseModels where d.Id == Convert.ToInt32(housemodel.Id) select d; if (MstHouseModelData.Any()) { var currentUser = from d in db.MstUsers where d.AspNetId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var UpdateMstHouseModelData = MstHouseModelData.FirstOrDefault(); UpdateMstHouseModelData.HouseModelCode = housemodel.HouseModelCode; UpdateMstHouseModelData.HouseModel = housemodel.HouseModel; UpdateMstHouseModelData.TFA = housemodel.TFA; UpdateMstHouseModelData.Price = housemodel.Price; UpdateMstHouseModelData.UpdatedBy = currentUser.FirstOrDefault().Id; UpdateMstHouseModelData.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public int PostMstHouseModel(MstHouseModel housemodel) { try { var currentUser = from d in db.MstUsers where d.AspNetId == User.Identity.GetUserId() select d; if (currentUser.Any()) { Data.MstHouseModel newMstHouseModel = new Data.MstHouseModel() { HouseModelCode = housemodel.HouseModelCode, HouseModel = housemodel.HouseModel, ProjectId = housemodel.ProjectId, TFA = housemodel.TFA, Price = housemodel.Price, IsLocked = true, CreatedBy = currentUser.FirstOrDefault().Id, CreatedDateTime = DateTime.Now, UpdatedBy = currentUser.FirstOrDefault().Id, UpdatedDateTime = DateTime.Now }; db.MstHouseModels.InsertOnSubmit(newMstHouseModel); db.SubmitChanges(); return(newMstHouseModel.Id); } else { return(0); } } catch (Exception e) { Debug.WriteLine(e); return(0); } }