using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using AccountPlus.BusinessLogic; using AccountPlus.Messaging; using AccountPlus.Formatting; namespace AccountPlus.UI { public partial class NewItem : AccountPlusBase { Items _itemManagement = new Items(); public NewItem() { InitializeComponent(); LoadData(string.Empty, string.Empty); } private void LoadData(string itemName, string itemDesc) { //StringBuilder sqlCommand = new StringBuilder("SELECT Item_Id, Item_Name, Item_Desc, IsActive From Item_Details "); //if (itemName != string.Empty) // sqlCommand.Append(" WHERE Item_Name LIKE '" + itemName + "'"); //if (itemName != string.Empty && itemDesc != string.Empty) // sqlCommand.Append(" AND Item_Name LIKE '" + itemDesc + "'"); //else if (itemName == string.Empty && itemDesc != string.Empty) // sqlCommand.Append(" WHERE Item_Name LIKE '" + itemDesc + "'"); GRID_VIEW_ITEM_DETAILS.DataSource = _itemManagement.GetItems(itemName, itemDesc); } private void btnSubmit_Click(object sender, EventArgs e) { AddUpdateItem(); } private void AddUpdateItem() { errorProvider1.Clear(); lblMessage.Clear(); string itemName = txtItemName.Text.Trim(); string itemDesc = txtaDesc.Text.Trim(); string message = string.Empty; if (itemName == string.Empty) { message = MessageManager.GetMessage("33"); errorProvider1.SetError(txtItemName, message); lblMessage.SetMessage(message); return; } if (itemDesc == string.Empty) { message = MessageManager.GetMessage("34"); errorProvider1.SetError(txtaDesc, message); lblMessage.SetMessage(message); return; } if (_itemId != 0) { if (_itemManagement.UpdateItem(_itemId, itemDesc, SessionParameters.UserID.ToString(), System.DateTime.Now.ToShortDateString())) { lblMessage.SetMessage(MessageManager.GetMessage("35")); Clear(); } else lblMessage.SetMessage(MessageManager.GetMessage("36")); } else { if (!_itemManagement.ItemExist(itemName)) { if (_itemManagement.AddNewItem(itemName, itemDesc, SessionParameters.UserID, System.DateTime.Now.ToShortDateString())) { lblMessage.SetMessage(MessageManager.GetMessage("38", itemName)); Clear(); } else lblMessage.SetMessage(MessageManager.GetMessage("36")); } else lblMessage.SetMessage(MessageManager.GetMessage("37", itemName)); } LoadData(string.Empty, string.Empty); } private void btnClose_Click(object sender, EventArgs e) { this.Close(); this.Dispose(); } private void btnClear_Click(object sender, EventArgs e) { Clear(); } private void Clear() { LoadData(string.Empty, string.Empty); errorProvider1.Clear(); txtItemName.Clear(); txtaDesc.Clear(); btnUpdate.Enabled = false; txtItemName.ReadOnly = false; btnAdd.Enabled = true; btnSearch.Enabled = true; _itemId = 0; } private int _itemId = 0; private void GRID_VIEW_ITEM_DETAILS_CellClick(object sender, DataGridViewCellEventArgs e) { errorProvider1.Clear(); lblMessage.Clear(); _itemId = DataFormat.GetInteger(GRID_VIEW_ITEM_DETAILS.Rows[e.RowIndex].Cells[0].Value); txtItemName.Text = DataFormat.GetString(GRID_VIEW_ITEM_DETAILS.Rows[e.RowIndex].Cells["Item_Name"].Value); txtaDesc.Text = DataFormat.GetString(GRID_VIEW_ITEM_DETAILS.Rows[e.RowIndex].Cells["Item_Desc"].Value); btnAdd.Enabled = false; btnUpdate.Enabled = true; btnSearch.Enabled = false; txtItemName.ReadOnly = true; } private void btnSearch_Click(object sender, EventArgs e) { LoadData(txtItemName.Text.Trim(), txtaDesc.Text.Trim()); } private void btnUpdate_Click(object sender, EventArgs e) { AddUpdateItem(); } private void NewItem_Load(object sender, EventArgs e) { base.SetBGColor(this); } } }
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.
This article, along with any associated source code and files, is licensed under The GNU Lesser General Public License (LGPLv3)