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