//Dim UniformType As Integer public void AddLaunderRecord() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); UniformCL.UniformLaunderUniformID = ViewModel.iUniformID; UniformCL.UniformLaunderDateFlagged = ViewModel.sDateFlagged; UniformCL.UniformLaunderFlaggedBy = modGlobal.Shared.gUser; UniformCL.UniformLaunderDateApproved = ViewModel.sDateApproved; if (modGlobal.Clean(ViewModel.sDateApproved) == "") { UniformCL.UniformLaunderApprovedBy = ""; } else { UniformCL.UniformLaunderApprovedBy = modGlobal.Shared.gUser; } UniformCL.UniformLaunderComment = modGlobal.Clean(ViewModel.sComment); //these fields will be blank UniformCL.UniformLaunderDateCleaned = ""; UniformCL.UniformLaunderCleanedBy = ""; UniformCL.UniformLaunderCleaningComments = ""; if (UniformCL.InsertUniformLaunderInfo() != 0) { //continue } else { ViewManager.ShowMessage("Oooops! Something went wrong inserting UniformLaunderInfo record." + " Call Debra Lewandowsky x5068.", "Error Inserting UniformLaunderInfo", UpgradeHelpers.Helpers.BoxButtons.OK); } }
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; } }
//Dim UniformType As Integer public void DetermineSecurity() { PTSProject.clsUniform cUniform = Container.Resolve <clsUniform>(); ViewModel.NoLimitUpdate = false; if (modGlobal.Shared.gSecurity == "ADM") { ViewModel.NoLimitUpdate = true; return; } if (cUniform.GetPPEInfoForSecurity(modGlobal.Shared.gUser) != 0) { ViewModel.NoLimitUpdate = true; } }
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); } }
public void GetEmployeeUniformSizeDetail() { PTSProject.clsUniform cUniform = Container.Resolve <clsUniform>(); if (ViewModel.sprUniformList.DataRowCnt == 0) { return; } if (ViewModel.CurrEmpID == "") { return; } if (ViewModel.cboUniformItem.SelectedIndex == -1) { return; } ViewModel.lbRecordID.Text = ""; int iItemType = ViewModel.cboUniformItem.GetItemData(ViewModel.cboUniformItem.SelectedIndex); if (cUniform.GetPersonnelUniformSizesByEmpItem(ViewModel.CurrEmpID, iItemType) != 0) { //continue } else { ViewModel.cmdEditUniformSize.Text = "Add"; ViewModel.cmdEditUniformSize.Tag = "1"; ViewModel.cmdEditUniformSize.Enabled = modGlobal.Clean(ViewModel.txtItemSizeDesc.Text) != ""; return; } ViewModel.lbRecordID.Text = cUniform.PersonnelUniformSizesID.ToString(); ViewModel.dteDateSized.Value = DateTime.Parse(cUniform.PersonnelUniformSizesDateSized); ViewModel.txtItemSizeDesc.Text = cUniform.PersonnelUniformSizesSizeDescription; ViewModel.cmdEditUniformSize.Text = "Update"; ViewModel.cmdEditUniformSize.Tag = "0"; ViewModel.cmdEditUniformSize.Enabled = true; }
public void EditEmployeeBunkerSizeInfo() { PTSProject.clsUniform cUniform = Container.Resolve <clsUniform>(); bool RecordExists = false; if (ViewModel.CurrEmpID == "") { return; } if (cUniform.GetUniformEmployeePPESizesByID(ViewModel.CurrEmpID) != 0) { RecordExists = true; } else { RecordExists = false; cUniform.EmployeeUniformSizeEmployeeID = ViewModel.CurrEmpID; } if (ViewModel.chkInDate.CheckState == UpgradeHelpers.Helpers.CheckState.Unchecked) { cUniform.EmployeeUniformSizeInDate = ""; } else { cUniform.EmployeeUniformSizeInDate = DateTime.Parse(ViewModel.dteInDate.Text).ToString("MM/dd/yyyy"); } if (ViewModel.cboPantSize.SelectedIndex == -1) { cUniform.EmployeeUniformSizePantSizeCode = 0; cUniform.EmployeeUniformSizePantSizeDesc = ""; } else { cUniform.EmployeeUniformSizePantSizeCode = ViewModel.cboPantSize.GetItemData(ViewModel.cboPantSize.SelectedIndex); cUniform.EmployeeUniformSizePantSizeDesc = modGlobal.Clean(ViewModel.cboPantSize.Text); } cUniform.EmployeeUniformSizeCoatSpreadDesc = modGlobal.Clean(ViewModel.txtCoatSizeDesc.Text); if (ViewModel.cboCoatSize.SelectedIndex == -1) { cUniform.EmployeeUniformSizeCoatSizeCode = 0; cUniform.EmployeeUniformSizeCoatSizeDesc = ""; } else { cUniform.EmployeeUniformSizeCoatSizeCode = ViewModel.cboCoatSize.GetItemData(ViewModel.cboCoatSize.SelectedIndex); cUniform.EmployeeUniformSizeCoatSizeDesc = modGlobal.Clean(ViewModel.cboCoatSize.Text); } cUniform.EmployeeUniformSizeBootSpreadDesc = modGlobal.Clean(ViewModel.txtBootSizeDesc.Text); if (ViewModel.cboBootSize.SelectedIndex == -1) { cUniform.EmployeeUniformSizeBootSizeCode = 0; cUniform.EmployeeUniformSizeBootSizeDesc = ""; } else { cUniform.EmployeeUniformSizeBootSizeCode = ViewModel.cboBootSize.GetItemData(ViewModel.cboBootSize.SelectedIndex); cUniform.EmployeeUniformSizeBootSizeDesc = modGlobal.Clean(ViewModel.cboBootSize.Text); } if (ViewModel.cboBootBrand.SelectedIndex == -1) { cUniform.EmployeeUniformSizeBootManufID = 0; cUniform.EmployeeUniformSizeBootManufDesc = ""; } else { cUniform.EmployeeUniformSizeBootManufID = ViewModel.cboBootBrand.GetItemData(ViewModel.cboBootBrand.SelectedIndex); cUniform.EmployeeUniformSizeBootManufDesc = modGlobal.Clean(ViewModel.cboBootBrand.Text); } if (ViewModel.cboGloveSize.SelectedIndex == -1) { cUniform.EmployeeUniformSizeGloveSizeCode = 0; cUniform.EmployeeUniformSizeGloveSizeDesc = ""; } else { cUniform.EmployeeUniformSizeGloveSizeCode = ViewModel.cboGloveSize.GetItemData(ViewModel.cboGloveSize.SelectedIndex); cUniform.EmployeeUniformSizeGloveSizeDesc = modGlobal.Clean(ViewModel.cboGloveSize.Text); } if (RecordExists) { if (cUniform.UpdateUniformEmployeePPESizes() != 0) { FillBunkerGrid(); FindEmployee(); } else { ViewManager.ShowMessage("Oooops! Error updating UniformEmployeePPESizes.", "Error Updating UniformEmployeePPESizes", UpgradeHelpers.Helpers.BoxButtons.OK); } } else { if (cUniform.InsertUniformEmployeePPESizes() != 0) { FillBunkerGrid(); FindEmployee(); } else { ViewManager.ShowMessage("Oooops! Error adding UniformEmployeePPESizes.", "Error Adding UniformEmployeePPESizes", 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); } }
public void EditRepairRecord() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); int RecordID = 0; if (modGlobal.Clean(ViewModel.lbRepairID.Text) == "") { RecordID = 0; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx UniformCL.UniformRepairUniformID = Convert.ToInt32(modGlobal.GetVal(ViewModel.lbUniformID.Text)); } 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.lbRepairID.Text)); if (UniformCL.GetUniformRepairByID(RecordID) != 0) { //continue... } else { ViewManager.ShowMessage("Ooooops! The UniformRepair record could not be found!", "Error Could not find Record for Update", UpgradeHelpers.Helpers.BoxButtons.OK); return; } } //edit the rest of the fields if (ViewModel.chkDateIn.CheckState == UpgradeHelpers.Helpers.CheckState.Checked) { UniformCL.UniformRepairDateIn = DateTime.Parse(ViewModel.dteDateIn.Text).ToString("M/d/yyyy"); } else { UniformCL.UniformRepairDateIn = ""; } if (ViewModel.chkDateOut.CheckState == UpgradeHelpers.Helpers.CheckState.Checked) { UniformCL.UniformRepairDateOut = DateTime.Parse(ViewModel.dteDateOut.Text).ToString("M/d/yyyy"); } else { UniformCL.UniformRepairDateOut = ""; } UniformCL.UniformRepairComment = modGlobal.Clean(ViewModel.txtComment.Text); if (ViewModel.cboRepairer.SelectedIndex == -1) { UniformCL.UniformRepairerID = 0; } else { UniformCL.UniformRepairerID = ViewModel.cboRepairer.GetItemData(ViewModel.cboRepairer.SelectedIndex); } if (RecordID == 0) { //Add if (UniformCL.InsertUniformRepair() != 0) { RecordID = UniformCL.UniformRepairID; } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Insert Repair Record!", "Error Inserting UniformRepair", UpgradeHelpers.Helpers.BoxButtons.OK); } } else { //Update if (UniformCL.UpdateUniformRepair() != 0) { } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Update Repair Record!", "Error Updating UniformRepair", UpgradeHelpers.Helpers.BoxButtons.OK); } } if (!ViewModel.LaundryRecordExists) { if (ViewModel.chkVendor.CheckState == UpgradeHelpers.Helpers.CheckState.Checked) { //proceed //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)); //default dates to now UniformCL.UniformLaunderDateFlagged = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); UniformCL.UniformLaunderDateApproved = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); UniformCL.UniformLaunderDateCleaned = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); //default flagged by to current user UniformCL.UniformLaunderFlaggedBy = modGlobal.Shared.gUser; UniformCL.UniformLaunderApprovedBy = modGlobal.Shared.gUser; UniformCL.UniformLaunderCleanedBy = ""; UniformCL.UniformLaunderVendorCleaned = "Y"; UniformCL.UniformLaunderComment = "Item was IN for cleaning ON: " + UniformCL.UniformRepairDateIn + "; "; UniformCL.UniformLaunderComment = UniformCL.UniformLaunderComment + " OUT ON: " + UniformCL.UniformRepairDateOut + "; "; UniformCL.UniformLaunderCleaningComments = "Item was cleaned by Vendor while in for repairs."; if (UniformCL.InsertUniformLaunderInfo() != 0) { if (UniformCL.InsertUniformRepairLaunderInfo() != 0) { //success } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Insert UniformRepairLaunderInfo. Call Debra Lewandowsky x5068." , "Insert UniformRepairLaunderInfo Record", UpgradeHelpers.Helpers.BoxButtons.OK); } } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Insert UniformLaunderInfo. Call Debra Lewandowsky x5068.", "Insert UniformLaunderInfo Record" , UpgradeHelpers.Helpers.BoxButtons.OK); } } } }
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 FillLaunderGrid() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); if (UniformCL.GetPPELaundryInfoHistoryByItem(modGlobal.Shared.gUniformID) != 0) { //continue } else { ViewManager.ShowMessage("This Item has no Laundry/Cleaning History.", "Uniform Laundry/Cleaning History", UpgradeHelpers.Helpers.BoxButtons.OK); return; } //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread method sprLaunderGrid.ClearRange was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprLaunderGrid.ClearRange(1, 1, ViewModel.sprLaunderGrid.MaxCols, ViewModel.sprLaunderGrid.MaxRows, false); ViewModel.iCurrRow = 0; while (!UniformCL.UniformLaundry.EOF) { (ViewModel.iCurrRow)++; ViewModel.sprLaunderGrid.Row = ViewModel.iCurrRow; ViewModel.sprLaunderGrid.Col = 1; ViewModel.sprLaunderGrid.Text = Convert.ToDateTime(UniformCL.UniformLaundry["date_flagged"]).ToString("M/d/yyyy") + " - " + modGlobal.Clean(UniformCL.UniformLaundry["FlaggedBy"]); ViewModel.sprLaunderGrid.Col = 3; if (modGlobal.Clean(UniformCL.UniformLaundry["date_approved"]) == "") { ViewModel.sprLaunderGrid.Text = ""; } else { ViewModel.sprLaunderGrid.Text = Convert.ToDateTime(UniformCL.UniformLaundry["date_approved"]).ToString("M/d/yyyy") + " - " + modGlobal.Clean(UniformCL.UniformLaundry["ApprovedBy"]); } ViewModel.sprLaunderGrid.Col = 2; if (modGlobal.Clean(UniformCL.UniformLaundry["date_cleaned"]) == "") { ViewModel.sprLaunderGrid.Text = ""; } else { if (modGlobal.Clean(UniformCL.UniformLaundry["vendor_cleaned"]) == "N") { ViewModel.sprLaunderGrid.Text = Convert.ToDateTime(UniformCL.UniformLaundry["date_cleaned"]).ToString("M/d/yyyy") + " - " + modGlobal.Clean(UniformCL.UniformLaundry["CleanedBy"]); } else { ViewModel.sprLaunderGrid.Text = Convert.ToDateTime(UniformCL.UniformLaundry["date_cleaned"]).ToString("M/d/yyyy") + " - Vendor Cleaned"; } } ViewModel.sprLaunderGrid.Col = 4; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.sprLaunderGrid.Text = Convert.ToString(modGlobal.GetVal(UniformCL.UniformLaundry["launder_id"])); if (modGlobal.Clean(UniformCL.UniformLaundry["comment"]) != "") { ViewModel.sprLaunderGrid.TextTip = FarPoint.ViewModels.TextTipPolicy.Floating; ViewModel.sprLaunderGrid.Col = 1; ViewModel.sprLaunderGrid.CellNoteIndicator = true; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprLaunderGrid.CellNote was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprLaunderGrid.CellNote = modGlobal.Clean(UniformCL.UniformLaundry["comment"]); } if (modGlobal.Clean(UniformCL.UniformLaundry["laundry_comment"]) != "") { ViewModel.sprLaunderGrid.TextTip = FarPoint.ViewModels.TextTipPolicy.Floating; ViewModel.sprLaunderGrid.Col = 2; ViewModel.sprLaunderGrid.CellNoteIndicator = true; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprLaunderGrid.CellNote was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprLaunderGrid.CellNote = modGlobal.Clean(UniformCL.UniformLaundry["laundry_comment"]); } UniformCL.UniformLaundry.MoveNext(); } ; }
public void AddRepairRecord() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); PTSProject.clsUniform clUniform = Container.Resolve <clsUniform>(); UniformCL.UniformRepairUniformID = ViewModel.iUniformID; UniformCL.UniformRepairerID = ViewModel.iRepairerID; //If Uniform Repair/Launder record exists... then don't create another one... if (ViewModel.CreateLaunderRecord) { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (clUniform.GetUniformRepairLaunderInfoByID(Convert.ToInt32(modGlobal.GetVal(ViewModel.iRepairID))) != 0) { ViewModel.CreateLaunderRecord = false; } } if (ViewModel.sDateIn == "") { UniformCL.UniformRepairDateIn = ""; } else { System.DateTime TempDate = DateTime.FromOADate(0); UniformCL.UniformRepairDateIn = (DateTime.TryParse(ViewModel.sDateIn, out TempDate)) ? TempDate.ToString("M/d/yyyy") : ViewModel.sDateIn; } if (ViewModel.sDateOut == "") { UniformCL.UniformRepairDateOut = ""; } else { System.DateTime TempDate2 = DateTime.FromOADate(0); UniformCL.UniformRepairDateOut = (DateTime.TryParse(ViewModel.sDateOut, out TempDate2)) ? TempDate2.ToString("M/d/yyyy") : ViewModel.sDateOut; } UniformCL.UniformRepairComment = modGlobal.Clean(ViewModel.sComment); if (ViewModel.iRepairID == 0) { if (UniformCL.InsertUniformRepair() != 0) { //continue } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Insert Repair Record. Call Debra Lewandowsky x5068.", "Inserting UniformRepair Record" , UpgradeHelpers.Helpers.BoxButtons.OK); } } else { UniformCL.UniformRepairID = ViewModel.iRepairID; if (UniformCL.UpdateUniformRepair() != 0) { //continue } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Update Repair Record. Call Debra Lewandowsky x5068.", "Update UniformRepair Record", UpgradeHelpers.Helpers.BoxButtons.OK); } } if (ViewModel.CreateLaunderRecord) { UniformCL.UniformLaunderUniformID = ViewModel.iUniformID; //default dates to now UniformCL.UniformLaunderDateFlagged = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); UniformCL.UniformLaunderDateApproved = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); UniformCL.UniformLaunderDateCleaned = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); //default flagged by to current user UniformCL.UniformLaunderFlaggedBy = modGlobal.Shared.gUser; UniformCL.UniformLaunderApprovedBy = modGlobal.Shared.gUser; UniformCL.UniformLaunderCleanedBy = ""; UniformCL.UniformLaunderVendorCleaned = "Y"; UniformCL.UniformLaunderComment = "Item was IN for cleaning ON: " + UniformCL.UniformRepairDateIn + "; "; UniformCL.UniformLaunderComment = UniformCL.UniformLaunderComment + " OUT ON: " + UniformCL.UniformRepairDateOut + "; "; UniformCL.UniformLaunderCleaningComments = "Item was cleaned by Vendor while in for repairs."; if (UniformCL.InsertUniformLaunderInfo() != 0) { if (UniformCL.InsertUniformRepairLaunderInfo() != 0) { //success } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Insert UniformRepairLaunderInfo. Call Debra Lewandowsky x5068." , "Insert UniformRepairLaunderInfo Record", UpgradeHelpers.Helpers.BoxButtons.OK); } } else { ViewManager.ShowMessage("Oooops! Something went wrong when trying to Insert UniformLaunderInfo. Call Debra Lewandowsky x5068.", "Insert UniformLaunderInfo Record" , UpgradeHelpers.Helpers.BoxButtons.OK); } } }
public void FillGrid() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); int iType = 0; int iStation = 0; string sName = ""; string sOrder = ""; string sStyle = ""; string sColor = ""; string sLength = ""; string sSleeve = ""; string sDate = ""; string sChstWaist = ""; ViewModel.sHeadingFilter = "List Filtered by: "; int CurrRow = 0; ViewModel.sprList.MaxRows = 5000; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread method sprList.ClearRange was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprList.ClearRange(1, 1, ViewModel.sprList.MaxCols, ViewModel.sprList.MaxRows, false); if (ViewModel.cboType.SelectedIndex != -1) { iType = ViewModel.cboType.GetItemData(ViewModel.cboType.SelectedIndex); ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + modGlobal.Clean(ViewModel.cboType.Text) + "; "; } if (modGlobal.Clean(ViewModel.cboStation.Text) != "") { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx iStation = Convert.ToInt32(modGlobal.GetVal(ViewModel.cboStation.Text)); ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Station = " + modGlobal.Clean(ViewModel.cboStation.Text) + "; "; } sName = modGlobal.Clean(Strings.Replace(ViewModel.txtNameSearch.Text, "'", "''", 1, -1, CompareMethod.Binary)); if (sName != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Name like " + sName + "; "; } sChstWaist = modGlobal.Clean(ViewModel.cboChstWaist.Text); if (sChstWaist != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Chst/Waist = " + sChstWaist + "; "; } sLength = modGlobal.Clean(ViewModel.cboLength.Text); if (sLength != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Length = " + sLength + "; "; } sSleeve = modGlobal.Clean(ViewModel.cboSleeve.Text); if (sSleeve != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Sleeve Length = " + sSleeve + "; "; } sDate = modGlobal.Clean(ViewModel.cboManufDate.Text); if (sDate != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Manuf Date = " + sDate + "; "; } sColor = modGlobal.Clean(ViewModel.cboColor.Text); if (sColor != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Color = " + sColor + "; "; } sOrder = modGlobal.Clean(ViewModel.cboOrder.Text); if (sOrder != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Order # = " + sOrder + "; "; } sStyle = modGlobal.Clean(ViewModel.cboStyle.Text); if (sStyle != "") { ViewModel.sHeadingFilter = ViewModel.sHeadingFilter + "Style # = " + sStyle + "; "; } if (~UniformCL.GetUniformGlobeList(iType, iStation, sName, sOrder, sStyle, sColor, sLength, sSleeve, sDate, sChstWaist) != 0) { ViewManager.ShowMessage("There is no Globe Uniforms returned. Clear Filters and try again.", "Get Globe Uniform Data", UpgradeHelpers.Helpers.BoxButtons.OK); return; } while (!UniformCL.Uniform.EOF) { CurrRow++; ViewModel.sprList.Row = CurrRow; ViewModel.sprList.Col = 1; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["co"]); ViewModel.sprList.Col = 2; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["description"]); ViewModel.sprList.Col = 3; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["serial_number"]); ViewModel.sprList.Col = 4; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["order_number"]); ViewModel.sprList.Col = 5; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["color"]); ViewModel.sprList.Col = 6; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["chst_waist_size"]); ViewModel.sprList.Col = 7; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["length"]); ViewModel.sprList.Col = 8; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["sleeve_length"]); ViewModel.sprList.Col = 9; ViewModel.sprList.Text = Convert.ToDateTime(UniformCL.Uniform["manufactured_date"]).ToString("M/d/yyyy"); ViewModel.sprList.Col = 10; ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["style_number"]); if (modGlobal.Clean(UniformCL.Uniform["style_description"]) != "") { ViewModel.sprList.TextTip = FarPoint.ViewModels.TextTipPolicy.Floating; ViewModel.sprList.CellNoteIndicator = true; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprList.CellNote was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprList.CellNote = modGlobal.Clean(UniformCL.Uniform["style_description"]); } ViewModel.sprList.Col = 11; if (modGlobal.Clean(UniformCL.Uniform["name_full"]) == "") { if (modGlobal.Clean(UniformCL.Uniform["station"]) == "") { ViewModel.sprList.Text = "???"; } else { ViewModel.sprList.Text = "Station " + modGlobal.Clean(UniformCL.Uniform["station"]); } } else { ViewModel.sprList.Text = modGlobal.Clean(UniformCL.Uniform["name_full"]); } ViewModel.sprList.Col = 12; if (modGlobal.Clean(UniformCL.Uniform["retired_date"]) == "") { if (modGlobal.Clean(UniformCL.Uniform["issued_date"]) == "") { ViewModel.sprList.Text = ""; } else { ViewModel.sprList.Text = Convert.ToDateTime(UniformCL.Uniform["issued_date"]).ToString("M/d/yyyy"); ViewModel.sprList.TextTip = FarPoint.ViewModels.TextTipPolicy.Floating; ViewModel.sprList.CellNoteIndicator = true; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprList.CellNote was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprList.CellNote = "Issued"; } } else { ViewModel.sprList.Text = Convert.ToDateTime(UniformCL.Uniform["retired_date"]).ToString("M/d/yyyy"); ViewModel.sprList.TextTip = FarPoint.ViewModels.TextTipPolicy.Floating; ViewModel.sprList.CellNoteIndicator = true; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread property sprList.CellNote was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprList.CellNote = "Retired"; } UniformCL.Uniform.MoveNext(); } ; ViewModel.lbCount.Text = "Total Count: " + ViewModel.sprList.DataRowCnt.ToString(); ViewModel.sprList.MaxRows = ViewModel.sprList.DataRowCnt; }
public void AddPPEUniform() { PTSProject.clsUniform cUniform = Container.Resolve <clsUniform>(); DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand(); ADORecordSetHelper oRec = null; string strSQL = ""; try { if (ViewModel.CurrRow == 0) { return; } ViewModel.sprPPEList.Row = ViewModel.CurrRow; oCmd.Connection = modGlobal.oConn; oCmd.CommandType = CommandType.Text; cUniform.UniformType = ViewModel.CurrRow; cUniform.UniformRetiredDate = ""; ViewModel.sprPPEList.Col = 4; cUniform.UniformTrackingNumber = modGlobal.Clean(ViewModel.sprPPEList.Text); cUniform.UniformColorType = 0; cUniform.UniformSizeType = 0; ViewModel.sprPPEList.Col = 3; //Size or Color if (modGlobal.Clean(ViewModel.sprPPEList.Text) != "") { if (ViewModel.CurrRow != 3) { //Size... Only Helmets have color strSQL = "Select size_type From UniformSizeCode Where description = '" + modGlobal.Clean(ViewModel.sprPPEList.Text) + "'"; oCmd.CommandText = strSQL; oRec = ADORecordSetHelper.Open(oCmd, ""); if (!oRec.EOF) { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx cUniform.UniformSizeType = Convert.ToInt32(modGlobal.GetVal(oRec["size_type"])); } } else { //Color strSQL = "Select color_type From UniformColorCode Where description = '" + modGlobal.Clean(ViewModel.sprPPEList.Text) + "'"; oCmd.CommandText = strSQL; oRec = ADORecordSetHelper.Open(oCmd, ""); if (!oRec.EOF) { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx cUniform.UniformColorType = Convert.ToInt32(modGlobal.GetVal(oRec["color_type"])); } } } cUniform.UniformManufacturerID = 0; ViewModel.sprPPEList.Col = 2; //Manufacturer if (modGlobal.Clean(ViewModel.sprPPEList.Text) != "") { strSQL = "Select manufacturer_id From UniformManufacturer Where manufacturer_name = '" + modGlobal.Clean(ViewModel.sprPPEList.Text) + "'"; oCmd.CommandText = strSQL; oRec = ADORecordSetHelper.Open(oCmd, ""); if (!oRec.EOF) { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx cUniform.UniformManufacturerID = Convert.ToInt32(modGlobal.GetVal(oRec["manufacturer_id"])); } } ViewModel.sprPPEList.Col = 5; if (modGlobal.Clean(ViewModel.sprPPEList.Text) == "") { cUniform.UniformManufacturedDate = ""; } else if (((int)DateAndTime.DateDiff("d", DateTime.Now, DateTime.Parse(ViewModel.sprPPEList.Text), FirstDayOfWeek.Sunday, FirstWeekOfYear.Jan1)) > 0) { ViewManager.ShowMessage("Manufactured Date can not be in the future.", "Manufactured Date Error", UpgradeHelpers.Helpers.BoxButtons.OK); return; } else { cUniform.UniformManufacturedDate = DateTime.Parse(ViewModel.sprPPEList.Text).ToString("MM/dd/yyyy"); } if (cUniform.InsertUniform() != 0) { cUniform.PersUniformID = cUniform.UniformID; cUniform.PersUniformEmpID = ViewModel.EmployeeID; ViewModel.sprPPEList.Col = 1; if (modGlobal.Clean(ViewModel.sprPPEList.Text) != "") { if (((int)DateAndTime.DateDiff("d", DateTime.Now, DateTime.Parse(DateTime.Parse(ViewModel.sprPPEList.Text).ToString("M/d/yyyy")), FirstDayOfWeek.Sunday, FirstWeekOfYear.Jan1)) > 0) { ViewManager.ShowMessage("Issued Date can not be in the future.", "Issued Date Error", UpgradeHelpers.Helpers.BoxButtons.OK); return; } else { cUniform.PersUniformIssuedDate = DateTime.Parse(ViewModel.sprPPEList.Text).ToString("M/d/yyyy"); } } else { cUniform.PersUniformIssuedDate = DateTime.Now.ToString("M/d/yyyy"); } if (cUniform.InsertPersonnelUniform() != 0) { //continue } else { ViewModel.sprPPEList.Col = 0; ViewManager.ShowMessage("Ooops! The " + modGlobal.Clean(ViewModel. sprPPEList.Text) + " PersonnelUniform Record was not added. " + "Please call Debra Lewandowsky x5068. Thanks.", "Insert PersonnelUniform Error", UpgradeHelpers.Helpers.BoxButtons.OK); } } else { ViewModel.sprPPEList.Col = 0; ViewManager.ShowMessage("Ooops! The " + modGlobal.Clean(ViewModel. sprPPEList.Text) + " Uniform Record was not added. " + "Please call Debra Lewandowsky x5068. Thanks.", "Insert Uniform Error", UpgradeHelpers.Helpers.BoxButtons.OK); } } catch { if (modGlobal.ErrorControl() == modGlobal.eFATALERROR) { return; } } }
private void sprRepairGrid_CellClick(object eventSender, Stubs._FarPoint.Win.Spread.CellClickEventArgs eventArgs) { int Col = eventArgs.Column; int Row = eventArgs.Row; PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); if (Row == 0) { return; } ViewModel.iCurrRow = Row; ViewModel.sprRepairGrid.Row = ViewModel.iCurrRow; //ViewModel.sprRepairGrid.SetSelection(1, ViewModel.iCurrRow, ViewModel.sprRepairGrid.MaxCols, ViewModel.iCurrRow); ViewModel.sprRepairGrid.Col = 6; if (modGlobal.Clean(ViewModel.sprRepairGrid.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.lbRepairID.Text = Convert.ToString(modGlobal.GetVal(ViewModel.sprRepairGrid.Text)); } //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (UniformCL.GetUniformRepairByID(Convert.ToInt32(modGlobal.GetVal(ViewModel.lbRepairID.Text))) != 0) { //continue } else { ViewManager.ShowMessage("Oooops! No Uniform Repair Record was found!", "Get Repair Record", UpgradeHelpers.Helpers.BoxButtons.OK); return; } ViewModel.lbRepairID.Text = UniformCL.UniformRepairID.ToString(); if (UniformCL.UniformRepairDateIn == "") { ViewModel.dteDateIn.Visible = false; ViewModel.chkDateIn.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; } else { ViewModel.chkDateIn.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; ViewModel.dteDateIn.Visible = true; ViewModel.dteDateIn.Text = UniformCL.UniformRepairDateIn; } if (UniformCL.UniformRepairDateOut == "") { ViewModel.dteDateOut.Visible = false; ViewModel.chkDateOut.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; } else { ViewModel.chkDateOut.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; ViewModel.dteDateOut.Visible = true; ViewModel.dteDateOut.Text = UniformCL.UniformRepairDateOut; } for (int i = 0; i <= ViewModel.cboRepairer.Items.Count - 1; i++) { if (ViewModel.cboRepairer.GetItemData(i) == UniformCL.UniformRepairerID) { ViewModel.cboRepairer.SelectedIndex = i; break; } } ViewModel.txtComment.Text = UniformCL.UniformRepairComment; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (UniformCL.GetUniformRepairLaunderInfoByID(Convert.ToInt32(modGlobal.GetVal(ViewModel.lbRepairID.Text))) != 0) { ViewModel.chkVendor.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; ViewModel.chkVendor.Enabled = false; ViewModel.LaundryRecordExists = true; } else { ViewModel.chkVendor.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; ViewModel.chkVendor.Enabled = true; ViewModel.LaundryRecordExists = false; } ViewModel.cmdEdit.Text = "Update"; ViewModel.cmdEdit.Tag = "0"; ViewModel.cmdEdit.Enabled = true; }
public void EditEmployeeUniformSizeDetail() { PTSProject.clsUniform cUniform = Container.Resolve <clsUniform>(); int lRecordID = 0; // MsgBox "This feature is under construction!", vbOKOnly, "Edit Uniform Size Record" if (ViewModel.CurrEmpID == "") { return; } if (ViewModel.cboUniformItem.SelectedIndex == -1) { return; } if (modGlobal.Clean(ViewModel.txtItemSizeDesc.Text) == "") { return; } if (ViewModel.lbRecordID.Text != "") { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx lRecordID = Convert.ToInt32(modGlobal.GetVal(ViewModel.lbRecordID.Text)); } else { lRecordID = 0; } bool RecordExists = false; if (lRecordID != 0) { if (cUniform.GetPersonnelUniformSizesByID(lRecordID) != 0) { RecordExists = true; } } cUniform.PersonnelUniformSizesEmployeeID = ViewModel.CurrEmpID; cUniform.PersonnelUniformSizesUniformType = ViewModel.cboUniformItem.GetItemData(ViewModel.cboUniformItem.SelectedIndex); cUniform.PersonnelUniformSizesDateSized = DateTime.Parse(ViewModel.dteDateSized.Text).ToString("M/d/yyyy"); cUniform.PersonnelUniformSizesSizeDescription = modGlobal.Clean(ViewModel.txtItemSizeDesc.Text); cUniform.PersonnelUniformSizesCreatedDate = DateTime.Now.ToString("M/d/yyyy HH:mm:ss"); cUniform.PersonnelUniformSizesCreatedBy = modGlobal.Shared.gUser; if (RecordExists) { if (cUniform.UpdatePersonnelUniformSizes() != 0) { FillUniformGrid(); FindEmployee(); } else { ViewManager.ShowMessage("Oooops! Error Updating PersonnelUniformSizes.", "Error Updating PersonnelUniformSizes", UpgradeHelpers.Helpers.BoxButtons.OK); } } else { if (cUniform.InsertPersonnelUniformSizes() != 0) { FillUniformGrid(); FindEmployee(); } else { ViewManager.ShowMessage("Oooops! Error Adding PersonnelUniformSizes.", "Error Adding PersonnelUniformSizes", UpgradeHelpers.Helpers.BoxButtons.OK); } } }
public void GetEmployeeBunkerSizeDetail() { PTSProject.clsUniform cUniform = Container.Resolve <clsUniform>(); if (ViewModel.sprBunkerList.DataRowCnt == 0) { return; } if (ViewModel.CurrEmpID == "") { return; } if (cUniform.GetUniformEmployeePPESizesByID(ViewModel.CurrEmpID) != 0) { //continue } else { ViewManager.ShowMessage("Ooops! There was a problem retrieving UniformEmployeePPESizes.", "Error Getting UniformEmployeePPESizes", UpgradeHelpers.Helpers.BoxButtons.OK); return; } if (cUniform.EmployeeUniformSizeInDate != "") { ViewModel.chkInDate.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; ViewModel.dteInDate.Visible = true; ViewModel.dteInDate.Text = cUniform.EmployeeUniformSizeInDate; } else { ViewModel.chkInDate.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; ViewModel.dteInDate.Visible = false; } ViewModel.txtCoatSizeDesc.Text = cUniform.EmployeeUniformSizeCoatSpreadDesc; ViewModel.txtBootSizeDesc.Text = cUniform.EmployeeUniformSizeBootSpreadDesc; if (cUniform.EmployeeUniformSizeCoatSizeCode != 0) { for (int i = 0; i <= ViewModel.cboCoatSize.Items.Count - 1; i++) { if (cUniform.EmployeeUniformSizeCoatSizeCode == ViewModel.cboCoatSize.GetItemData(i)) { ViewModel.cboCoatSize.SelectedIndex = i; break; } } } else { ViewModel.cboCoatSize.SelectedIndex = -1; } if (cUniform.EmployeeUniformSizePantSizeCode != 0) { for (int i = 0; i <= ViewModel.cboPantSize.Items.Count - 1; i++) { if (cUniform.EmployeeUniformSizePantSizeCode == ViewModel.cboPantSize.GetItemData(i)) { ViewModel.cboPantSize.SelectedIndex = i; break; } } } else { ViewModel.cboPantSize.SelectedIndex = -1; } if (cUniform.EmployeeUniformSizeBootSizeCode != 0) { for (int i = 0; i <= ViewModel.cboBootSize.Items.Count - 1; i++) { if (cUniform.EmployeeUniformSizeBootSizeCode == ViewModel.cboBootSize.GetItemData(i)) { ViewModel.cboBootSize.SelectedIndex = i; break; } } } else { ViewModel.cboBootSize.SelectedIndex = -1; } if (cUniform.EmployeeUniformSizeGloveSizeCode != 0) { for (int i = 0; i <= ViewModel.cboGloveSize.Items.Count - 1; i++) { if (cUniform.EmployeeUniformSizeGloveSizeCode == ViewModel.cboGloveSize.GetItemData(i)) { ViewModel.cboGloveSize.SelectedIndex = i; break; } } } else { ViewModel.cboGloveSize.SelectedIndex = -1; } if (cUniform.EmployeeUniformSizeBootManufID != 0) { for (int i = 0; i <= ViewModel.cboBootBrand.Items.Count - 1; i++) { if (cUniform.EmployeeUniformSizeBootManufID == ViewModel.cboBootBrand.GetItemData(i)) { ViewModel.cboBootBrand.SelectedIndex = i; break; } } } else { ViewModel.cboBootBrand.SelectedIndex = -1; } ViewModel.cmdEdit.Text = "Update"; ViewModel.cmdEdit.Tag = "0"; ViewModel.cmdEdit.Enabled = true; }
internal void cmdEditItem_Click(Object eventSender, System.EventArgs eventArgs) { PTSProject.clsUniform cUniform = Container.Resolve <clsUniform>(); // MsgBox "This feature is under construction!", vbOKOnly, "Updating Return Date / Inserting Retired Record" try { //if there is no UniformID or EmployeeID... should not be here... if (modGlobal.Clean(ViewModel.lbUniformID.Text) == "") { return; } //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx cUniform.UniformID = Convert.ToInt32(modGlobal.GetVal(ViewModel.lbUniformID.Text)); //Edit Information & gather variables if (cUniform.GetUniformByID(cUniform.UniformID) != 0) { cUniform.UniformReasonRetiredUniformID = cUniform.UniformID; cUniform.UniformReasonRetiredCreatedBy = modGlobal.Shared.gUser; cUniform.UniformReasonRetiredCreatedDate = UpgradeHelpers.Helpers.DateTimeHelper.ToString(DateTime.Now); //Get Rid of any UniformInventory record if (cUniform.DeleteUniformInventory(cUniform.UniformID) != 0) { //all is well either way } } else { ViewManager.ShowMessage("Could not find the Uniform in the Database.", "Find Uniform", UpgradeHelpers.Helpers.BoxButtons.OK); return; } cUniform.UniformRetiredDate = DateTime.Parse(ViewModel.dteRetired.Text).ToString("MM/dd/yyyy"); cUniform.UniformReasonRetiredReasonID = 0; if (ViewModel.cboReason.SelectedIndex != -1) { cUniform.UniformReasonRetiredReasonID = ViewModel.cboReason.GetItemData(ViewModel.cboReason.SelectedIndex); } cUniform.UniformReasonRetiredComment = modGlobal.Clean(ViewModel.txtComment.Text); if (ViewModel.cboItemType.GetItemData(ViewModel.cboItemType.SelectedIndex) != cUniform.UniformType) { ViewManager.ShowMessage("You can not change the PPE type.", "Update PPE Item", UpgradeHelpers.Helpers.BoxButtons.OK); for (int i = 0; i <= ViewModel.cboItemType.Items.Count - 1; i++) { if (ViewModel.cboItemType.GetItemData(i) == cUniform.UniformType) { ViewModel.cboItemType.SelectedIndex = i; break; } } } cUniform.UniformTrackingNumber = modGlobal.Clean(ViewModel.txtTrackingNumber.Text); cUniform.UniformColorType = 0; cUniform.UniformSizeType = 0; if (ViewModel.cboColorSize.Visible) { if (ViewModel.cboColorSize.SelectedIndex == -1) { //continue } else { if (ViewModel.lbItemColorSize.Text == "Color") { cUniform.UniformColorType = ViewModel.cboColorSize.GetItemData(ViewModel.cboColorSize.SelectedIndex); } else { cUniform.UniformSizeType = ViewModel.cboColorSize.GetItemData(ViewModel.cboColorSize.SelectedIndex); } } } cUniform.UniformManufacturerID = 0; if (ViewModel.cboItemBrand.Visible) { if (ViewModel.cboItemBrand.SelectedIndex == -1) { //continue } else { cUniform.UniformManufacturerID = ViewModel.cboItemBrand.GetItemData(ViewModel.cboItemBrand.SelectedIndex); } } if (ViewModel.chkManufDate.CheckState == UpgradeHelpers.Helpers.CheckState.Unchecked) { cUniform.UniformManufacturedDate = ""; } else if (((int)DateAndTime.DateDiff("d", DateTime.Now, DateTime.Parse(DateTime.Parse(ViewModel.dteManufDate.Text).ToString("MM/dd/yyyy")), FirstDayOfWeek.Sunday, FirstWeekOfYear.Jan1)) > 0) { ViewManager.ShowMessage("Manufactured Date can not be in the future.", "Manufactured Date Error", UpgradeHelpers.Helpers.BoxButtons.OK); return; } else { cUniform.UniformManufacturedDate = DateTime.Parse(ViewModel.dteManufDate.Text).ToString("MM/dd/yyyy"); } if (cUniform.UpdateUniform() != 0) { if (cUniform.InsertUniformReasonRetiredInfo() != 0) { ViewManager.ShowMessage("PPE Item / Retired Info has been successfully updated.", "Update PPE Item Retired Info", UpgradeHelpers.Helpers.BoxButtons.OK); } else { ViewManager.ShowMessage("Ooops! Error Updating PersonnelUniform record. Call Debra Lewandowsky x5068.", "Error Updating PersonnelUniform", UpgradeHelpers.Helpers.BoxButtons.OK); } } else { ViewManager.ShowMessage("Ooops! Error Updating Uniform record. Call Debra Lewandowsky x5068.", "Error Updating Uniform", UpgradeHelpers.Helpers.BoxButtons.OK); } ViewManager.DisposeView(this); } catch { if (modGlobal.ErrorControl() == modGlobal.eFATALERROR) { return; } } }
public void GetUniformDetail() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); if (UniformCL.GetUniformDetailByID(modGlobal.Shared.gUniformID) != 0) { //continue } else { ViewManager.ShowMessage("Oooops! Can't find any Uniform Information based on ID = " + modGlobal.Shared.gUniformID .ToString() + "! Call Debra Lewandowsky x5068.", "Uniform Repair History", UpgradeHelpers.Helpers.BoxButtons.OK); } ViewModel.lbItem.Text = modGlobal.Clean(UniformCL.Uniform["Item"]); ViewModel.lbTrackingNumber.Text = modGlobal.Clean(UniformCL.Uniform["tracking_number"]); ViewModel.lbRetiredReason.Text = modGlobal.Clean(UniformCL.Uniform["reason_description"]); if (modGlobal.Clean(UniformCL.Uniform["retired_date"]) != "") { ViewModel.lbRetiredDate.Text = Convert.ToDateTime(UniformCL.Uniform["retired_date"]).ToString("M/d/yyyy"); } else { ViewModel.lbRetiredDate.Text = ""; } if (modGlobal.Clean(UniformCL.Uniform["InspDate"]) != "") { ViewModel.lbLastInspDate.Text = Convert.ToDateTime(UniformCL.Uniform["InspDate"]).ToString("M/d/yyyy"); } else { ViewModel.lbLastInspDate.Text = ""; } ViewModel.lbBrand.Text = modGlobal.Clean(UniformCL.Uniform["manufacturer_name"]); if (modGlobal.Clean(UniformCL.Uniform["manufactured_date"]) != "") { ViewModel.lbManufDate.Text = Convert.ToDateTime(UniformCL.Uniform["manufactured_date"]).ToString("M/d/yyyy"); } else { ViewModel.lbManufDate.Text = ""; } if (modGlobal.Clean(UniformCL.Uniform["ItemSize"]) != "") { ViewModel.lbColorSize.Text = modGlobal.Clean(UniformCL.Uniform["ItemSize"]); } else if (modGlobal.Clean(UniformCL.Uniform["ItemColor"]) != "") { ViewModel.lbColorSize.Text = modGlobal.Clean(UniformCL.Uniform["ItemColor"]); } else { ViewModel.lbColorSize.Text = ""; } if (modGlobal.Clean(UniformCL.Uniform["name_full"]) != "") { ViewModel.lbLocation.Text = "Issued to " + modGlobal.Clean(UniformCL.Uniform["name_full"]); } else if (modGlobal.Clean(UniformCL.Uniform["station"]) != "") { ViewModel.lbLocation.Text = "Station " + modGlobal.Clean(UniformCL.Uniform["station"]); } else { ViewModel.lbLocation.Text = ""; } //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.lbUniformID.Text = Convert.ToString(modGlobal.GetVal(UniformCL.Uniform["uniform_id"])); modGlobal.Shared.gUniformID = Convert.ToInt32(Double.Parse(ViewModel.lbUniformID.Text)); FillLaunderGrid(); }
public void LoadUniformFields() { PTSProject.clsUniform cUniform = Container.Resolve <clsUniform>(); if (cUniform.GetUniformByID(Convert.ToInt32(Double.Parse(ViewModel.lbUniformID.Text))) != 0) { } else { ViewManager.ShowMessage("Could not find the Uniform in the Database.", "Find Uniform", UpgradeHelpers.Helpers.BoxButtons.OK); return; } ViewModel.txtTrackingNumber.Text = cUniform.UniformTrackingNumber; if (cUniform.UniformManufacturedDate != "") { ViewModel.dteManufDate.Text = cUniform.UniformManufacturedDate; ViewModel.chkManufDate.CheckState = UpgradeHelpers.Helpers.CheckState.Checked; ViewModel.dteManufDate.Visible = true; } else { ViewModel.dteManufDate.Text = DateTime.Now.AddDays(-30).ToString("MM/dd/yyyy"); ViewModel.chkManufDate.CheckState = UpgradeHelpers.Helpers.CheckState.Unchecked; ViewModel.dteManufDate.Visible = false; } for (int i = 0; i <= ViewModel.cboItemType.Items.Count - 1; i++) { if (cUniform.UniformType == ViewModel.cboItemType.GetItemData(i)) { ViewModel.cboItemType.SelectedIndex = i; break; } } if (cUniform.UniformManufacturerID != 0) { for (int i = 0; i <= ViewModel.cboItemBrand.Items.Count - 1; i++) { if (ViewModel.cboItemBrand.GetItemData(i) == cUniform.UniformManufacturerID) { ViewModel.cboItemBrand.SelectedIndex = i; break; } } } else { ViewModel.cboItemBrand.SelectedIndex = -1; } if (cUniform.UniformSizeType != 0) { for (int i = 0; i <= ViewModel.cboColorSize.Items.Count - 1; i++) { if (ViewModel.cboColorSize.GetItemData(i) == cUniform.UniformSizeType) { ViewModel.cboColorSize.SelectedIndex = i; break; } } } else if (cUniform.UniformColorType != 0) { for (int i = 0; i <= ViewModel.cboColorSize.Items.Count - 1; i++) { if (ViewModel.cboColorSize.GetItemData(i) == cUniform.UniformColorType) { ViewModel.cboColorSize.SelectedIndex = i; break; } } } else { ViewModel.cboColorSize.SelectedIndex = -1; } }
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 FillRepairGrid() { PTSProject.clsUniform UniformCL = Container.Resolve <clsUniform>(); if (UniformCL.GetPPERepairHistoryByItem(modGlobal.Shared.gUniformID) != 0) { //continue } else { ViewManager.ShowMessage("This Item has no Repair History.", "Uniform Repair History", UpgradeHelpers.Helpers.BoxButtons.OK); return; } //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread method sprRepairGrid.ClearRange was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprRepairGrid.ClearRange(1, 1, ViewModel.sprRepairGrid.MaxCols, ViewModel.sprRepairGrid.MaxRows, false); ViewModel.iCurrRow = 0; while (!UniformCL.UniformRepair.EOF) { (ViewModel.iCurrRow)++; ViewModel.sprRepairGrid.Row = ViewModel.iCurrRow; ViewModel.sprRepairGrid.Col = 1; if (modGlobal.Clean(UniformCL.UniformRepair["date_in"]) == "") { ViewModel.sprRepairGrid.Text = ""; } else { ViewModel.sprRepairGrid.Text = Convert.ToDateTime(UniformCL.UniformRepair["date_in"]).ToString("M/d/yyyy"); } ViewModel.sprRepairGrid.Col = 2; if (modGlobal.Clean(UniformCL.UniformRepair["date_out"]) == "") { ViewModel.sprRepairGrid.Text = ""; } else { ViewModel.sprRepairGrid.Text = Convert.ToDateTime(UniformCL.UniformRepair["date_out"]).ToString("M/d/yyyy"); } ViewModel.sprRepairGrid.Col = 3; ViewModel.sprRepairGrid.Text = modGlobal.Clean(UniformCL.UniformRepair["repairer_name"]); ViewModel.sprRepairGrid.Col = 4; ViewModel.sprRepairGrid.Text = modGlobal.Clean(UniformCL.UniformRepair["comment"]); ViewModel.sprRepairGrid.Col = 5; ViewModel.sprRepairGrid.CellType = FarPoint.ViewModels.Cells.FpCellType.CellTypeCheckBox; ViewModel.sprRepairGrid.TypeCheckCenter = true; if (modGlobal.Clean(UniformCL.UniformRepair["launder_id"]) == "") { ViewModel.sprRepairGrid.Value = 0; } else { ViewModel.sprRepairGrid.Value = 1; } ViewModel.sprRepairGrid.Col = 6; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.sprRepairGrid.Text = Convert.ToString(modGlobal.GetVal(UniformCL.UniformRepair["repair_id"])); UniformCL.UniformRepair.MoveNext(); } ; }