public static int AdmNoExists2(int admno)
{
DbAccess db = new DbAccess();
object c = db.ExecuteScalar("Select Count(*) from Student where AdmNo = '" + admno + "'");
return (Convert.ToInt32(c));
}
public DataTable GetClasses()
{
using (DbAccess db = new DbAccess())
{
DataTable dt = db.ExecuteDataTable("select * from Class");
return dt;
}
}
public DataTable GetRoles() // Get all the user's roll from roll Table
{
using (DbAccess db = new DbAccess())
{
DataTable dt = db.ExecuteDataTable("select * from Role");
return dt;
}
}
public DataTable TotrecpNos(int adno)
{
using (DbAccess db = new DbAccess())
{
DataTable dt = db.ExecuteDataTable("select COUNT(ReceiptNo) trecpno from StudentFee where AdmNo='" + adno + "'");
//where UID='" + id + "'
return dt;
}
}
public static bool AdmNoExists(int admno)//To check that admission number already exists or not
{
DbAccess db = new DbAccess();
object c = db.ExecuteScalar("Select Count(*) from Student where AdmNo = '" + admno+ "'");
if (Convert.ToInt32(c) == 0)
return false;
else
return true;
}
public DataTable GetMaxSFID(int admno) //Get Max Fee ID for Fee Table
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@AdmNo",SqlDbType.Int ,4,admno),
};
return db.ExecuteSpDataTable("MAXSFID", ref prams);
}
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 bool Update()
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@CID",SqlDbType.Int,4,CID),
db.CreateInParam("@CName",SqlDbType.VarChar,50,CName),
db.CreateInParam("@Desc",SqlDbType.VarChar,20,Desc),
};
db.ExecuteStoredProcedure("Class_Update", ref prams);
return true;
}
public bool Update()
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@UID",SqlDbType.Int,4,UserID),
db.CreateInParam("@UserName",SqlDbType.VarChar,50,UserName),
db.CreateInParam("@Password",SqlDbType.VarChar,20,Password),
db.CreateInParam("@RoleID",SqlDbType.Int,4,RoleID),
db.CreateInParam("@Section",SqlDbType.VarChar,30,Department),
db.CreateInParam("@Designation",SqlDbType.VarChar,30,Designation),
db.CreateInParam("@CNIC",SqlDbType.VarChar,15,CNIC),
};
db.ExecuteStoredProcedure("User_Update", ref prams);
return true;
}
public bool Update(string names,string cont,string dycont,string phone,string email,string add)
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@Name",SqlDbType.VarChar,100,names),
db.CreateInParam("@Controller",SqlDbType.VarChar,50,cont),
db.CreateInParam("@DyController",SqlDbType.VarChar,200,dycont),
db.CreateInParam("@Phone",SqlDbType.VarChar,200,phone),
db.CreateInParam("@Email",SqlDbType.VarChar,200,email),
db.CreateInParam("@Address",SqlDbType.VarChar,200,add),
};
db.ExecuteStoredProcedure("Org_Update", ref prams);
return true;
}
public bool ChangePwd(int uid,string pwd)
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@UID",SqlDbType.Int,4,uid),
db.CreateInParam("@Password",SqlDbType.VarChar,10,pwd),
};
db.ExecuteStoredProcedure("User_ChangePwd", ref prams);
return true;
}
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 LoadArrearsList()
{
DbAccess db = new DbAccess();
return db.ExecuteSPDataSet("ArrearList");
}
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 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 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 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 DataTable GetMaxRecpNo(int admno) //Max receipt Number
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@AdmNo",SqlDbType.Int ,4,admno),
};
return db.ExecuteSpDataTable("GetMaxReceiptIndex", 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 bool Update()
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@SFID",SqlDbType.Int,4,SFID),
db.CreateInParam("@SID",SqlDbType.Int,4,SID),
db.CreateInParam("@AdmNo",SqlDbType.Int,4,AdmNo),
db.CreateInParam("@ClassID",SqlDbType.Int,4,ClassID),
db.CreateInParam("@RecptNo",SqlDbType.VarChar,20,RecptNo),
db.CreateInParam("@Year",SqlDbType.VarChar,10,Year ),
db.CreateInParam("@Month",SqlDbType.VarChar,10,Month),
db.CreateInParam("@RegFee",SqlDbType.Int,4,RegFee),
db.CreateInParam("@AdmFee",SqlDbType.Int,4,AdmFee),
db.CreateInParam("@SecFee",SqlDbType.Int,4,SecFee),
db.CreateInParam("@ExamsFee",SqlDbType.Int,4,ExamsFee),
db.CreateInParam("@SportsFee",SqlDbType.Int,4,SportsFee),
db.CreateInParam("@TutionFee",SqlDbType.Int,4,TutionFee),
db.CreateInParam("@CollFund",SqlDbType.Int,4,CollegeFund),
db.CreateInParam("@CompFee",SqlDbType.Int,4,CompFee),
db.CreateInParam("@TransFee",SqlDbType.Int,4,TransportFee),
db.CreateInParam("@LateFee",SqlDbType.Int,4,LateFee),
db.CreateInParam("@Misc",SqlDbType.Int,4,Misc),
db.CreateInParam("@Total",SqlDbType.Int,4,Total),
db.CreateInParam("@Payed",SqlDbType.Int,4,Payed),
db.CreateInParam("@PayDate",SqlDbType.DateTime,8,PayDate),
db.CreateInParam("@CurrArrears",SqlDbType.Int,4,CurrArrears),
db.CreateInParam("@PrevArrears",SqlDbType.Int,4,PrevArrears),
};
db.ExecuteStoredProcedure("StudentFee_Update", ref prams);
return true;
}
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 GetList() //Get list of all the students
{
DbAccess db = new DbAccess();
return db.ExecuteSPDataSet("StudentList_List");
}
public bool UpdateArrears()
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@AdmNo",SqlDbType.Int,4,AdmNo),
db.CreateInParam("@Arrears",SqlDbType.Int,4,CurrArrears),
};
db.ExecuteStoredProcedure("ArrearsUpdate", ref prams);
return true;
}
public DataSet backup()
{
DbAccess db = new DbAccess();
return db.ExecuteSPDataSet("backupdata");
}
public bool Insert()
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@AdmNo",SqlDbType.Int,4,AdmNo),
db.CreateInParam("@AdmDate",SqlDbType.Date,8,AdmDate),
db.CreateInParam("@SName",SqlDbType.VarChar,50,SName ),
db.CreateInParam("@DOB",SqlDbType.Date,8,DOB),
db.CreateInParam("@Nationality",SqlDbType.VarChar,30,Nationality),
db.CreateInParam("@ClassID",SqlDbType.Int,4,ClassID),
db.CreateInParam("@Section",SqlDbType.VarChar,10,Section),
db.CreateInParam("@PrevSchool",SqlDbType.VarChar,300,PrevSchool),
db.CreateInParam("@Address",SqlDbType.VarChar,300,Address),
db.CreateInParam("@Phone",SqlDbType.VarChar,30,Phone),
db.CreateInParam("@FName",SqlDbType.VarChar,50,FName),
db.CreateInParam("@FMobile",SqlDbType.VarChar,30,FMobile),
db.CreateInParam("@MName",SqlDbType.VarChar,50,MName),
db.CreateInParam("@MMobile",SqlDbType.VarChar,30,MMobile),
db.CreateInParam("@Guardian",SqlDbType.VarChar,50,Guardian),
db.CreateInParam("@FGAddress",SqlDbType.VarChar,300,FGAddress),
db.CreateInParam("@WPhone",SqlDbType.VarChar,30,WPhone),
db.CreateInParam("@Email",SqlDbType.VarChar,30,Email),
db.CreateInParam("@Scholarship",SqlDbType.VarChar,10,Scholarship),
db.CreateInParam("@AdmStatus",SqlDbType.VarChar,100,AdmStatus),
db.CreateInParam("@Remarks",SqlDbType.VarChar,300,Remarks),
db.CreateInParam("@PIC",SqlDbType.Image,PIC.Length,PIC),
};
db.ExecuteStoredProcedure("Student_Insert", ref prams);
return true;
}
public bool SetCanceled(int sfid,int admno,int payed,int tot,string status,int parrs)
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@SFID",SqlDbType.Int,4,sfid),
db.CreateInParam("@AdmNo",SqlDbType.Int,4,admno),
db.CreateInParam("@Payed",SqlDbType.Int,4,payed),
db.CreateInParam("@Total",SqlDbType.Int,4,tot),
db.CreateInParam("@PrevArrears",SqlDbType.Int,4,parrs),
db.CreateInParam("@Status",SqlDbType.VarChar,30,status),
// db.CreateInParam("@RecptNo",SqlDbType.VarChar,20,RecptNo),
};
db.ExecuteStoredProcedure("SetCanceled", ref prams);
return true;
}
public DataTable GetList()
{
DbAccess db = new DbAccess();
return db.ExecuteDataTable("Org_List");
}
public DataTable TransactionStatus(int admno)
{
DbAccess db = new DbAccess();
SqlParameter[] prams ={
db.CreateInParam("@AdmNo",SqlDbType.Int ,4,admno),
};
return db.ExecuteSpDataTable("LastTransactionStatus", ref prams);
}
