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 }; }