public Result update(DTO_Table table) { String query = "UPDATE [TABLE] "; query += "SET [NUMBER] = @NUMBER , "; query += " [AREA] = @AREA , "; query += " [LIMIT] = @LIMIT , "; query += " [STATUS] = @STATUS "; query += " WHERE [ID_TAB] = @ID_TAB "; SqlCommand cmmd = new SqlCommand(); cmmd.Connection = conn; cmmd.CommandType = System.Data.CommandType.Text; cmmd.CommandText = query; cmmd.Parameters.AddWithValue("@ID_TAB", table.ID); cmmd.Parameters.AddWithValue("@NUMBER", table.NUMBER); cmmd.Parameters.AddWithValue("@AREA", table.AREA); cmmd.Parameters.AddWithValue("@LIMIT", table.LIMIT); cmmd.Parameters.AddWithValue("@STATUS", table.STATUS); try { conn.Open(); cmmd.ExecuteNonQuery(); } catch (Exception e) { conn.Close(); System.Console.WriteLine(e.Message); return(new Result(false, e.Message)); } conn.Close(); return(new Result(true)); }
public Result insert(DTO_Table table) { String query = "INSERT INTO [TABLE] ([ID_TAB], [NUMBER], [AREA], [LIMIT], [STATUS]) "; query += "VALUES (@ID_TAB, @NUMBER, @AREA, @LIMIT, @STATUS)"; SqlCommand cmmd = new SqlCommand(); cmmd.Connection = conn; cmmd.CommandType = System.Data.CommandType.Text; cmmd.CommandText = query; cmmd.Parameters.AddWithValue("@ID_TAB", table.ID); cmmd.Parameters.AddWithValue("@NUMBER", table.NUMBER); cmmd.Parameters.AddWithValue("@AREA", table.AREA); cmmd.Parameters.AddWithValue("@LIMIT", table.LIMIT.ToString()); cmmd.Parameters.AddWithValue("@STATUS", table.STATUS.ToString()); try { conn.Open(); cmmd.ExecuteNonQuery(); } catch (Exception e) { conn.Close(); System.Console.WriteLine(e.Message); return(new Result(false, e.Message)); } conn.Close(); return(new Result(true)); }
private void Btn_Click(object sender, EventArgs e) { String id = ((sender as Button).Tag as DTO_Table).ID; MessageBox.Show(id); DTO_Table cur_table = new DTO_Table(); cur_table = tab_BUS.Select_ID(id); resetView(cur_table); }
public void resetView(DTO_Table cTable) { tbx_id.Text = cTable.ID; ntd_number.Value = Convert.ToInt32(cTable.NUMBER); ntd_limit.Value = Convert.ToInt32(cTable.LIMIT); if (cTable.STATUS == "0") { cbx_status.SelectedIndex = 0; } else { cbx_status.SelectedIndex = 1; } }
private void btn_update_Click(object sender, EventArgs e) { DTO_Table tab = new DTO_Table(tbx_id.Text, ntd_number.Value.ToString(), "AR1", ntd_limit.Value.ToString(), cbx_status.SelectedIndex.ToString()); Result result = tab_BUS.update(tab); if (result.Flag) { MessageBox.Show("Updated...", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); loadFlowpanel(); } else { MessageBox.Show("Error...", "Information", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_put_Click(object sender, EventArgs e) { if (status_tab == -1) { MessageBox.Show("Choose table to put."); } if (status_tab == 0) { DTO_Table tab = new DTO_Table(); tab = table_BUS.Select_ID(lb_id_table.Text); DTO_Table tabTemp = new DTO_Table(tab.ID, tab.NUMBER, tab.AREA, tab.LIMIT, "1"); table_BUS.update(tabTemp); LoadDataGridBill(); } if (status_tab == 1) { MessageBox.Show("Table is busy."); } }
public DTO_Table Select_ID(String id) { DTO_Table listtable = new DTO_Table(); String query = "SELECT * FROM [TABLE] "; query += "WHERE [ID_TAB] = @ID_TAB"; SqlCommand cmmd = new SqlCommand(); cmmd.Connection = conn; cmmd.CommandType = System.Data.CommandType.Text; cmmd.CommandText = query; cmmd.Parameters.AddWithValue("@ID_TAB", id); try { conn.Open(); SqlDataReader reader; reader = cmmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { listtable = new DTO_Table(reader["ID_TAB"].ToString(), reader["NUMBER"].ToString(), reader["AREA"].ToString(), reader["LIMIT"].ToString(), reader["STATUS"].ToString()); } } } catch (Exception e) { conn.Close(); System.Console.WriteLine(e.Message); return(null); } conn.Close(); return(listtable); }
public Result update(DTO_Table table) { return(new Result(true)); }
public Result update(DTO_Table table) { return(dal_table.update(table)); }
public Result insert(DTO_Table table) { return(dal_table.insert(table)); }