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"); } }