private void btnSave_Click(object sender, EventArgs e)
{
if (txtNewItem.Text.Trim() != null & txtNewItem.Text.Trim() != String.Empty)
{
if (txtQuanty.Text.Trim() != String.Empty & txtQuanty.Text != null)
{
try
{
int.Parse(txtQuanty.Text.Trim());
}
catch (Exception exx)
{
MessageBox.Show("Please use figures to specify quantity",exx.Message);
return;
}
}
item = new ItemInfo();
item.Item = txtNewItem.Text.Trim();
item.InitialQuantity = txtQuanty.Text.Trim();
item.InitialEntryDate = System.DateTime.Now.ToLongDateString();
item.EnteredBy = OtherUtilities.Settings.LoggedInUser.UserId;
item.CurrentStock = item.InitialQuantity;
}
try
{
ItemMapper.Getinstance().AddItem(item);
MessageBox.Show(item.Item + " successfully saved");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public SqlParameter[] CreateParameters(ItemInfo item)
{
SqlParameter param_itemId = new SqlParameter(PARAM_ITEMID, item.ItemId);
SqlParameter param_item = new SqlParameter(PARAM_ITEM, item.Item);
SqlParameter param_initq = new SqlParameter(PARAM_INITQ, item.InitialQuantity);
SqlParameter param_initdate = new SqlParameter(PARAM_INITDATE, item.InitialEntryDate);
SqlParameter param_enterer = new SqlParameter(PARAM_ENTEREDBY, item.EnteredBy);
SqlParameter param_rcvd = new SqlParameter(PARAM_RCVD,item.Received);
SqlParameter param_issued = new SqlParameter(PARAM_ISSUED,item.Issued);
SqlParameter param_returned = new SqlParameter(PARAM_RETURNED,item.Returned);
SqlParameter param_currstock = new SqlParameter(PARAM_CURRSTOCK, item.CurrentStock);
return new SqlParameter[] { param_itemId, param_item, param_initq, param_initdate, param_enterer, param_rcvd, param_issued, param_returned, param_currstock };
}
public IList<ItemInfo> GetAllItems()
{
IList<ItemInfo> items = new List<ItemInfo>();
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction,
System.Data.CommandType.Text, SQL_SELECT_ALL, null))
{
while (rdr.Read())
{
ItemInfo item = new ItemInfo(rdr.GetString(0),
rdr.GetValue(1).GetType().Equals(typeof(DBNull)) ? "" :rdr.GetString(1),
rdr.GetValue(2).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(2),
rdr.GetValue(3).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(3),
rdr.GetValue(4).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(4),
rdr.GetValue(5).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(5),
rdr.GetValue(6).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(6),
rdr.GetValue(7).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(7),
rdr.GetValue(8).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(8));
items.Add(item);
}
}
return items;
}
public void DeleteItem(ItemInfo item)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text,
SQL_DELETE_ITEM, CreateParameters(item));
}
public ItemInfo GetItem(string itemid)
{
ItemInfo item = null;
SqlParameter param_itemid = new SqlParameter(PARAM_ITEMID,itemid);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction,
System.Data.CommandType.Text, SQL_SELECT_ITEM, param_itemid))
{
while (rdr.Read())
{
item = new ItemInfo(rdr.GetString(0),
rdr.GetValue(1).GetType().Equals(typeof(DBNull)) ? "" :rdr.GetString(1),
rdr.GetValue(2).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(2),
rdr.GetValue(3).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(3),
rdr.GetValue(4).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(4),
rdr.GetValue(5).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(5),
rdr.GetValue(6).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(6),
rdr.GetValue(7).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(7),
rdr.GetValue(8).GetType().Equals(typeof(DBNull)) ? "" : rdr.GetString(8));
}
}
return item;
}
