private static fooditem readerDatafooditem(MySqlDataReader reader)
{
fooditem objfooditem = new fooditem();
objfooditem.ITEMID = Utility.IsValidInt(reader["ITEMID"]);
objfooditem.ITEMNAME = Utility.IsValidString(reader["ITEMNAME"]);
objfooditem.PRICE = Utility.IsValidInt(reader["PRICE"]);
objfooditem.ITEMDESCRIPTION = Utility.IsValidString(reader["ITEMDESCRIPTION"]);
objfooditem.ITEMCATEGORY = Utility.IsValidString(reader["ITEMCATEGORY"]);
objfooditem.ITEMSTATUS = Utility.IsValidString(reader["ITEMSTATUS"]);
return(objfooditem);
}
public static List <fooditem> Getfooditem(string WhereClause, MySqlConnection conn = null)
{
fooditem objfooditem = null;
List <fooditem> lstfooditem = new List <fooditem>();
try
{
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);
string sql = "select * from fooditem ";
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())
{
objfooditem = readerDatafooditem(reader);
lstfooditem.Add(objfooditem);
}
}
else
{
}
}
}
if (isConnArgNull == true)
{
connection.Dispose();
}
}
catch (Exception ex)
{
}
return(lstfooditem);
}
public static string Savefooditem(fooditem objfooditem, MySqlConnection conn = null, MySqlTransaction trans = null)
{
string returnMessage = "";
string sITEMID = "";
sITEMID = objfooditem.ITEMID.ToString();
var templstfooditem = Getfooditem("ITEMID='" + sITEMID + "'", conn);
try
{
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;
bool isEdit = true;
if (templstfooditem.Count <= 0)
{
isEdit = false;
sql = @"INSERT INTO fooditem(
ITEMNAME,PRICE,ITEMDESCRIPTION,ITEMSTATUS,ITEMCATEGORY) VALUES(@ITEMNAME,@PRICE,@ITEMDESCRIPTION,@ITEMSTATUS,@ITEMCATEGORY)";
}
else
{
sql = @"UPDATE fooditem set ITEMID=@ITEMID,ITEMNAME=@ITEMNAME, PRICE=@PRICE,ITEMDESCRIPTION=@ITEMDESCRIPTION,ITEMCATEGORY=@ITEMCATEGORY,ITEMSTATUS=@ITEMSTATUS WHERE ITEMID=@ITEMID";
}
if (trans != null)
{
command.Transaction = trans;
}
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = sql;
if (isEdit)
{
command.Parameters.AddWithValue("@ITEMID", objfooditem.ITEMID);
}
command.Parameters.AddWithValue("@ITEMNAME", objfooditem.ITEMNAME);
command.Parameters.AddWithValue("@PRICE", objfooditem.PRICE);
command.Parameters.AddWithValue("@ITEMDESCRIPTION", objfooditem.ITEMDESCRIPTION);
//command.Parameters.AddWithValue("@CATEGORYID", objfooditem.CATEGORYID);
command.Parameters.AddWithValue("@ITEMCATEGORY", objfooditem.ITEMCATEGORY);
command.Parameters.AddWithValue("@ITEMSTATUS", objfooditem.ITEMSTATUS);
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();
}
}
catch (Exception ex)
{
}
return(returnMessage);
}