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 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)
{
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 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 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 dgvCusKeys_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
var cusSelected = (MCustomer)dgvCustomerList.CurrentRow.DataBoundItem;
CreateKeyForm createKeyForm = new CreateKeyForm();
createKeyForm.Mode = CreateKeyForm.ViewMode.EDIT;
createKeyForm.currentCustomer = cusSelected;
CustomerKey cusKey = null;
List <string> lstOldMac = new List <string>();
try
{
var x = SQLiteCommon.GetALlKeyDevices();
cusKey = (CustomerKey)dgvCusKeys.CurrentRow.DataBoundItem;
if (cusKey == null)
{
return;
}
lstOldMac = SQLiteCommon.GetCustomerKeyByKeyCode(cusKey.KeyCode).ListMacAddress;
}
catch (Exception ex)
{
log.Error(ex);
ShowMsg(MessageBoxIcon.Error, ex.Message);
}
Params param = new Params
{
KeyCode = cusKey.KeyCode,
MachineCode = cusKey.MachineCode,
ListMacs = lstOldMac
};
createKeyForm.param = param;
createKeyForm.InitForm();
DialogResult result = createKeyForm.ShowDialog();
if (result == DialogResult.OK)
{
if (createKeyForm.isSuccess)
{
loadCustomerKey();
}
}
}
private void loadDevices()
{
try
{
List <MDevice> lstDevice = SQLiteCommon.GetALlDevices();
BindingDataGridView(dgvDevices, lstDevice);
}
catch (Exception ex)
{
log.Error(ex);
ShowMsg(MessageBoxIcon.Error, ex.Message);
}
}
private void btnExit_Click(object sender, EventArgs e)
{
try
{
SQLiteCommon.CloseDB();
Application.Exit();
}
catch (Exception ex)
{
log.Error(ex);
ShowMsg(MessageBoxIcon.Error, ex.Message);
}
}
private void loadListUser()
{
try
{
List <MUser> lstUser = SQLiteCommon.GetALlUsers();
BindingDataGridView(dgvUserList, lstUser);
}
catch (Exception ex)
{
log.Error(ex);
ShowMsg(MessageBoxIcon.Error, ex.Message);
}
}
public LoginForm()
{
InitializeComponent();
txtUserName.Focus();
try
{
SQLiteCommon.InitDB();
}
catch (Exception e)
{
log.Error(e);
ShowMsg(MessageBoxIcon.Error, e.Message);
}
}
private List <MDevice> searchListDevice()
{
var key = this.txtKeySeach.Text.Trim()?.ToLower();
try
{
List <MDevice> lstDevice = SQLiteCommon.GetALlDevices().Where(i => string.IsNullOrEmpty(key) ||
i.DeviceName.ToLower().Contains(key) ||
i.MacAddress.ToLower().Contains(key)).ToList();
return(lstDevice);
}
catch (Exception ex)
{
throw ex;
}
}
private void loadCustomerKey()
{
try
{
List <CustomerKey> lstCusKey = new List <CustomerKey>();
if (dgvCustomerList.CurrentRow != null)
{
var cusSelected = (MCustomer)dgvCustomerList.CurrentRow.DataBoundItem;
lstCusKey = SQLiteCommon.GetALlKeysByCusId(cusSelected.ID);
}
BindingDataGridView(dgvCusKeys, lstCusKey);
}
catch (Exception ex)
{
log.Error(ex);
ShowMsg(MessageBoxIcon.Error, ex.Message);
}
}
private List <MCustomer> searchListCustomer()
{
var keySeach = txtKeySeach.Text.Trim().ToLower();
List <MCustomer> result = new List <MCustomer>();
try
{
List <MCustomer> lstCustomer = SQLiteCommon.GetALlCustomers();
List <KeyDevice> lstKeyDevice = SQLiteCommon.GetALlKeyDevices();
List <CustomerKey> lstCusKey = SQLiteCommon.GetALlCustomerKeys();
result = (from cus in lstCustomer
join cusKey in lstCusKey on cus.ID equals cusKey.CusId into grp
from g in grp.DefaultIfEmpty()
join keyDevice in lstKeyDevice on g?.KeyCode equals keyDevice.KeyCode into grp1
from g1 in grp1.DefaultIfEmpty()
select new MCustomer
{
ID = cus.ID,
CompanyName = cus.CompanyName,
CompanyAddress = cus.CompanyAddress,
CompanyMobile = cus.CompanyMobile,
CusName = cus.CusName,
CusEmail = cus.CusEmail,
CusMobile = cus.CusMobile,
KeyCode = g != null ? g.KeyCode : "",
MachineCode = g1 != null ? g1.MachineCode : "",
MacAddress = g1 != null ? g1.MacAddress : "",
UserId = g1 != null ? g1.UserId : "",
CreateDate = g1?.CreateDate
}).Where(i => (string.IsNullOrEmpty(keySeach) ||
i.KeyCode.ToLower().Contains(keySeach) || i.CusName.ToLower().Contains(keySeach) || i.MacAddress.ToLower().Contains(keySeach))).ToList();
return(result);
}
catch (Exception ex)
{
log.Error(ex);
throw ex;
}
}
private bool isDeviceExist(string macAddress)
{
bool result = false;
try
{
string sql = string.Format("SELECT * FROM M_DEVICES WHERE LOWER(MACADDRESS) = '{0}'", macAddress.ToLower());
var res = SQLiteCommon.ExecuteSqlWithResult(sql);
if (res != null && res.HasRows)
{
result = true;
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
private bool isUserExist(string userName)
{
bool result = false;
try
{
string sql = string.Format("SELECT * FROM M_USERS WHERE LOWER(USERID) = '{0}'", userName.ToLower());
var res = SQLiteCommon.ExecuteSqlWithResult(sql);
if (res != null && res.HasRows)
{
result = true;
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
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 btnLogin_Click(object sender, EventArgs e)
{
try
{
string userName = this.txtUserName.Text.Trim();
string passWord = this.txtPassword.Text.Trim();
if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(passWord))
{
ShowMsg(MessageBoxIcon.Warning, "Please input UserName Or Password!");
this.txtUserName.Focus();
return;
}
string sql = string.Format("SELECT * FROM M_USERS WHERE LOWER(USERID)='{0}' AND PASSWORD='******'", userName.ToLower(), passWord);
var result = SQLiteCommon.ExecuteSqlWithResult(sql);
if (result != null && result.HasRows)
{
CURRENT_USER = userName;
MainForm mainForm = new MainForm();
mainForm.Show();
this.Hide();
}
else
{
ShowMsg(MessageBoxIcon.Warning, "UserName Or Password Wrong! Please input this again!");
this.txtUserName.Focus();
this.txtPassword.Text = string.Empty;
}
}
catch (Exception ex)
{
log.Error(ex);
ShowMsg(MessageBoxIcon.Error, ex.Message);
}
}
private void loadListCustomer()
{
var keySeach = txtKeySeach.Text.Trim().ToLower();
DateTime dateFrom = dtpFrom?.Value ?? DateTime.MinValue;
DateTime dateTo = dtpTo?.Value ?? DateTime.MinValue;
dateFrom = new DateTime(dateFrom.Year, dateFrom.Month, dateFrom.Day, 0, 0, 0);
dateTo = new DateTime(dateTo.Year, dateTo.Month, dateTo.Day, 23, 59, 59);
try
{
List <MCustomer> lstCustomer = SQLiteCommon.GetALlCustomers();
List <KeyDevice> lstKeyDevice = SQLiteCommon.GetALlKeyDevices();
List <CustomerKey> lstCusKey = SQLiteCommon.GetALlCustomerKeys();
var lstCusKeyGroup = lstCusKey.GroupBy(i => new { i.CusId, i.KeyCode });
var data = (from cus in lstCustomer
join cusKey in lstCusKeyGroup on cus.ID equals cusKey.Key.CusId into grp
from g in grp.DefaultIfEmpty()
join keyDevice in lstKeyDevice on g?.Key.KeyCode equals keyDevice.KeyCode into grp1
from g1 in grp1.DefaultIfEmpty()
select new MCustomer
{
ID = cus.ID,
CompanyName = cus.CompanyName,
CompanyAddress = cus.CompanyAddress,
CompanyMobile = cus.CompanyMobile,
CusName = cus.CusName,
CusEmail = cus.CusEmail,
CusMobile = cus.CusMobile,
KeyCode = g != null ? g.Key.KeyCode : "",
MachineCode = g1 != null ? g1.MachineCode : "",
MacAddress = g1 != null ? g1.MacAddress : "",
UserId = g1 != null ? g1.UserId : "",
CreateDate = g1?.CreateDate
}).Where(i => (string.IsNullOrEmpty(keySeach) ||
i.KeyCode.ToLower().Contains(keySeach) || i.CusName.ToLower().Contains(keySeach) || i.MacAddress.ToLower().Contains(keySeach) ||
i.MachineCode.ToLower().Contains(keySeach)) &&
(string.IsNullOrEmpty(i.KeyCode) || (i.CreateDate >= dateFrom && i.CreateDate <= dateTo)))
.GroupBy(i => new { i.ID, i.CompanyName, i.CompanyAddress, i.CompanyMobile, i.CusName, i.CusMobile, i.CusEmail })
.Select(i => new MCustomer
{
ID = i.Key.ID,
CompanyName = i.Key.CompanyName,
CompanyAddress = i.Key.CompanyAddress,
CompanyMobile = i.Key.CompanyMobile,
CusName = i.Key.CusName,
CusEmail = i.Key.CusEmail,
CusMobile = i.Key.CusMobile
})
.ToList();
BindingDataGridView(dgvCustomerList, data);
loadCustomerKey();
}
catch (Exception ex)
{
log.Error(ex);
ShowMsg(MessageBoxIcon.Error, 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);
}
}
