public void tao(int r, int c)
{
// select Bidatablemap
lg.openconection();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable table = new DataTable();
SqlCommand command = new SqlCommand("SELECT * FROM BidaTabledb", lg.Connection);
adapter = new SqlDataAdapter(command);
adapter.Fill(table);
//
lg.closeconection();
int check = 0;
int lengh = table.Rows.Count;
r = lengh / 5 + 1;
int top = 0;
for (int i = 0; i < r; i++)
{
int left = 0;
for (int j = 0; j < 5; j++)
{
if (check >= lengh)
{
break;
}
Button NewButton = new Button();
//
int name = Convert.ToInt32(table.Rows[check].ItemArray[0].ToString());
NewButton.Name = string.Format("{0}", name);
NewButton.Text = string.Format("ban so {0}", name);
NewButton.BackColor = Color.Green;
NewButton.Tag = string.Format("{0}", name);
NewButton.Size = new Size(50, 50);
NewButton.Top = top;
NewButton.Left = left;
left += 50;
NewButton.Click += new EventHandler(Button_Click);
panel1.Controls.Add(NewButton);
check++;
}
top += 50;
}
}
private void ButtonSignin_Click(object sender, EventArgs e)
{
MYDB lg = new MYDB();
lg.openconection();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable table = new DataTable();
SqlCommand command = new SqlCommand("SELECT * FROM Customersdb WHERE Cuser=@User and Cpass=@Pass", lg.Connection);
command.Parameters.Add("@User", SqlDbType.VarChar).Value = textBoxUser.Text;
command.Parameters.Add("@Pass", SqlDbType.VarChar).Value = textBoxPass.Text;
SqlDataReader reader = command.ExecuteReader();
if ((reader.Read() == true))
//if (command.ExecuteNonQuery() == 1)
{
KhachHangForm kh = new KhachHangForm(textBoxUser.Text);
kh.Show();
}
else
{
lg.closeconection();
lg.openconection();
command = new SqlCommand("SELECT * FROM Employeesdb WHERE Euser=@User and Epass=@Pass", lg.Connection);
command.Parameters.Add("@User", SqlDbType.VarChar).Value = textBoxUser.Text;
command.Parameters.Add("@Pass", SqlDbType.VarChar).Value = textBoxPass.Text;
SqlDataReader reader1 = command.ExecuteReader();
if (reader1.Read() == true)
{
NhanVienForm nv = new NhanVienForm();
nv.Show();
}
else
{
MessageBox.Show("invalid user");
}
}
}
public void loaddatabidamap()
{
MYDB lg = new MYDB();
int id = Convert.ToInt32(labelSoBan.Text);
lg.openconection();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable table = new DataTable();
SqlCommand command = new SqlCommand("SELECT * FROM BidaTableMap where BidaTableID = " + id, lg.Connection);
adapter = new SqlDataAdapter(command);
adapter.Fill(table);
//
lg.closeconection();
dataGridView2.DataSource = table;
}
public bool UpdateStatus(int status, int id)
{
MYDB db = new MYDB();
SqlCommand command = new SqlCommand("UPDATE BidaTableMap SET Status = @status where BidaTableMapID = @id", db.Connection);
//command.Parameters.Add("@id", SqlDbType.Int).Value = PeopleId;
command.Parameters.Add("@id", SqlDbType.Int).Value = id;
command.Parameters.Add("@status", SqlDbType.Int).Value = status;
db.openconection();
if ((command.ExecuteNonQuery() == 1))
{
db.closeconection();
return(true);
}
else
{
db.closeconection();
return(false);
}
}
public bool insert(int Soban, string madichvu, int soluong)
{
MYDB db = new MYDB();
SqlCommand command = new SqlCommand("insert into OrderFooddb (BidaTableMap,Food,Number)" + "values(@BidaTableMap,@Food,@Number)", db.Connection);
command.Parameters.Add("@BidaTableMap", SqlDbType.Int).Value = Soban;
command.Parameters.Add("@Food", SqlDbType.Char).Value = madichvu;
command.Parameters.Add("@Number", SqlDbType.Int).Value = soluong;
db.openconection();
if ((command.ExecuteNonQuery() == 1))
{
db.closeconection();
return(true);
}
else
{
db.closeconection();
return(false);
}
}
private void ButtonCapNhat_Click(object sender, EventArgs e)
{
string sex;
if (radioButtonNam.Checked == true)
{
sex = "Man";
}
else
{
sex = "Girl";
}
MYDB db = new MYDB();
SqlCommand cmd = new SqlCommand("update Customersdb set CName=@ht,Cphone=@st,CBrithday=@bd,Csex=@dc where [Cuser]=N'" + std + "'", db.Connection);
cmd.Parameters.Add("@ht", SqlDbType.NVarChar).Value = textBoxHoTen.Text;
cmd.Parameters.Add("@st", SqlDbType.NVarChar).Value = textBoxStd.Text;
cmd.Parameters.Add("@bd", SqlDbType.DateTime).Value = dateTimePicker1.Value;
cmd.Parameters.Add("@dc", SqlDbType.NVarChar).Value = sex;
db.openconection();
if (cmd.ExecuteNonQuery() == 1)
{
db.closeconection();
ThongTinKhachHang_Load(sender, e);
textBoxHoTen.Enabled = false;
textBoxStd.Enabled = false;
dateTimePicker1.Enabled = false;
radioButtonNam.Enabled = false;
radioButtonNu.Enabled = false;
MessageBox.Show("Đã Cập Nhật Thành Công", "Thông tin Khách Hàng", MessageBoxButtons.OK);
}
else
{
db.closeconection();
MessageBox.Show("Không Thể Cập Nhật", "Thông Tin Khách Hàng", MessageBoxButtons.OK);
}
}
public bool insert(DateTime Bdate, int employee, int bidatablemapID, float total)
{
MYDB db = new MYDB();
SqlCommand command = new SqlCommand("INSERT INTO Billsdb (Bdate,Employee,BidaTableMapID,Total)" + " VALUES (@Bdate,@Employee,@BidaTableMapID,@Total)", db.Connection);
//command.Parameters.Add("@id", SqlDbType.Int).Value = PeopleId;
command.Parameters.Add("@Bdate", SqlDbType.DateTime).Value = Bdate;
command.Parameters.Add("@Employee", SqlDbType.Int).Value = employee;
command.Parameters.Add("@BidaTableMapID", SqlDbType.Int).Value = bidatablemapID;
command.Parameters.Add("@Total", SqlDbType.Float).Value = total;
db.openconection();
if ((command.ExecuteNonQuery() == 1))
{
db.closeconection();
return(true);
}
else
{
db.closeconection();
return(false);
}
}
public bool insert(int id, int status, int custommer, DateTime begin, DateTime end)
{
MYDB db = new MYDB();
SqlCommand command = new SqlCommand("INSERT INTO BidaTableMap (BidaTableID, Status,Customer,TimeBegin,TimeEnd)" + " VALUES (@id, @status, @customer, @begin,@end)", db.Connection);
//command.Parameters.Add("@id", SqlDbType.Int).Value = PeopleId;
command.Parameters.Add("@id", SqlDbType.Int).Value = id;
command.Parameters.Add("@status", SqlDbType.Int).Value = status;
command.Parameters.Add("@customer", SqlDbType.Int).Value = custommer;
command.Parameters.Add("@begin", SqlDbType.DateTime).Value = begin;
command.Parameters.Add("@end", SqlDbType.DateTime).Value = end;
db.openconection();
if ((command.ExecuteNonQuery() == 1))
{
db.closeconection();
return(true);
}
else
{
db.closeconection();
return(false);
}
}
