public HttpResponseMessage unlockCompany(String id, Models.MstCompany company) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); var companies = from d in db.MstCompanies where d.Id == Convert.ToInt32(id) select d; if (companies.Any()) { var updateCompany = companies.FirstOrDefault(); updateCompany.IsLocked = false; updateCompany.UpdatedById = userId; updateCompany.UpdatedDateTime = DateTime.Now; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 insertCompany(Models.MstCompany company) { try { var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault(); Data.MstCompany newCompany = new Data.MstCompany(); newCompany.Company = "NA"; newCompany.Address = "NA"; newCompany.ContactNumber = "NA"; newCompany.TaxNumber = "NA"; newCompany.IsLocked = false; newCompany.CreatedById = userId; newCompany.CreatedDateTime = DateTime.Now; newCompany.UpdatedById = userId; newCompany.UpdatedDateTime = DateTime.Now; db.MstCompanies.InsertOnSubmit(newCompany); db.SubmitChanges(); return(newCompany.Id); } catch { return(0); } }