public bool them(LoaiBanThangDTO lbt)
{
string query = string.Empty;
query += "INSERT INTO [loaibanthang] ([MaLoaiBT], [TenLoaiBT])";
query += "VALUES (@MaLoaiBT,@TenLoaiBT)";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@MaLoaiBT", lbt.MaLoaiBT);
cmd.Parameters.AddWithValue("@TenLoaiBT", lbt.TenLoaiBT);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
private void LBTRemoveButt_Click(object sender, EventArgs e)
{
string dataID = dataGridViewLBT.CurrentRow.Cells[0].Value.ToString();
string data = dataGridViewLBT.CurrentRow.Cells[1].Value.ToString();
LoaiBanThangDTO itemtoRemove = ListLoaiBanThangSTO.SingleOrDefault(item => item.MaLoaiBT == dataID);
ListLoaiBanThangSTO.Remove(itemtoRemove);
for (int i = 0; i < ListLoaiBanThangSTO.Count; i++) //set lại ID LBT cho List
{
ListLoaiBanThangSTO[i].MaLoaiBT = i.ToString();
}
dataGridViewLBT_load();
}
private void DefaultButt_Click(object sender, EventArgs e)
{
tsBUS.deleteData();
lbtBUS.deleteData();
LoaiBanThangDTO lbt = new LoaiBanThangDTO();
lbt.MaLoaiBT = "0";
lbt.TenLoaiBT = "A";
lbtBUS.them(lbt);
LoaiBanThangDTO lbt1 = new LoaiBanThangDTO();
lbt1.MaLoaiBT = "1";
lbt1.TenLoaiBT = "B";
lbtBUS.them(lbt1);
LoaiBanThangDTO lbt2 = new LoaiBanThangDTO();
lbt2.MaLoaiBT = "2";
lbt2.TenLoaiBT = "C";
lbtBUS.them(lbt2);
UpdateButt_Clicked = 0;
loadData();
}
private void formThemLBT_FormClosed(object sender, FormClosedEventArgs e)
{
if (formThemLBT.AddStatus == true)
{
LoaiBanThangDTO lbt_DTO = new LoaiBanThangDTO();
lbt_DTO.MaLoaiBT = ListLoaiBanThangSTO.Count().ToString();
lbt_DTO.TenLoaiBT = formThemLBT.send_data();
ListLoaiBanThangSTO.Add(lbt_DTO);
BindingSource bsLBT = new BindingSource();
bsLBT.DataSource = ListLoaiBanThangSTO;
dataGridViewLBT.Columns.Clear();
dataGridViewLBT.DataSource = null;
dataGridViewLBT.ColumnHeadersVisible = false;
dataGridViewLBT.AutoGenerateColumns = false;
dataGridViewLBT.AllowUserToAddRows = false;
dataGridViewLBT.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridViewLBT.DataSource = bsLBT;
DataGridViewTextBoxColumn clMLBT = new DataGridViewTextBoxColumn();
clMLBT.Name = "MaLoaiCT";
clMLBT.HeaderText = "Mã Loại BT";
clMLBT.DataPropertyName = "MaLoaiBT";
dataGridViewLBT.Columns.Add(clMLBT);
clMLBT.Visible = false;
DataGridViewTextBoxColumn clLBT = new DataGridViewTextBoxColumn();
clLBT.Name = "LoaiBT";
clLBT.HeaderText = "Loại BT";
clLBT.DataPropertyName = "TenLoaiBT";
dataGridViewLBT.Columns.Add(clLBT);
dataGridViewLBT.CurrentCell = dataGridViewLBT.Rows[0].Cells[1]; //thiết lập lại currentCell
}
formThemLBT = new ThemLoaiBT();
}
public bool them(LoaiBanThangDTO lbt)
{
bool re = lbtDAL.them(lbt);
return(re);
}
