public void frm_MainService_Load(object sender, EventArgs e)
{
this.ContextMenuStrip = ContextMenuStrip1;
btOrder.Enabled = false;
btStart.Enabled = false;
btCheckBill.Enabled = false;
btCalculate.Enabled = false;
btPaid.Enabled = false;
mnPaid.Visible = false;
mnorder.Visible = false;
mnPrint.Visible = false;
mnCal.Visible = false;
mnPaid.Visible = false;
mnStart.Visible = false;
classDatabaseConnection connect = new classDatabaseConnection();
show.ShowData("select * from v_Selling", connect.DatabaseConnection(ConstVar.constr), dgvOrder);
show.ShowData("select * from v_SellDetail", connect.DatabaseConnection(ConstVar.constr), dgvOrderDetail);
lbSellID.BackColor = Color.FromArgb(70, Color.Black);
Panel4.BackColor = Color.FromArgb(70, Color.Black);
dgvOrder.Columns[8].DefaultCellStyle.Format = "HH:mm:ss";
dgvOrder.Columns[9].DefaultCellStyle.Format = "HH:mm:ss";
// dgvOrder.Columns(0).Width = 150
// dgvOrderDetail.Columns(6).Width = 1
setRowColor();
dgvOrder.CurrentCell = dgvOrder.Rows[dgvOrder.RowCount - 1].Cells[0];
}
public void frm_FoodType_Load(object sender, EventArgs e)
{
// TabControl1.BackColor = Color.FromArgb(70, Color.Black)
// TabPage1.BackColor = Color.FromArgb(70, Color.Black)
//TabPage2.BackColor = Color.FromArgb(70, Color.Black)
show.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvFoodType);
// txtID.Text = autoID.SetID(constr, "FoodtypeID", "tb_FoodType", "FT00", 2, 3)
txtID.Text = autoID.SetID(constr, "foodTypeID", "tb_foodType", "FT", 2, 3, 3, "000");
}
public void frm_Food_Load(object sender, EventArgs e)
{
this.UseWaitCursor = true;
show.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvEmployee);
Panel2.Height = 0;
show.ShowDataInCombobox("Select FoodTypeID, FoodTypeName From tb_FoodType", connect.DatabaseConnection(constr), cbFoodType, "FoodTypeID", "FoodTypeName");
show.ShowDataInCombobox("Select FoodGroupID, FoodGroupName From tb_FoodGroup", connect.DatabaseConnection(constr), cbfoodGroup, "FoodGroupID", "FoodGroupName");
show.ShowDataInCombobox("Select UnitID, UnitName From tb_Unit", connect.DatabaseConnection(constr), cbUnit, "UnitID", "UnitName");
txtID1.Text = autoID.SetID(constr, "FoodID", "tb_FoodAndDrink", "FD00", 2, 3);
pnbt.BackColor = Color.FromArgb(70, Color.Black);
// pndata.BackColor = Color.FromArgb(70, Color.Black)
Panel3.BackColor = Color.FromArgb(70, Color.Black);
}
public void btSave_Click(object sender, EventArgs e)
{
var sqlScript = "select boatID from tb_boat where boatID = '" + txtBoatID.Text + "'";
//SQL.SQLCm = New SqlCommand(sqlScript, db.DatabaseConnection(constr))
//db.SQLDr = db.SQLCm.ExecuteReader()
// Timer1.Enabled = True
SQL.SQLCmd = new System.Data.SqlClient.SqlCommand(sqlScript, SQL.SQLCon);
SQL.SQLCon.Open();
SQL.SQLDr = SQL.SQLCmd.ExecuteReader();
if (SQL.SQLDr.HasRows)
{
MessageBox.Show("ລະຫັດນີ້ມີຢູ່ໃນຖານຂໍ້ມູນແລ້ວ", "ຄໍາເຕືອນ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// MsgBox("ລະຫັດ" 5)
}
else
{
sqlInsert = "INSERT INTO tb_boat(boatID, boatTypeID, Boatname, boatStatus, boatPicture) values('" + txtBoatID.Text + "','" + System.Convert.ToString(cbBoatType.SelectedValue) + "',N'" + txtBoatName.Text + "',N'" + ComboBox1.SelectedItem.ToString() + "', '" + txtpicture.Text + "')";
ClassInsert save = new ClassInsert();
save.Insert(sqlInsert, connect.DatabaseConnection(constr), "ຂໍ້ມູນເຮືອລະຫັດ " + txtBoatID.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ");
txtBoatID.Text = autoID.SetID(constr, "BoatID", "tb_Boat", "B0", 1, 2);
selectData.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvboat);
Clear();
}
SQL.SQLCon.Close();
}
public void btSave_Click(object sender, EventArgs e)
{
var sqlScript = "select FoodGroupID from tb_FoodGroup where FoodgroupID = '" + txtID.Text + "'";
SQL.SQLCmd = new System.Data.SqlClient.SqlCommand(sqlScript, SQL.SQLCon);
SQL.SQLCon.Open();
SQL.SQLDr = SQL.SQLCmd.ExecuteReader();
if (SQL.SQLDr.HasRows)
{
MessageBox.Show("ລະຫັດນີ້ມີຢູ່ໃນຖານຂໍ້ມູນແລ້ວ", "ຄໍາເຕືອນ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
ClassInsert save1 = new ClassInsert();
save1.Insert("INSERT INTO tb_FoodGroup VALUES('" + txtID.Text + "',N'" + txtName.Text + "',N'" + txtDEs.Text + "')", connect.DatabaseConnection(constr), "ຂໍ້ມູນກຸ່ມອາຫານລະຫັດ " + txtID.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ");
show.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvFoodType);
txtID.Text = autoID.SetID(constr, "FoodGroupID", "tb_FoodGroup", "FG00", 2, 3);
cleartxt();
}
}
public void btSave_Click(object sender, EventArgs e)
{
string sqlInsert = "";
var sqlscript = "SELECT EmployeeID FROM tb_Employee WHERE EmployeeID = '" + txtEmployeeID.Text + "'";
SQL.SQLCmd = new System.Data.SqlClient.SqlCommand(sqlscript, SQL.SQLCon);
SQL.SQLCon.Open();
SQL.SQLDr = SQL.SQLCmd.ExecuteReader();
if (SQL.SQLDr.HasRows)
{
MessageBox.Show("ລະຫັດນີ້ມີຢູ່ໃນຖານຂໍ້ມູນແລ້ວ", "ຄໍາເຕືອນ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
SQL.SQLDr.Close();
}
else
{
sqlInsert = "INSERT INTO tb_Employee VALUES('" + txtEmployeeID.Text + "','" + txtEmployeeName.Text + "','" + txtEmployeeLastName.Text + "','" + dtbDob.Text + "','" + txtEmployeePosition.Text + "','" + txtEmployeeTel.Text + "','" + txtEmployeeParentTel.Text + "','" + txtEmployeeEmail.Text + "','" + txtEmployeeVillage.Text + "','" + txtEmployeeDistrict.Text + "','" + cbProvince.SelectedValue.ToString() + "','" + txtEmployeeSalary.Text + "','" + txtPicturePath.Text + "')";
ClassInsert save = new ClassInsert();
save.Insert(sqlInsert, connect.DatabaseConnection(constr), "ຂໍ້ມູນຂອງພະນັກງານລະຫັດ " + txtEmployeeID.Text + " ໄດ້ຖືກບັນທຶກລົງໃນຖານຂໍ້ມູນແລ້ວ");
txtEmployeeID.Text = idauto.SetID(constr, "EmployeeID", "tb_Employee", "EP00", 2, 3);
show.ShowData("SELECT * FROM v_Employee", connect.DatabaseConnection(constr), dgvEmployee);
}
SQL.SQLCon.Close();
}
public void ButtonX1_Click(object sender, EventArgs e)
{
if ((string)btRefresh.Tag == "ວ່າງ")
{
serveStyle = System.Convert.ToString(0);
}
else if ((string)btRefresh.Tag == "ບໍ່ວ່າງ")
{
serveStyle = System.Convert.ToString(1);
}
else if ((string)btRefresh.Tag == "ຈອງແລ້ວ")
{
serveStyle = System.Convert.ToString(0);
}
DateTime tt = DateTime.Parse(txtTime.Text);
string tt2 = tt.ToShortTimeString();
SqlCommand cm3 = new SqlCommand("select convert(varchar(8),reserveComeTime, 108) from tb_reserveBoat where reserveComeTime ='" + tt2 + "' and reserveComeDate = '" + dtpDatecome.Text + "'", ConstVar.connect.DatabaseConnection(ConstVar.constr));
SqlDataReader dr = default(SqlDataReader);
dr = cm3.ExecuteReader();
// dr.Read()
if (dr.HasRows)
{
MessageBox.Show("ເວລານີ້ຖືກຈອງແລ້ວ!!!" + Constants.vbNewLine + "ແນະນໍາ: ກະລຸນາປ້ອນເວລາໃໝ່", "ຄໍາເຕືອນ", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTime.Clear();
txtTime.Focus();
return;
}
else
{
SqlCommand cm1 = new SqlCommand("select employeeID from tb_employee where employeeName = '" + frm_Login.Default.txtUsername.Text + "'", ConstVar.connect.DatabaseConnection(ConstVar.constr)); //''Problem
SqlDataReader dr1 = default(SqlDataReader);
dr1 = cm1.ExecuteReader();
dr1.Read();
ConstVar.emID = dr1[0].ToString();
var sqlScript = "select CustomerID from tb_customer where customerID = '" + txtID.Text + "'";
db.SQLCm = new SqlCommand(sqlScript, db.DatabaseConnection(ConstVar.constr));
db.SQLDr = db.SQLCm.ExecuteReader();
if (db.SQLDr.HasRows)
{
//Dim sql = "insert into tb_Reserveboat(reserveID, reserveDate, reserveComeDate, reserveComeTime, reserveStatus, customerID, employeeID) VALUES('" & txtReservID.Text & "','" & dtvReserve.Value.ToString("MM/dd/yyyy") & "','" & dtpDatecome.Value.ToString("MM/dd/yyyy") & "','" & txtTimecome.Text & "',N'ຍັງບໍ່ມາ','" & txtID.Text & "','" & emID & "')"
var sql = "insert into tb_ReserveBoat VALUES('" + txtReservID.Text + "','" + ConstVar.emID + "','" + txtBoatID.Text + "','" + txtID.Text + "','" + dtvReserve.Value.ToString("MM/dd/yyyy") + "','" + dtpDatecome.Value.ToString("MM/dd/yyyy") + "','" + txtTime.Text + "','" + txtHour.Text + "',N'ຍັງບໍ່ມາ','" + serveStyle + "')";
ConstVar.sav.Insert(sql, ConstVar.connect.DatabaseConnection(ConstVar.constr));
txtID.Text = ConstVar.au.SetID(ConstVar.constr, "CustomerID", "tb_Customer", "C", 1, 4, 4, "0000");
txtReservID.Text = ConstVar.au.SetID(ConstVar.constr, "reserveID", "tb_ReserveBoat", "RSB", 3, 5, 5, "00000");
txtName.Text = "";
txtLastName.Text = "";
txtTel.Text = "";
txtTel2.Text = "";
txtTime.Text = "";
// Dispose()
string sqlboat = "";
string sqlinsert;
sqlboat = "update tb_boat set boatStatus = N'ຈອງແລ້ວ' where boatID='" + txtBoatID.Text + "'";
ConstVar.upd.Update(sqlboat, ConstVar.connect.DatabaseConnection(ConstVar.constr));
ConstVar.sh.ShowData("select * from v_ReserveBoat", ConstVar.connect.DatabaseConnection(ConstVar.constr), frm_MainReserve.Default.dgvReserveBoat);
frm_MainReserve.Default.cbYet.Checked = true;
}
else
{
string sqlCustomer = "Insert into tb_customer values('" + txtID.Text + "',N'" + txtName.Text + "',N'" + txtLastName.Text + "','" + txtTel.Text + "','" + txtTel2.Text + "')";
// Dim sql = "insert into tb_Reserveboat(reserveID, reserveDate, reserveComeDate, reserveComeTime, reserveStatus, customerID, employeeID) VALUES('" & txtReservID.Text & "','" & dtvReserve.Value.ToString("MM/dd/yyyy") & "','" & dtpDatecome.Value.ToString("MM/dd/yyyy") & "','" & txtTime.Text & "',N'ຍັງບໍ່ມາ','" & txtID.Text & "','" & emID & "')"
var sql = "insert into tb_ReserveBoat VALUES('" + txtReservID.Text + "','" + ConstVar.emID + "','" + txtBoatID.Text + "','" + txtID.Text + "','" + dtvReserve.Value.ToString("MM/dd/yyyy") + "','" + dtpDatecome.Value.ToString("MM/dd/yyyy") + "','" + txtTime.Text + "','" + txtHour.Text + "',N'ຍັງບໍ່ມາ','" + serveStyle + "')";
ConstVar.sav.Insert(sqlCustomer, ConstVar.connect.DatabaseConnection(ConstVar.constr));
ConstVar.sav.Insert(sql, ConstVar.connect.DatabaseConnection(ConstVar.constr));
txtID.Text = ConstVar.au.SetID(ConstVar.constr, "CustomerID", "tb_Customer", "C", 1, 4, 4, "0000");
txtReservID.Text = ConstVar.au.SetID(ConstVar.constr, "reserveID", "tb_ReserveBoat", "RSB", 3, 5, 5, "00000");
txtName.Text = "";
txtLastName.Text = "";
txtTel.Text = "";
txtTel2.Text = "";
txtTime.Text = "";
// Dispose()
string sqlboat = "";
string sqlinsert;
sqlboat = "update tb_boat set boatStatus = N'ຈອງແລ້ວ' where boatID='" + txtBoatID.Text + "'";
ConstVar.upd.Update(sqlboat, ConstVar.connect.DatabaseConnection(ConstVar.constr));
ConstVar.sh.ShowData("select * from v_ReserveBoat", ConstVar.connect.DatabaseConnection(ConstVar.constr), frm_MainReserve.Default.dgvReserveBoat);
frm_MainReserve.Default.cbYet.Checked = true;
}
}
}
public void frm_RateExchange_Load(object sender, EventArgs e)
{
txtRateID.Text = idauto.SetID(constr, "RateID", "tb_RateExchange", "R000", 1, 4);
Panel1.BackColor = Color.FromArgb(80, Color.Black);
show.ShowData("SELECT * FROM v_RateExchange", connect.DatabaseConnection(constr), dgvRate);
}
public void Timer1_Tick(object sender, EventArgs e)
{
if (pgb.Value >= pgb.Maximum - 1)
{
Timer1.Stop();
// Frm_Main.Show()
if (txtUsername.Text == "")
{
MessageBox.Show("Enter Username Please", "Username Require");
pgb.Visible = false;
btLogin.Text = "ເຂົ້າສູ່ລະບົບ";
return;
}
if (txtPassword.Text == "")
{
MessageBox.Show("Enter Passwore Please", "Password Require");
pgb.Visible = false;
btLogin.Text = "ເຂົ້າສູ່ລະບົບ";
return;
}
if (txtUsername.Text == "" && txtPassword.Text == "")
{
MessageBox.Show("Enter User and Password Please", "User Info Require");
pgb.Visible = false;
btLogin.Text = "ເຂົ້າສູ່ລະບົບ";
return;
}
if (cbState.Text == "----ເລືອກສະຖານະ-----")
{
MessageBox.Show("Select State Please", "State Require");
pgb.Visible = false;
btLogin.Text = "ເຂົ້າສູ່ລະບົບ";
return;
}
var sqlScript = "select Username,userpassword, userState from tb_user where username = '******' and Userpassword = '******' and userstate = '" + cbState.SelectedItem.ToString() + "'";
db.SQLCm = new SqlCommand(sqlScript, db.DatabaseConnection(constr));
db.SQLDr = db.SQLCm.ExecuteReader();
if (db.SQLDr.HasRows)
{
db.SQLDr.Close();
Frm_Main.Default.Show();
if (cbState.Text == "staff")
{
Frm_Main.Default.ButtonX6.Enabled = false;
frm_OrderFood3.Default.txtprice.Enabled = false;
}
else if (cbState.Text == "admin")
{
Frm_Main.Default.ButtonX6.Enabled = true;
frm_OrderFood3.Default.txtprice.Enabled = true;
}
// Frm_Main.lbUsername.Text = Me.txtUsername.Text
this.Hide();
this.Hide();
}
else
{
db.SQLDr.Close();
MessageBox.Show("ຊື່ ແລະລະຫັດຜູ້ໃຊ້ບໍຖຶກຕ້ອງ");
cbState.Text = "-----ເລືອກສະຖານະ-----";
txtUsername.Clear();
txtPassword.Clear();
txtUsername.Focus();
}
btLogin.Text = "ເຂົ້າສູ່ລະບົບ";
pgb.Visible = false;
}
else
{
pgb.Value = pgb.Value + 5;
}
}
public void frm_Unit_Load(object sender, EventArgs e)
{
txtUnitID.Text = idauto.SetID(constr, "UnitID", "tb_Unit", "UN00", 2, 3);
show.ShowData("SELECT * FROM v_Unit", connect.DatabaseConnection(constr), dgvUnit);
}
