private void Txt_numOfSeat_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
if (validateInput())
{
string floorId = cb_floor.SelectedValue.ToString();
string tableZoneId = cb_zone.SelectedValue.ToString();
string tableName = Encrption.trim(txt_tablename.Text.ToString());
string numOfSeat = Encrption.trim(txt_numOfSeat.Text.ToString());
if (this.is_edit.Equals(true))
{
Tables tables = new Tables(this.table_id, floorId, tableZoneId, tableName, numOfSeat);
if (Convert.ToBoolean(tables.updateTable()).Equals(true))
{
MessageBox.Show("Table has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
else
{
Tables tables = new Tables(floorId, tableZoneId, tableName, numOfSeat);
if (Convert.ToBoolean(tables.addTable()).Equals(true))
{
MessageBox.Show("Table has created successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
}
}
private void SearchEnterPressEventOccure(object sender, KeyPressEventArgs e)
{
if (e.KeyChar.Equals((char)Keys.Return))
{
Customer customer;
if (txt_search.Text.ToString().Length > 0)
{
customer = new Customer();
DataTable dataTable = customer.searchCustomer(Encrption.trim(txt_search.Text.ToString()), cb_search.SelectedItem.ToString());
if (dataTable.Rows.Count > 0)
{
btn_clear.Show();
this.customerGridViewFormatting(dataTable);
}
else
{
MessageBox.Show("No record(s) found", "Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
customer = null;
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cb_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_search.Focus();
this.loadCustomer();
}
}
}
private void btnt_search_Click(object sender, EventArgs e)
{
if (txtt_search.Text.ToString().Length > 0)
{
DataTable data = tables.searchTable(Encrption.trim(txtt_search.Text.ToString()), cbt_search.SelectedItem.ToString());
if (data.Rows.Count > 0)
{
btnt_clear.Show();
refreshTable(data);
}
else
{
MessageBox.Show(String.Format("No record(s) found", cbt_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnt_clear.Hide();
txtt_search.Clear();
txtt_search.Focus();
refreshTable(tables.getTables());
}
}
else
{
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cbt_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnt_clear.Hide();
txtt_search.Clear();
txtt_search.Focus();
refreshTable(tables.getTables());
}
}
private void EnterKeyPressEventOccure(object sender, KeyPressEventArgs e)
{
if (e.KeyChar.Equals((char)Keys.Return))
{
items = new Items();
if (txt_search.Text.ToString().Length > 0)
{
DataTable data = items.searchItem(Encrption.trim(txt_search.Text.ToString()), cb_search.SelectedItem.ToString());
if (data.Rows.Count > 0)
{
is_search = true;
btn_clear.Show();
LoadItems(data);
}
else
{
MessageBox.Show("No record(s) found", "Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cb_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_search.Focus();
LoadItems(items.getItems());
}
}
}
private void txtf_search_TextChanged(object sender, EventArgs e)
{
if (txtf_search.Text.ToString().Length > 0)
{
refreshFloor(floor.searchFloor(Encrption.trim(txtf_search.Text.ToString())));
}
else
{
refreshFloor(floor.getFloor());
}
}
private void Txt_zonename_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
string floor_id = cb_floor.SelectedValue.ToString();
string zone_name = Encrption.trim(txt_zonename.Text.ToString());
if (zone_name.Length > 0)
{
if (zone_name.Length > 191)
{
MessageBox.Show("Zone name is too long", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (int.TryParse(zone_name, out int result))
{
MessageBox.Show("Zone name must be alphabetic", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (is_edit.Equals(true))
{
TableZone tableZone = new TableZone(tablezone_id, floor_id, zone_name);
if (Convert.ToBoolean(tableZone.updateTableZone()).Equals(true))
{
MessageBox.Show("Table zone updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
else
{
TableZone tableZone = new TableZone(floor_id, zone_name);
if (Convert.ToBoolean(tableZone.addTableZone()).Equals(true))
{
MessageBox.Show("Table zone created successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
}
}
else
{
MessageBox.Show("Please enter zone name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btn_search_Click(object sender, EventArgs e)
{
if (txtz_search.Text.ToString().Length > 0)
{
btn_clear.Show();
refreshZone(tableZone.searchZone(Encrption.trim(txtz_search.Text.ToString()), cbz_search.SelectedItem.ToString()));
}
else
{
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cbz_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
btn_clear.Hide();
txtz_search.Clear();
txtz_search.Focus();
refreshZone(tableZone.getTableZone());
}
}
private void PressEnterOccure(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
string category_name = Encrption.trim(txtc_name.Text.ToString());
if (category_name.Length > 0)
{
if (category_name.Length > 191)
{
MessageBox.Show("Category name is too long", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (int.TryParse(category_name, out int result))
{
MessageBox.Show("Category name must be alphabetic", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (this.is_edit.Equals(true))
{
Category category = new Category(this.category_id, category_name, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
if (Convert.ToBoolean(category.updateCategory()).Equals(true))
{
MessageBox.Show("Category has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
else
{
Category category = new Category(category_name, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
if (Convert.ToBoolean(category.addCategory()).Equals(true))
{
MessageBox.Show("Category has created successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
}
}
else
{
MessageBox.Show("Please enter category", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void EnterKeyPressEventOccure(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
if (this.validateUser())
{
if (this.verifiedUser == true)
{
if (txt_cpassword.Text.ToString().Length > 0)
{
if (txt_password.Text.ToString().Length < 6 || txt_password.Text.ToString().Length > 20)
{
string name = Encrption.trim(txt_name.Text.ToString());
string username = Encrption.trim(txt_username.Text.ToString());
string email = Encrption.trim(txt_email.Text.ToString());
string user_role = Login.user_role;
string user_status = Login.user_status;
string password = txt_cpassword.Text.ToString();
string created_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
users = new Users(Login.user_id, name, username, email, password, user_role, user_status, created_at);
if (users.updateUser() > 0)
{
MessageBox.Show("Account has been updated", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
confirmPasswordlbl.Visible = false;
txt_cpassword.Visible = false;
txt_password.Clear();
}
}
else
{
MessageBox.Show("Password must be in between 6 to 20 characters", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Please enter new password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Please enter valid password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void Txt_floor_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
string floor_name = Encrption.trim(txt_floor.Text.ToString());
if (floor_name.Length > 0)
{
if (floor_name.Length > 191)
{
MessageBox.Show("Floor name is too long", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (int.TryParse(floor_name, out int result))
{
MessageBox.Show("Floor name must be alphabetic", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (is_edit.Equals(true))
{
Floor floor = new Floor(floor_id, floor_name);
if (Convert.ToBoolean(floor.updateFloor()).Equals(true))
{
MessageBox.Show("Floor has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
else
{
Floor floor = new Floor(floor_id, floor_name);
if (Convert.ToBoolean(floor.addFloor(floor_name)).Equals(true))
{
MessageBox.Show("Floor has created successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
}
}
else
{
MessageBox.Show("Please enter floor name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void ZoneSearchEnterEventOccure(object sender, KeyPressEventArgs e)
{
if (e.KeyChar.Equals((char)Keys.Return))
{
if (txtz_search.Text.ToString().Length > 0)
{
btn_clear.Show();
refreshZone(tableZone.searchZone(Encrption.trim(txtz_search.Text.ToString()), cbz_search.SelectedItem.ToString()));
}
else
{
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cbz_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
btn_clear.Hide();
txtz_search.Clear();
txtz_search.Focus();
refreshZone(tableZone.getTableZone());
}
}
}
private void EnterKeyPressEventOccure(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
if (this.validateInput())
{
string name = Encrption.trim(txt_name.Text.ToString());
string email = Encrption.trim(txt_email.Text.ToString());
string address = Encrption.trim(txt_address.Text.ToString());
string phone = Encrption.trim(txt_phone.Text.ToString());
string additional_info = Encrption.trim(txt_additionalInfo.Text.ToString());
if (this.isCustomerEdit == true)
{
string updated_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
customer = new Customer(int.Parse(this.customerId), name, phone, address, email, additional_info, updated_at);
int result = customer.updateCustomer();
if (result > 0)
{
MessageBox.Show("Customer has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.nullInputFied();
this.Close();
}
}
else
{
string created_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string updated_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
customer = new Customer(name, phone, address, email, additional_info, created_at, updated_at);
int result = customer.addCustomer();
if (result > 0)
{
MessageBox.Show("Customer has created successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.nullInputFied();
this.Close();
}
}
}
}
}
private void loadKitchen(string search = null)
{
kitchen = new Kitchen();
List <Tuple <string, string, string> > kitchenList = new List <Tuple <string, string, string> >();
if (search != null && Encrption.trim(search).Length > 0)
{
kitchenList = kitchen.getKitchens(kitchen.searchKitchen(search));
}
else
{
kitchenList = kitchen.getKitchens();
}
dgv_kitchen.Rows.Clear();
int sno = 0;
foreach (var tuple in kitchenList)
{
dgv_kitchen.Rows.Add(new object[] { ++sno, tuple.Item1, tuple.Item2, tuple.Item3 });
}
}
private void CheckEnterKeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
string username = Encrption.trim(txt_username.Text.ToString());
string password = Encrption.trim(txt_password.Text.ToString());
if (validateInput())
{
DataTable data = login.Login_action(username, password);
if (data.Rows.Count > 0)
{
if (Login.user_status.Equals("1"))
{
MainPanel mainPanel = new MainPanel();
mainPanel.Owner = this;
this.Hide();
mainPanel.Show();
}
else if (Login.user_status.Equals("2"))
{
MessageBox.Show("Your account has been de-active");
}
else if (Login.user_status.Equals("3"))
{
MessageBox.Show("Your account has been suspended");
}
else
{
MessageBox.Show("Your account has been terminated");
}
this.emptyInputField();
}
else
{
MessageBox.Show("Invalid login id or password", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.emptyInputField();
}
}
}
}
private void btn_search_Click(object sender, EventArgs e)
{
Customer customer = new Customer();
if (txt_search.Text.ToString().Length > 0)
{
DataTable dataTable = customer.searchCustomer(Encrption.trim(txt_search.Text.ToString()), cb_search.SelectedItem.ToString());
if (dataTable.Rows.Count > 0)
{
btn_clear.Show();
this.customerGridViewFormatting(dataTable);
}
else
{
MessageBox.Show("No record(s) found", "Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cb_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_search.Focus();
this.loadCustomer();
}
}
private void btn_add_Click(object sender, EventArgs e)
{
if (this.validateInput())
{
string name = Encrption.trim(txt_name.Text.ToString());
string father_name = Encrption.trim(txt_fathername.Text.ToString());
string email = Encrption.trim(txt_email.Text.ToString());
string mobile = Encrption.trim(txt_mobile.Text.ToString());
string nic = Encrption.trim(txt_nic.Text.ToString());
string address = Encrption.trim(txt_address.Text.ToString());
string user_role = cb_role.SelectedValue.ToString();
string user_status = cb_status.SelectedValue.ToString();
string created_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string updated_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (this.isEditEmployee == true)
{
if (this.filePath.Equals("") && this.fileExt.Equals(""))
{
if (this.removeImage == true)
{
employee = new Employee(int.Parse(this.employeeId), name, father_name, address, email, mobile, nic, user_role, "", user_status, updated_at);
}
else
{
employee = new Employee(int.Parse(this.employeeId), name, father_name, address, email, mobile, nic, user_role, this.previousImage, user_status, updated_at);
}
if (employee.updateEmployee() > 0)
{
MessageBox.Show("Employee has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
else
{
string file = Guid.NewGuid() + "_" + this.employeeId + this.fileExt;
this.appPath = this.appPath + file;
File.Copy(this.filePath, this.appPath);
employee = new Employee(int.Parse(this.employeeId), name, father_name, address, email, mobile, nic, user_role, file, user_status, updated_at);
if (employee.updateEmployee() > 0)
{
MessageBox.Show("Employee has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
else
{
employee = new Employee(name, father_name, address, email, mobile, nic, user_role, "", user_status, created_at, updated_at);
int result = employee.addEmployee();
if (result > 0)
{
if (this.filePath.Equals("") && this.fileExt.Equals(""))
{
MessageBox.Show("Employee has inserted successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.nullInputFied();
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
string employeeId = employee.getLastInsertedItemId();
string file = Guid.NewGuid() + "_" + employeeId + this.fileExt;
this.appPath = this.appPath + file;
File.Copy(this.filePath, this.appPath);
employee = null;
employee = new Employee(employeeId, file);
int check = employee.updateItemImage();
if (check > 0)
{
MessageBox.Show("Employee has inserted successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.nullInputFied();
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
}
}
}
private void EnterKeyPressEventOccure(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
if (this.validateInput())
{
string name = Encrption.trim(txt_name.Text.ToString());
string father_name = Encrption.trim(txt_fathername.Text.ToString());
string email = Encrption.trim(txt_email.Text.ToString());
string mobile = Encrption.trim(txt_mobile.Text.ToString());
string nic = Encrption.trim(txt_nic.Text.ToString());
string address = Encrption.trim(txt_address.Text.ToString());
string user_role = cb_role.SelectedValue.ToString();
string user_status = cb_status.SelectedValue.ToString();
string created_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string updated_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (this.isEditEmployee == true)
{
if (this.filePath.Equals("") && this.fileExt.Equals(""))
{
if (this.removeImage == true)
{
employee = new Employee(int.Parse(this.employeeId), name, father_name, address, email, mobile, nic, user_role, "", user_status, updated_at);
}
else
{
employee = new Employee(int.Parse(this.employeeId), name, father_name, address, email, mobile, nic, user_role, this.previousImage, user_status, updated_at);
}
if (employee.updateEmployee() > 0)
{
MessageBox.Show("Record has been updated");
this.Close();
}
}
else
{
string file = Guid.NewGuid() + "_" + this.employeeId + this.fileExt;
this.appPath = this.appPath + file;
File.Copy(this.filePath, this.appPath);
employee = new Employee(int.Parse(this.employeeId), name, father_name, address, email, mobile, nic, user_role, file, user_status, updated_at);
if (employee.updateEmployee() > 0)
{
MessageBox.Show("Record has been updated");
this.Close();
}
}
}
else
{
employee = new Employee(name, father_name, address, email, mobile, nic, user_role, "", user_status, created_at, updated_at);
int result = employee.addEmployee();
if (result > 0)
{
if (this.filePath.Equals("") && this.fileExt.Equals(""))
{
MessageBox.Show(String.Format("{0} Record has been inserted.", result));
this.nullInputFied();
this.Close();
}
else
{
string employeeId = employee.getLastInsertedItemId();
string file = Guid.NewGuid() + "_" + employeeId + this.fileExt;
this.appPath = this.appPath + file;
File.Copy(this.filePath, this.appPath);
employee = null;
employee = new Employee(employeeId, file);
int check = employee.updateItemImage();
if (check > 0)
{
MessageBox.Show("Record has been inserted");
this.nullInputFied();
this.Close();
}
}
}
}
}
}
}
private void btn_add_Click(object sender, EventArgs e)
{
if (this.validateInput())
{
string name = Encrption.trim(txt_name.Text.ToString());
string categoryId = cb_category.SelectedValue.ToString();
string desc = Encrption.trim(txt_desc.Text.ToString());
string sale_price = Encrption.trim(txt_saleprice.Text.ToString());
string purchase_price = Encrption.trim(txt_purchase.Text.ToString());
string discount = Encrption.trim(txt_discount.Text.ToString());
string apply_discount = "0";
if (chk_ad.Checked == true)
{
apply_discount = "1";
}
string apply_tax = "0";
if (chk_at.Checked == true)
{
apply_tax = "1";
}
string is_kitchen = "0";
if (chk_ktch.Checked == true)
{
is_kitchen = "1";
}
string created_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string updated_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (isEditItem == true)
{
try
{
string file;
if (this.filePath.Equals(""))
{
file = this.previousImage;
items = new Items(this.itemId, categoryId, name, desc, sale_price, purchase_price, discount, apply_discount, apply_tax, is_kitchen, file, created_at, updated_at);
int result = items.updateItem();
if (result > 0)
{
MessageBox.Show("Item has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
else
{
file = Guid.NewGuid() + "_" + this.itemId + this.fileExt;
items = new Items(this.itemId, categoryId, name, desc, sale_price, purchase_price, discount, apply_discount, apply_tax, is_kitchen, file, created_at, updated_at);
int result = items.updateItem();
if (result > 0)
{
MessageBox.Show("Item has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
string checkFilePath = this.appPath + file;
File.Copy(this.filePath, checkFilePath, true);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
string imagePath = "";
items = new Items(categoryId, name, desc, sale_price, purchase_price, discount, apply_discount, apply_tax, is_kitchen, imagePath, created_at, updated_at);
int result = items.addItem();
if (result > 0)
{
if (this.filePath.Equals("") && this.fileExt.Equals(""))
{
MessageBox.Show("Item has created successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.nullInputFied();
this.Close();
}
else
{
string itemId = items.getLastInsertedItemId();
string file = Guid.NewGuid() + "_" + itemId + this.fileExt;
this.appPath = this.appPath + file;
File.Copy(this.filePath, this.appPath);
items = null;
items = new Items(itemId, file);
int check = items.updateItemImage();
if (check > 0)
{
MessageBox.Show("Item has created successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.nullInputFied();
this.Close();
}
}
}
}
}
}
private void SearchPressEnterEventOccure(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (Char)Keys.Return)
{
Employee employee = new Employee();
if (cb_search.SelectedItem.ToString().Equals("Name"))
{
if (txt_search.Text.ToString().Length > 0)
{
DataTable data = employee.searchEmployee(Encrption.trim(txt_search.Text.ToString()), cb_search.SelectedItem.ToString());
if (data.Rows.Count > 0)
{
btn_clear.Show();
this.employeeGridViewFormatting(data);
}
else
{
MessageBox.Show("No record(s) found", "Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cb_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_search.Focus();
this.loadEmployee();
}
}
else if (cb_search.SelectedItem.ToString().Equals("Role"))
{
if (txt_search.Text.ToString().Length > 0)
{
DataTable data = employee.searchEmployee(Encrption.trim(txt_search.Text.ToString()), cb_search.SelectedItem.ToString());
if (data.Rows.Count > 0)
{
btn_clear.Show();
this.employeeGridViewFormatting(data);
}
else
{
MessageBox.Show("No record(s) found", "Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cb_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_search.Focus();
this.loadEmployee();
}
}
else if (cb_search.SelectedItem.ToString().Equals("Mobile"))
{
if (txt_search.Text.ToString().Length > 0)
{
DataTable data = employee.searchEmployee(Encrption.trim(txt_search.Text.ToString()), cb_search.SelectedItem.ToString());
if (data.Rows.Count > 0)
{
btn_clear.Show();
this.employeeGridViewFormatting(data);
}
else
{
MessageBox.Show("No record(s) found", "Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cb_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_search.Focus();
this.loadEmployee();
}
}
else if (cb_search.SelectedItem.ToString().Equals("Nic"))
{
if (txt_search.Text.ToString().Length > 0)
{
DataTable data = employee.searchEmployee(Encrption.trim(txt_search.Text.ToString()), cb_search.SelectedItem.ToString());
if (data.Rows.Count > 0)
{
btn_clear.Show();
this.employeeGridViewFormatting(data);
}
else
{
MessageBox.Show("No record(s) found", "Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show(String.Format("Please enter keyword to search by {0}", cb_search.SelectedItem.ToString()), "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_search.Focus();
this.loadEmployee();
}
}
else
{
employee = null;
}
}
}
private void btn_update_Click(object sender, EventArgs e)
{
if (is_edit.Equals(true))
{
if (role.Equals("admin"))
{
if (this.validateUser())
{
if (this.selectedUserId.Equals(Login.user_id))
{
if (this.verifiedUser == true)
{
if (txt_newPassword.Text.ToString().Length > 0)
{
if (txt_newPassword.Text.ToString().Length >= 6 && txt_newPassword.Text.ToString().Length <= 20)
{
// Admin update operation
string name = Encrption.trim(txt_name.Text.ToString());
string username = Encrption.trim(txt_username.Text.ToString());
string email = Encrption.trim(txt_email.Text.ToString());
string user_role = cb_userRole.SelectedValue.ToString();
string user_status = cb_userStatus.SelectedValue.ToString();
string password = Encrption.trim(txt_newPassword.Text.ToString());
string created_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
users = new Users(Login.user_id, name, username, email, password, user_role, user_status, created_at);
if (users.updateUser() > 0)
{
MessageBox.Show("User has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
else
{
MessageBox.Show("Password must be in between 6 to 20 character");
}
}
else
{
MessageBox.Show("Please enter new password");
}
}
else
{
MessageBox.Show("Please enter password to verify");
}
}
else
{
if (login_id == txt_username.Text.ToString())
{
// Other update operation
string name = Encrption.trim(txt_name.Text.ToString());
string username = Encrption.trim(txt_username.Text.ToString());
string email = Encrption.trim(txt_email.Text.ToString());
string user_role = cb_userRole.SelectedValue.ToString();
string user_status = cb_userStatus.SelectedValue.ToString();
string password = Encrption.trim(txt_password.Text.ToString());
string created_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
users = new Users(this.selectedUserId, name, username, email, password, user_role, user_status, created_at);
if (users.updateUser() > 0)
{
MessageBox.Show("User has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
else
{
users = new Users();
if (users.is_LoginIdAlreadyExist(txt_username.Text.ToString()))
{
MessageBox.Show("Login id already taken", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
// Other update operation
string name = Encrption.trim(txt_name.Text.ToString());
string username = Encrption.trim(txt_username.Text.ToString());
string email = Encrption.trim(txt_email.Text.ToString());
string user_role = cb_userRole.SelectedValue.ToString();
string user_status = cb_userStatus.SelectedValue.ToString();
string password = Encrption.trim(txt_password.Text.ToString());
string created_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
users = new Users(this.selectedUserId, name, username, email, password, user_role, user_status, created_at);
if (users.updateUser() > 0)
{
MessageBox.Show("User has updated successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
}
}
}
}
else
{
if (this.validateUser().Equals(true))
{
users = new Users();
if (users.is_LoginIdAlreadyExist(txt_username.Text.ToString()))
{
MessageBox.Show("The Login Id is already in use", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
string name = Encrption.trim(txt_name.Text.ToString());
string username = Encrption.trim(txt_username.Text.ToString());
string email = Encrption.trim(txt_email.Text.ToString());
string user_role = cb_userRole.SelectedValue.ToString();
string status = cb_userStatus.SelectedValue.ToString();
string password = Encrption.trim(txt_password.Text.ToString());
string created_at = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
users = null;
users = new Users(0, name, username, email, password, user_role, status, created_at);
int result = users.addUser();
if (result > 0)
{
MessageBox.Show("The user has created successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.nullInputField();
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
this.nullInputField();
}
}
}
}
}
