public static List <User> GetUserById(int userId)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@UserId", userId)
};
ds = objHelper.ExecDataSetProc("Gkl_USP_GETUserMaster", sqlParameter);
List <User> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new User
{
UserId = row.Field <int>("UserId"),
UserName = row.Field <string>("UserName"),
EmailAddress = row.Field <string>("EmailAddress"),
PhoneNumber = row.Field <string>("PhoneNumber"),
Gender = row.Field <string>("Gender"),
password = row.Field <string>("password"),
RoleId = row.Field <int>("RoleId"),
Active = row.Field <bool>("active")
}).ToList();
return(objlm);
}
public static List <Course> GetCourseBySemester(int SemesterId)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@SemesterId", SemesterId)
};
ds = objHelper.ExecDataSetProc("Gkl_USP_GetCourseBySemester", sqlParameter);
List <Course> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new Course
{
CourseId = row.Field <int>("CourseId"),
CourseCode = Common.ConvertFromDBVal <string>(row["CourseCode"]),
CourseName = Common.ConvertFromDBVal <string>(row["CourseName"]),
CourseType = Common.ConvertFromDBVal <string>(row["CourseType"]),
Active = row.Field <bool>("Active"),
CourseTypeId = row.Field <int>("CourseTypeId"),
SemesterId = row.Field <int>("SemesterId"),
}).ToList();
return(objlm);
}
public static FeeCategory UpdateFeeCategory(FeeCategory feeCategory)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
SqlParameter[] sqlParameter =
{
new SqlParameter("@SetAction", feeCategory.SetAction.ToUpper()),
new SqlParameter("@FeeCategoryId", feeCategory.FeeCategoryId),
new SqlParameter("@FeeCategoryName", feeCategory.FeeCategoryName),
new SqlParameter("@FeeCategoryDescription ", feeCategory.FeeCategoryDescription)
};
DataSet ds = new DataSet();
ds = objHelper.ExecDataSetProc("GKL_USP_UpdateFeeCategory", sqlParameter);
List <FeeCategory> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new FeeCategory
{
FeeCategoryId = row.Field <int>("FeeCategoryId"),
FeeCategoryName = Common.ConvertFromDBVal <string>(row["FeeCategoryName"]),
FeeCategoryDescription = Common.ConvertFromDBVal <string>(row["FeeCategoryDescription"]),
Active = row.Field <bool>("Active")
}).ToList();
return(objlm[0]);
}
public static List <Menu> GetMenuById(int menuId)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@MenuId", menuId)
};
ds = objHelper.ExecDataSetProc("GKL_USP_GETMenuMaster", sqlParameter);
List <Menu> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new Menu
{
MenuId = row.Field <int>("MenuId"),
MenuName = row.Field <string>("MenuName"),
MenuType = row.Field <string>("MenuType"),
MenuOrder = row.Field <string>("MenuOrder"),
MenuIcon = row.Field <string>("MenuIcon"),
Menu_Uri = row.Field <string>("Menu_Uri"),
ParentId = row.Field <string>("ParentId"),
Active = row.Field <bool>("Active")
}).ToList();
return(objlm);
}
public static List <AdmissionCriteriaAssociation> UpdateAdmissionCriteriaAssociation(AdmissionCriteriaAssociation admissionCriteriaAssociation)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@SetAction", admissionCriteriaAssociation.SetAction.ToUpper()),
new SqlParameter("@CriteriaIds", admissionCriteriaAssociation.CriteriaIds),
new SqlParameter("@ProgramId", admissionCriteriaAssociation.ProgramId),
new SqlParameter("@BatchId", admissionCriteriaAssociation.BatchId)
};
ds = objHelper.ExecDataSetProc("Gkl_USP_UpdateAdmissionCriteriaAssociation", sqlParameter);
List <AdmissionCriteriaAssociation> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new AdmissionCriteriaAssociation
{
BatchId = row.Field <int>("BatchId"),
ProgramId = row.Field <int>("ProgramId"),
CriteriaId = row.Field <int>("CriteriaId"),
CriteriaDescription = Common.ConvertFromDBVal <string>(row["CriteriaDescription"])
}).ToList();
return(objlm);
}
public static List <Branch> GetBranchByProgram(int ProgramId)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@ProgramId", ProgramId)
};
ds = objHelper.ExecDataSetProc("Gkl_USP_GetBranchByProgram", sqlParameter);
List <Branch> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new Branch
{
BranchId = row.Field <int>("BranchId"),
BranchCode = Common.ConvertFromDBVal <string>(row["BranchCode"]),
BranchName = Common.ConvertFromDBVal <string>(row["BranchName"]),
Active = row.Field <bool>("Active"),
ProgramId = row.Field <int>("ProgramId"),
}).ToList();
return(objlm);
}
public static List <DegreeType> GetDegreeTypeByCategory(int?id)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@DegreeCategoryId", id)
};
ds = objHelper.ExecDataSetProc("Gkl_USP_GetDegreeTypeByCategory", sqlParameter);
List <DegreeType> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new DegreeType
{
DegreeTypeId = row.Field <int>("DegreeTypeId"),
DegreeTypeCode = Common.ConvertFromDBVal <string>(row["DegreeTypeCode"]),
DegreeTypeName = Common.ConvertFromDBVal <string>(row["DegreeTypeName"]),
Active = row.Field <bool>("Active"),
DegreeCategoryId = row.Field <int>("DegreeCategoryId")
}).ToList();
return(objlm);
}
public static List <BranchSemesterAssociation> UpdateBranchSemesterAssociation(BranchSemesterAssociation branchSemesterAssociation)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@SetAction", branchSemesterAssociation.SetAction.ToUpper()),
new SqlParameter("@SemesterIds", branchSemesterAssociation.SemesterIds),
new SqlParameter("@BranchId", branchSemesterAssociation.BranchId)
};
ds = objHelper.ExecDataSetProc("Gkl_USP_UpdateBranchSemesterAssociation", sqlParameter);
List <BranchSemesterAssociation> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new BranchSemesterAssociation
{
BranchId = row.Field <int>("BranchId"),
SemesterId = row.Field <int>("SemesterId"),
SemesterCode = Common.ConvertFromDBVal <string>(row["SemesterCode"]),
SemesterName = Common.ConvertFromDBVal <string>(row["SemesterName"])
}).ToList();
return(objlm);
}
public static List <Role> GetAllRole()
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
ds = objHelper.ExecDataSetProc("Gkl_USP_GETRoleMaster");
List <Role> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new Role
{
RoleId = row.Field <int>("RoleId"),
RoleName = row.Field <string>("RoleName"),
Active = row.Field <bool>("Active")
}).ToList();
return(objlm);
}
public static List <Course> GetAllCourseType()
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
ds = objHelper.ExecDataSetProc("GKL_USP_GetCourseType");
List <Course> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new Course
{
CourseType = Common.ConvertFromDBVal <string>(row["CourseType"]),
CourseTypeId = row.Field <int>("CourseTypeId")
}).ToList();
return(objlm);
}
public static List <Batch> GetAllAcademicYear()
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
ds = objHelper.ExecDataSetProc("GKL_USP_GetAcademicYear");
List <Batch> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new Batch
{
AcademicYear = Common.ConvertFromDBVal <string>(row["AcademicYear"]),
AcademicYearId = row.Field <int>("AcademicYearId")
}).ToList();
return(objlm);
}
public static List <AdmissionCriteria> GetAllAdmissionCriteria()
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
ds = objHelper.ExecDataSetProc("Gkl_USP_GetAdmissionCriteria");
List <AdmissionCriteria> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new AdmissionCriteria
{
CriteriaId = row.Field <int>("CriteriaId"),
CriteriaDescription = Common.ConvertFromDBVal <string>(row["CriteriaDescription"]),
Active = row.Field <bool>("Active")
}).ToList();
return(objlm);
}
public static List <FeeType> GetActiveFeeType()
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
ds = objHelper.ExecDataSetProc("GKL_USP_GetActiveFeeType");
List <FeeType> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new FeeType
{
FeeTypeId = row.Field <int>("FeeTypeId"),
FeeTypeName = Common.ConvertFromDBVal <string>(row["FeeTypeName"]),
FeeTypeDescription = Common.ConvertFromDBVal <string>(row["FeeTypeDescription"]),
}).ToList();
return(objlm);
}
public static List <DegreeCategory> GetAllDegreeCategory()
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
ds = objHelper.ExecDataSetProc("Gkl_USP_GetDegreeCategory");
List <DegreeCategory> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new DegreeCategory
{
DegreeCategoryId = row.Field <int>("DegreeCategoryId"),
DegreeCategoryCode = Common.ConvertFromDBVal <string>(row["DegreeCategoryCode"]),
DegreeCategoryName = Common.ConvertFromDBVal <string>(row["DegreeCategoryName"]),
Active = row.Field <bool>("Active")
}).ToList();
return(objlm);
}
public static List <Chapter> GetAllChapter()
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
ds = objHelper.ExecDataSetProc("Gkl_USP_GetChapter");
List <Chapter> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new Chapter
{
ChapterId = row.Field <int>("ChapterId"),
ChapterCode = Common.ConvertFromDBVal <string>(row["ChapterCode"]),
ChapterName = Common.ConvertFromDBVal <string>(row["ChapterName"]),
Active = row.Field <bool>("Active")
}).ToList();
return(objlm);
}
public DataSet LoanOBLookUpTable(char loanType, int GroupID)
{
DataSet ds = new DataSet();
List <DepositOBLookup> lstloanOBLookup = new List <DepositOBLookup>();
try
{
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@LoanType", loanType);
parms[0].SqlDbType = SqlDbType.Char;
parms[1] = new SqlParameter("@GroupId", GroupID);
parms[1].SqlDbType = SqlDbType.Int;
ds = obj.ExecDataSetProc("uspLoanMasterGetGroupOldLoansLookUpTable", parms);
}
catch (Exception ex)
{
}
return(ds);
}
public DataSet DepositOBLookUpTable(bool Type, int GroupId)
{
DataSet ds = new DataSet();
List <DepositOBLookup> lstloanOBLookup = new List <DepositOBLookup>();
try
{
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@Type", Type);
parms[0].SqlDbType = System.Data.SqlDbType.Bit;
parms[1] = new SqlParameter("@GroupId", GroupId);
parms[1].SqlDbType = System.Data.SqlDbType.Int;
SqlDataAdapter dadapter = new SqlDataAdapter();
ds = obj.ExecDataSetProc("uspDepositsLookupTable", parms);
}
catch (Exception ex)
{
}
return(ds);
}
public static List <Program> GetAllProgram()
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
ds = objHelper.ExecDataSetProc("Gkl_USP_GetProgram");
List <Program> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new Program
{
ProgramId = row.Field <int>("ProgramId"),
ProgramCode = Common.ConvertFromDBVal <string>(row["ProgramCode"]),
ProgramName = Common.ConvertFromDBVal <string>(row["ProgramName"]),
Active = row.Field <bool>("Active"),
DegreeTypeId = row.Field <int>("DegreeTypeId"),
DegreeTypeCode = Common.ConvertFromDBVal <string>(row["DegreeTypeCode"]),
DegreeTypeName = Common.ConvertFromDBVal <string>(row["DegreeTypeName"]),
}).ToList();
return(objlm);
}
public static List <CourseChapterAssociation> GetCourseChapterNotMapped(int CourseId)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@CourseId", CourseId)
};
ds = objHelper.ExecDataSetProc("Gkl_USP_GetCourseChapterNotMapped", sqlParameter);
List <CourseChapterAssociation> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new CourseChapterAssociation
{
ChapterId = row.Field <int>("ChapterId"),
ChapterCode = Common.ConvertFromDBVal <string>(row["ChapterCode"]),
ChapterName = Common.ConvertFromDBVal <string>(row["ChapterName"]),
}).ToList();
return(objlm);
}
public static List <Batch> UpdateBatch(Batch batch)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@SetAction", batch.SetAction.ToUpper()),
new SqlParameter("@BatchId", batch.BatchId),
new SqlParameter("@AcademicYearId", batch.AcademicYearId)
};
ds = objHelper.ExecDataSetProc("GKL_USP_UpdateBatch", sqlParameter);
List <Batch> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new Batch
{
BatchId = row.Field <int>("BatchId"),
AcademicYearId = row.Field <int>("AcademicYearId")
}).ToList();
return(objlm);
}
public static List <BatchProgramAssociation> GetProgramByBatch(int BatchId)
{
AdoHelper objHelper = new AdoHelper(ConfigurationManager.ConnectionStrings["con"].ToString());
DataSet ds = new DataSet();
SqlParameter[] sqlParameter =
{
new SqlParameter("@BatchId", BatchId)
};
ds = objHelper.ExecDataSetProc("Gkl_USP_GetProgramByBatch", sqlParameter);
List <BatchProgramAssociation> objlm = null;
objlm = ds.Tables[0].AsEnumerable()
.Select(row => new BatchProgramAssociation
{
BatchId = row.Field <int>("BatchId"),
ProgramId = row.Field <int>("ProgramId"),
ProgramCode = Common.ConvertFromDBVal <string>(row["ProgramCode"]),
ProgramName = Common.ConvertFromDBVal <string>(row["ProgramName"])
}).ToList();
return(objlm);
}
