public void UpdateRecord() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); if (UniformCL.GetUniformLaunderInfoByID(Convert.ToInt32(Double.Parse(ViewModel.lbLaunderID.Text))) != 0) { } else { ViewManager.ShowMessage("Oooops! Something is Wrong", "Where's the Laundry Record??", UpgradeHelpers.Helpers.BoxButtons.OK); return; } }
public void UpdateLaunderRecord() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand(); if (ViewModel.iLaunderID == 0) { return; } if (UniformCL.GetUniformLaunderInfoByID(ViewModel.iLaunderID) != 0) { //continue } else { ViewManager.ShowMessage("Oooops! Something went wrong Getting UniformLaunderInfo record." + " Call Debra Lewandowsky x5068.", "Error Getting UniformLaunderInfo", UpgradeHelpers.Helpers.BoxButtons.OK); } if (modGlobal.Clean(ViewModel.sDateApproved) == "") { ViewModel.sDateApproved = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); } UniformCL.UniformLaunderDateApproved = ViewModel.sDateApproved; UniformCL.UniformLaunderApprovedBy = modGlobal.Shared.gUser; UniformCL.UniformLaunderComment = modGlobal.Clean(ViewModel.sComment); if (UniformCL.UpdateUniformLaunderInfo() != 0) { //continue } else { ViewManager.ShowMessage("Oooops! Something went wrong Updating UniformLaunderInfo record." + " Call Debra Lewandowsky x5068.", "Error Updating UniformLaunderInfo", UpgradeHelpers.Helpers.BoxButtons.OK); } }
private void sprLaunderGrid_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs) { int Col = eventArgs.Column; int Row = eventArgs.Row; PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); PTSProject.clsTraining TrainCL = Container.Resolve <clsTraining>(); if (Row == 0) { return; } ViewModel.iCurrRow = Row; ViewModel.sprLaunderGrid.Row = ViewModel.iCurrRow; //ViewModel.sprLaunderGrid.SetSelection(1, ViewModel.iCurrRow, ViewModel.sprLaunderGrid.MaxCols, ViewModel.iCurrRow); ViewModel.sprLaunderGrid.Col = 4; if (modGlobal.Clean(ViewModel.sprLaunderGrid.Text) == "") { return; } else { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.lbLaunderID.Text = Convert.ToString(modGlobal.GetVal(ViewModel.sprLaunderGrid.Text)); } ViewModel.bAllowUpdate = false; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (UniformCL.GetUniformLaunderInfoByID(Convert.ToInt32(modGlobal.GetVal(ViewModel.lbLaunderID.Text))) != 0) { //continue } else { ViewManager.ShowMessage("Oooops! No Uniform Laundry/Cleaning ecord was found!", "Get Laundry/Cleaning Record", UpgradeHelpers.Helpers.BoxButtons.OK); return; } ViewModel.lbLaunderID.Text = UniformCL.UniformLaunderID.ToString(); if (UniformCL.UniformLaunderDateFlagged == "") { ViewManager.ShowMessage("Ooooops! Something is wrong! Call Debra Lewandowsky x5068.", "Missing Flagged Date!!", UpgradeHelpers.Helpers.BoxButtons.OK); return; } else { ViewModel.chkFlagged.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; ViewModel.dteDateFlagged.Text = UniformCL.UniformLaunderDateFlagged; ViewModel.dteDateFlagged.Visible = true; } if (UniformCL.UniformLaunderDateCleaned == "") { ViewModel.chkCleaned.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; ViewModel.dteDateCleaned.Visible = false; ViewModel.chkVendor.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; ViewModel.cboFlaggedBy.Visible = true; ViewModel.bAllowUpdate = true; } else { ViewModel.chkCleaned.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; ViewModel.dteDateCleaned.Text = UniformCL.UniformLaunderDateCleaned; ViewModel.dteDateCleaned.Visible = true; } for (int i = 0; i <= ViewModel.cboFlaggedBy.Items.Count - 1; i++) { if (ViewModel.cboFlaggedBy.GetListItem(i).Substring(Math.Max(ViewModel.cboFlaggedBy.GetListItem(i).Length - 5, 0)) == UniformCL.UniformLaunderFlaggedBy) { ViewModel.cboFlaggedBy.Text = ViewModel.cboFlaggedBy.GetListItem(i); break; } } if (UniformCL.UniformLaunderVendorCleaned == "N") { for (int i = 0; i <= ViewModel.cboCleanedBy.Items.Count - 1; i++) { if (ViewModel.cboCleanedBy.GetListItem(i).Substring(Math.Max(ViewModel.cboCleanedBy.GetListItem(i).Length - 5, 0)) == UniformCL.UniformLaunderCleanedBy) { ViewModel.cboCleanedBy.Text = ViewModel.cboCleanedBy.GetListItem(i); break; } } } else { ViewModel.chkVendor.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; ViewModel.cboCleanedBy.Visible = false; } ViewModel.txtComment.Text = UniformCL.UniformLaunderComment; ViewModel.txtLaundryComment.Text = UniformCL.UniformLaunderCleaningComments; string sEmployeeName = ""; if (UniformCL.UniformLaunderApprovedBy != "") { if (TrainCL.GetEmployee(UniformCL.UniformLaunderApprovedBy) != 0) { sEmployeeName = modGlobal.Clean(TrainCL.Employee["name_full"]); } } if (UniformCL.UniformLaunderDateApproved != "") { if (sEmployeeName != "") { ViewModel.chkApproved.Text = "PPE Item was cleared for use by " + sEmployeeName + " on " + UniformCL.UniformLaunderDateApproved; ViewModel.chkApproved.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; } else { ViewModel.chkApproved.Text = "PPE Item was cleared for use on " + UniformCL.UniformLaunderDateApproved; ViewModel.chkApproved.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; } } else { ViewModel.bAllowUpdate = true; ViewModel.chkApproved.Text = "PPE Item is ready for Use?"; ViewModel.chkApproved.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; } if (ViewModel.bAllowUpdate) { ViewModel.cmdEdit.Enabled = true; ViewModel.cmdEdit.Text = "Update"; ViewModel.cmdEdit.Tag = "0"; } else { ViewModel.cmdEdit.Enabled = false; ViewModel.cmdEdit.Text = "Update"; ViewModel.cmdEdit.Tag = "0"; } }
public void EditLaundryRecord() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); int RecordID = 0; if (modGlobal.Clean(ViewModel.lbLaunderID.Text) == "") { RecordID = 0; //The following fields have to be filled in or defaulted //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx UniformCL.UniformLaunderUniformID = Convert.ToInt32(modGlobal.GetVal(ViewModel.lbUniformID.Text)); if (ViewModel.chkFlagged.CheckState == UpgradeHelpers.Helpers.CheckState.Unchecked) { ViewModel.chkFlagged.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; ViewModel.dteDateFlagged.Text = DateTime.Now.ToString("MM/dd/yyyy"); ViewModel.dteDateFlagged.Visible = true; UniformCL.UniformLaunderFlaggedBy = modGlobal.Shared.gUser; UniformCL.UniformLaunderDateFlagged = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); } else { UniformCL.UniformLaunderDateFlagged = DateTime.Parse(ViewModel.dteDateFlagged.Text).ToString("M/d/yyyy"); if (ViewModel.cboFlaggedBy.SelectedIndex == -1) { UniformCL.UniformLaunderFlaggedBy = modGlobal.Shared.gUser; } else { UniformCL.UniformLaunderFlaggedBy = ViewModel.cboFlaggedBy.Text.Substring(Math.Max(ViewModel.cboFlaggedBy.Text.Length - 5, 0)); } } } else { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx RecordID = Convert.ToInt32(modGlobal.GetVal(ViewModel.lbLaunderID.Text)); if (UniformCL.GetUniformLaunderInfoByID(RecordID) != 0) { //continue... } else { ViewManager.ShowMessage("Ooooops! The UniformLaunderInfo record could not be found!", "Error Could not find Record for Update", UpgradeHelpers.Helpers.BoxButtons.OK); return; } } //edit the rest of the fields UniformCL.UniformLaunderComment = modGlobal.Clean(ViewModel.txtComment.Text); if (ViewModel.chkApproved.CheckState == UpgradeHelpers.Helpers.CheckState.Checked) { UniformCL.UniformLaunderDateApproved = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); UniformCL.UniformLaunderApprovedBy = modGlobal.Shared.gUser; } if (ViewModel.chkCleaned.CheckState == UpgradeHelpers.Helpers.CheckState.Checked) { UniformCL.UniformLaunderCleaningComments = modGlobal.Clean(ViewModel.txtLaundryComment.Text); UniformCL.UniformLaunderDateCleaned = DateTime.Parse(ViewModel.dteDateCleaned.Text).ToString("M/d/yyyy"); UniformCL.UniformLaunderCleanedBy = ""; UniformCL.UniformLaunderVendorCleaned = "N"; if (ViewModel.chkVendor.CheckState == UpgradeHelpers.Helpers.CheckState.Unchecked) { if (modGlobal.Clean(ViewModel.cboCleanedBy.Text) != "") { UniformCL.UniformLaunderCleanedBy = ViewModel.cboCleanedBy.Text.Substring(Math.Max(ViewModel.cboCleanedBy.Text.Length - 5, 0)); } } else { UniformCL.UniformLaunderVendorCleaned = "Y"; } } if (RecordID == 0) { //Add if (UniformCL.InsertUniformLaunderInfo() != 0) { RecordID = UniformCL.UniformLaunderID; } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Insert Laundry Record!", "Error Inserting UniformLaunderInfo", UpgradeHelpers.Helpers.BoxButtons.OK); } } else { //Update if (UniformCL.UpdateUniformLaunderInfo() != 0) { } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Update Laundry Record!", "Error Updating UniformLaunderInfo", UpgradeHelpers.Helpers.BoxButtons.OK); } } }
public void GetDetail() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); if (ViewModel.CurrRow == 0) { return; } ViewModel.lbLaunderID.Text = ""; ViewModel.sprList.Row = ViewModel.CurrRow; ViewModel.sprList.Col = 12; if (modGlobal.Clean(ViewModel.sprList.Text) == "") { ViewManager.ShowMessage("Oooops! Something is Wrong", "Where's the Launder ID??", UpgradeHelpers.Helpers.BoxButtons.OK); return; } else { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.lbLaunderID.Text = Convert.ToString(modGlobal.GetVal(ViewModel.sprList.Text)); } //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (UniformCL.GetUniformLaunderInfoByID(Convert.ToInt32(modGlobal.GetVal(ViewModel.lbLaunderID.Text))) != 0) { } else { ViewManager.ShowMessage("Oooops! Something is Wrong", "Where's the Laundry Record??", UpgradeHelpers.Helpers.BoxButtons.OK); return; } ViewModel.txtPPEInfo.Text = ""; string sText = "PPE Info: "; ViewModel.sprList.Col = 5; //Brand if (modGlobal.Clean(ViewModel.sprList.Text) != "") { sText = sText + modGlobal.Clean(ViewModel.sprList.Text) + " "; } ViewModel.sprList.Col = 2; //Type if (modGlobal.Clean(ViewModel.sprList.Text) != "") { sText = sText + modGlobal.Clean(ViewModel.sprList.Text) + " "; } else { sText = sText + "Item "; } ViewModel.sprList.Col = 3; //Tracking # if (modGlobal.Clean(ViewModel.sprList.Text) != "") { sText = sText + "- " + modGlobal.Clean(ViewModel.sprList.Text) + "; "; } ViewModel.sprList.Col = 1; //Station if (modGlobal.Clean(ViewModel.sprList.Text) != "") { sText = sText + "Located at Station " + modGlobal.Clean(ViewModel.sprList.Text) + ". "; } else { ViewModel.sprList.Col = 7; if (modGlobal.Clean(ViewModel.sprList.Text) != "") { sText = sText + "Issued to " + modGlobal.Clean(ViewModel.sprList.Text); ViewModel.sprList.Col = 6; if (modGlobal.Clean(ViewModel.sprList.Text) != "") { sText = sText + " on " + modGlobal.Clean(ViewModel.sprList.Text) + ". "; } else { sText = sText + ". "; } } } sText = sText + "Was flagged for cleaning on " + UniformCL.UniformLaunderDateFlagged; if (UniformCL.UniformLaunderComment == "") { sText = sText + "."; } else { sText = sText + " - " + UniformCL.UniformLaunderComment + "."; } ViewModel.txtPPEInfo.Text = sText; ViewModel.cmdUpdate.Enabled = true; }
internal void cmdUpdate_Click(Object eventSender, System.EventArgs eventArgs) { // MsgBox "This feature is under construction.", vbOKOnly, "Updating Laundry Info" PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); if (modGlobal.Clean(ViewModel.lbLaunderID.Text) == "") { return; } //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (UniformCL.GetUniformLaunderInfoByID(Convert.ToInt32(modGlobal.GetVal(ViewModel.lbLaunderID.Text))) != 0) { } else { ViewManager.ShowMessage("Oooops! Something is Wrong... Record Not Found", "Where's the Laundry Record??", UpgradeHelpers.Helpers.BoxButtons.OK); return; } //edit the rest of the fields if (ViewModel.chkApproveItem.CheckState == UpgradeHelpers.Helpers.CheckState.Checked) { UniformCL.UniformLaunderDateApproved = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); UniformCL.UniformLaunderApprovedBy = modGlobal.Shared.gUser; } else { UniformCL.UniformLaunderDateApproved = ""; UniformCL.UniformLaunderApprovedBy = ""; } UniformCL.UniformLaunderCleaningComments = modGlobal.Clean(ViewModel.txtLaundryComment.Text); UniformCL.UniformLaunderDateCleaned = DateTime.Parse(ViewModel.dteDateCleaned.Text).ToString("M/d/yyyy"); UniformCL.UniformLaunderCleanedBy = ""; UniformCL.UniformLaunderVendorCleaned = "N"; if (ViewModel.chkVendor.CheckState == UpgradeHelpers.Helpers.CheckState.Unchecked) { if (modGlobal.Clean(ViewModel.cboName.Text) != "") { UniformCL.UniformLaunderCleanedBy = ViewModel.cboName.Text.Substring(Math.Max(ViewModel.cboName.Text.Length - 5, 0)); } } else { UniformCL.UniformLaunderVendorCleaned = "Y"; } if (UniformCL.UpdateUniformLaunderInfo() != 0) { // dteDateCleaned.Text = Format$(Now(), "m/d/yyyy") // cboName.Text = "" // cboName.ListIndex = -1 // txtLaundryComment.Text = "" // chkvendor.Value = 0 // cboName.Visible = True ViewModel.txtPPEInfo.Text = ""; ViewModel.lbLaunderID.Text = ""; ViewModel.cmdUpdate.Enabled = false; FillGrid(); } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Update Laundry Record!", "Error Updating UniformLaunderInfo", UpgradeHelpers.Helpers.BoxButtons.OK); } }