public ActionResult Index(ContatosModel contatosModel)
{
DataTable tbluser = new DataTable();
using (SqlConnection sqlCon = new SqlConnection(contatosDAL.Conexao))
{
sqlCon.Open();
SqlDataAdapter sqlDa = new SqlDataAdapter("select * from UsuarioAgenda", sqlCon);
sqlDa.Fill(tbluser);
}
return(View(tbluser));
}
public ActionResult Excluir(ContatosModel model)
{
var strcnn = System.Configuration.ConfigurationManager.AppSettings["connectionString"].ToString();
if (model.TIP == 1)
{
EmailBLL email = new EmailBLL(strcnn);
email.Excluir(model.ID, out int retval);
}
else if (model.TIP == 2)
{
TelefoneBLL telefone = new TelefoneBLL(strcnn);
telefone.Excluir(model.ID, out int retval);
}
return(RedirectToAction("Lista"));
}
public ActionResult Detalhes(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ContatosModel usuarios = new ContatosModel();
DataTable dataUsuario = new DataTable();
using (SqlConnection sqlCon = new SqlConnection(contatosDAL.Conexao))
{
sqlCon.Open();
string query = "SELECT * FROM UsuarioAgenda Where ID = @ID";
SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlCon);
sqlDa.SelectCommand.Parameters.AddWithValue("@ID", id);
sqlDa.Fill(dataUsuario);
}
if (dataUsuario.Rows.Count == 1)
{
usuarios.ID = Convert.ToInt32(dataUsuario.Rows[0][0].ToString());
usuarios.Nome = dataUsuario.Rows[0][1].ToString();
usuarios.Telefone = dataUsuario.Rows[0][2].ToString();
usuarios.Telefone2 = dataUsuario.Rows[0][3].ToString();
usuarios.Telefone3 = dataUsuario.Rows[0][4].ToString();
usuarios.Email = dataUsuario.Rows[0][5].ToString();
usuarios.Email2 = dataUsuario.Rows[0][6].ToString();
usuarios.Email3 = dataUsuario.Rows[0][7].ToString();
usuarios.Empresa = dataUsuario.Rows[0][8].ToString();
usuarios.Endereco = dataUsuario.Rows[0][9].ToString();
return(View(usuarios));
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult Create([Bind(Include = "ID,Nome,telefone,telefone2,telefone3,Email,Email2,Email3,Empresa,Endereco")] ContatosModel contatosModel)
{
using (SqlConnection sqlCon = new SqlConnection(contatosDAL.Conexao))
{
sqlCon.Open();
string query = "INSERT INTO UsuarioAgenda VALUES(@Nome,@telefone,@telefone2,@telefone3,@Email,@Email2,@Email3,@Empresa,@Endereco)";
SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
sqlCmd.Parameters.AddWithValue("@Nome", contatosModel.Nome);
sqlCmd.Parameters.AddWithValue("@telefone", contatosModel.Telefone);
sqlCmd.Parameters.AddWithValue("@telefone2",
((object)contatosModel.Telefone2) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@telefone3",
((object)contatosModel.Telefone3) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Email",
((object)contatosModel.Email) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Email2",
((object)contatosModel.Email2) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Email3",
((object)contatosModel.Email3) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Empresa",
((object)contatosModel.Empresa) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Endereco",
((object)contatosModel.Endereco) ?? DBNull.Value);
sqlCmd.ExecuteNonQuery();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(ContatosModel contatosModel)
{
using (SqlConnection sqlCon = new SqlConnection(contatosDAL.Conexao))
{
sqlCon.Open();
string query = "UPDATE UsuarioAgenda SET Nome = @Nome ,telefone=@telefone,telefone2=@telefone2,telefone3=@telefone3, Email = @Email,Email2 = @Email2,Email3 = @Email3,Empresa=@Empresa,Endereco=@Endereco WHere ID = @ID";
SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
sqlCmd.Parameters.AddWithValue("@ID", contatosModel.ID);
sqlCmd.Parameters.AddWithValue("@Nome", contatosModel.Nome);
sqlCmd.Parameters.AddWithValue("@telefone",
((object)contatosModel.Telefone) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@telefone2",
((object)contatosModel.Telefone2) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@telefone3",
((object)contatosModel.Telefone3) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Email",
((object)contatosModel.Email) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Email2",
((object)contatosModel.Email2) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Email3",
((object)contatosModel.Email3) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Empresa",
((object)contatosModel.Empresa) ?? DBNull.Value);
sqlCmd.Parameters.AddWithValue("@Endereco",
((object)contatosModel.Endereco) ?? DBNull.Value);
sqlCmd.ExecuteNonQuery();
}
return(RedirectToAction("Index"));
}
public ActionResult Lista(string pParam)
{
var strcnn = System.Configuration.ConfigurationManager.AppSettings["connectionString"].ToString();
ContatosBLL contatos = new ContatosBLL(strcnn);
DataTable result = contatos.CONSULTA(pParam);
List <ContatosModel> lista = new List <ContatosModel>();
foreach (DataRow row in result.Rows)
{
ContatosModel contato = new ContatosModel();
contato.IDCONTATO = (int)row["ID_CONTATO"];
contato.NOMECONTATO = row["NOME_CONTATO"].ToString();
contato.ID = (int)row["ID"];
contato.DSC = row["DSC"].ToString();
contato.TIP = (int)row["TIP"];
lista.Add(contato);
}
ListaContatos model = new ListaContatos();
model.ContatosModelLista = lista;
return(PartialView(model));
}
public ActionResult Editar(ContatosModel model)
{
return(View(model));
}
