private void btnUpdate_Click(object sender, EventArgs e) { if (!validateUser(false)) { return; } var userName = this.txtUserName.Text.Trim(); var password = this.txtPassword.Text.Trim(); var email = this.txtEmail.Text.Trim(); var mobile = this.txtMobile.Text.Trim(); var fullName = this.txtFullName.Text.Trim(); var role = this.cboRole.SelectedValue ?? 1; SQLiteCommon.BeginTran(); try { string sql = "UPDATE M_USERS SET PASSWORD = '******', FULLNAME = '{1}', EMAIL = '{2}', MOBILE = '{3}' , ROLE = {4} WHERE USERID = '{5}'"; sql = string.Format(sql, password, fullName, email, mobile, role, paramUpdate.UserId); SQLiteCommon.ExecuteSqlNonResult(sql); SQLiteCommon.CommitTran(); ShowMsg(MessageBoxIcon.Information, UPDATE_USER_SUCCESS); this.isSuccess = true; this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { SQLiteCommon.RollBackTran(); log.Error(ex); ShowMsg(MessageBoxIcon.Error, UPDATE_USER_FAIL + " : " + ex.Message); } }
private void btnAdd_Click(object sender, EventArgs e) { var userName = this.txtUserName.Text.Trim(); var password = this.txtPassword.Text.Trim(); var email = this.txtEmail.Text.Trim(); var mobile = this.txtMobile.Text.Trim(); var fullName = this.txtFullName.Text.Trim(); var role = this.cboRole.SelectedValue; if (!validateUser()) { return; } try { SQLiteCommon.BeginTran(); string sql = "INSERT INTO M_USERS (USERID, PASSWORD, FULLNAME, EMAIL, MOBILE, ROLE, CREATEBY) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', {5}, '{6}')"; sql = string.Format(sql, userName, password, fullName, email, mobile, role, CURRENT_USER); SQLiteCommon.ExecuteSqlNonResult(sql); SQLiteCommon.CommitTran(); ShowMsg(MessageBoxIcon.Information, ADD_USER_SUCCESS); this.isSuccess = true; this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { SQLiteCommon.RollBackTran(); log.Error(ex); ShowMsg(MessageBoxIcon.Error, ADD_USER_FAIL + " : " + ex.Message); } }
private void btnAdd_Click(object sender, EventArgs e) { if (!validateCustomer()) { return; } var companyName = this.txtCompanyName.Text.Trim(); var companyAddress = this.txtCompanyAddress.Text.Trim(); var companyMobile = this.txtCompanyMobile.Text.Trim(); var cusName = this.txtCusName.Text.Trim(); var cusEmail = this.txtCusEmail.Text.Trim(); var cusMobile = this.txtCompanyMobile.Text.Trim(); try { SQLiteCommon.BeginTran(); string sql = "INSERT INTO M_CUSTOMERS (COMPANYNAME, COMPANYADDRESS, COMPANYMOBILE, CUSNAME, CUSEMAIL, CUSMOBILE, USERID) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')"; sql = string.Format(sql, companyName, companyAddress, companyMobile, cusName, cusEmail, cusMobile, CURRENT_USER); SQLiteCommon.ExecuteSqlNonResult(sql); SQLiteCommon.CommitTran(); ShowMsg(MessageBoxIcon.Information, ADD_CUSTOMER_SUCCESS); this.btnAdd.Enabled = false; this.isSuccess = true; this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { SQLiteCommon.RollBackTran(); log.Error(ex); ShowMsg(MessageBoxIcon.Error, ADD_CUSTOMER_FAIL + " : " + ex.Message); } }
private void btnUpdate_Click(object sender, EventArgs e) { if (!validateCustomer()) { return; } var companyName = this.txtCompanyName.Text.Trim(); var companyAddress = this.txtCompanyAddress.Text.Trim(); var companyMobile = this.txtCompanyMobile.Text.Trim(); var cusName = this.txtCusName.Text.Trim(); var cusEmail = this.txtCusEmail.Text.Trim(); var cusMobile = this.txtCompanyMobile.Text.Trim(); SQLiteCommon.BeginTran(); try { string sql = "UPDATE M_CUSTOMERS SET COMPANYNAME = '{0}', COMPANYADDRESS = '{1}', COMPANYMOBILE = '{2}', CUSNAME = '{3}' , CUSEMAIL = '{4}' , CUSMOBILE = '{5}', USERID = '{6}' WHERE ID = {7}"; sql = string.Format(sql, companyName, companyAddress, companyMobile, cusName, cusEmail, cusMobile, CURRENT_USER, paramUpdate.ID); SQLiteCommon.ExecuteSqlNonResult(sql); SQLiteCommon.CommitTran(); ShowMsg(MessageBoxIcon.Information, UPDATE_CUSTOMER_SUCCESS); this.isSuccess = true; this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { SQLiteCommon.RollBackTran(); log.Error(ex); ShowMsg(MessageBoxIcon.Error, UPDATE_CUSTOMER_FAIL + " : " + ex.Message); } }
private void btnAdd_Click(object sender, EventArgs e) { var deviceName = this.txtDeviceName.Text.Trim(); var macAddress = this.txtMacAddress.Text.Trim(); if (!validateDevice()) { return; } try { SQLiteCommon.BeginTran(); string sql = "INSERT INTO M_DEVICES (DEVICENAME, MACADDRESS, USERID) VALUES ('{0}', '{1}', '{2}')"; sql = string.Format(sql, deviceName, macAddress, CURRENT_USER); SQLiteCommon.ExecuteSqlNonResult(sql); SQLiteCommon.CommitTran(); ShowMsg(MessageBoxIcon.Information, ADD_DEVICE_SUCCESS); this.isSuccess = true; this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { SQLiteCommon.RollBackTran(); log.Error(ex); ShowMsg(MessageBoxIcon.Error, ADD_DEVICE_FAIL + " : " + ex.Message); } }
private void btnUpdate_Click(object sender, EventArgs e) { if (!validateDevice(false)) { return; } var deviceName = this.txtDeviceName.Text.Trim(); var macAddress = this.txtMacAddress.Text.Trim(); SQLiteCommon.BeginTran(); try { string sql = "UPDATE M_DEVICES SET DEVICENAME = '{0}', MACADDRESS = '{1}' WHERE ID = {2}"; sql = string.Format(sql, deviceName, macAddress, paramUpdate.ID); SQLiteCommon.ExecuteSqlNonResult(sql); SQLiteCommon.CommitTran(); ShowMsg(MessageBoxIcon.Information, UPDATE_DEVICE_SUCCESS); this.isSuccess = true; this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { SQLiteCommon.RollBackTran(); log.Error(ex); ShowMsg(MessageBoxIcon.Error, UPDATE_DEVICE_FAIL + " : " + ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { SQLiteCommon.BeginTran(); try { string sql = "DELETE FROM M_USERS WHERE USERID = '{0}'"; sql = string.Format(sql, paramUpdate.UserId); SQLiteCommon.ExecuteSqlNonResult(sql); SQLiteCommon.CommitTran(); ShowMsg(MessageBoxIcon.Information, DELETE_USER_SUCCESS); this.isSuccess = true; this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { SQLiteCommon.RollBackTran(); log.Error(ex); ShowMsg(MessageBoxIcon.Error, DELETE_USER_FAIL + " : " + ex.Message); } }
private void btnCreateKey_Click(object sender, EventArgs e) { SQLiteCommon.BeginTran(); try { string pathOutput = "keys"; if (!validateCreateKey()) { return; } var machineCode = this.txtMachineCode.Text.Trim(); var mac1 = this.txtMac1.Text.Trim(); var mac2 = this.txtMac2.Text.Trim(); var mac3 = this.txtMac3.Text.Trim(); var mac4 = this.txtMac4.Text.Trim(); var mac5 = this.txtMac5.Text.Trim(); //var key = string.Join(",", machineCode, mac1, mac2, mac3, mac4, mac5); var key = machineCode; string keyEncripted = Cipher.EncryptText(key); string fileName = pathOutput + "/" + machineCode.Substring(0, 5) + "_" + DateTime.Now.ToString("yyyyMMdd") + "_keycode.txt"; if (!Directory.Exists(pathOutput)) { Directory.CreateDirectory(pathOutput); } File.WriteAllText(fileName, keyEncripted); //INSERT CUSTOMERKEYS string sql = "INSERT INTO CUSTOMERKEYS (CUSID, KEYCODE, USERID) VALUES ({0}, '{1}', '{2}')"; sql = string.Format(sql, currentCustomer.ID, keyEncripted, CURRENT_USER); SQLiteCommon.ExecuteSqlNonResult(sql); //INSERT KEYDEVICES var lstMacs = getListMacInput(); foreach (var mac in lstMacs) { sql = "INSERT INTO KEYDEVICES (KEYCODE, MACHINECODE, MACADDRESS, USERID) VALUES ('{0}','{1}','{2}', '{3}')"; sql = string.Format(sql, keyEncripted, machineCode, mac, CURRENT_USER); SQLiteCommon.ExecuteSqlNonResult(sql); } SQLiteCommon.CommitTran(); ShowMsg(MessageBoxIcon.Information, "Create Key Success!"); this.isSuccess = true; this.DialogResult = DialogResult.OK; this.Close(); Process.Start("explorer.exe", pathOutput); } catch (Exception ex) { SQLiteCommon.RollBackTran(); ShowMsg(MessageBoxIcon.Error, "Create Key Fail!"); log.Error(ex); } }