public ReturnState RemoveComment(CourseCommentView model) { ReturnState result; courseCommentClient.RemoveComment(model, out result, out specify); return(result); }
public static List <CourseCommentView> GetCourseCommentListByCode(string code) { var ret = new List <CourseCommentView>(); using (var conn = new SqlConnection(connectionString)) { conn.Open(); var cmdText = string.Format("select Code, Email, cDate, Content, CmtFloor, Id from CourseCommentSets where Code = N'{0}' order by CmtFloor DESC", code); using (var cmd = new SqlCommand(cmdText, conn)) { var reader = cmd.ExecuteReader(); while (reader.Read()) { var comment = new CourseCommentView() { Code = Convert.ToString(reader.GetValue(0)), Email = Convert.ToString(reader.GetValue(1)), PubDate = Convert.ToDateTime(reader.GetValue(2)), Content = Convert.ToString(reader.GetValue(3)), Floor = Convert.ToInt32(reader.GetValue(4)), Id = Convert.ToInt32(reader.GetValue(5)) }; ret.Add(comment); } } } return(ret); }
public ReturnState AddComment(CourseCommentView model) { var filters = new UtilityService().GetFilterLisst(); model.Content = Utilities.Filter(model.Content, filters); return(CourseCommentOperator.AddCourseComment(model) ? ReturnState.ReturnOK : ReturnState.ReturnError); }
public static bool AddCourseComment(CourseCommentView model) { var result = false; using (var conn = new SqlConnection(connectionString)) { conn.Open(); var cmdText = string.Format("insert into CourseCommentSets values (N'{0}', N'{1}' , '{2}', N'{3}', {4})", model.Code, model.Email, DateTime.Now, model.Content, model.Floor); using (var cmd = new SqlCommand(cmdText, conn)) { result = cmd.ExecuteNonQuery() > 0; conn.Close(); } } return(result); }
public static bool RemoveCourseComment(CourseCommentView model) { var result = false; using (var conn = new SqlConnection(connectionString)) { conn.Open(); var cmdText = string.Format("delete from CourseCommentSets where Code = N'{0}' and Email = N'{1}' and cDate = '{2}'", model.Code, model.Email, model.PubDate); using (var cmd = new SqlCommand(cmdText, conn)) { result = cmd.ExecuteNonQuery() > 0; conn.Close(); } } return(result); }
public ReturnState RemoveComment(CourseCommentView model) { return(CourseCommentOperator.RemoveCourseComment(model) ? ReturnState.ReturnOK : ReturnState.ReturnError); }