private void LoadInventory()
{
BSInventoryItem bs = new BSInventoryItem();
item = bs.getInventoryItem(this.item.ItemId);
if (item != null)
{
txtItemName.Text = item.ItemName;
txtCategory.Text = item.CategoryName;
txtQuantity.Text = item.Quantity.ToString();
txtPrice.Text = item.Price.ToString();
txtAvailable.Text = item.Available;
txtRemarks.Text = item.Remarks;
lblCreated.Text = item.CreatedByName + " at " + String.Format("{0:MMMM dd, yyyy}", item.CreatedDate) + " " + String.Format("{0:HH:MM:sstt}", item.CreatedDate);
if (String.IsNullOrEmpty(item.ModifiedByName))
{
lblModified.Visible = false;
lblTitleCreatedBy.Visible = false;
}
else
{
lblModified.Visible = true;
lblTitleCreatedBy.Visible = true;
lblModified.Text = item.ModifiedByName + " at " + String.Format("{0:MMMM dd, yyyy}", item.ModifiedDate) + " " + String.Format("{0:HH:MM:sstt}", item.ModifiedDate);
}
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (ValidateForm())
{
BSInventoryItem bs = new BSInventoryItem();
Boolean isExists = false;
isExists = bs.checkInventoryItemByName(txtItemName.Text.Trim());
if (isExists)
{
VJUtility util = new VJUtility();
util.ShowMessage(VJConstants.MSG_ITEM_ALREADY_EXISTS, MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
this.item.ItemName = txtItemName.Text;
this.item.CategoryId = Convert.ToInt32(cmbCategory.SelectedValue);
this.item.Price = Convert.ToDecimal(txtPrice.Text);
this.item.Quantity = Convert.ToInt32(npdQuantity.Value);
this.item.Remarks = txtRemarks.Text;
if (cmbAvailable.SelectedItem.ToString() == "Yes")
{
this.item.Available = VJConstants.CONST_YES;
}
else
{
this.item.Available = VJConstants.CONST_NO;
}
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
}
}
private Boolean DeleteInventoryItem(int itemid)
{
Boolean result = false;
BSInventoryItem bs = new BSInventoryItem();
result = bs.DeleteInventoryItem(itemid);
return result;
}
private void tsbAddItem_Click(object sender, EventArgs e)
{
frmAddEditInventory frm = new frmAddEditInventory();
if (frm.ShowDialog(this) == DialogResult.OK)
{
InventoryItem objItem = frm.item;
BSInventoryItem bs = new BSInventoryItem();
Boolean result = false;
result = bs.InsertInventoryItem(objItem.ItemName, objItem.CategoryId, objItem.Quantity, objItem.Price, objItem.Available, objItem.Remarks, this.userinfo.EmployeeID);
if (result)
{
MessageBox.Show(VJConstants.MSG_ITEM_SUCCESSFULLY_ADDED, VJConstants.MESSAGEBOX_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadInventory();
}
else
{
MessageBox.Show(VJConstants.MSG_ERROR_ENCOUNTERED, VJConstants.MESSAGEBOX_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
frm.Dispose();
}
private void LoadInventory()
{
BSInventoryItem bs = new BSInventoryItem();
List<InventoryItem> itemlist = new List<InventoryItem>();
InventoryItem s = new InventoryItem();
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "";
Editlink.DataPropertyName = "lnkColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
dgvData.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "";
Deletelink.DataPropertyName = "lnkColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
dgvData.Columns.Add(Deletelink);
itemlist = bs.getInventoryItem(0, 0);
dgvData.DataSource = null;
dgvData.Rows.Clear();
dgvData.Columns.Clear();
dgvData.Refresh();
dgvData.DataSource = itemlist;
for (int i = 0; i < dgvData.ColumnCount; i++)
{
if (dgvData.Columns[i].HeaderText.ToUpper() == VJColumnName.CONST_ITEM_ID.ToUpper() ||
dgvData.Columns[i].HeaderText.ToUpper() == VJColumnName.CONST_CATEGORY_ID.ToUpper()||
dgvData.Columns[i].HeaderText.ToUpper() == VJColumnName.CONST_CREATED_BY.ToUpper()||
dgvData.Columns[i].HeaderText.ToUpper() == VJColumnName.CONST_MODIFIED_BY.ToUpper())
{
dgvData.Columns[i].Visible = false;
}
}
}
private void LoadInventoryItem(int itemid)
{
BSInventoryItem bs = new BSInventoryItem();
InventoryItem data = new InventoryItem();
data = bs.getInventoryItem(itemid);
if (data != null)
{
txtItemName.Text = data.ItemName;
cmbCategory.SelectedValue = data.CategoryId;
cmbAvailable.SelectedValue = data.Available;
npdQuantity.Value = data.Quantity;
txtPrice.Text = data.Price.ToString();
txtRemarks.Text = data.Remarks;
}
}
private void GetItemList(int catid)
{
BSInventoryItem bs = new BSInventoryItem();
List<InventoryItemData> itemList = new List<InventoryItemData>();
//itemList = bs.GetItemList(catid);
//if (itemList != null || itemList.Count > 0)
//{
// cmbItemName.DisplayMember = "ItemName";
// cmbItemName.ValueMember = "ItemId";
// cmbItemName.DataSource = itemList;
// cmbItemName.Enabled = true;
//}
}
private void GetItemDetails(int itemid)
{
BSInventoryItem bs = new BSInventoryItem();
InventoryItemData item = new InventoryItemData();
//item = bs.GetItemByID(itemid);
//if (item != null)
//{
// txtAvailableStock.Text = item.Quantity.ToString();
// txtPrice.Text = String.Format("{0:0.00}",item.Price);
// txtQuantity.Text = "0";
//}
//else
//{
// txtAvailableStock.Text = "0";
// txtPrice.Text = String.Format("{0:0.00}",0);
// txtQuantity.Text = "0";
//}
}
