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;
            }
        }
예제 #2
0
        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);
            }
        }
예제 #3
0
        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";
            }
        }
예제 #4
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);
            }
        }