Exemple #1
0
 public static DataSet GetAllSTD_FeessWithRelation()
 {
     DataSet sTD_Feess = new DataSet();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Feess = sqlSTD_FeesProvider.GetAllSTD_Feess();
     return sTD_Feess;
 }
Exemple #2
0
 public static int GetStdCalculateSemesterFee()
 {
     int rowExecuted = 0;
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     rowExecuted = sqlSTD_FeesProvider.GetStdCalculateSemesterFee();
     return rowExecuted;
 }
Exemple #3
0
 public static DataSet GetAllSTD_FeesList()
 {
     DataSet sTD_Fees = new DataSet();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Fees = sqlSTD_FeesProvider.GetAllSTD_FeesList();
     return sTD_Fees;
 }
Exemple #4
0
 public static DataSet GetDropDownListAllSTD_Fees()
 {
     DataSet sTD_Feess = new DataSet();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Feess = sqlSTD_FeesProvider.GetDropDownLisAllSTD_Fees();
     return sTD_Feess;
 }
Exemple #5
0
    public static void GetAllSTD_FeesList_NotPaid(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
    {
        int recordCount = 0;
        int PageSize = int.Parse(ddlPageSize.SelectedValue);
        SqlSTD_FeesProvider sqlSTD_ProgramProvider = new SqlSTD_FeesProvider();
        DataSet ds = sqlSTD_ProgramProvider.GetAllSTD_FeesList_NotPaid(pageIndex, PageSize, out recordCount);
        gv.DataSource = processDataSet(ds);
        gv.DataBind();

        COMN_CommonManager.Paggination(rptPager, recordCount, pageIndex, PageSize);
    }
Exemple #6
0
 public static DataSet GetSTD_StudentByStudentID(string StudentID, int courseID)
 {
     DataSet sTD_Fees = new DataSet();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByStudentID(StudentID,courseID);
     return sTD_Fees;
 }
Exemple #7
0
 public static bool UpdateSTD_Fees(STD_Fees sTD_Fees)
 {
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     return sqlSTD_FeesProvider.UpdateSTD_Fees(sTD_Fees);
 }
Exemple #8
0
 public static bool DeleteSTD_FeesByFeesMasterID(int sTD_FeesID)
 {
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     return sqlSTD_FeesProvider.DeleteSTD_FeesFeesMasterID(sTD_FeesID);
 }
Exemple #9
0
 public static void LoadSTD_FeesPageByStudentIDisPaid(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize, string StudentID,bool ispaid)
 {
     int recordCount = 0;
     int PageSize = int.Parse(ddlPageSize.SelectedValue);
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     DataSet ds = sqlSTD_FeesProvider.GetSTD_FeesPageWiseByStudentIDisPaid(pageIndex, PageSize, out recordCount, StudentID, ispaid);
     gv.DataSource = ds;
     gv.DataBind();
     sTD_FeessPaggination(rptPager, recordCount, pageIndex, PageSize);
 }
Exemple #10
0
 public static int InsertSTD_Fees(STD_Fees sTD_Fees)
 {
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     return sqlSTD_FeesProvider.InsertSTD_Fees(sTD_Fees);
 }
Exemple #11
0
 public static DataSet GetSTD_FeesListByFeesMasterID(string feesMasterID)
 {
     DataSet sTD_Fees = new DataSet();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesListByFeesMasterID(feesMasterID);
     return sTD_Fees;
 }
Exemple #12
0
 public static DataSet GetSTD_SemesterFeeByStudentID(string studentID)
 {
     DataSet sTD_Feess = new DataSet();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Feess = sqlSTD_FeesProvider.GetSTD_SemesterFeeByStudentID(studentID);
     return sTD_Feess;
 }
Exemple #13
0
 public static STD_Fees GetSTD_RowStatusByRowStatusID(int RowStatusID)
 {
     STD_Fees sTD_Fees = new STD_Fees();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByRowStatusID(RowStatusID);
     return sTD_Fees;
 }
Exemple #14
0
 public static STD_Fees GetSTD_FeesTypeByFeesTypeID(int FeesTypeID)
 {
     STD_Fees sTD_Fees = new STD_Fees();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByFeesTypeID(FeesTypeID);
     return sTD_Fees;
 }
Exemple #15
0
 public static DataSet GetSTD_FeesStudentByStudentID(string StudentID,bool isDataset)
 {
     DataSet sTD_Fees = new DataSet();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByStudentID(StudentID,isDataset);
     return sTD_Fees;
 }
Exemple #16
0
 public static STD_Fees GetSTD_FeesStudentByStudentID(string StudentID)
 {
     STD_Fees sTD_Fees = new STD_Fees();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByStudentID(StudentID);
     return sTD_Fees;
 }
Exemple #17
0
 public static DataSet GetSTD_FeesListByStudentCode(string studentCode)
 {
     DataSet sTD_Fees = new DataSet();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesListByStudentCode(studentCode);
     return sTD_Fees;
 }
Exemple #18
0
 public static bool DeleteSTD_Fees(int sTD_FeesID)
 {
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     return sqlSTD_FeesProvider.DeleteSTD_Fees(sTD_FeesID);
 }
Exemple #19
0
 //public static void sTD_FeesPaggination(System.Web.UI.WebControls.Repeater rptPager, int recordCount, int currentPage, int PageSize)
 //{
 //    double dblPageCount = (double)((decimal)recordCount / decimal.Parse(PageSize.ToString()));
 //    int pageCount = (int)Math.Ceiling(dblPageCount);
 //    List<ListItem> pages = new List<ListItem>();
 //    if (pageCount > 0)
 //    {
 //        pages.Add(new ListItem("First", "1", currentPage > 1));
 //        for (int i = 1; i <= pageCount; i++)
 //        {
 //            pages.Add(new ListItem(i.ToString(), i.ToString(), i != currentPage));
 //        }
 //        pages.Add(new ListItem("Last", pageCount.ToString(), currentPage < pageCount));
 //    }
 //    rptPager.DataSource = pages;
 //    rptPager.DataBind();
 //}
 //public static DataSet GetAllSTD_FeesList_NotPaid()
 //{
 //    DataSet sTD_Fees = new DataSet();
 //    SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
 //    sTD_Fees = sqlSTD_FeesProvider.GetAllSTD_FeesList_NotPaid();
 //    return sTD_Fees;
 //}
 public static STD_Fees GetSTD_CourseByCourseID(int CourseID)
 {
     STD_Fees sTD_Fees = new STD_Fees();
     SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
     sTD_Fees = sqlSTD_FeesProvider.GetSTD_FeesByCourseID(CourseID);
     return sTD_Fees;
 }