internal DataSet GetReceiptNoDetails(ReceiptNoBO receiptNoBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(receiptNoBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "usp_GetReceiptNo";
sqlHelper.AddParameter(command, "@UserId", receiptNoBO.UserId, ParameterDirection.Input);
return(sqlHelper.ExecuteDataSet(command));
}
internal int UpdateReceiptNo(ReceiptNoBO receiptNoBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(receiptNoBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "uspUpdateRecieptNo";
sqlHelper.AddParameter(command, "@UserId", receiptNoBO.UserId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@RecieptNo", receiptNoBO.ReceiptNo, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@Mode", receiptNoBO.Flag, ParameterDirection.Input);
return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command)));
}
