public int UpdateForumEntries(JobForum UpdateForumEntryRequest) { try { //using (var dataContext = new WorkersInMotionDB()) //{ // var qry = from p in dataContext.JobForums where p.JobGUID == UpdateForumEntryRequest.JobGUID select p; // var item = qry.Single(); // item.ForumStatus = UpdateForumEntryRequest.ForumStatus; // item.UserGUID = UpdateForumEntryRequest.UserGUID; // item.ForumText = UpdateForumEntryRequest.ForumText; // item.LastModifiedDate = DateTime.UtcNow; // item.LastModifiedBy = UpdateForumEntryRequest.LastModifiedBy; // return dataContext.SaveChanges(); //} if (UpdateForumEntryRequest.JobGUID != null) { JobForum forum = GetJobForumbyJobGUID(new Guid(UpdateForumEntryRequest.JobGUID.ToString())); forum.ForumStatus = UpdateForumEntryRequest.ForumStatus; forum.UserGUID = UpdateForumEntryRequest.UserGUID; forum.ForumText = UpdateForumEntryRequest.ForumText; forum.LastModifiedDate = DateTime.UtcNow; forum.LastModifiedBy = UpdateForumEntryRequest.LastModifiedBy; SqlParameter[] Param = new SqlParameter[5]; Param[0] = new SqlParameter("@pJobForumGUID", SqlDbType.UniqueIdentifier); Param[0].Value = forum.JobForumGUID; Param[1] = new SqlParameter("@pUserGUID", SqlDbType.UniqueIdentifier); Param[1].Value = (object)forum.UserGUID ?? DBNull.Value; Param[2] = new SqlParameter("@pForumText", SqlDbType.NVarChar, -1); Param[2].Value = (object)forum.ForumText ?? DBNull.Value; Param[3] = new SqlParameter("@pLastModifiedDate", SqlDbType.DateTime); Param[3].Value = (object)forum.LastModifiedDate ?? DBNull.Value; Param[4] = new SqlParameter("@pLastModifiedBy", SqlDbType.UniqueIdentifier); Param[4].Value = (object)forum.LastModifiedBy ?? DBNull.Value; return context.Database.ExecuteSqlCommand("update JobForums set UserGUID=@pUserGUID,ForumText=@pForumText,LastModifiedDate=@pLastModifiedDate,LastModifiedBy=@pLastModifiedBy" + " where JobForumGUID=@pJobForumGUID", Param); } else return 0; } catch (Exception exception) { return 0; } }
public int InsertForumEntries(JobForum lJobForum) { //context.JobForums.Add(lJobForum); SqlParameter[] Param = new SqlParameter[12]; Param[0] = new SqlParameter("@pJobForumGUID", SqlDbType.UniqueIdentifier); Param[0].Value = lJobForum.JobForumGUID; Param[1] = new SqlParameter("@pJobOfferGUID", SqlDbType.UniqueIdentifier); Param[1].Value = (object)lJobForum.JobOfferGUID ?? DBNull.Value; Param[2] = new SqlParameter("@pJobGUID", SqlDbType.UniqueIdentifier); Param[2].Value = (object)lJobForum.JobGUID ?? DBNull.Value; Param[3] = new SqlParameter("@pUserGUID", SqlDbType.UniqueIdentifier); Param[3].Value = (object)lJobForum.UserGUID ?? DBNull.Value; Param[4] = new SqlParameter("@pParentJobForumGUID", SqlDbType.UniqueIdentifier); Param[4].Value = (object)lJobForum.ParentJobForumGUID ?? DBNull.Value; Param[5] = new SqlParameter("@pForumText", SqlDbType.NVarChar, -1); Param[5].Value = (object)lJobForum.ForumText ?? DBNull.Value; Param[6] = new SqlParameter("@pIsRead", SqlDbType.Bit); Param[6].Value = (object)lJobForum.IsRead ?? DBNull.Value; Param[7] = new SqlParameter("@pForumStatus", SqlDbType.SmallInt); Param[7].Value = (object)lJobForum.ForumStatus ?? DBNull.Value; Param[8] = new SqlParameter("@pStartTimePreference", SqlDbType.DateTime); Param[8].Value = (object)lJobForum.StartTimePreference ?? DBNull.Value; Param[9] = new SqlParameter("@pCounterCostOffer", SqlDbType.Float); Param[9].Value = (object)lJobForum.CounterCostOffer ?? DBNull.Value; Param[10] = new SqlParameter("@pLastModifiedDate", SqlDbType.DateTime); Param[10].Value = (object)lJobForum.LastModifiedDate ?? DBNull.Value; Param[11] = new SqlParameter("@pLastModifiedBy", SqlDbType.UniqueIdentifier); Param[11].Value = (object)lJobForum.LastModifiedBy ?? DBNull.Value; return context.Database.ExecuteSqlCommand("insert into JobForums(JobForumGUID,JobOfferGUID,JobGUID,UserGUID,ParentJobForumGUID,ForumText," + "IsRead,ForumStatus,StartTimePreference,CounterCostOffer,LastModifiedDate,LastModifiedBy)values(@pJobForumGUID,@pJobOfferGUID,@pJobGUID,@pUserGUID,@pParentJobForumGUID,@pForumText," + "@pIsRead,@pForumStatus,@pStartTimePreference,@pCounterCostOffer,@pLastModifiedDate,@pLastModifiedBy)", Param); }
public int UpdateForumStatus(JobForum JobForumRequest) { try { //using (var dataContext = new WorkersInMotionDB()) //{ // var qry = from p in dataContext.JobForums where p.JobGUID == JobForumRequest.JobGUID select p; // var item = qry.FirstOrDefault(); // item.ForumStatus = JobForumRequest.ForumStatus; // item.LastModifiedDate = DateTime.UtcNow; // item.LastModifiedBy = JobForumRequest.LastModifiedBy; // return dataContext.SaveChanges(); //} if (JobForumRequest.JobGUID != null) { JobForum forum = GetJobForumbyJobGUID(new Guid(JobForumRequest.JobGUID.ToString())); forum.ForumStatus = JobForumRequest.ForumStatus; forum.LastModifiedDate = DateTime.UtcNow; forum.LastModifiedBy = JobForumRequest.LastModifiedBy; SqlParameter[] Param = new SqlParameter[4]; Param[0] = new SqlParameter("@pForumStatus", SqlDbType.SmallInt); Param[0].Value = forum.ForumStatus; Param[1] = new SqlParameter("@pLastModifiedDate", SqlDbType.DateTime); Param[1].Value = forum.LastModifiedDate; Param[2] = new SqlParameter("@pLastModifiedBy", SqlDbType.UniqueIdentifier); Param[2].Value = forum.LastModifiedBy; Param[3] = new SqlParameter("@pJobForumGUID", SqlDbType.UniqueIdentifier); Param[3].Value = forum.JobForumGUID; return context.Database.ExecuteSqlCommand("update JobForums set ForumStatus=@pForumStatus,LastModifiedDate=@pLastModifiedDate," + "LastModifiedBy=@pLastModifiedBy where JobForumGUID=@pJobForumGUID", Param); } else return 0; } catch (Exception exception) { throw exception; //return 0; } }