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