// Select function by ID public image_validation AdminListById(string data) { // Image Validation object creation var imagevalidation_obj = new image_validation(); try { // Initialization SqlConnection conn; SqlDataReader rdr; SqlCommand cmd; var id = Convert.ToInt32(data); using (conn = new SqlConnection(connectionString)) { // Selecting all the rows in the image validation cmd = new SqlCommand("SELECT * FROM imagevalidation where id ='" + id + "'", conn); conn.Open(); rdr = cmd.ExecuteReader(); while (rdr.Read()) { imagevalidation_obj.id = (int)rdr["id"]; imagevalidation_obj.validation_type = rdr["validation_type"].ToString(); imagevalidation_obj.validation_message = rdr["validation_message"].ToString(); imagevalidation_obj.isactive = (int)rdr["isactive"]; } conn.Close(); } // Returning object return(imagevalidation_obj); } catch (Exception e) { error = e.Message; return(imagevalidation_obj); } }
// Select function public List <image_validation> AdminList() { // Image Validation List creation var imagevalidation_list = new List <image_validation>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { // Selecting all rows in image validation table SqlCommand cmd = new SqlCommand("SELECT * FROM imagevalidation", conn); //Connection Open conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { //Creating Image Validation Object var imagevalidation_obj = new image_validation(); imagevalidation_obj.id = (int)rdr["id"]; imagevalidation_obj.validation_type = rdr["validation_type"].ToString(); imagevalidation_obj.validation_message = rdr["validation_message"].ToString(); imagevalidation_obj.isactive = (int)rdr["isactive"]; // Adding object file to Model file imagevalidation_list.Add(imagevalidation_obj); } //Connection Close conn.Close(); } // returning the List return(imagevalidation_list); } catch (Exception e) { error = e.Message; return(imagevalidation_list); } }