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);
            }
        }