public DataSet GetListSpecific(string uname,string pwd,int roleid)
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@UserName",SqlDbType.VarChar ,50,uname),
db.CreateInParam("@Password",SqlDbType.VarChar,20,pwd ),
db.CreateInParam("@RoleID",SqlDbType.Int,4,roleid),
};
return db.ExecuteSPDataSet("CheckLogin", ref prams);
}
public DataSet GetList() //Get list of all the students
{
DbAccess db = new DbAccess();
return db.ExecuteSPDataSet("StudentList_List");
}
public DataSet LoadArrearsClass(int clsid) //get list by classid
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@ClassID",SqlDbType.Int,4,clsid),
};
return db.ExecuteSPDataSet("ArrearstbyClass", ref prams);
}
public DataSet GetArrearsAdmNo(int admno)//get list by admission number
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@AdmNo",SqlDbType.Int,4,admno),
};
return db.ExecuteSPDataSet("ArrearsbyAdmNo", ref prams);
}
public DataSet LoadFreshFee(int admno) // Fee for a fresh student
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@AdmNo",SqlDbType.Int ,4,admno),
};
return db.ExecuteSPDataSet("LoadFreshFee", ref prams);
}
public DataSet MonthlyFeeRem(int admno)
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@AdmNo",SqlDbType.Int ,4,admno),
};
return db.ExecuteSPDataSet("MonthlyFeeReminder", ref prams);
}
public DataSet LoadArrearsList()
{
DbAccess db = new DbAccess();
return db.ExecuteSPDataSet("ArrearList");
}
public DataSet LoadStudentFeeByClass(int cls)
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@ClassID",SqlDbType.Int ,4,cls),
};
return db.ExecuteSPDataSet("StudentFeeByClass_Load", ref prams);
}
public DataSet LoadStudentFeeByReceipt(string recpno)
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@ReceiptNo",SqlDbType.VarChar,20,recpno),
};
return db.ExecuteSPDataSet("StudentFee_Receipt", ref prams);
}
public DataSet LoadStudentFee(int admno)
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@AdmNo",SqlDbType.Int ,4,admno),
};
return db.ExecuteSPDataSet("StudentFee_Load", ref prams);
}
public DataSet GetList()
{
DbAccess db = new DbAccess();
return db.ExecuteSPDataSet("AllUsers_List");
}
public DataSet backup()
{
DbAccess db = new DbAccess();
return db.ExecuteSPDataSet("backupdata");
}