private static imagetest readerDataimagetest(MySqlDataReader reader)
{
imagetest objimage = new imagetest();
objimage.itemname = Utility.IsValidString(reader["itemname"]);
objimage.itemimage = Utility.IsValidString(reader["itemimage"]);
return(objimage);
}
public static string SaveImage(imagetest objimage, MySqlConnection conn = null, MySqlTransaction trans = null)
{
string returnMessage = "";
bool isConnArgNull = (conn != null) ? false : true;
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
//MySqlConnection connection = new MySqlConnection("server=132.148.68.125;user id = testusr; password=Testusr123!@#; database=testdatabase");
tryOpenConnection(connection);
using (MySqlCommand command = new MySqlCommand())
{
string sql;
sql = @"INSERT INTO imagetest(
itemname,image) VALUES(@itemname,@itemimage)";
if (trans != null)
{
command.Transaction = trans;
}
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = sql;
command.Parameters.AddWithValue("@itemname", objimage.itemname);
command.Parameters.AddWithValue("@itemimage", objimage.itemimage);
int affectedRows = command.ExecuteNonQuery();
var lastInsertID = command.LastInsertedId;
if (affectedRows > 0)
{
returnMessage = "OK";
}
else
{
returnMessage = Shared.Constants.MSG_ERR_DBSAVE.Text;
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
return(returnMessage);
}
public static List <imagetest> Getimagetest(string WhereClause, MySqlConnection conn = null)
{
imagetest objimagetest = new imagetest();
List <imagetest> lstimagetest = new List <imagetest>();
try
{
bool isConnArgNull = (conn != null) ? false : true;
// MySqlConnection connection = new MySqlConnection("server=132.148.68.125;user id = testusr; password=Testusr123!@#; database=testdatabase");
MySqlConnection connection = (conn != null) ? conn : PrimaryConnection();
tryOpenConnection(connection);
string sql = "select * from imagetest ";
if (!string.IsNullOrEmpty(WhereClause))
{
sql += "where " + WhereClause;
}
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandText = sql;
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
objimagetest = readerDataimagetest(reader);
lstimagetest.Add(objimagetest);
}
}
else
{
}
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(lstimagetest);
}