public string InsertCollegeDayComment(NextCollegeDayComment Info)
{
string Result = string.Empty;
try
{
using (SqlConnection con = new SqlConnection(conn))
{
SqlCommand com = new SqlCommand("SP_InsertNextCollegeComment", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Comment", Info.Comment);
com.Parameters.AddWithValue("@StudentID", Info.StudentID);
com.Parameters.AddWithValue("@TeacherID", Info.TeacherID);
com.Parameters.AddWithValue("@EventID", Info.EventID);
com.Parameters.Add("@Commentid", SqlDbType.BigInt).Direction = ParameterDirection.Output;
con.Open();
if (com.ExecuteNonQuery() > 0)
{
Result = "Success!" + com.Parameters["@Commentid"].Value.ToString();
}
else
{
Result = "Failed! ";
}
con.Close();
}
}
catch (Exception ex)
{
}
return(Result);
}
public JsonResult InsertCollegeDayComment(NextCollegeDayComment Info)
{
ResultInfo <string> ResultInfo = new ResultInfo <string>()
{
Status = false,
Description = "Failed|Login"
};
try
{
if (Info != null)
{
Global PageObj = new Global();
ResultInfo.Info = PageObj.InsertCollegeDayComment(Info);
if (ResultInfo.Info != null)
{
ResultInfo.Description = "Success| Insert Topic";
ResultInfo.Status = true;
}
}
}
catch (Exception ex)
{
ResultInfo.Description = ex.Message;
}
return(Json(ResultInfo, JsonRequestBehavior.AllowGet));
}
public List <NextCollegeDayComment> GetCollegeComments(long id)
{
List <NextCollegeDayComment> Result = new List <NextCollegeDayComment>();
try
{
using (SqlConnection con = new SqlConnection(conn))
{
SqlCommand com = new SqlCommand("SP_GetAllNextCollegeCommentByEventID", con);
com.Parameters.AddWithValue("@EventID", id);
com.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
NextCollegeDayComment temp = new NextCollegeDayComment();
temp.CommentID = Convert.ToInt16(reader["NxtCollege_Comments_ID"]);
temp.Comment = Convert.ToString(reader["NxtCollege_Comments_Text"]);
temp.CreatedDate = Convert.ToDateTime(reader["NxtCollege_Comments_InsertedDate"]);
temp.StudentName = Convert.ToString(reader["Student_Name"]);
temp.TeacherName = Convert.ToString(reader["TeacherName"]);
temp.IsStudent = Convert.ToBoolean(reader["IsStudent"]);
Result.Add(temp);
}
con.Close();
}
}
catch (Exception ex)
{
WriteLogFile.WriteErrorLog("Error.txt", ex.Message);
}
return(Result);
}
