private void ageReportAreaListView_MouseClick(object sender, MouseEventArgs e)
{
ListViewHitTestInfo HI = ageReportAreaListView.HitTest(e.Location);
List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", "areaName", HI.Item.Text);
if (areas.Count != 0)
{
ageReportMainListView.Items.Clear();
foreach (LocationObject loc in areas[0].locationsList)
{
foreach (CaseInfo ci in loc.casesList)
{
DateTime dt = DateTime.Parse(ci.ageInfo);
ListViewItem item = new ListViewItem(ci.ageInfo);
item.SubItems.Add(ci.caseID);
AgeInfo cai = CalculateAgeInfo(dt, MongoCRUD.GetInstance().GetServerTime());
item.SubItems.Add("Days: " + cai.days + " Hours: " + cai.hours + " Min: " + cai.minute);
item.SubItems.Add(ci.curLoc);
ageReportMainListView.Items.Add(item);
}
}
}
}
private void serialInfoTextBox_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
serialInfoListView.Items.Clear();
List <SerialInfo> list = MongoCRUD.GetInstance().LoadRecords <SerialInfo>("Serial", "serial", serialInfoTextBox.Text);
if (list.Count != 0)
{
foreach (SerialInfo si in list)
{
List <LocationData> tempLD = si.locationData;
foreach (LocationData ld in tempLD)
{
ListViewItem item = new ListViewItem(list[0].ID.ToString());
item.SubItems.Add(ld.date);
item.SubItems.Add(ld.curCase);
item.SubItems.Add(ld.location);
item.SubItems.Add(ld.userID);
item.SubItems.Add(ld.time);
item.SubItems.Add(ld.lastLocation.ToString());
serialInfoListView.Items.Add(item);
}
}
}
ResizeListViewColumns(serialInfoListView);
}
}
public static MongoCRUD GetInstance()
{
if (instance == null)
{
instance = new MongoCRUD();
}
return(instance);
}
private void caseTextBox_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
List <SerialInfo> list = MongoCRUD.GetInstance().LoadRecords <SerialInfo>("Serial", "caseID", caseTextBox.Text);
if (list.Count != 0)
{
numUnitsLabel.Text = list.Count.ToString();
foreach (SerialInfo item in list)
{
serialListView.Items.Add(item.serial);
}
if (validateInputTabs.SelectedTab == validateInputTabs.TabPages["VerifyTab"])
{
serialTextBox.Enabled = true;
this.SelectNextControl(ActiveControl, true, true, true, true);
caseTextBox.Enabled = false;
}
else
{
serialTextBox2.Enabled = true;
this.SelectNextControl(ActiveControl, true, true, true, true);
caseTextBox2.Enabled = false;
serialTextBox2.Focus();
}
}
else
{
if (validateInputTabs.SelectedTab == validateInputTabs.TabPages["VerifyTab"])
{
caseTextBox.Clear();
numUnitsLabel.Text = list.Count.ToString();
}
else
{
serialTextBox2.Enabled = true;
this.SelectNextControl(ActiveControl, true, true, true, true);
caseTextBox2.Enabled = false;
serialTextBox2.Focus();
}
}
}
}
private void RefreshAreasList()
{
List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", null, null);
if (areas.Count != 0)
{
settingsAreaListView.Items.Clear();
foreach (AreaInfo a in areas)
{
settingsAreaListView.Items.Add(a.areaName);
}
}
}
private void areaLocationBox_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
bool locationExists = false;
string areaName = (string)areaComboBox.SelectedItem;
List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", "areaName", areaName);
if (areas.Count != 0)
{
foreach (LocationObject lo in areas[0].locationsList)
{
if (lo.locName == areaLocationBox.Text)
{
locationExists = true;
}
else if (lo.locName == areaLocationBox2.Text)
{
locationExists = true;
}
}
if (locationExists)
{
if (validateInputTabs.SelectedTab == validateInputTabs.TabPages["VerifyTab"])
{
caseTextBox.Enabled = true;
this.SelectNextControl(ActiveControl, true, true, true, true);
areaLocationBox.Enabled = false;
}
else
{
caseTextBox2.Enabled = true;
this.SelectNextControl(ActiveControl, true, true, true, true);
areaLocationBox2.Enabled = false;
}
}
else
{
areaLocationBox.Clear();
areaLocationBox2.Clear();
Console.WriteLine("Nobody here wrong again man");
}
}
}
}
private void LoadAreaComboBox()
{
List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", null, null);
if (areas.Count != 0)
{
areaComboBox.Items.Clear();
foreach (AreaInfo a in areas)
{
areaComboBox.Items.Add(a.areaName);
}
}
}
private void settingsAreaAddButton_Click(object sender, EventArgs e)
{
string areaName = ShowDialog("Enter Area Name", "New Add Area", true);
if (areaName.Length > 0)
{
AreaInfo area = new AreaInfo();
area.areaName = areaName;
if (!MongoCRUD.GetInstance().RecordExists <AreaInfo>("Areas", areaName, "areaName"))
{
MongoCRUD.GetInstance().InsertRecord("Areas", area, areaName, null);
RefreshAreasList();
}
}
}
static void Main()
{
MongoCRUD.GetInstance().ConnectToDB("Serials");
Console.WriteLine(MongoCRUD.GetInstance().GetServerTime().ToString());
if (MongoCRUD.GetInstance().DBConnectionStatus())
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
}
else
{
ShowDialog("Cannot Connect To Specified Database", "Error");
}
}
private void settingsLocAddButton_Click(object sender, EventArgs e)
{
string locName = ShowDialog("Enter Location Name", "New Add Location", true);
string areaName = settingsAreaListView.SelectedItems[0].Text;
if (locName.Length > 0)
{
LocationObject lo = new LocationObject();
lo.locName = locName;
if (MongoCRUD.GetInstance().RecordExists <AreaInfo>("Areas", areaName, "areaName"))
{
MongoCRUD.GetInstance().AppendRecord <AreaInfo>("Areas", areaName, lo);
RefreshLocationsList(settingsAreaListView.SelectedItems[0].Text);
}
}
}
private void RefreshLocationsList(string areaName)
{
List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", "areaName", areaName);
if (areas.Count != 0)
{
settingsLocationsListView.Items.Clear();
foreach (AreaInfo a in areas)
{
foreach (LocationObject loc in a.locationsList)
{
settingsLocationsListView.Items.Add(loc.locName);
}
}
}
}
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (tabControl1.SelectedTab == tabControl1.TabPages["AgeReportTab"])
{
List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", null, null);
if (areas.Count != 0)
{
ageReportAreaListView.Items.Clear();
foreach (AreaInfo a in areas)
{
ageReportAreaListView.Items.Add(a.areaName);
}
}
}
}
private void UpdateAreaLocCases(CaseInfo ci, string areaID)
{
List <AreaInfo> areas = MongoCRUD.GetInstance().LoadRecords <AreaInfo>("Areas", "areaName", areaID);
if (areas.Count != 0)
{
foreach (LocationObject lo in areas[0].locationsList)
{
if (lo.locName == ci.curLoc)
{
if (!lo.casesList.Contains(ci))
{
MongoCRUD.GetInstance().UpdateLocationCases(lo, areas[0], ci);
}
}
}
}
}
private void serialTextBox_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (serialTextBox.Text.ToUpper() == "CLEAR" || serialTextBox2.Text.ToUpper() == "CLEAR")
{
serialListBox.Items.Clear();
serialListView.Clear();
numScannedLabel.Text = serialListBox.Items.Count.ToString();
numUnitsLabel.Text = "0";
if (validateInputTabs.SelectedTab == validateInputTabs.TabPages["VerifyTab"])
{
serialTextBox.Clear();
serialTextBox.Enabled = false;
caseTextBox.Enabled = false;
areaLocationBox.Enabled = true;
caseTextBox.Clear();
areaLocationBox.Clear();
areaLocationBox.Focus();
}
else
{
serialTextBox2.Clear();
serialTextBox2.Enabled = false;
caseTextBox2.Enabled = false;
areaLocationBox2.Enabled = true;
caseTextBox2.Clear();
areaLocationBox2.Clear();
areaLocationBox2.Focus();
}
}
else if (serialTextBox.Text.ToUpper() == "CLEARLIST" || serialTextBox2.Text.ToUpper() == "CLEARLIST")
{
serialListBox.Items.Clear();
serialListView.Clear();
numScannedLabel.Text = serialListBox.Items.Count.ToString();
numUnitsLabel.Text = "0";
if (validateInputTabs.SelectedTab == validateInputTabs.TabPages["VerifyTab"])
{
List <SerialInfo> list = MongoCRUD.GetInstance().LoadRecords <SerialInfo>("Serial", "caseID", caseTextBox.Text);
if (list.Count != 0)
{
numUnitsLabel.Text = list.Count.ToString();
foreach (SerialInfo item in list)
{
serialListView.Items.Add(item.serial);
}
}
serialTextBox.Clear();
serialTextBox.Focus();
}
else
{
serialTextBox2.Clear();
serialTextBox2.Focus();
}
}
else if (serialTextBox.Text.ToUpper() == "CLEARCASE" || serialTextBox2.Text.ToUpper() == "CLEARCASE")
{
serialListBox.Items.Clear();
serialListView.Clear();
numScannedLabel.Text = serialListBox.Items.Count.ToString();
numUnitsLabel.Text = "0";
if (validateInputTabs.SelectedTab == validateInputTabs.TabPages["VerifyTab"])
{
serialTextBox.Clear();
serialTextBox.Enabled = false;
caseTextBox.Enabled = true;
caseTextBox.Clear();
caseTextBox.Focus();
}
else
{
serialTextBox2.Clear();
serialTextBox2.Enabled = false;
caseTextBox2.Enabled = true;
caseTextBox2.Clear();
caseTextBox2.Focus();
}
}
else if (serialTextBox.Text.ToUpper() == "VALIDATE")
{
bool isBad = false;
List <SerialInfo> list = MongoCRUD.GetInstance().LoadRecords <SerialInfo>("Serial", "caseID", caseTextBox.Text);
List <string> serialList = new List <string>();
if (list.Count != 0)
{
foreach (SerialInfo serial in list)
{
serialList.Add(serial.serial);
}
foreach (string item in serialListBox.Items)
{
if (!serialList.Contains(item))
{
isBad = true;
}
}
}
if (isBad)
{
ShowDialog("Unable to commit case, try again", "Cannot Validate", false);
serialListBox.Items.Clear();
serialListView.Clear();
numScannedLabel.Text = serialListBox.Items.Count.ToString();
numUnitsLabel.Text = "0";
if (validateInputTabs.SelectedTab == validateInputTabs.TabPages["VerifyTab"])
{
serialTextBox.Clear();
serialTextBox.Enabled = false;
caseTextBox.Enabled = true;
caseTextBox.Clear();
caseTextBox.Focus();
}
}
else
{
foreach (string item in serialListBox.Items)
{
SerialInfo si = new SerialInfo();
si.serial = item;
LocationData d = new LocationData();
d.curCase = caseTextBox.Text;
d.date = DateTime.UtcNow.Date.ToString("MM/dd/yyyy");
d.time = DateTime.Now.ToString("h:mm:ss tt");
d.location = areaLocationBox.Text;
d.lastLocation = true;
d.userID = "311015";
si.locationData.Add(d);
if (MongoCRUD.GetInstance().RecordExists <SerialInfo>("Serial", item, "serial"))
{
MongoCRUD.GetInstance().AppendRecord <SerialInfo>("Serial", item, d);
}
}
CaseInfo ci = new CaseInfo();
ci.caseID = caseTextBox.Text;
ci.curLoc = areaLocationBox.Text;
ci.ageInfo = DateTime.Now.ToString("MM-dd-yyyy hh: mm tt");
MongoCRUD.GetInstance().InsertRecord("Cases", ci, caseTextBox.Text, null);
UpdateAreaLocCases(ci, areaComboBox.SelectedItem.ToString());
ShowDialog("Case Passed", "Case Validated", false);
serialListBox.Items.Clear();
serialListView.Clear();
serialTextBox.Clear();
numScannedLabel.Text = serialListBox.Items.Count.ToString();
numUnitsLabel.Text = "0";
serialTextBox.Enabled = false;
caseTextBox.Enabled = true;
caseTextBox.Clear();
caseTextBox.Focus();
}
}
else if (serialTextBox2.Text.ToUpper() == "ADD")
{
foreach (string item in serialListBox.Items)
{
SerialInfo si = new SerialInfo();
si.serial = item;
LocationData d = new LocationData();
d.curCase = caseTextBox2.Text;
d.date = DateTime.UtcNow.Date.ToString("MM/dd/yyyy");
d.time = DateTime.Now.ToString("h:mm:ss tt");
d.location = areaLocationBox2.Text;
d.lastLocation = true;
d.userID = "311015";
si.locationData.Add(d);
if (MongoCRUD.GetInstance().RecordExists <SerialInfo>("Serial", item, "serial"))
{
MongoCRUD.GetInstance().AppendRecord <SerialInfo>("Serial", item, d);
}
else
{
MongoCRUD.GetInstance().InsertRecord("Serial", si, item, caseTextBox2.Text);
}
}
CaseInfo ci = new CaseInfo();
ci.caseID = caseTextBox2.Text;
ci.curLoc = areaLocationBox2.Text;
ci.ageInfo = DateTime.Now.ToString("MM-dd-yyyy hh: mm tt");
MongoCRUD.GetInstance().InsertRecord("Cases", ci, caseTextBox2.Text, null);
UpdateAreaLocCases(ci, areaComboBox.SelectedItem.ToString());
serialListBox.Items.Clear();
serialListView.Clear();
serialTextBox2.Clear();
numScannedLabel.Text = serialListBox.Items.Count.ToString();
numUnitsLabel.Text = "0";
serialTextBox2.Enabled = false;
caseTextBox2.Enabled = true;
caseTextBox2.Clear();
caseTextBox2.Focus();
}
else
{
List <string> serialsList = new List <string>();
if (validateInputTabs.SelectedTab == validateInputTabs.TabPages["VerifyTab"])
{
serialListBox.Items.Add(serialTextBox.Text);
numScannedLabel.Text = serialListBox.Items.Count.ToString();
for (int i = 0; i < serialListView.Items.Count; i++)
{
serialsList.Add(serialListView.Items[i].Text);
if (serialTextBox.Text == serialListView.Items[i].Text)
{
serialListView.Items[i].BackColor = Color.Green;
}
}
if (!serialsList.Contains(serialTextBox.Text))
{
serialListView.Items.Add(serialTextBox.Text).BackColor = Color.Red;
}
serialTextBox.Clear();
serialTextBox.Focus();
}
else
{
serialListBox.Items.Add(serialTextBox2.Text);
numScannedLabel.Text = serialListBox.Items.Count.ToString();
for (int i = 0; i < serialListView.Items.Count; i++)
{
if (serialTextBox2.Text == serialListView.Items[i].Text)
{
serialListView.Items[i].BackColor = Color.Green;
}
}
serialTextBox2.Clear();
serialTextBox2.Focus();
}
}
}
}