// 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);
}
}
