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 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); } } }
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); } }