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