/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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);
}