public JsonResult AddDiscussionMsg(DAL.Job.Discussion OBJ)
{
if (!String.IsNullOrEmpty(System.Web.HttpContext.Current.User.Identity.Name))
{
OBJ.UserName = System.Web.HttpContext.Current.User.Identity.Name.ToString();
}
else
{
OBJ.UserName = "******";
}
var status = DAL.Job.InsertDiscussionMsg(OBJ);
return(Json(status, JsonRequestBehavior.AllowGet));
}
public static Boolean InsertDiscussionMsg(DAL.Job.Discussion OBJ)
{
String connstring = Connection.GetConnectionString();
var status = false;
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_INSERTDISSCUSSIONTEXT, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.AddWithValue("@JobNumber", OBJ.JobNo);
dbCom.Parameters.AddWithValue("@USERNAME", OBJ.UserName);
dbCom.Parameters.AddWithValue("@MESSAGES", OBJ.Messages);
status = Convert.ToBoolean(dbCom.ExecuteNonQuery());
}
}
return(status);
}
