private void ItemCostRevisionHistory_Load(object sender, EventArgs e)
{
DataSet ds = InventoryInquiries.getRetailPriceRevision(new Icn(this.labelICN.Text.Replace(" ", "")));
if (ds.IsNullOrEmpty())
{
MessageBox.Show("No Results");
this.DialogResult = DialogResult.Cancel;
return;
}
_theData = ds;
this.resultsGrid_dg.DataSource = ds.Tables[0];
this.resultsGrid_dg.Columns[0].Width = 200;
this.resultsGrid_dg.Columns[1].Width = 100;
this.resultsGrid_dg.Columns[2].Width = 200;
this.resultsGrid_dg.Columns[3].Width = 200;
this.resultsGrid_dg.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
this.resultsGrid_dg.Columns[0].HeaderText = "Transaction Date";
this.resultsGrid_dg.Columns[1].HeaderText = "Percent Change";
this.resultsGrid_dg.Columns[2].HeaderText = "Original Price";
this.resultsGrid_dg.Columns[3].HeaderText = "Current Price";
this.resultsGrid_dg.Columns[4].HeaderText = "User Id";
}
public InventoryInquirySearch()
{
//string errText;
//int errNo;
InitializeComponent();
NavControlBox = new NavBox();
NavControlBox.Owner = this;
dateCalendarStart.PositionPopupCalendarOverTextbox = true;
dateCalendarStart.BringToFront();
dateCalendarEnd.PositionPopupCalendarOverTextbox = true;
dateCalendarEnd.BringToFront();
//dateCalendarStart.SelectedDate = "";
//dateCalendarEnd.SelectedDate = "";
dateCalendarStart.SelectedDate = "mm/dd/yyyy";
dateCalendarEnd.SelectedDate = "mm/dd/yyyy";
//dateCalendarStart.SelectedDate = DateTime.Now.ToString("MM/dd/yyyy");
//dateCalendarEnd.SelectedDate = DateTime.Now.ToString("MM/dd/yyyy");
sortBy_cb.DataSource = StringDBMap_Enum <sortField_enum> .displayValues();
status_cb.DataSource = StringDBMap_Enum <statusField_enum> .displayValues();
//sortDir_cb.DataSource = StringDBMap_Enum<Inquiry.sortDir_enum>.displayValues();
sortBy_cb.SelectedIndex = 0;
sortDir_cb.SelectedIndex = 0;
DataSet data = InventoryInquiries.getCategories();
categoryForm = new CategorySelect(data);
}
private void ItemCostRevisionHistory_Load(object sender, EventArgs e)
{
// TODO: load Item Cost Revision History from the database.
DataSet ds = InventoryInquiries.getItemDescRevision(new Icn(this.labelICN.Text.Replace(" ", "")));
if (ds.IsNullOrEmpty())
{
MessageBox.Show("No Results");
this.DialogResult = DialogResult.Cancel;
return;
}
this.resultsGrid_dg.DataSource = ds.Tables[0];
this.resultsGrid_dg.Columns[0].Width = 200;
this.resultsGrid_dg.Columns[1].Width = 500;
this.resultsGrid_dg.Columns[2].Width = 100;
this.resultsGrid_dg.Columns[0].HeaderText = "Transaction Date";
this.resultsGrid_dg.Columns[1].HeaderText = "Merchandise Description";
this.resultsGrid_dg.Columns[2].HeaderText = "User Id";
}
private void Find_btn_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
var criteria = new InventoryInquiries();
criteria.Mdse = new MDSE();
criteria.Mdse.Icn.ShopNumber = getIntVal(ICN_shop_tb, -1);
if (ICN_year_tb.Text.Length > 0)
{
criteria.Mdse.Icn.LastDigitOfYear = getIntVal(ICN_year_tb, -1);
criteria.icnYear_IsNull = false;
}
criteria.Mdse.Icn.DocumentNumber = getIntVal(ICN_doc_tb, -1);
int doc_type = getIntVal(ICN_doc_type_tb, -1);
if (doc_type >= 0 && doc_type < 10)
{
criteria.Mdse.Icn.DocumentType = (DocumentType)doc_type;
criteria.icnDocType_IsNull = false;
}
// need to add exception management -- parse is not fail safe
criteria.Mdse.Icn.ItemNumber = getIntVal(ICN_item_tb, -1);
criteria.Mdse.Icn.SubItemNumber = getIntVal(ICN_sub_item_tb, -1);
criteria.RfbNr = getIntVal(rfb_tb, -1);
criteria.GunNumber = getIntVal(gunNbr_tb, -1);
if (status_cb.SelectedItem != null)
{
criteria.status = StringDBMap_Enum <statusField_enum> .fromString(status_cb.SelectedItem.ToString());
}
if (dateCalendarStart.SelectedDate != "mm/dd/yyyy" && dateCalendarStart.SelectedDate.Length > 0)
{
criteria.lowStatusDate = DateTime.Parse(dateCalendarStart.SelectedDate);
}
else
{
criteria.lowStatusDate = DateTime.MinValue;
}
if (dateCalendarEnd.SelectedDate != "mm/dd/yyyy" && dateCalendarStart.SelectedDate.Length > 0)
{
criteria.highStatusDate = DateTime.Parse(dateCalendarEnd.SelectedDate);
}
else
{
criteria.highStatusDate = DateTime.MaxValue;
}
criteria.age = getIntVal(invAge_tb, -1);
bool converted = decimal.TryParse(lowRetailAmt_tb.Text, out criteria.lowRetail);
if (!converted)
{
criteria.lowRetail = -1;
}
converted = decimal.TryParse(highRetailAmt_tb.Text, out criteria.highRetail);
if (!converted)
{
criteria.highRetail = -1;
}
converted = decimal.TryParse(lowCost_tb.Text, out criteria.lowCost);
if (!converted)
{
criteria.lowCost = -1;
}
converted = decimal.TryParse(highCost_tb.Text, out criteria.highCost);
if (!converted)
{
criteria.highCost = -1;
}
converted = decimal.TryParse(fieldCost_tb.Text, out criteria.fieldCost);
if (!converted)
{
criteria.fieldCost = -1;
}
criteria.descr = descr_tb.Text;
criteria.manufacturer = manuf_tb.Text;
criteria.model = model_tb.Text;
criteria.serialNr = serialNr_tb.Text;
criteria.aisle = aisle_tb.Text;
criteria.shelf = shelf_tb.Text;
criteria.location = loctn_tb.Text;
criteria.sortBy = StringDBMap_Enum <sortField_enum> .fromString(sortBy_cb.SelectedItem.ToString());
criteria.sortDir = StringDBMap_Enum <Inquiry.sortDir_enum> .fromString(sortDir_cb.SelectedItem.ToString());
if (this.catCodes != null && this.catCodes.GetLength(0) > 0)
{
criteria.cat_code = new List <string>(this.catCodes);
criteria.cat_names = new List <string>(this.catNames);
}
else
{
criteria.cat_code = new List <string>();
criteria.cat_code.Add("-1"); //empty array
}
DataSet s = null;
try
{
s = criteria.getData();
if (s.IsNullOrEmpty())
{
throw new BusinessLogicException(ReportConstants.NODATA);
}
}
catch (BusinessLogicException blex)
{
MessageBox.Show(blex.Message);
return;
}
//this.NavControlBox.Action = NavBox.NavAction.HIDEANDSHOW;
Cursor.Current = Cursors.Default;
this.Visible = false;
var resultsDisplay = new InventorySearchResults(s, criteria, "MDSE");
resultsDisplay.ShowDialog();
if (resultsDisplay.DialogResult == DialogResult.Cancel)
{
this.Close();
}
else
{
this.Visible = true;
}
}
