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 EclockEntrySave(DomainObjects.Entry entry) { try { DataLayer.EntryDal entryDal = new EntryDal(); return(entryDal.EclockEntrySave(entry)); } catch (Exception ex) { throw ex; } }