public void Delete(REF_Item oREF_Item)
{
DBConnecton db;
db = new DBConnecton();
string sqlQuery;
SqlCommand oSqlCommand;
try
{
sqlQuery = "UPDATE `tblitem` SET `Status` = '1' WHERE `tblitem`.`ID` = " + oREF_Item.ID + "";
//open connection
if (db.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(sqlQuery, db.getConnetion());
//Execute command
cmd.ExecuteNonQuery();
//close connection
db.CloseConnection();
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable SelectItemByID(REF_Item oREF_Item)
{
DBConnecton db;
db = new DBConnecton();
DataTable dataTable = new DataTable();
string query = "SELECT * FROM `tblitem` WHERE `ID`='" + oREF_Item.ID + "'";
//Open connection
if (db.OpenConnection() == true)
{
//Create Command
MySqlCommand cmd = new MySqlCommand(query, db.getConnetion());
//Create a data reader and Execute the command
MySqlDataReader dataReader = cmd.ExecuteReader();
DataSet ds = new DataSet();
ds.Tables.Add(dataTable);
ds.EnforceConstraints = false;
dataTable.Load(dataReader);
dataReader.Close();
//close Connection
db.CloseConnection();
//return list to be displayed
return(dataTable);
}
else
{
return(dataTable);
}
}
public void Insert(REF_Item oREF_Item)
{
DBConnecton db;
db = new DBConnecton();
string sqlQuery;
SqlCommand oSqlCommand;
try
{
sqlQuery = "INSERT INTO `tblitem` (`ID`, `Name`, `Price`, `Status`, `ExpiredDate`,`DelivaryPrice`) VALUES (NULL, '" + oREF_Item.Name + "', '" + oREF_Item.Price + "', '0', '" + oREF_Item.ExpiredDate + "','" + oREF_Item.Delivary + "');";
//open connection
if (db.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(sqlQuery, db.getConnetion());
//Execute command
cmd.ExecuteNonQuery();
//close connection
db.CloseConnection();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btndelete_Click(object sender, EventArgs e)
{
REF_Item oREF_Item = new REF_Item();
DAC_Item oDAC_Item = new DAC_Item();
oREF_Item.ID = ItemID;
oREF_Item.Name = ItemName.Text;
oREF_Item.Price = ItemPrice.Text;
oDAC_Item.Delete(oREF_Item);
Response.Redirect("./frmItem.aspx", true);
}
public void LoadData(REF_Item oREF_Item)
{
try
{
DataTable dt;
DAC_Item oDAC_Item = new DAC_Item();
dt = oDAC_Item.SelectItemByID(oREF_Item);
ItemName.Text = dt.Rows[0][1].ToString();
ItemPrice.Text = dt.Rows[0][2].ToString();
DelivaryPrice.Text = dt.Rows[0][5].ToString();
}
catch (Exception ex)
{
throw;
}
}
protected void btnsubmitoffers_Click(object sender, EventArgs e)
{
try
{
REF_Item oREF_Item = new REF_Item();
DAC_Item oDAC_Item = new DAC_Item();
oREF_Item.Name = ItemName.Text;
oREF_Item.Price = ItemPrice.Text;
oREF_Item.Delivary = DelivaryPrice.Text;
oREF_Item.ExpiredDate = Request.Form["ExpairDate"];
oDAC_Item.Insert(oREF_Item);
Response.Redirect("./frmItem.aspx", true);
}catch (Exception ex)
{
ShowMessage("Something went wrong! Please try again!");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
btndelete.Visible = false;
btnupdate.Visible = false;
if (Request.QueryString["ID"] != null)
{
btndelete.Visible = true;
btnupdate.Visible = true;
btnsave.Visible = false;
ItemID = Request.QueryString["ID"];
REF_Item oREF_Item = new REF_Item();
oREF_Item.ID = ItemID;
LoadData(oREF_Item);
}
else
{
}
}
ItemID = Request.QueryString["ID"];
LoadData();
}
