public CourseRegistration GetCourse2(string CourseId)
{
string query = "SELECT * from CourseTable WHERE CourseId = '" + CourseId + "'";
CourseRegistration c = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
c = new CourseRegistration();
c.CourseId = sdr["CourseId"].ToString();
c.CourseName = sdr["Name"].ToString();
c.Semester = sdr["Semester"].ToString();
c.Section = sdr["Section"].ToString();
}
dcc.CloseConnection();
return(c);
}
public List <Note> GetAllNotes(string semester, string courseName)
{
string query = "SELECT * from NoteTable WHERE Semester= '" + semester + "' AND CourseName= '" + courseName + "'";
List <Note> nList = new List <Note>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Note n = new Note();
n.CourseName = sdr["CourseName"].ToString();
n.NotePath = sdr["NotePath"].ToString();
n.Semester = sdr["Semester"].ToString();
n.Section = sdr["Section"].ToString();
nList.Add(n);
}
dcc.CloseConnection();
return(nList);
}
public List <CourseAssign> GetAllAssignedCourses2()
{
string query = "SELECT * from CourseAssignTable";
List <CourseAssign> sList = new List <CourseAssign>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
CourseAssign s = new CourseAssign();
s.AccountId = sdr["AccountId"].ToString();
s.AssignedCourse = sdr["AssignedCourse"].ToString();
s.Semester = sdr["Semester"].ToString();
s.Section = sdr["Section"].ToString();
sList.Add(s);
}
dcc.CloseConnection();
return(sList);
}
/*public bool UpdatePlaces(Places p)
* {
* string query = "UPDATE Places SET = '" + emp.Name + "', phonenumber = '" + emp.PhnNumber + "', salary = " + emp.Salary + ", designation = '" + emp.Designation + "' WHERE id = '" + emp.Id + "'";
* try
* {
* dcc.ConnectWithDB();
* dcc.ExecuteSQL(query);
* return true;
* }
* catch (Exception exp)
* {
* return false;
* }
* finally
* {
* dcc.CloseConnection();
* }
* }*/
public List <Places> GetAllPlaces()
{
List <Places> listOfPlaces = new List <Places>();
string query = "SELECT * FROM Places";
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Places p = new Places();
p.From = sdr["wherefrom"].ToString();
p.To = sdr["whereto"].ToString();
listOfPlaces.Add(p);
}
dcc.CloseConnection();
return(listOfPlaces);
}
public List <Teacher> GetAllTeacherInfo2()
{
string query = "SELECT * from TeacherTable";
List <Teacher> cList = new List <Teacher>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Teacher t = new Teacher();
t.AccountId = sdr["AccountId"].ToString();
t.WeekHour = Convert.ToInt32(sdr["WeekHour"]);
t.Status = sdr["Status"].ToString();
t.Salary = Convert.ToDouble(sdr["Salary"]);
cList.Add(t);
}
dcc.CloseConnection();
return(cList);
}
public List <string> GetOnlySection(string semester, string ID, string course)
{
string query = "SELECT * from CourseRegistrationTable WHERE Semester= '" + semester + "' AND AccountId= '" + ID + "'AND CourseName= '" + course + "'";
List <string> cList = new List <string>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
CourseRegistration c = new CourseRegistration();
c.CourseId = sdr["CourseId"].ToString();
c.CourseName = sdr["CourseName"].ToString();
c.Section = sdr["Section"].ToString();
c.AccountId = sdr["AccountId"].ToString();
c.Status = sdr["Status"].ToString();
cList.Add(c.Section);
}
dcc.CloseConnection();
return(cList);
}
public List <Course> GetAllCourse2(string accountid, string sname)
{
string query = "SELECT Name,Schedule from CourseTable WHERE CourseId IN (SELECT CourseId from CourseRegistrationTable WHERE AccountId='" + accountid + "' AND Semester='" + sname + "')";
List <Course> aList = new List <Course>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Course a = new Course();
a.Name = sdr["Name"].ToString();
a.Schedule = sdr["Schedule"].ToString();
aList.Add(a);
}
dcc.CloseConnection();
return(aList);
}
public List <string> GetAccountIdsScholarshipApprove2()
{
string query = "SELECT * from StudentBalanceTable WHERE Scholarship = 'Eligible For Scholarship'";
List <string> sList = new List <string>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
StudentBalance s = new StudentBalance();
s.AccountId = sdr["AccountId"].ToString();
s.Semester = sdr["Semester"].ToString();
s.Scholarship = sdr["Scholarship"].ToString();
s.Balance = Convert.ToDouble(sdr["Balance"]);
s.Validation = sdr["Validation"].ToString();
sList.Add(s.AccountId);
}
dcc.CloseConnection();
return(sList);
}
public List <CourseAssign> GetAllSections(string accountId, string semseter)
{
string query = "SELECT * from CourseAssignTable WHERE AccountId='" + accountId + "' AND Semester='" + semseter + "'";
List <CourseAssign> cList = new List <CourseAssign>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
CourseAssign c = new CourseAssign();
c.AccountId = sdr["AccountId"].ToString();
c.AssignedCourse = sdr["AssignedCourse"].ToString();
c.Semester = sdr["Semester"].ToString();
c.Section = sdr["Section"].ToString();
cList.Add(c);
}
dcc.CloseConnection();
return(cList);
}
public List <Notice> GetAllNotice(string semester, string courseId, string section)
{
string query = "SELECT * from NoticeTable WHERE Semester= '" + semester + "' AND CourseId= '" + courseId + "' AND Section= '" + section + "'";
List <Notice> cList = new List <Notice>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Notice c = new Notice();
c.CourseId = sdr["CourseId"].ToString();
c.Semester = sdr["Semester"].ToString();
c.Section = sdr["Section"].ToString();
c.Noticee = sdr["Notice"].ToString();
c.Date = sdr["Date"].ToString();
cList.Add(c);
}
dcc.CloseConnection();
return(cList);
}
public bool RoutineVerification2(string accountid, string sname)
{
string query = "SELECT CourseId from CourseRegistrationTable WHERE AccountId='" + accountid + "' AND Semester='" + sname + "'";
Course a = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
a = new Course();
dcc.CloseConnection();
return(true);
}
else
{
dcc.CloseConnection();
return(false);
}
}
public string UserLoginVerification2(Account a)
{
string query = "SELECT * from AccountTable WHERE AccountId= '" + a.AccountId + "' AND Password= '******'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
//a.Name = sdr["AccountName"].ToString();
//a.Gender = Convert.ToDouble(sdr["Salary"]);
//a.Address = sdr["Designation"].ToString();
a.AccountType = sdr["AccountType"].ToString();
dcc.CloseConnection();
return(a.AccountType);
}
else
{
dcc.CloseConnection();
return("false");
}
}
public List <CourseRegistration> GetAllCourses2()
{
string query = "SELECT * from CourseRegistrationTable";
List <CourseRegistration> cList = new List <CourseRegistration>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
CourseRegistration c = new CourseRegistration();
c.CourseId = sdr["CourseId"].ToString();
c.CourseName = sdr["CourseName"].ToString();
c.Semester = sdr["Semester"].ToString();
c.Section = sdr["Section"].ToString();
c.AccountId = sdr["AccountId"].ToString();
c.Status = sdr["Status"].ToString();
cList.Add(c);
}
dcc.CloseConnection();
return(cList);
}
public bool CheckExamCourseId2(string CourseId)
{
string query = "SELECT * from ExamTable WHERE CourseId = '" + CourseId + "'";
Exam e = new Exam();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
e = new Exam();
e.CourseId = sdr["CourseId"].ToString();
e.Semester = sdr["Semester"].ToString();
e.Day = sdr["Day"].ToString();
e.Slot = sdr["Slot"].ToString();
e.AssignedFacultyId = sdr["AssignedFacultyId"].ToString();
e.Room = sdr["Room"].ToString();
return(true);
}
dcc.CloseConnection();
return(false);
}
public List <Exam> GetAllExams2()
{
string query = "SELECT * from ExamTable";
List <Exam> eList = new List <Exam>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Exam e = new Exam();
e.CourseId = sdr["CourseId"].ToString();
e.Semester = sdr["Semester"].ToString();
e.Day = sdr["Day"].ToString();
e.Slot = sdr["Slot"].ToString();
e.Room = sdr["Room"].ToString();
e.AssignedFacultyId = sdr["AssignedFacultyId"].ToString();
eList.Add(e);
}
dcc.CloseConnection();
return(eList);
}
public bool UserLoginValidation(Customer cm)
{
string query = "SELECT * from Customer WHERE CId = '" + cm.CId + "' AND CPassword='******'";
DatabaseConnectionClass dcc1 = new DatabaseConnectionClass();
dcc1.ConnectWithDB();
SqlDataReader sdr3 = dcc1.GetData(query);
// dcc.CloseConnection();
if (sdr3.Read())
{
cm.CName = sdr3["CName"].ToString();
cm.CEmail = sdr3["CEmail"].ToString();
cm.CPhone = sdr3["CPhone"].ToString();
dcc1.CloseConnection();
return(true);
}
else
{
dcc1.CloseConnection();
return(false);
}
}
public bool UserLoginValidation(Owner own)
{
string query = "SELECT * from Owner WHERE OId = '" + own.OId + "' AND OPassword='******'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr1 = dcc.GetData(query);
// dcc.CloseConnection();
if (sdr1.Read())
{
own.OName = sdr1["OName"].ToString();
own.OEmail = sdr1["OEmail"].ToString();
own.OPhone = sdr1["OPhone"].ToString();
dcc.CloseConnection();
return(true);
}
else
{
dcc.CloseConnection();
return(false);
}
}
public List <CourseResults> GetAllResult(string semester, string ID)
{
string query = "SELECT * from CourseResultsTable WHERE Semester= '" + semester + "' AND AccountId= '" + ID + "'";
List <CourseResults> gList = new List <CourseResults>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
CourseResults c = new CourseResults();
c.CourseName = sdr["CourseName"].ToString();
c.Section = sdr["Section"].ToString();
c.Quiz = Convert.ToDouble(sdr["Quiz"]);
c.Term = Convert.ToDouble(sdr["Term"]);
c.FinalMark = Convert.ToDouble(sdr["FinalMark"]);
c.Grade = Convert.ToDouble(sdr["Grade"]);
c.Status = sdr["Status"].ToString();
gList.Add(c);
}
dcc.CloseConnection();
return(gList);
}
public Account GetAccountTypeShovon2(string AccountId)
{
string query = "SELECT * from AccountTable WHERE AccountId= '" + AccountId + "'";
Account a = null;
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
if (sdr.Read())
{
a = new Account();
a.AccountId = sdr["AccountId"].ToString();
a.Password = sdr["Password"].ToString();
a.Name = sdr["Name"].ToString();
a.Gender = sdr["Gender"].ToString();
a.Address = sdr["Address"].ToString();
a.AccountType = sdr["AccountType"].ToString();
a.BloodGroup = sdr["BloodGroup"].ToString();
a.DOB = sdr["DOB"].ToString();;
}
dcc.CloseConnection();
return(a);
}
