// Edit function
public gesture_management Edit(string data)
{
// Image Validation object creation
var gesturemanagement_obj = new gesture_management();
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 gesture where id ='" + id + "'", conn);
conn.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
gesturemanagement_obj.id = (int)rdr["id"];
gesturemanagement_obj.gesture_name = rdr["gesture_name"].ToString();
gesturemanagement_obj.thumbnail_url = rdr["thumbnail_url"].ToString();
gesturemanagement_obj.gesture_message = rdr["gesture_message"].ToString();
gesturemanagement_obj.isactive = (int)rdr["isactive"];
}
conn.Close();
}
// Returning object
return(gesturemanagement_obj);
}
catch (Exception e)
{
error = e.Message;
// Returning the result
return(gesturemanagement_obj);
}
}
// Select function
public List <gesture_management> List()
{
// Gesture Management Model Initialization
var gesturemanagement_list = new List <gesture_management>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
// Selecting all the rows in the gesture table
SqlCommand cmd = new SqlCommand("SELECT * FROM gesture", conn);
//connection open
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
// Creating Gesture management Object file
var gesturemanagement_obj = new gesture_management();
gesturemanagement_obj.id = (int)rdr["id"];
gesturemanagement_obj.gesture_name = rdr["gesture_name"].ToString();
gesturemanagement_obj.thumbnail_url = rdr["thumbnail_url"].ToString();
gesturemanagement_obj.gesture_message = rdr["gesture_message"].ToString();
gesturemanagement_obj.isactive = (int)rdr["isactive"];
// Adding the Object to model file
gesturemanagement_list.Add(gesturemanagement_obj);
}
//connection close
conn.Close();
}
// Returning the model file
return(gesturemanagement_list);
}
catch (Exception e)
{
error = e.Message;
return(gesturemanagement_list);
}
}
