public bool themChiNhanh(ChiNhanh chiNhanh)
{
var cm = CreateCommand();
cm.CommandText = @"insert into ChiNhanh (tenCN,diaChi,dienThoai,tinhThanh) values (@a,@b,@c,@d)";
cm.Parameters.Add(new SqlParameter("@a", chiNhanh.TenCN));
cm.Parameters.Add(new SqlParameter("@b", chiNhanh.DiaChi));
cm.Parameters.Add(new SqlParameter("@c", chiNhanh.DienThoai));
cm.Parameters.Add(new SqlParameter("@d", chiNhanh.TinhThanh));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
private void button4_Click(object sender, EventArgs e)
{
var cn = new ChiNhanh();
cn.DienThoai = textBox5.Text;
cn.TinhThanh = textBox3.Text;
cn.DiaChi = textBox7.Text;
cn.TenCN = textBox8.Text;
var sql = new GetDataFromSQL();
bool temp = sql.themChiNhanh(cn);
cn.MaCN = sql.timMaChiNhanh(cn.TenCN);
bool test = false;
foreach (DataGridViewRow row in dataGridView2.Rows)
{
var menu = new MenuChiNhanh();
menu.MaMA = sql.timMaMonAn(Convert.ToString(row.Cells["ten"].Value));
menu.GhiChu = Convert.ToString(row.Cells["ghichu"].Value);
menu.MaCN = cn.MaCN;
if (sql.themMenuChiNhanh(menu))
{
test = true;
}
else
{
return;
}
}
if (temp == true && test == true)
{
MessageBox.Show("Thêm chi nhánh thành công!");
}
else
{
MessageBox.Show("Không thêm được chi nhánh!");
}
this.Close();
}
