public string InsertTeacherNote(TeacherNote Info) { string Result = string.Empty; try { using (SqlConnection con = new SqlConnection(conn)) { SqlCommand com = new SqlCommand("[teacher].[SP_InsertTeacherNote]", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@TeacherID_FK", Info.TeacherID_FK); com.Parameters.AddWithValue("@Note", Info.Note); con.Open(); int LastRow = Convert.ToInt32(com.ExecuteScalar()); if (LastRow > 0) { Result = "Success!" + LastRow;; } else { Result = "Failed! "; } con.Close(); } } catch (Exception ex) { WriteLogFile.WriteErrorLog("Error.txt", ex.Message); } return(Result); }
public List <TeacherNote> GetTeacherNotes(long TeacherID_FK) { List <TeacherNote> Result = new List <TeacherNote>(); try { using (SqlConnection con = new SqlConnection(conn)) { SqlCommand com = new SqlCommand("[teacher].[SP_GetTeacherNotes]", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@TeacherID", TeacherID_FK); con.Open(); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { TeacherNote temp = new TeacherNote(); temp.ID = Convert.ToInt32(reader["ID"]); temp.Note = Convert.ToString(reader["Note"]); temp.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]); Result.Add(temp); } con.Close(); } } catch (Exception ex) { WriteLogFile.WriteErrorLog("Error.txt", ex.Message); } return(Result); }
public JsonResult InsertTeacherNote(TeacherNote Info) { ResultInfo <string> ResultInfo = new ResultInfo <string>() { Status = false, Description = "Failed|Login" }; if (Info != null) { Hod PageObj = new Hod(); ResultInfo.Info = PageObj.InsertTeacherNote(Info); if (ResultInfo.Info.Split('!')[0] == "Success") { ResultInfo.Description = "Success| Inserted"; ResultInfo.Status = true; } } return(Json(ResultInfo, JsonRequestBehavior.AllowGet)); }