public DataSet RfidSave(string rfidTags) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn(SP_RFIDSAVE); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@RFIDTags", rfidTags); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); return(dataResult); } catch (Exception ex) { throw ex; } }
public DataSet EclockEntrySave(DomainObjects.Entry entry) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("EclockEntryGlobalSave"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@ClubName", entry.Clubname); dbconn.sqlComm.Parameters.AddWithValue("@RFID", entry.RFID); dbconn.sqlComm.Parameters.AddWithValue("@MemberIDNo", entry.MemberIDNo); dbconn.sqlComm.Parameters.AddWithValue("@BirdCategory", entry.RaceCategoryName); dbconn.sqlComm.Parameters.AddWithValue("@DateRelease", entry.ReleaseDate); dbconn.sqlComm.Parameters.AddWithValue("@RingNumber", entry.RingNumber); dbconn.sqlComm.Parameters.AddWithValue("@MobileNumber", entry.MobileNumber); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); return(dataResult); } catch (Exception ex) { throw ex; } }
public DataSet EclockResultSave(DomainObjects.Result result) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("EclockCommand"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.Parameters.AddWithValue("@SMSContent", result.SMSContent); dbconn.sqlComm.Parameters.AddWithValue("@ActionFrom", result.ActionFrom); dbconn.sqlComm.Parameters.AddWithValue("@ClubName", result.ClubName); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); return(dataResult); } catch (Exception ex) { throw ex; } }