private void button_Click(object sender, EventArgs e)
{
if (sender.Equals(this.buttonUpdate))
{
if (this.textexApplicationRoleName.Text.Trim() != "" && this.textexApplicationRolePassword.Text.Trim() != "")
{
IBaseRepository baseRepository = CommonNinject.Kernel.Get <IBaseRepository>();
if (baseRepository.UpdateApplicationRole(SecurePassword.Encrypt(this.textexApplicationRoleName.Text.Trim()), SecurePassword.Encrypt(this.textexApplicationRolePassword.Text.Trim())) == 1)
{
this.DialogResult = DialogResult.OK;
}
else
{
throw new Exception("Fail to update application role.");
}
}
}
else
if (sender.Equals(this.buttonApplicationRoleRequired) || sender.Equals(this.buttonApplicationRoleIgnored))
{
CommonConfigs.AddUpdateAppSetting("ApplicationRoleRequired", sender.Equals(this.buttonApplicationRoleRequired) ? "true" : "false");
CustomMsgBox.Show(this, "Please open your program again in order to take new effect.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.DialogResult = DialogResult.Cancel;
}
else
{
this.DialogResult = DialogResult.Cancel;
}
}
private void buttonDownload_Click(object sender, EventArgs e)
{
try
{
throw new Exception("Please open your program again in order to update new version." + "\r\n" + "\r\n" + "Contact your admin for more information. Thank you!" + "\r\n" + "\r\n" + "\r\n" + "\r\n" + "Vui lòng mở lại phần mềm để cập nhật phiên bản mới nhất. Cám ơn.");
}
catch (Exception exception)
{
CommonConfigs.AddUpdateAppSetting("VersionID", "-9");
ExceptionHandlers.ShowExceptionMessageBox(this, exception);
this.DialogResult = DialogResult.Cancel;
}
}
private void buttonApplicationRole_Click(object sender, EventArgs e)
{
if (sender.Equals(this.buttonApplicationRoleRequired) || sender.Equals(this.buttonApplicationRoleIgnored))
{
CommonConfigs.AddUpdateAppSetting("ApplicationRoleRequired", sender.Equals(this.buttonApplicationRoleRequired) ? "true" : "false");
CustomMsgBox.Show(this, "Please open your program again in order to take new effect.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.DialogResult = DialogResult.Cancel;
}
if (sender.Equals(this.buttonConnectServer))
{
ConnectServer connectServer = new ConnectServer(true);
DialogResult dialogResult = connectServer.ShowDialog(); connectServer.Dispose();
if (dialogResult == System.Windows.Forms.DialogResult.OK)
{
CustomMsgBox.Show(this, "Please open your program again in order to take new effect.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); this.DialogResult = DialogResult.Cancel;
}
}
}
private bool VersionValidate()
{
try
{
foreach (GlobalVariables.FillingLine fillingLine in Enum.GetValues(typeof(GlobalVariables.FillingLine)))
{
this.baseRepository.ExecuteStoreCommand("UPDATE Configs SET VersionID = " + GlobalVariables.ConfigVersionID((int)fillingLine) + " WHERE ConfigID = " + (int)fillingLine + " AND VersionID < " + GlobalVariables.ConfigVersionID((int)fillingLine), new ObjectParameter[] { });
}
if (this.baseRepository.VersionValidate(GlobalVariables.ConfigID, GlobalVariables.ConfigVersionID(GlobalVariables.ConfigID)))
{
CommonConfigs.AddUpdateAppSetting("VersionID", GlobalVariables.ConfigVersionID(GlobalVariables.ConfigID).ToString());
}
return(true);
}
catch (Exception exception)
{
CommonConfigs.AddUpdateAppSetting("VersionID", "-9");
throw exception;
}
}
private void buttonLoginExit_Click(object sender, EventArgs e)
{
try
{
if (!(GlobalVariables.ConfigID == (int)GlobalEnums.NmvnTaskID.Lavie || GlobalVariables.ConfigID == (int)GlobalVariables.FillingLine.Smallpack || GlobalVariables.ConfigID == (int)GlobalVariables.FillingLine.Pail || GlobalVariables.ConfigID == (int)GlobalVariables.FillingLine.BatchMaster))
{
CustomMsgBox.Show(this, "Sorry, can not open this application." + "\r\n" + "\r\n" + "Call 0919 878 329 for more information. Thanks!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop);
this.DialogResult = DialogResult.Cancel; return;
}
if (sender.Equals(this.buttonExit))
{
this.DialogResult = DialogResult.Cancel; return;
}
if (this.comboBoxEmployeeID.SelectedIndex >= 0)
{
ActiveUser activeUser = this.comboBoxEmployeeID.SelectedItem as ActiveUser;
if (activeUser != null)
{
UserAPIs userAPIs = new UserAPIs(CommonNinject.Kernel.Get <IUserAPIRepository>());
string passwordHash = userAPIs.GetPasswordHash(activeUser.UserID);
if (passwordHash != "")
{
passwordHash = SecurePassword.Decrypt(passwordHash);
}
if (this.textPassword.Text != passwordHash)
{
throw new Exception("Sai mật khẩu. Vui lòng nhập lại mật khẩu trước khi tiếp tục.");
}
ContextAttributes.User = new UserInformation(activeUser.UserID, activeUser.OrganizationalUnitID, activeUser.LocationID, activeUser.LocationName, activeUser.UserName, activeUser.SecurityIdentifier, activeUser.FullyQualifiedUserName, activeUser.IsDatabaseAdmin, new DateTime());
if (this.comboFillingLineID.Visible && (this.comboFillingLineID.SelectedIndex < 0 || this.comboBoxAutonicsPortName.SelectedIndex < 0))
{
throw new System.ArgumentException("Vui lòng chọn chuyền sản xuất (NOF1, NOF2, NOF...), và chọn đúng cổng COM để chạy phần mềm"); // || (this.comboFillingLineID.Enabled && (GlobalVariables.ProductionLine)this.comboFillingLineID.SelectedValue == GlobalVariables.ProductionLine.SERVER)
}
if (this.comboFillingLineID.Visible)
{
GlobalVariables.FillingLineID = (GlobalVariables.FillingLine) this.comboFillingLineID.SelectedValue;
GlobalVariables.FillingLineCode = ((FillingLineBase)this.comboFillingLineID.SelectedItem).Code;
GlobalVariables.FillingLineName = ((FillingLineBase)this.comboFillingLineID.SelectedItem).Name;
GlobalVariables.FillingLineFactoryCode = ((FillingLineBase)this.comboFillingLineID.SelectedItem).FactoryCode;
}
else
{
GlobalVariables.FillingLineID = GlobalVariables.FillingLine.None;
}
GlobalVariables.ComportName = (string)this.comboBoxAutonicsPortName.SelectedValue;
CommonConfigs.AddUpdateAppSetting("ConfigID", (GlobalVariables.ConfigID).ToString());
CommonConfigs.AddUpdateAppSetting("ComportName", GlobalVariables.ComportName);
//CommonConfigs.AddUpdateAppSetting("ReportServerUrl", GlobalVariables.ReportServerUrl); //WILL BE REMOVE THIS LINE
GlobalVariables.ReportServerUrl = CommonConfigs.ReadSetting("ReportServerUrl");
this.VersionValidate();
#region EMPTY DATABASE
if (false && this.checkEmptyData.Checked)
{
this.baseRepository.ExecuteStoreCommand("UPDATE GoodsReceipts SET PickupID = NULL, GoodsIssueID = NULL, WarehouseAdjustmentID = NULL", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("UPDATE GoodsReceiptDetails SET PickupDetailID = NULL, PickupID = NULL, GoodsIssueTransferDetailID = NULL, GoodsIssueID = NULL, WarehouseAdjustmentDetailID = NULL, WarehouseAdjustmentID = NULL", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM WarehouseAdjustmentDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('WarehouseAdjustmentDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM WarehouseAdjustments", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('WarehouseAdjustments', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsIssueTransferDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsIssueTransferDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsIssueDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsIssueDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsIssues", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsIssues', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM TransferOrderDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('TransferOrderDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM TransferOrders", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('TransferOrders', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM DeliveryAdviceDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('DeliveryAdviceDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM DeliveryAdvices", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('DeliveryAdvices', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM SalesOrderDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('SalesOrderDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM SalesOrders", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('SalesOrders', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsReceiptDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsReceiptDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsReceipts", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsReceipts', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM PickupDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('PickupDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Pickups", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Pickups', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Packs", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Packs', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Cartons", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Cartons', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Pallets", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Pallets', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Batches", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Batches', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Lots", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Lots', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM BatchMasters", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('BatchMasters', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Commodities", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Commodities', RESEED, 0)", new ObjectParameter[] { });
}
#endregion
if (this.baseRepository.AutoUpdates(sender.Equals(this.buttonLoginRestore)))
{
this.DialogResult = DialogResult.OK;
}
else
{
CustomMsgBox.Show(this, "The program on this computer must be updated to the latest version." + "\r\n" + "\r\n" + "Contact your administrator for more information.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop);
this.buttonDownload_Click(this.buttonDownload, new EventArgs());
}
}
}
}
catch (Exception exception)
{
ExceptionHandlers.ShowExceptionMessageBox(this, exception);
this.DialogResult = DialogResult.None;
}
}
private void buttonLoginExit_Click(object sender, EventArgs e)
{
try
{
if (sender.Equals(this.buttonExit))
{
this.DialogResult = DialogResult.Cancel; return;
}
if (this.comboUserID.SelectedIndex >= 0)
{
ActiveUser activeUser = this.comboUserID.SelectedItem as ActiveUser;
if (activeUser != null)
{
ContextAttributes.LocalIPAddress = this.GetLocalIPAddress();
ContextAttributes.User = new UserInformation(activeUser.UserID, activeUser.OrganizationalUnitID, activeUser.LocationID, activeUser.LocationName, activeUser.UserName, activeUser.SecurityIdentifier, activeUser.FullyQualifiedUserName, activeUser.IsDatabaseAdmin, new DateTime());
if (this.comboFillingLineID.Visible && (this.comboFillingLineID.SelectedIndex < 0 || this.comboComportName.SelectedIndex < 0))
{
throw new System.ArgumentException("Vui lòng chọn chuyền sản xuất (NOF1, NOF2, NOF...), và chọn đúng cổng COM để chạy phần mềm"); // || (this.comboFillingLineID.Enabled && (GlobalVariables.ProductionLine)this.comboFillingLineID.SelectedValue == GlobalVariables.ProductionLine.SERVER)
}
if (this.comboFillingLineID.Visible)
{
GlobalVariables.FillingLineID = (GlobalVariables.FillingLine) this.comboFillingLineID.SelectedValue;
GlobalVariables.FillingLineCode = ((FillingLineBase)this.comboFillingLineID.SelectedItem).Code;
GlobalVariables.FillingLineName = ((FillingLineBase)this.comboFillingLineID.SelectedItem).Name;
}
else
{
GlobalVariables.FillingLineID = GlobalVariables.FillingLine.None;
}
if (GlobalVariables.FillingLineID == GlobalVariables.FillingLine.Drum)
{
TotalBase.Enums.GlobalEnums.GlobalDrumWithDigit = this.checkGlobalDrumWithDigit.Checked;
}
GlobalVariables.ComportName = (string)this.comboComportName.SelectedValue;
CommonConfigs.AddUpdateAppSetting("ConfigID", (GlobalVariables.ConfigID).ToString());
CommonConfigs.AddUpdateAppSetting("ComportName", GlobalVariables.ComportName);
if (CommonConfigs.ReadSetting("ReportServerUrl") == "")
{
CommonConfigs.AddUpdateAppSetting("ReportServerUrl", GlobalVariables.ReportServerUrl); //INIT NEW Setting IN CONFIG FILE
}
GlobalVariables.ReportServerUrl = CommonConfigs.ReadSetting("ReportServerUrl");
this.VersionValidate();
#region EMPTY DATABASE
if (false && this.checkEmptyData.Checked)
{
this.baseRepository.ExecuteStoreCommand("DELETE FROM WarehouseAdjustmentDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('WarehouseAdjustmentDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM WarehouseAdjustments", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('WarehouseAdjustments', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsIssueTransferDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsIssueTransferDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsIssueDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsIssueDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsIssues", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsIssues', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM TransferOrderDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('TransferOrderDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM TransferOrders", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('TransferOrders', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM DeliveryAdviceDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('DeliveryAdviceDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM DeliveryAdvices", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('DeliveryAdvices', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM SalesOrderDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('SalesOrderDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM SalesOrders", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('SalesOrders', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsReceiptDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsReceiptDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM GoodsReceipts", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('GoodsReceipts', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM PickupDetails", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('PickupDetails', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Pickups", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Pickups', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Packs", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Packs', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Cartons", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Cartons', RESEED, 0)", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DELETE FROM Pallets", new ObjectParameter[] { });
this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Pallets', RESEED, 0)", new ObjectParameter[] { });
//this.baseRepository.ExecuteStoreCommand("DELETE FROM Batches", new ObjectParameter[] { });
//this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Batches', RESEED, 0)", new ObjectParameter[] { });
//this.baseRepository.ExecuteStoreCommand("DELETE FROM Commodities", new ObjectParameter[] { });
//this.baseRepository.ExecuteStoreCommand("DBCC CHECKIDENT ('Commodities', RESEED, 0)", new ObjectParameter[] { });
}
#endregion
if (this.baseRepository.AutoUpdates(sender.Equals(this.buttonLoginRestore)))
{
this.DialogResult = DialogResult.OK;
}
else
{
CustomMsgBox.Show(this, "The program on this computer must be updated to the latest version." + "\r\n" + "\r\n" + "Contact your administrator for more information.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop);
this.buttonDownload_Click(this.buttonDownload, new EventArgs());
}
SmartLogDTO.Init();
}
}
}
catch (Exception exception)
{
ExceptionHandlers.ShowExceptionMessageBox(this, exception);
this.DialogResult = DialogResult.None;
}
}
