void assignMaxQty(int id) { NumericUpDown qtyCart = ((NumericUpDown)this.Controls.Find("itemQtyCartTB" + id, true)[0]); BunifuDropdown name = ((BunifuDropdown)this.Controls.Find("itemNameCombo" + id, true)[0]); NumericUpDown qtyPc = ((NumericUpDown)this.Controls.Find("itemQtyPcTB" + id, true)[0]); ComboBox desc = ((ComboBox)this.Controls.Find("itemDescCombo" + id, true)[0]); NumericUpDown unitPrice = ((NumericUpDown)this.Controls.Find("itemUnitPriceTB" + id, true)[0]); ComboBox expiry = ((ComboBox)this.Controls.Find("expiry" + id, true)[0]); if (expiry.Items.Count == 0) { fillExpiry(id, name.selectedValue, desc.Text); } int crt = 0; int maxcart = 0; int maxpc = 0; foreach (item i in itemsList) { if (i.desc == desc.Text && i.Name == name.selectedValue && i.expiry == expiry.Text) { qtyCart.Maximum = i.maxCart; qtyPc.Maximum = i.maxPcs; unitPrice.Value = i.rate; crt = i.crt; maxcart = i.maxCart; maxpc = i.maxPcs; break; } } modifyOrder(id, name, desc, crt, expiry, int.Parse(qtyCart.Value.ToString()), int.Parse(qtyPc.Value.ToString()), maxcart, maxpc); setAmount(id); }
bool validate() { bool validated = false; foreach (item i in orderList) { NumericUpDown qtyCart = ((NumericUpDown)this.Controls.Find("itemQtyCartTB" + i.id, true)[0]); NumericUpDown qtyPc = ((NumericUpDown)this.Controls.Find("itemQtyPcTB" + i.id, true)[0]); NumericUpDown unitPrice = ((NumericUpDown)this.Controls.Find("itemUnitPriceTB" + i.id, true)[0]); NumericUpDown tradeOffer = ((NumericUpDown)this.Controls.Find("tradeOfferTB" + i.id, true)[0]); Label amount = ((Label)this.Controls.Find("totalLB" + i.id, true)[0]); BunifuDropdown name = ((BunifuDropdown)this.Controls.Find("itemNameCombo" + i.id, true)[0]); ComboBox desc = ((ComboBox)this.Controls.Find("itemDescCombo" + i.id, true)[0]); if (qtyCart.Text == "" || qtyPc.Text == "" || unitPrice.Text == "" || tradeOffer.Text == "" || amount.Text == "" || name.selectedIndex == -1 || desc.Text == "" || !validateAmounts() || !validateBillDetails()) { validated = false; } else { validated = true; } } return(validated); }
public Panel createItemsPanel() { Panel itemsPanel = new Panel(); NumericUpDown itemUnitPrice = createItemUnitPriceTB(); NumericUpDown itemQtyCart = createItemQtyCartTB(); NumericUpDown itemQtyPc = createItemQtyPcTB(); NumericUpDown TradeOffer = createTradeOfferTB(); ComboBox itemDesc = createItemDescCombo(); BunifuDropdown itemName = createItemNameCombo(); Label amount = createAmount(); Label remove = createRemoveSign(); ComboBox expiry = createExpiryCB(); itemsPanel.Dock = DockStyle.Top; //itemsPanel.BorderStyle = BorderStyle.FixedSingle; itemsPanel.Location = new Point(0, 0); itemsPanel.Name = "itemsPanel" + numberOfItems; itemsPanel.Size = new System.Drawing.Size(700, 25); itemsPanel.Controls.Add(itemName); itemsPanel.Controls.Add(itemDesc); itemsPanel.Controls.Add(itemQtyCart); itemsPanel.Controls.Add(itemUnitPrice); itemsPanel.Controls.Add(itemQtyPc); itemsPanel.Controls.Add(TradeOffer); itemsPanel.Controls.Add(amount); itemsPanel.Controls.Add(remove); itemsPanel.Controls.Add(expiry); return(itemsPanel); }
public void ThemDichVu(BunifuDropdown ddtenphong, BunifuDropdown ddDichVu, out int transfer) { transfer = 0; HotelObject.ThuePhongHo tp = new HotelObject.ThuePhongHo(); string temp2 = null; tp.MaThue = conn.LayBien("EXEC PROC_SELECT_MASD", 0); if (tp.MaThue != null) { for (int i = 2; i < tp.MaThue.Length; i++) { temp2 = temp2 + tp.MaThue[i]; } } else { temp2 = "0"; } tp.MaThue = "SD" + (Int32.Parse(temp2) + 1).ToString(); conn.InsertDeleteUpdate("EXEC PROC_SELECT_THEMDICHVU N'" + ddtenphong.selectedValue + "','" + tp.MaThue + "',N'" + ddDichVu.selectedValue + "','" + DateTime.Now + "' "); Notification nf = new Notification("DỊCH VỤ", "Thêm dịch vụ thành công.", ""); nf.Show(); transfer = 1; }
private int MakeDropDownString(BunifuDropdown nameforDropdown, string selectedName) { int index = nameforDropdown.Items.Select((v, i) => new { Index = i, Value = v }) .Where(p => p.Value == selectedName) .Select(p => p.Index).FirstOrDefault(); return(index); }
private bool checkAdd() { string msg = ""; bool isEmpty = false; int count = 0; string[] condReqName = { "txtMobile", "txtPhone1", "txtPhone2" }; //判斷欄位三個至少填一個 string[] condName = { "txtName", "txtAddr", "txtMain" }; //必填欄位 foreach (Control c in this.Controls) { if (c is BunifuMetroTextbox) { BunifuMetroTextbox textBox = c as BunifuMetroTextbox; if (condName.Contains(textBox.Name) && textBox.Text == string.Empty) { msg = "欄位不能為空值!"; isEmpty = true; } else if (condReqName.Contains(textBox.Name) && textBox.Text == string.Empty) { count++; } } else if (c is BunifuDropdown) { BunifuDropdown dropdown = c as BunifuDropdown; if (dropdown.selectedIndex == -1) { msg = "欄位不能為空值!"; isEmpty = true; } } } if (count == condReqName.Length) { msg = "電話欄位至少輸入一欄!"; isEmpty = true; } if (!isEmpty && mode == mode.Add) { RosterInfo vRoster = new RosterInfo(APConfig.Conn); vRoster.Conditions = vRoster.getCondition(RosterInfo.ncConditions.main.ToString(), txtMain.Text); if (vRoster.calculateCount() > 0) { msg = "該手機號碼已經有資料!請重複確認!"; } } if (!string.IsNullOrEmpty(msg)) { APConfig.SweetAlert(ShowBoxType.alert, msg); } return(string.IsNullOrEmpty(msg)? true: false); }
/* METHOD : (2) * ******************************************************************************************************** * If user proceed without selecting any value from dropdown list then, select value of dropdown will by default set as other. * If nothing is selected return string value other else return selected value. * ******************************************************************************************************** */ public static String ValidateDropDown(BunifuDropdown dropdown) { if (dropdown.selectedIndex == 0) { return("Other"); } else { return(dropdown.selectedValue); } }
public void LayTenDichVu(BunifuDropdown ddDichVu) { int n; string[] tendichvu = new string[100]; conn.LayMangSql(tendichvu, "EXEC PROC_SELECT_TENDICHVU", out n, 0); ddDichVu.Clear(); for (int i = 0; i < n; i++) { ddDichVu.AddItem(tendichvu[i]); } ddDichVu.selectedIndex = 0; }
void fillItems(BunifuDropdown name) { List <string> list = new List <string>(); foreach (item i in itemsList) { list.Add(i.Name); } foreach (string s in list.Distinct()) { name.AddItem(s); } }
void assignQty(int id) { NumericUpDown qtyCart = ((NumericUpDown)this.Controls.Find("itemQtyCartTB" + id, true)[0]); BunifuDropdown name = ((BunifuDropdown)this.Controls.Find("itemNameCombo" + id, true)[0]); NumericUpDown qtyPc = ((NumericUpDown)this.Controls.Find("itemQtyPcTB" + id, true)[0]); ComboBox desc = ((ComboBox)this.Controls.Find("itemDescCombo" + id, true)[0]); NumericUpDown unitPrice = ((NumericUpDown)this.Controls.Find("itemUnitPriceTB" + id, true)[0]); ComboBox expiry = ((ComboBox)this.Controls.Find("expiry" + id, true)[0]); if (name.selectedValue != "" && desc.Text != "" && expiry.Text != "") { assignNewMax(id, name, desc, expiry, qtyCart, qtyPc); } }
int getProductID(int id) { BunifuDropdown name = ((BunifuDropdown)this.Controls.Find("itemNameCombo" + id, true)[0]); ComboBox desc = ((ComboBox)this.Controls.Find("itemDescCombo" + id, true)[0]); ComboBox expiry = ((ComboBox)this.Controls.Find("expiry" + id, true)[0]); foreach (item i in itemsList) { if (i.Name == name.selectedValue && i.desc == desc.Text && i.expiry == expiry.Text) { return(i.id); } } return(0); }
public void LayTenPhong(BunifuDropdown ddsotang, BunifuDropdown ddtenphong) { string[] tenphong = new string[15]; int m; conn.LayMangSql(tenphong, "EXEC PRO_SELECT_TENPHONG1 " + ddsotang.selectedValue, out m, 0); ddtenphong.Clear(); for (int i = 0; i < m; i++) { ddtenphong.AddItem(tenphong[i]); } if (m != 0) { ddtenphong.selectedIndex = 0; } }
void modifyOrder(int id, BunifuDropdown name, ComboBox desc, int crt, ComboBox expiry, int qtyCart, int qtyPc, int maxCart, int maxPc) { foreach (item i in orderList) { if (i.id == id) { i.Name = name.selectedValue; i.desc = desc.Text; i.crt = crt; i.expiry = expiry.Text; i.qtycart = qtyCart; i.qtypcs = qtyPc; i.maxCart = maxCart; i.maxPcs = maxPc; break; } } }
public void ThemNhanVien(TextBoxX tbhoten, BunifuDropdown ddGioiTinh, TextBoxX tbpass, TextBoxX tbphone, BunifuDatepicker DPNgaySinh, BunifuDropdown ddchucvu, string btavtar, out int transfer) { transfer = 0; HotelObject.NhanVienHo nv = new HotelObject.NhanVienHo(); string temp = null; ChuanHoa ch = new ChuanHoa(); nv.NgaySinh = DPNgaySinh.Value.ToString(); ch.ChuanHoaDate(nv.NgaySinh, out day, out month, out year); nv.NgaySinh = year + month + day; nv.MaNhanVien = conn.LayBien("EXEC PROC_SELECT_MANHANVIEN", 0); if (nv.MaNhanVien == "" || nv.MaNhanVien == null || nv.MaNhanVien == "1" || nv.MaNhanVien == "ADMIN") { nv.MaNhanVien = "NV1234"; } for (int i = 2; i < nv.MaNhanVien.Length; i++) { temp = temp + nv.MaNhanVien[i]; } nv.MaNhanVien = "NV" + (Int32.Parse(temp) + 1).ToString(); nv.HoTen = ch.CH_Name(tbhoten); if (ch.Check_Phone(tbphone) == false) { Notification nf = new Notification("LỖI", "Số điện thoại không hợp lệ", "Mời bạn nhập lại."); nf.Show(); transfer = 0; } else if (ch.Check_Text_Name(tbhoten) == false) { Notification nf = new Notification("LỖI", "Tên nhập chứa chữ số", "Mời bạn nhập lại."); nf.Show(); transfer = 0; } else { conn.InsertDeleteUpdate("EXEC PROC_INSERT_NHANVIEN '" + nv.MaNhanVien + "','" + tbpass.Text + "',N'" + tbhoten.Text + "',N'" + ddchucvu.selectedValue + "',N'" + ddGioiTinh.selectedValue + "',N'" + btavtar + "','" + year + month + day + "','" + tbphone.Text + "'"); Notification nf = new Notification("THÊM NHÂN VIÊN", "Thêm nhân viên thành công.", "Mã nhân viên :" + nv.MaNhanVien); nf.Show(); transfer = 1; } }
//-------------Descriptions-------------------------------------- public BunifuDropdown createItemNameCombo() { BunifuDropdown itemNameCombo = new BunifuDropdown(); itemNameCombo.Anchor = AnchorStyles.None; itemNameCombo.Font = new Font("Microsoft Sans Serif", 9.75F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))); //itemNameCombo.FormattingEnabled = true; //itemNameCombo.FontWeight = MetroComboBoxWeight.Regular; //itemNameCombo.FontSize = MetroComboBoxSize.Small; itemNameCombo.Location = new Point(2, 0); itemNameCombo.Name = "itemNameCombo" + numberOfItems; itemNameCombo.Size = new Size(100, 25); itemNameCombo.Margin = new Padding(0); itemNameCombo.BorderRadius = 3; //itemNameCombo.DropDownStyle = ComboBoxStyle.DropDownList; fillItems(itemNameCombo); itemNameCombo.Tag = numberOfItems; itemNameCombo.onItemSelected += (s, args) => addDescription(int.Parse(itemNameCombo.Tag.ToString())); return(itemNameCombo); }
void assignNewMax(int id, BunifuDropdown name, ComboBox desc, ComboBox expiry, NumericUpDown qtyCart, NumericUpDown qtyPc) { int qtycartons = 0; int qtypcs = 0; foreach (item ii in orderList) { if (ii.id != id) { if (name.selectedValue == ii.Name && desc.Text == ii.desc && expiry.Text == ii.expiry) { qtycartons += ii.qtycart; qtypcs += ii.qtypcs; } } } qtyCart.Maximum = qtyCart.Maximum - qtycartons; qtyPc.Maximum = qtyPc.Maximum - qtypcs; }
void addDescription(int id) { BunifuDropdown name = ((BunifuDropdown)this.Controls.Find("itemNameCombo" + id, true)[0]); ComboBox desc = ((ComboBox)this.Controls.Find("itemDescCombo" + id, true)[0]); ComboBox expiry = ((ComboBox)this.Controls.Find("expiry" + id, true)[0]); desc.Items.Clear(); expiry.Items.Clear(); bool exists = false; foreach (item i in itemsList) { if (i.Name == name.selectedValue) { foreach (string s in desc.Items) { if (s == i.desc) { exists = true; break; } } if (exists) { break; } else { desc.Items.Add(i.desc); } } } if (desc.Items.Count > 0) { desc.Text = desc.Items[0].ToString(); } }
void setAmount(int id) { NumericUpDown qtyCart = ((NumericUpDown)this.Controls.Find("itemQtyCartTB" + id, true)[0]); NumericUpDown qtyPc = ((NumericUpDown)this.Controls.Find("itemQtyPcTB" + id, true)[0]); NumericUpDown unitPrice = ((NumericUpDown)this.Controls.Find("itemUnitPriceTB" + id, true)[0]); NumericUpDown tradeOffer = ((NumericUpDown)this.Controls.Find("tradeOfferTB" + id, true)[0]); Label amount = ((Label)this.Controls.Find("totalLB" + id, true)[0]); BunifuDropdown name = ((BunifuDropdown)this.Controls.Find("itemNameCombo" + id, true)[0]); ComboBox desc = ((ComboBox)this.Controls.Find("itemDescCombo" + id, true)[0]); ComboBox expiry = ((ComboBox)this.Controls.Find("expiry" + id, true)[0]); if (qtyCart.Value > qtyCart.Maximum) { qtyCart.Value = qtyCart.Maximum; } if (qtyPc.Value > qtyPc.Maximum) { qtyPc.Value = qtyPc.Maximum; } if (name.selectedIndex != -1 && desc.SelectedIndex != -1 && expiry.SelectedIndex != -1) { foreach (item i in orderList) { if (i.Name == name.selectedValue && i.desc == desc.Text && i.expiry == expiry.Text) { i.rate = int.Parse(unitPrice.Value.ToString()); i.qtypcs = int.Parse(qtyPc.Text); i.qtycart = int.Parse(qtyCart.Text); i.tradeOffer = tradeOffer.Value.ToString(); double total = calculateItemTotal(i); amount.Text = total.ToString(); i.total = double.Parse(total.ToString()); } } } }
public static bool Missedbox(List <BunifuMaterialTextbox> textBoxes, BunifuDropdown comboBox) { bool missed = false; foreach (var item in textBoxes) { try { if (item.Text.Length == 0 && comboBox.selectedValue == "") { } else if (item.Text.Length == 0) { missed = true; } } catch (Exception) { missed = true; } } return(missed); }
private void Register_Load(object sender, EventArgs e) { backbutton = BackBTN; backbutton2 = BackBTN2; regpositionscombobox = RegPositionsComboBox; }
private bool checkAdd() { string msg = ""; int n, count = 0; string[] condReqName = { "txtMobile1", "txtMobile2", "txtPhone" }; //判斷欄位三個至少填一個 string[] condName = { "txtName", "txtNo" }; //必填欄位 string[] condNumberName = { "txtAmount" }; //判斷數字欄位 foreach (Control c in this.Controls) { if (c is BunifuMetroTextbox) { BunifuMetroTextbox textBox = c as BunifuMetroTextbox; if (condName.Contains(textBox.Name) && textBox.Text == string.Empty) { msg = "必要欄位不能為空值!"; } else if (condReqName.Contains(textBox.Name) && textBox.Text == string.Empty) { count++; } else if (condNumberName.Contains(textBox.Name) && textBox.Text != string.Empty) { if (!int.TryParse(textBox.Text, out n)) { msg = "金額欄位請輸入數字"; } } } else if (c is BunifuDropdown) { BunifuDropdown dropdown = c as BunifuDropdown; if (dropdown.selectedIndex == -1) { msg = "欄位不能為空值!"; } } } if (count == condReqName.Length) { msg = "電話欄位至少輸入一欄!"; } if (string.IsNullOrEmpty(msg) && mode == mode.Add) { foreach (DataGridViewRow row in dgvItem.Rows) { if (txtNo.Text == row.Cells["dgvItem_No"].Value.ToString()) { msg = "該訂單編號已經存在列表中!請重複確認!!"; break; } } } if (string.IsNullOrEmpty(msg) && mode == mode.Add) { RosterInfo vRoster = new RosterInfo(APConfig.Conn); vRoster.Conditions = vRoster.getCondition(RosterInfo.ncConditions.no.ToString(), txtNo.Text); if (vRoster.calculateCount() > 0) { msg = "該訂單編號已經有資料!請重複確認!"; } } if (!string.IsNullOrEmpty(msg)) { APConfig.SweetAlert(ShowBoxType.alert, msg); } return(string.IsNullOrEmpty(msg) ? true : false); }
private void btnSaveEmployee_Click(object sender, EventArgs e) { string rowId = empTbl.Rows[empTbl.CurrentRow.Index].Cells[0].Value.ToString(); bool error = false; foreach (Control control in tabPage1.Controls) { if (control is BunifuTextBox) { BunifuTextBox textBox = control as BunifuTextBox; if (textBox.Text == "") { string[] optionalFields = { "txtMiddle", "txtSss", "txtTin", "txtPhilhealth", "txtPagibig" }; if (optionalFields.Contains(textBox.Name)) { error = false; } else { error = true; } } } else if (control is BunifuDropdown) { BunifuDropdown jobType = control as BunifuDropdown; if (jobType.SelectedIndex == -1) { error = true; } } } if (error) { MessageBox.Show("Fill all required fields!", "Error"); return; } using (SQLiteConnection conn = new SQLiteConnection(database.ConnectionString)) { conn.Open(); using (SQLiteCommand command = new SQLiteCommand()) { string query = null; string message = null; if (updateInformation) { query = @"UPDATE EMP_TBL " + "SET emp_id=@emp_id,last=@last,first=@first,middle=@middle,address=@address,dob=@dob,civil=@civil," + "nationality=@nationality,sss=@sss,philhealth=@philhealth,pagibig=@pagibig,tin=@tin,email=@email," + "mobile=@mobile,position=@position,class=@class,basic=@basic,allowance=@allowance WHERE id_emp_tbl=@rowid"; message = "Employee details updated successfully!"; command.Parameters.AddWithValue("@rowid", rowId); } else { query = @"INSERT INTO EMP_TBL " + "(emp_id,last,first,middle,address,dob,civil,nationality,sss,philhealth,pagibig,tin,email,mobile,position,class,basic,allowance)" + "VALUES " + "(@emp_id,@last,@first,@middle,@address,@dob,@civil,@nationality,@sss,@philhealth,@pagibig,@tin,@email,@mobile,@position,@class,@basic,@allowance)"; message = "New Employee inserted!"; } command.CommandText = query; command.Connection = conn; command.Parameters.AddWithValue("@emp_id", txtEmpId.Text); command.Parameters.AddWithValue("@last", txtLast.Text); command.Parameters.AddWithValue("@first", txtFirst.Text); command.Parameters.AddWithValue("@middle", txtMiddle.Text); command.Parameters.AddWithValue("@address", txtAddress.Text); command.Parameters.AddWithValue("@dob", txtDob.Value.ToString("MM-dd-yy")); command.Parameters.AddWithValue("@civil", txtCivil.Text); command.Parameters.AddWithValue("@nationality", txtNationality.Text); command.Parameters.AddWithValue("@sss", txtSss.Text); command.Parameters.AddWithValue("@philhealth", txtPhilhealth.Text); command.Parameters.AddWithValue("@pagibig", txtPagibig.Text); command.Parameters.AddWithValue("@tin", txtTin.Text); command.Parameters.AddWithValue("@email", txtEmail.Text); command.Parameters.AddWithValue("@mobile", txtMobile.Text); command.Parameters.AddWithValue("@position", txtPosition.Text); command.Parameters.AddWithValue("@class", txtType.GetItemText(txtType.SelectedItem)); command.Parameters.AddWithValue("@basic", txtBasic.Text); command.Parameters.AddWithValue("@allowance", txtAllowance.Text); if (command.ExecuteNonQuery() > 0) { MessageBox.Show(message, "Success"); empTbl.Rows.Clear(); attendanceTbl.Rows.Clear(); loadAttendanceTable(); loadDashboardTable(); clear(); } else { MessageBox.Show("There is a problem while inserting the data. Call the Programmer to resolve this problem.", "Error"); } } conn.Close(); } }
public void DatPhong(TextBoxX tbhoten, BunifuDropdown ddGioiTinh, TextBoxX tbsocmt, TextBoxX tbphone, BunifuDatepicker DPNgayDat, BunifuDatepicker DPNgayTra, Label label2, Label label8, out int transfer) { transfer = 0; ChuanHoa ch = new ChuanHoa(); HotelObject.KhachHangHo kh = new HotelObject.KhachHangHo(); HotelObject.ThuePhongHo tp = new HotelObject.ThuePhongHo(); HotelObject.PhongHo p = new HotelObject.PhongHo(); string day, month, year; string day1, month1, year1; string day2, month2, year2; ch.ChuanHoaDate(DPNgayTra.Value.ToString(), out day1, out month1, out year1); ch.ChuanHoaDate(DPNgayDat.Value.ToString(), out day, out month, out year); ch.ChuanHoaDate(DateTime.Now.ToString(), out day2, out month2, out year2); Connection cn = new Connection(); if (ch.CheckTB(tbhoten.Text, tbsocmt.Text, tbphone.Text) == false) { Notification nf = new Notification("LỖI", "Thông tin phải được nhập đầy đủ.", "Mời bạn nhập lại."); nf.Show(); } else if (ch.Check_Text_Name(tbhoten) == false) { Notification nf = new Notification("LỖI", "Tên không chứa chữ số.", "Mời bạn nhập lại."); nf.Show(); } else if (ch.CheckDate(Int32.Parse(day2), Int32.Parse(month2), Int32.Parse(year2), Int32.Parse(day), Int32.Parse(month), Int32.Parse(year)) == false) { Notification nf = new Notification("LỖI", "Ngày đặt phòng không hợp lệ.", "Mời bạn nhập lại."); nf.Show(); } else if (ch.CheckDate(Int32.Parse(day), Int32.Parse(month), Int32.Parse(year), Int32.Parse(day1), Int32.Parse(month1), Int32.Parse(year1)) == false) { Notification nf = new Notification("LỖI", "Ngày đặt phòng và ngày trả phòng không hợp lệ.", "Mời bạn nhập lại."); nf.Show(); } else if (ch.Check_SoCMT(tbsocmt) == false) { Notification nf = new Notification("LỖI", "Số CMT không hợp lệ.", "Mời bạn nhập lại."); nf.Show(); } else if (ch.Check_Phone(tbphone) == false) { Notification nf = new Notification("LỖI", "Số điện thoại không hợp lệ.", "Mời bạn nhập lại."); nf.Show(); } else { kh.TenKhachHang = ch.CH_Name(tbhoten); kh.SoCMT = ch.CH_Space(tbsocmt); string temp = null, temp2 = null; kh.MaKhachHang = cn.LayBien("select makhachhang from khachhang order by makhachhang asc", 0); tp.MaThue = cn.LayBien("select mathue from thuephong order by mathue asc", 0); for (int i = 2; i < tp.MaThue.Length; i++) { temp2 = temp2 + tp.MaThue[i]; } tp.MaThue = "TP" + (Int32.Parse(temp2) + 1).ToString(); p.MaPhong = cn.LayBien("select maphong from phong where tenphong='" + label2.Text + "'", 0); for (int i = 2; i < kh.MaKhachHang.Length; i++) { temp = temp + kh.MaKhachHang[i]; } kh.MaKhachHang = "KH" + (Int32.Parse(temp) + 1).ToString(); cn.InsertDeleteUpdate("INSERT INTO KHACHHANG VALUES('" + kh.MaKhachHang + "',N'" + kh.TenKhachHang + "',N'" + ddGioiTinh.selectedValue + "','" + kh.SoCMT + "','" + tbphone.Text + "')"); cn.InsertDeleteUpdate("INSERT INTO THUEPHONG VALUES('" + tp.MaThue + "','" + kh.MaKhachHang + "','" + p.MaPhong + "','" + year + month + day + "','" + year1 + month1 + day1 + "',1)"); Notification nf = new Notification("ĐẶT PHÒNG", "Đặt phòng thành công.", ""); nf.Show(); transfer = 1; } }
public void LayLoaiPhong(BunifuDropdown ddtenphong, Label tenphong, Label loaiphong) { tenphong.Text = ddtenphong.selectedValue; loaiphong.Text = conn.LayBien("EXEC PROC_SELECT_MALOAIPHONG N'" + tenphong.Text + "'", 0); }