public Boolean Delete(BIZ.RegisterRFID bizData)
{
try
{
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("Eclock_MemberRFIDRegisrationDelete", "_webDB");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@MemberRegistrationID", bizData.MemberRFIDRegistrationID);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetMemberRFIDRegisterGetByID(BIZ.RegisterRFID bizData)
{
try
{
DataSet dataResult = new DataSet();
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("Eclock_MemberRFIDRegisrationGeyByID", "_webDB");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", bizData.MemberID);
dbconn.sqlComm.Parameters.AddWithValue("@ScheduleName", bizData.Season);
dbconn.sqlComm.Parameters.AddWithValue("@Clubid", bizData.ClubID);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = dbconn.sqlComm;
da.Fill(dataResult);
dbconn.sqlConn.Close();
return(dataResult);
}
catch (Exception ex)
{
throw ex;
}
}
public Boolean Save(BIZ.RegisterRFID bizData)
{
try
{
dbconn = new DatabaseConnection();
dbconn.DatabaseConn("Eclock_MemberRFIDRegisrationSave", "_webDB");
if (dbconn.sqlConn.State == ConnectionState.Open)
{
dbconn.sqlConn.Close();
}
dbconn.sqlConn.Open();
dbconn.sqlComm.CommandTimeout = 0;
dbconn.sqlComm.Parameters.Clear();
dbconn.sqlComm.Parameters.AddWithValue("@MemberRegistrationID", bizData.MemberRFIDRegistrationID);
dbconn.sqlComm.Parameters.AddWithValue("@ClubID", bizData.ClubID);
dbconn.sqlComm.Parameters.AddWithValue("@MemberIDNo", bizData.MemberIDNo);
dbconn.sqlComm.Parameters.AddWithValue("@MemberID", bizData.MemberID);
dbconn.sqlComm.Parameters.AddWithValue("@ScheduleName", bizData.Season);
dbconn.sqlComm.Parameters.AddWithValue("@RingType", bizData.Type);
dbconn.sqlComm.Parameters.AddWithValue("@BandNumber", bizData.BandNumber);
dbconn.sqlComm.Parameters.AddWithValue("@BandID", bizData.BandID);
dbconn.sqlComm.Parameters.AddWithValue("@RFIDSerialNo", bizData.RFID);
dbconn.sqlComm.Parameters.AddWithValue("@Picture", "");
dbconn.sqlComm.Parameters.AddWithValue("@BirdCategory", bizData.BirdCategory);
dbconn.sqlComm.ExecuteNonQuery();
dbconn.sqlConn.Close();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
