public Int32 SaveStudentsDetails(STUDENT_BEL objBEL) { SqlDataReader dr = null; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); SqlCommand cmd = new SqlCommand("ENTER_STUDENT_SP", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@FIRST_NAME", objBEL.FIRST_NAME); cmd.Parameters.AddWithValue("@MIDDLE_NAME", objBEL.MIDDLE_NAME); cmd.Parameters.AddWithValue("@LAST_NAME", objBEL.LAST_NAME); cmd.Parameters.AddWithValue("@DATE_OF_ADMISSION", DateTime.Now); try { dr = cmd.ExecuteReader(); if (dr.Read()) { if (dr[0].ToString() == "1") { return(1); } else { return(0); } } else { return(0); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { dr.Close(); cmd.Dispose(); Conn.Close(); Conn.Dispose(); } } } }
public DataSet GetStudentsRecords() { dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; DataSet ds = new DataSet(); try { SqlCommand cmd = new SqlCommand("GET_STUDENT_SP", Conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(ds); cmd.Dispose(); } catch (Exception ex) { throw ex; } finally { ds.Dispose(); } return(ds); }