public string insertPresentCourse(string coursetitle, string coursecode, string credit, string type, string grade, string final, string mid, string outof, string userid)
{
MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand();
String insertQuery = "INSERT INTO presentcourse (coursetitle, coursecode, credit, type, grade, final, mid, outof,userid) VALUES (@ct,@cc,@cdt,@typ,@grd,@fnl,@mid,@out,@uid)";
command.CommandText = insertQuery;
command.Connection = conn.GetConnection();
command.Connection.Open();
command.Parameters.Add("@ct", MySqlDbType.VarChar).Value = coursetitle;
command.Parameters.Add("@cc", MySqlDbType.VarChar).Value = coursecode;
command.Parameters.Add("@cdt", MySqlDbType.VarChar).Value = credit;
command.Parameters.Add("@typ", MySqlDbType.VarChar).Value = type;
command.Parameters.Add("@grd", MySqlDbType.VarChar).Value = grade;
command.Parameters.Add("@fnl", MySqlDbType.VarChar).Value = final;
command.Parameters.Add("@mid", MySqlDbType.VarChar).Value = mid;
command.Parameters.Add("@out", MySqlDbType.VarChar).Value = outof;
command.Parameters.Add("@uid", MySqlDbType.VarChar).Value = userid;
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return("ok");
}
else
{
conn.closeConnection();
return("no");
}
}
public string insertRoutine(string day, string time, string subjectcode, string subjectname, string room)
{
MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand();
String insertQuery = "INSERT INTO routine (day, time, subjectcode, subjectname,room) VALUES (@day,@time,@sc,@sn,@room)";
command.CommandText = insertQuery;
command.Connection = conn.GetConnection();
command.Connection.Open();
command.Parameters.Add("@day", MySqlDbType.VarChar).Value = day;
command.Parameters.Add("@time", MySqlDbType.VarChar).Value = time;
command.Parameters.Add("@sc", MySqlDbType.VarChar).Value = subjectcode;
command.Parameters.Add("@sn", MySqlDbType.VarChar).Value = subjectname;
command.Parameters.Add("@room", MySqlDbType.VarChar).Value = room;
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return("ok");
}
else
{
conn.closeConnection();
return("no");
}
}
public string insertRegister(string userid, string password, string IdSerialNo, string email, string phone)
{
MySqlCommand studentComm = new MySqlCommand("SELECT * FROM `student` where rollid=@id", conn.GetConnection());
MySqlDataAdapter Studentadapter = new MySqlDataAdapter();
studentComm.Parameters.AddWithValue("@id", userid);
studentComm.Connection = conn.GetConnection();
studentComm.Connection.Open();
MySqlDataReader studentreader;
studentreader = studentComm.ExecuteReader();
int count = 0;
string studentName = string.Empty;
string userRole = string.Empty;
while (studentreader.Read())
{
count = count + 1;
studentName = studentreader["name"].ToString();
}
if (count == 1)
{
conn.closeConnection();
MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand();
String insertQuery = "INSERT INTO users (userid, password, IdSerialNo, email, phone) VALUES (@uid,@pa,@sid,@eml,@phn)";
command.CommandText = insertQuery;
command.Connection = conn.GetConnection();
command.Connection.Open();
command.Parameters.Add("@uid", MySqlDbType.VarChar).Value = userid;
command.Parameters.Add("@pa", MySqlDbType.VarChar).Value = password;
command.Parameters.Add("@sid", MySqlDbType.VarChar).Value = IdSerialNo;
command.Parameters.Add("@eml", MySqlDbType.VarChar).Value = email;
command.Parameters.Add("@phn", MySqlDbType.VarChar).Value = phone;
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return("ok");
}
else
{
conn.closeConnection();
return("no");
}
}
else
{
conn.closeConnection();
return("authorized");
}
}
