/// <summary>
/// save the inventory item
/// </summary>
/// <returns></returns>
private bool SaveInventoryItem()
{
InventoryClasses.InventoryObject io = new InventoryClasses.InventoryObject();
InventoryClasses.InventoryUtilities iu = new InventoryClasses.InventoryUtilities();
io.ItemID = txtItemID.Text;
io.Description = txtDescription.Text;
decimal dpResult = 0;
if (decimal.TryParse(txtAskPrice.Text, out dpResult))
{
io.Price = dpResult;
}
else
{
io.Price = dpResult;
}
decimal dsResult = 0;
if (decimal.TryParse(txtSellPrice.Text, out dsResult))
{
io.SellPrice = dsResult;
}
else
{
io.SellPrice = dsResult;
}
io.Comment = txtComment.Text;
io.SoldStatus = cboSoldStatus.SelectedIndex;
io.Returnable = ckReturn.Checked;
//CHECK FOR NULL DATES
DateTime dtResult = DateTime.MinValue;
if (DateTime.TryParse(txtDateIn.Text, out dtResult))
{
io.DateIn = dtResult;
}
else
{
io.DateIn = DateTime.MinValue;
}
if (DateTime.TryParse(txtDateSold.Text, out dtResult))
{
io.DateSold = dtResult;
}
else
{
io.DateSold = DateTime.MinValue;
}
if (DateTime.TryParse(txtDatePaid.Text, out dtResult))
{
io.DatePaid = dtResult;
}
else
{
io.DatePaid = DateTime.MinValue;
}
decimal pResult = 0;
if (decimal.TryParse(txtPaidAmount.Text, out pResult))
{
io.PaidAmount = pResult;
}
else
{
io.PaidAmount = pResult;
}
bool returnValue = iu.UpdateInventory(io);
return returnValue;
}
/// <summary>
/// Save inventory to the database
/// </summary>
/// <returns></returns>
private bool SaveInventory()
{
for (int iRowCount = 0; iRowCount < dgInventory.Rows.Count-1; iRowCount++)
{
InventoryClasses.InventoryObject newInventory = new InventoryClasses.InventoryObject();
newInventory.Consignor = int.Parse(txtConsignerID.Text.ToString());
newInventory.Description = dgInventory[0, iRowCount].Value.ToString();
newInventory.Price = decimal.Parse(dgInventory[1, iRowCount].Value.ToString());
string comment = string.Empty;
if (dgInventory[2, iRowCount].Value != null)
{
comment = dgInventory[2, iRowCount].Value.ToString();
}
newInventory.Comment = comment;
InventoryClasses.InventoryUtilities iu = new InventoryClasses.InventoryUtilities();
int returnValue = iu.SaveInventory(newInventory);
if (returnValue == -1)
{
return false;
}
}
return true;
}
/// <summary>
/// load up the found details for an inventory item
/// </summary>
/// <param name="ItemID"></param>
private void LoadDetails(int ItemID)
{
try
{
InventoryClasses.InventoryUtilities iu = new InventoryClasses.InventoryUtilities();
InventoryClasses.InventoryObject io = new InventoryClasses.InventoryObject();
io = iu.GetInventoryDetails(ItemID.ToString());
if (io == null)
{
MessageBox.Show("There was a problem retrieving that inventory item", Properties.Settings.Default.MessageBoxTitle, MessageBoxButtons.OK);
}
else
{
txtItemID.Text = io.ItemID;
txtDescription.Text = io.Description;
txtAskPrice.Text = decimal.Round(io.Price, 2).ToString();
txtDateIn.Text = io.DateIn.ToString();
txtSellPrice.Text = decimal.Round(io.SellPrice, 2).ToString();
if (DateTime.Compare(io.DateSold, DateTime.MinValue) == 0)
{
txtDateSold.Text = string.Empty;
}
else
{
txtDateSold.Text = io.DateSold.ToString();
}
if (DateTime.Compare(io.DatePaid, DateTime.MinValue) == 0)
{
txtDatePaid.Text = string.Empty;
}
else
{
txtDatePaid.Text = io.DatePaid.ToString();
}
txtPaidAmount.Text = decimal.Round(io.PaidAmount, 2).ToString();
txtComment.Text = io.Comment;
cboSoldStatus.SelectedIndex = io.SoldStatus;
this.ckReturn.Checked = io.Returnable;
txtConsignID.Text = io.Consignor.ToString();
txtConsignor.Text = io.ConsignorName;
if (io.Donate)
{
lblDonateCheck.Text = "x";
}
else
{
lblDonateCheck.Text = "o";
}
}
}
catch (Exception e)
{
MessageBox.Show(string.Format("There was an error: {0}", e.Message), Properties.Settings.Default.MessageBoxTitle, MessageBoxButtons.OK);
}
}
