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