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