예제 #1
0
 /// <summary>
 /// Fetch All Students
 /// </summary>
 /// <returns>Data Table</returns>
 public static TransferableDataTable FetchAllStudents()
 {
     try
     {
         using (var comm = GenericDataAccess.CreateCommand(Connections.Configuration.StudentV4Db))
         {
             comm.CommandText = "dbo.Student__FetchAll";
             var result = GenericDataAccess.ExecuteSelectCommand(comm);
             return(result);
         }
     }
     catch (Exception ex)
     {
         DataErrorLogger.LogError(ex);
         throw ex;
     }
 }
예제 #2
0
 /// <summary>
 /// Fetch Student By StudentId
 /// </summary>
 /// <param name="studentId">Student Id</param>
 /// <returns>Return student data table</returns>
 public static TransferableDataTable FetchStudentByStudentId(int studentId)
 {
     try
     {
         using (var comm = GenericDataAccess.CreateCommand(Connections.Configuration.StudentV4Db))
         {
             comm.CommandText = "dbo.Student__FetchByStudentId";
             comm.AddParamWithValue("@StudentId", DbType.Int32, studentId);
             var result = GenericDataAccess.ExecuteSelectCommand(comm);
             return(result);
         }
     }
     catch (Exception ex)
     {
         DataErrorLogger.LogError(ex);
         throw ex;
     }
 }
예제 #3
0
 /// <summary>
 /// FetchAllStudents With Paging Sorting
 /// </summary>
 /// <param name="searchValue">searchValue</param>
 /// <param name="pageNo">page No</param>
 /// <param name="pageSize">page Size</param>
 /// <param name="sortColumn">sort Column</param>
 /// <param name="sortOrder">sort Order</param>
 /// <returns>Student data table</returns>
 public static TransferableDataTable FetchAllStudentsWithPaging_Sorting(string searchValue, int pageNo, int pageSize, string sortColumn, string sortOrder)
 {
     try
     {
         using (var comm = GenericDataAccess.CreateCommand(Connections.Configuration.StudentV4Db))
         {
             comm.CommandText = "dbo.Student__FetchAll_Paging";
             comm.AddParamWithValue("@SearchValue", DbType.String, searchValue);
             comm.AddParamWithValue("@PageNo", DbType.Int32, pageNo);
             comm.AddParamWithValue("@PageSize", DbType.Int32, pageSize);
             comm.AddParamWithValue("@SortColumn", DbType.String, sortColumn);
             comm.AddParamWithValue("@SortOrder", DbType.String, sortOrder);
             var result = GenericDataAccess.ExecuteSelectCommand(comm);
             return(result);
         }
     }
     catch (Exception ex)
     {
         DataErrorLogger.LogError(ex);
         throw ex;
     }
 }
예제 #4
0
        /// <summary>
        /// Insert or Update Student
        /// </summary>
        /// <param name="studentEntity">The Student Entity</param>
        /// <returns> entity id</returns>
        //public static int InsertUpdate(IStudentEntity studentEntity)
        public static IStudentEntity InsertUpdate(IStudentEntity studentEntity)
        {
            try
            {
                using var comm   = GenericDataAccess.CreateCommand(Connections.Configuration.StudentV4Db);
                comm.CommandText = "Student_InsertUpdate";
                comm.AddParamWithValue("@StudentId", DbType.Int32, studentEntity.StudentId);
                comm.AddParamWithValue("@StudentName", DbType.String, studentEntity.StudentName);
                comm.AddParamWithValue("@StudentRollNumber", DbType.String, studentEntity.StudentRollNumber);
                comm.AddParamWithValue("@StudentFatherName", DbType.String, studentEntity.StudentFatherName);
                comm.AddParamWithValue("@StudentMotherName", DbType.String, studentEntity.StudentMotherName);
                var resu = GenericDataAccess.ExecuteNonQuery(comm);
                studentEntity.StudentId = resu;
            }
            catch (Exception ex)
            {
                DataErrorLogger.LogError(ex);
                throw ex;
            }

            return(studentEntity);
        }