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;
}
public static int GetStdCalculateSemesterFee()
{
int rowExecuted = 0;
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
rowExecuted = sqlSTD_FeesProvider.GetStdCalculateSemesterFee();
return rowExecuted;
}
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;
}
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;
}
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);
}
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;
}
public static bool UpdateSTD_Fees(STD_Fees sTD_Fees)
{
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
return sqlSTD_FeesProvider.UpdateSTD_Fees(sTD_Fees);
}
public static bool DeleteSTD_FeesByFeesMasterID(int sTD_FeesID)
{
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
return sqlSTD_FeesProvider.DeleteSTD_FeesFeesMasterID(sTD_FeesID);
}
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);
}
public static int InsertSTD_Fees(STD_Fees sTD_Fees)
{
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
return sqlSTD_FeesProvider.InsertSTD_Fees(sTD_Fees);
}
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;
}
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;
}
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;
}
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;
}
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;
}
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;
}
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;
}
public static bool DeleteSTD_Fees(int sTD_FeesID)
{
SqlSTD_FeesProvider sqlSTD_FeesProvider = new SqlSTD_FeesProvider();
return sqlSTD_FeesProvider.DeleteSTD_Fees(sTD_FeesID);
}
//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;
}