private void btnSaveRec_Click(object sender, EventArgs e)
{
ReceiveInfo receive = new ReceiveInfo();
receive.ItemId = ((ItemInfo)cboItems.SelectedItem).ItemId;
receive.ReceivedQty = txtQty.Text.Trim();
receive.ReceivedBy = ((UserInfo)cboIssuedBy.SelectedItem).UserId;
receive.ReceiveDate = dtpIssue.Text;
try
{
ReceiveMapper.GetInstance().AddReceive(receive);
ItemInfo item = (ItemInfo)cboItems.SelectedItem;
item.Received = (Convert.ToInt32(item.Received) + Convert.ToInt32(receive.ReceivedQty)).ToString();
item.CurrentStock = (Convert.ToInt32(item.CurrentStock) + Convert.ToInt32(receive.ReceivedQty)).ToString();
ItemMapper.Getinstance().UpdateItem(item);
MessageBox.Show("Transaction successful");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public IList<ReceiveInfo> GetAllReceived()
{
IList<ReceiveInfo> receives = new List<ReceiveInfo>();
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction,
System.Data.CommandType.Text, SQL_SELECT_ALL, null))
{
while (rdr.Read())
{
ReceiveInfo receive = new ReceiveInfo(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));
receives.Add(receive);
}
}
return receives;
}
public void UpdateReceive(ReceiveInfo receive)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text,
SQL_UPDATE_REC, CreateParameters(receive));
}
public ReceiveInfo GetReceive(string receiveid)
{
ReceiveInfo receive = null;
SqlParameter param_receiveid = new SqlParameter(PARAM_RECID, receiveid);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction,
System.Data.CommandType.Text, SQL_SELECT_REC, param_receiveid))
{
while (rdr.Read())
{
receive = new ReceiveInfo(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));
}
}
return receive;
}
private SqlParameter[] CreateParameters(ReceiveInfo receive)
{
SqlParameter param_recid = new SqlParameter(PARAM_RECID,receive.ReceiveId);
SqlParameter param_itemid = new SqlParameter(PARAM_ITEMID,receive.ItemId);
SqlParameter param_recqty = new SqlParameter(PARAM_RECQTY,receive.ReceivedQty);
SqlParameter param_recdate = new SqlParameter(PARAM_RECDATE,receive.ReceiveDate);
SqlParameter param_recby = new SqlParameter(PARAM_RECBY,receive.ReceivedBy);
return new SqlParameter[] {param_recid,param_itemid,param_recqty,param_recdate,param_recby };
}
