public Int32 PostTrnSoldUnitRequirementActivity(TrnSoldUnitRequirementActivity soldUnitRequirementActivity) { try { var currentUser = from d in db.MstUsers where d.AspNetId == User.Identity.GetUserId() select d; if (currentUser.Any()) { Data.TrnSoldUnitRequirementActivity newTrnSoldUnitRequirementActivity = new Data.TrnSoldUnitRequirementActivity() { SoldUnitRequirementId = soldUnitRequirementActivity.SoldUnitRequirementId, ActivityDate = DateTime.Now, Activity = soldUnitRequirementActivity.Activity, Remarks = soldUnitRequirementActivity.Remarks, UserId = currentUser.FirstOrDefault().Id }; db.TrnSoldUnitRequirementActivities.InsertOnSubmit(newTrnSoldUnitRequirementActivity); db.SubmitChanges(); return(newTrnSoldUnitRequirementActivity.Id); } else { return(0); } } catch (Exception e) { Debug.WriteLine(e); return(0); } }
public HttpResponseMessage Update(TrnSoldUnitRequirementActivity soldUnitRequirementActivity) { try { var TrnSoldUnitRequirementActivityData = from d in db.TrnSoldUnitRequirementActivities where d.Id == Convert.ToInt32(soldUnitRequirementActivity.Id) select d; if (TrnSoldUnitRequirementActivityData.Any()) { var currentUser = from d in db.MstUsers where d.AspNetId == User.Identity.GetUserId() select d; if (currentUser.Any()) { var UpdateTrnSoldUnitRequirementActivityData = TrnSoldUnitRequirementActivityData.FirstOrDefault(); UpdateTrnSoldUnitRequirementActivityData.ActivityDate = DateTime.Now; UpdateTrnSoldUnitRequirementActivityData.Activity = soldUnitRequirementActivity.Activity; UpdateTrnSoldUnitRequirementActivityData.Remarks = soldUnitRequirementActivity.Remarks; UpdateTrnSoldUnitRequirementActivityData.UserId = currentUser.FirstOrDefault().Id; db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } else { return(Request.CreateResponse(HttpStatusCode.OK)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }