public ActionResult DeleteConfirmed(int id)
{
amigos amigos = db.amigos.Find(id);
db.amigos.Remove(amigos);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}//NEWCONTACT
public void InsertContactToGroupA(amigos newamigos)
{
using (var dbConn = new SQLiteConnection(App.DB_PATH))
{
dbConn.RunInTransaction(() =>
{
dbConn.Insert(newamigos);
});
}
}//NEWCONTACT
public ActionResult Edit([Bind(Include = "AmigoID,NM_Amigo,Telefone,Email,UserID")] amigos amigos)
{
if (ModelState.IsValid)
{
db.Entry(amigos).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(amigos));
}
public ActionResult Create([Bind(Include = "NM_Amigo,Telefone,Email,UserID")] amigos amigos)
{
if (ModelState.IsValid)
{
db.amigos.Add(amigos);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(amigos));
}
// GET: Amigos/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
amigos amigos = db.amigos.Find(id);
if (amigos == null)
{
return(HttpNotFound());
}
return(View(amigos));
}
protected void Page_Load(object sender, EventArgs e)
{
var connString = "Server=localhost;Database=mensageiro;Uid=root;Pwd=master"; //Aqui você substitui pelos seus dados
var connection = new MySqlConnection(connString);
var command = connection.CreateCommand();
MySqlDataReader dr;
var String = hiddenchoice;
amigos am = new amigos();
Literal1.Text = am.retornaAmigos("renato", hiddenchoice.Text);
/* try
* {
* connection.Open();
* command.CommandText = "select c.* from usuario a join amigos b on a.usuarioid = b.usuarioid join usuario c on b.usuarioamigoid = c.usuarioid where a.login = '******'";
* /*MySqlDataAdapter adap = new MySqlDataAdapter(command);
* DataSet ds = new DataSet();
* adap.Fill(ds);*/
/* dr = command.ExecuteReader();
* String divs = "",selecionado ="";
* while (dr.Read())
* {
* if (hiddenchoice.Text == Convert.ToString(dr["login"]))
* {
* selecionado = " selecionado";
* }else
* {
* // hiddenchoice.Text =""+ dr["login"];
* selecionado = "";
* }
*
*
*
* divs = divs + "<a href='#'><div onclick='javascript: DivClicked(" + '"' + dr["login"] + '"' + "); return true;'" + " class='usuario " + selecionado + "' id=" + dr["login"] + ">" + dr["nome"] + "</div></a>";
* //<div onclick="javascript:DivClicked(); return true;">click aqui</div>
* }
* Literal1.Text = divs;
* }
* finally
* {
* connection.Close();
* }*/
usuarioSessao.Text = "chegou aqui " + Session["usuarioSelecionado"];
}
