private void btnSearch_Click(object sender, EventArgs e)
{
try
{
string partNumber = txtRestPartNumber.Text.Trim().ToString();
int version = Convert.ToInt32(txtRestVersion.Text.Trim().ToString());
InventoryItem item = new InventoryItem();
item.PartNumber = partNumber;
item.Version = version;
List <LocationQty> listLocations = PartNumberRepository.GetPartNumbersByPartNumberVersion(item);
if (listLocations.Count == 0)
{
statusLabel.ForeColor = Color.Red;
statusLabel.Text = "No PartNumber Locations availlable";
MessageBox.Show("Quantity is empty for Given PartNumber and Version", "Search - PartNumber Operation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
int totalQty = listLocations.Sum(x => x.Quantity);
listLocations.Add(new LocationQty("Total :- ", totalQty));
dgvSearchGrid.DataSource = listLocations;
}
catch (Exception exp)
{
objLogger.LogMsg(LogModes.UI, LogLevel.ERROR, "Error while Searching Location vise Part Numbers - " + exp.Message + " StackTrace:- " + exp.StackTrace);
statusLabel.ForeColor = Color.Red;
statusLabel.Text = "Error while Searching Location vise Part Numbers";
MessageBox.Show("Error while Searching Location vise Part Numbers",
"Searching - Part Number Locations", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button3_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtLocation.Text))
{
InventoryItem item = new InventoryItem();
item.Location = txtLocation.Text;
bool locationExist = PartNumberRepository.CheckPartLocaionExist(item);
if (!locationExist)
{
bool addStatus = PartNumberRepository.AddLocationColumn(txtLocation.Text);
if (addStatus)
{
MessageBox.Show("Location Added successfully", "Location", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Unable to Add Location", "Location", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
}
else
{
MessageBox.Show("Location already exist", "Location", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
}
else
{
MessageBox.Show("Location should not be empty", "Location", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
txtLocation.Clear();
}
private void button1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtUsername.Text) && !string.IsNullOrEmpty(txtPassword.Text))
{
try
{
bool loginStatus = PartNumberRepository.ValidateAdminUser(txtUsername.Text, txtPassword.Text);
if (loginStatus == true)
{
this.DialogResult = DialogResult.Yes;
this.Close();
}
else
{
MessageBox.Show("Oops!, Username or Password is wrong", "Admin Login", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
catch (Exception exp)
{
MessageBox.Show("Error while logging Admin panel", "Login Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Username or Password is Empty", "Admin Login", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
private void button4_Click(object sender, EventArgs e)
{
DialogResult confirmResult = MessageBox.Show("Are you sure want to perform Master Reset in DB ",
"Master Reset DB", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (DialogResult.Yes == confirmResult)
{
frmAuthentiation adm = new frmAuthentiation();
DialogResult res = adm.ShowDialog();
if (DialogResult.Yes == res)
{
if (PartNumberRepository.ResetInventoryItemsToZero())
{
MessageBox.Show("Successfully Reset Invetory Items", "Reset Inventory", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Unable to Reset the Inventory", "Reset Inventory", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
}
private void Search()
{
_projectDataContext = new ProjectDataContext();
_partNumberRepository = new PartNumberRepository(_projectDataContext);
dgvDuLieu.DataSource = _partNumberRepository.GetAll().OrderBy(_ => _.PartNo);
Control();
}
private void frmPartNumber_Load(object sender, EventArgs e)
{
_partNumberRepository = new PartNumberRepository(_projectDataContext);
LanguageTranslate.ChangeLanguageForm(this);
LanguageTranslate.ChangeLanguageGridView(viewDuLieu);
Search();
}
private void button1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtOtp.Text))
{
try
{
bool loginStatus = PartNumberRepository.ValidateAdminOtp(txtOtp.Text);
if (loginStatus == true)
{
this.DialogResult = DialogResult.Yes;
this.Close();
}
else
{
MessageBox.Show("Oops!, OTP Passowrd is wrong", "Admin Login", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
catch (Exception exp)
{
MessageBox.Show("Error while logging Authenticate panel", "Login Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("OTP is empty", "Authenticate Login", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
private void frmScanBarcode_Load(object sender, EventArgs e)
{
_projectDataContext = new ProjectDataContext();
_scanBarcodeRepository = new ScanBarcodeRepository(_projectDataContext);
_registBarcodeRepository = new RegistBarcodeRepository(_projectDataContext);
_partNumberRepository = new PartNumberRepository(_projectDataContext);
_machineRepository = new MachineRepository(_projectDataContext);
_moldRepository = new MoldRepository(_projectDataContext);
_shiftRepository = new ShiftRepository(_projectDataContext);
LanguageTranslate.ChangeLanguageForm(this);
LoadCount();
LoadPartNumberData();
LoadMachineData();
LoadMoldData();
_serialPort = new SerialPort();
_serialPort.DataReceived += new SerialDataReceivedEventHandler(this.serialPort_DataReceived);
Control.CheckForIllegalCrossThreadCalls = false;
ClosePortCOM(GlobalConstants.portCOM);
OpenPortCOM(GlobalConstants.portCOM, 9600);
timer.Enabled = true;
txtBarcode.Focus();
}
private void button2_Click(object sender, EventArgs e)
{
try
{
string partNumber = partNo.Text.Trim().ToString();
int version = Convert.ToInt32(ver.Text.Trim().ToString());
int quantity = Convert.ToInt32(qty.Text.Trim().ToString());
string location = loc.Text.Trim();
InventoryItem item = new InventoryItem(partNumber, version, quantity, location);
bool updated = PartNumberRepository.RestorePartNumber(item);
if (updated)
{
statusLabel.ForeColor = Color.Green;
statusLabel.Text = "Successfully Restoring Inventory Item " + partNumber;
MessageBox.Show("Successfully Restore Inventory Item " + partNumber,
"PartNumber - Restore Operation", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearRestPartNumberGroupSection();
}
}
catch (Exception exp)
{
objLogger.LogMsg(LogModes.UI, LogLevel.ERROR, "Error while Restoring Store Itrms- " + exp.Message + " StackTrace:- " + exp.StackTrace);
statusLabel.ForeColor = Color.Red;
statusLabel.Text = "Invalid Operation - Unable to Restore ";
MessageBox.Show("Error while Restore Inventory Items",
"PartNumber - Failed Operation", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void SetAutoCompleteSources()
{
List <string> listStrings = PartNumberRepository.GetStoreLocations();
List <string> listPartNumbers = PartNumberRepository.GetPartNumbers();
txtLocation.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtLocation.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtPartNumber.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtPartNumber.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtRestPartNumber.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtRestPartNumber.AutoCompleteSource = AutoCompleteSource.CustomSource;
partNo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
partNo.AutoCompleteSource = AutoCompleteSource.CustomSource;
loc.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
loc.AutoCompleteSource = AutoCompleteSource.CustomSource;
autoComplete.AddRange(listStrings.ToArray());
partNumberAutoComplete.AddRange(listPartNumbers.ToArray());
txtLocation.AutoCompleteCustomSource = autoComplete;
txtPartNumber.AutoCompleteCustomSource = partNumberAutoComplete;
txtRestPartNumber.AutoCompleteCustomSource = partNumberAutoComplete;
partNo.AutoCompleteCustomSource = partNumberAutoComplete;
loc.AutoCompleteCustomSource = autoComplete;
}
private void frmPartNumberAddEdit_Load(object sender, EventArgs e)
{
_partNumberRepository = new PartNumberRepository(_projectDataContext);
LanguageTranslate.ChangeLanguageForm(this);
if (String.IsNullOrEmpty(_id))
{
Clear();
}
else
{
GetData();
}
}
private void button1_Click(object sender, EventArgs e)
{
Queue <InventoryItem> listInventoryItems = PartNumberRepository.GetAllNonZeroItems();
reportViewer1.LocalReport.DataSources.Clear(); //clear report
reportViewer1.LocalReport.ReportEmbeddedResource = "LiveStock.rdlc"; // bind reportviewer with .rdlc
Microsoft.Reporting.WinForms.ReportDataSource dataset = new Microsoft.Reporting.WinForms.ReportDataSource("LiveStockDataset", listInventoryItems.ToList()); // set the datasource
reportViewer1.LocalReport.DataSources.Add(dataset);
dataset.Value = listInventoryItems.ToList();
reportViewer1.LocalReport.Refresh();
reportViewer1.RefreshReport();
}
private Queue <InventoryItem> GetDataSourceFromDb()
{
Queue <InventoryItem> listInventoryItems = new Queue <InventoryItem>();
try
{
listInventoryItems = PartNumberRepository.GetAllNonZeroItems();
}
catch (Exception exp)
{
objLogger.LogMsg(LogModes.UI, LogLevel.ERROR, "Error GetDataSourceFromDb - " + exp.Message + " StackTrace:- " + exp.StackTrace);
MessageBox.Show("Error while fetchig Data from DB",
"Error in DB Access", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(listInventoryItems);
}
private void ver_Leave(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(partNo.Text.Trim()) && !string.IsNullOrEmpty(ver.Text.Trim()))
{
string partNumber = partNo.Text.Trim().ToString();
int version = Convert.ToInt32(ver.Text.Trim().ToString());
InventoryItem item = new InventoryItem();
item.PartNumber = partNumber;
item.Version = version;
bool foundPartNumber = PartNumberRepository.CheckPartNumberExist(item);
if (foundPartNumber == true)
{
statusLabel.ForeColor = Color.Green;
statusLabel.Text = "PartNumber and Version already exist";
}
else
{
statusLabel.ForeColor = Color.Red;
statusLabel.Text = "PartNumber and Version not Exist, Please Contact Store Admin";
MessageBox.Show("PartNumber and Version not Exist, Please Contact Store Admin",
"PartNumber - Version Missing", MessageBoxButtons.OK, MessageBoxIcon.Error);
partNo.Clear();
ver.Clear();
qty.Clear();
loc.Clear();
;
partNo.Focus();
}
}
}
catch (Exception exp)
{
objLogger.LogMsg(LogModes.UI, LogLevel.ERROR, "Error while cheking PartNumber and Version - " + exp.Message + " StackTrace:- " + exp.StackTrace);
statusLabel.ForeColor = Color.Red;
statusLabel.Text = "invalid PartNumer / Version";
MessageBox.Show("invalid PartNumer / Version , Please Contact Store Admin",
"PartNumber - Version Missing", MessageBoxButtons.OK, MessageBoxIcon.Error);
partNo.Clear();
ver.Clear();
qty.Clear();
loc.Clear();
;
partNo.Focus();
}
}
private void button1_Click(object sender, EventArgs e)
{
string fromDate = Convert.ToDateTime(dtpFrom.Text).ToString("dd/MM/yyyy");
string endDate = Convert.ToDateTime(dtpTo.Text).ToString("dd/MM/yyyy");
List <InventoryDaiyFact> listDailyFacts = PartNumberRepository.GetInventoryReport(fromDate, endDate);
reportViewer1.LocalReport.DataSources.Clear(); //clear report
reportViewer1.LocalReport.ReportEmbeddedResource = "InventoryReport.rdlc"; // bind reportviewer with .rdlc
Microsoft.Reporting.WinForms.ReportDataSource dataset = new Microsoft.Reporting.WinForms.ReportDataSource("InventoryDS", listDailyFacts); // set the datasource
reportViewer1.LocalReport.DataSources.Add(dataset);
dataset.Value = listDailyFacts;
reportViewer1.LocalReport.Refresh();
reportViewer1.RefreshReport();
}
private void button1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtPartNumber.Text) && !string.IsNullOrEmpty(txtVersion.Text))
{
InventoryItem item = new InventoryItem();
item.PartNumber = txtPartNumber.Text;
item.Version = Convert.ToInt32(txtVersion.Text);
bool partNumberExist = PartNumberRepository.CheckPartNumberExist(item);
if (!partNumberExist)
{
bool addstatus = PartNumberRepository.AddPartNumberAdmin(item);
if (addstatus)
{
MessageBox.Show("Successfully added PartNumber", "PartNumber", MessageBoxButtons.OK,
MessageBoxIcon.Information);
txtPartNumber.Clear();
txtVersion.Clear();
}
else
{
MessageBox.Show("Unable to add Part Number and Version", "PartNumber", MessageBoxButtons.OK,
MessageBoxIcon.Error);
txtPartNumber.Clear();
txtVersion.Clear();
}
}
else
{
MessageBox.Show("PartNumber and Version already exist", "PartNumber", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
txtPartNumber.Clear();
txtVersion.Clear();
}
}
else
{
MessageBox.Show("PartNumber and Version already exist", "PartNumber", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
txtPartNumber.Clear();
txtVersion.Clear();
}
}
private void frmRegistBarcodeAddEdit_Load(object sender, EventArgs e)
{
_registBarcodeRepository = new RegistBarcodeRepository(_projectDataContext);
_partNumberRepository = new PartNumberRepository(_projectDataContext);
_machineRepository = new MachineRepository(_projectDataContext);
_moldRepository = new MoldRepository(_projectDataContext);
_shiftRepository = new ShiftRepository(_projectDataContext);
LanguageTranslate.ChangeLanguageForm(this);
LoadPartNumberData();
LoadMachineData();
LoadShiftData();
LoadMoldData();
if (String.IsNullOrEmpty(_id))
{
Clear();
}
else
{
Close();
}
}
private void loc_Leave(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(loc.Text.Trim()))
{
string location = loc.Text.Trim().ToString();
InventoryItem item = new InventoryItem();
item.Location = location;
bool foundPartNumber = PartNumberRepository.CheckPartLocaionExist(item);
if (foundPartNumber == true)
{
statusLabel.ForeColor = Color.Green;
statusLabel.Text = "Location Exist";
}
else
{
statusLabel.ForeColor = Color.Red;
statusLabel.Text = "Location Not Exist, Please Contact Store Admin";
MessageBox.Show("Location Not Exist",
"Locations Missing", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtLocation.Clear();
txtLocation.Focus();
}
}
}
catch (Exception exp)
{
objLogger.LogMsg(LogModes.UI, LogLevel.ERROR, "Error while cheking PartNumber and Version - " + exp.Message + " StackTrace:- " + exp.StackTrace);
statusLabel.ForeColor = Color.Red;
statusLabel.Text = "Invalid Location";
MessageBox.Show("Location Missing , Please Contact Store Admin",
"Location Missing", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtLocation.Clear();
txtLocation.Focus();
}
}
