public ActionResult courseauthors(courseXuser cua)
{
///store i in the db
/// establish the connection
try
{
/// string connectionString = "server=localhost;user id=root;database=mydb;persistsecurityinfo=True";
string conString = ConfigurationManager.ConnectionStrings["sbsclatest"].ConnectionString.ToString();
MySqlConnection con = new MySqlConnection(conString);
/// con. connectionString = "server=localhost;user id=root;database=mydb;persistsecurityinfo=True";
///
/// open the connection
con.Open();
ViewBag.successMessage = "connection was established";
string theSql = "insert courseschedule (course_idcourse,user_iduser) values(@course_idcourse,@user_iduser) where username=@username ";
MySqlCommand command = new MySqlCommand(theSql, con);
command.Parameters.AddWithValue(("@username"), cua.username);
command.Parameters.AddWithValue(("@course_idcourse"), cua.courseid);
command.Parameters.AddWithValue(("@user_iduser"), cua.userid);
//command.Parameters.Add("@coursename", MySqlDbType.String);
//command.Parameters["@coursename"].Value = theUser.coursename;
//command.Parameters.Add("@corsecode", MySqlDbType.String);
//command.Parameters["@corsecode"].Value = theUser.coursecode;
//command.Parameters.Add("@courseAuthor", MySqlDbType.String);
//command.Parameters["@courseAuthor"].Value = theUser.author;
//command.Parameters.Add("@description", MySqlDbType.String);
//command.Parameters["@description"].Value = theUser.description;
//command.Parameters.Add("@datecreated", MySqlDbType.DateTime);
//command.Parameters["@datecreated"].Value = theUser.date;
//command.Parameters.Add("@duration", MySqlDbType.String);
//command.Parameters["@duration"].Value = theUser.duration;
command.ExecuteNonQuery();
ViewBag.success = "Registration Successful";
con.Close();
}
catch (Exception e)
{
ViewBag.errorMessage = e.Message;
return(View());
}
return(RedirectToAction("Login"));
}
public ActionResult courseauthors(int id)
{
courseXuser cua = new courseXuser();
try {
string conString = ConfigurationManager.ConnectionStrings["sbsclatest"].ConnectionString.ToString();
MySqlConnection con = new MySqlConnection(conString);
/// con. connectionString = "server=localhost;user id=root;database=mydb;persistsecurityinfo=True";
///
/// open the connection
//con.Open();
ViewBag.successMessage = "connection was established";
string theSql = "SELECT iduser,username FROM sbsclatest.user";
MySqlCommand command = new MySqlCommand(theSql, con);
con.Open();
MySqlDataAdapter sda = new MySqlDataAdapter(command);
DataSet ds = new DataSet();
sda.Fill(ds);
ViewBag.usernames = ds.Tables[0];
List <SelectListItem> getusername = new List <SelectListItem>();
foreach (System.Data.DataRow dr in ViewBag.usernames.Rows)
{
getusername.Add(new SelectListItem {
Text = @dr["username"].ToString(), Value = @dr["username"].ToString()
});
}
ViewBag.usernames = getusername;
cua.courseid = id;
con.Close();
return(View(cua));
}
catch (Exception e)
{
}
return(View(cua));
}
