public int updateADM(BeanADM adm)
{
String sql = "UPDATE SchoolManager.dbo.adm SET nome = @nome, login = @login, senha = @senha, status = @status "
+ " WHERE idadm= @id ;";
int i = 0;
using (conn = new Connection().abrirConexao())
{
using (SqlCommand command = new SqlCommand(sql, conn))
{
command.Parameters.AddWithValue("@nome", adm.Nome);
command.Parameters.AddWithValue("@login", adm.Login);
command.Parameters.AddWithValue("@senha", adm.Senha);
command.Parameters.AddWithValue("@status", adm.Status);
command.Parameters.AddWithValue("@id", adm.Idadm);
try
{
i = command.ExecuteNonQuery();
return(i);
}
catch (Exception e)
{
Debug.WriteLine("Falha ao atualizar dados: " + e);
return(i);
}
}
}
}
public int insertADM(BeanADM adm)
{
int i = 0;
String sql = "INSERT INTO SchoolManager.dbo.adm(nome,login,senha,status) VALUES(@nome,@login,@senha,@status);";
using (conn = new Connection().abrirConexao())
{
using (SqlCommand command = new SqlCommand(sql, conn))
{
command.Parameters.AddWithValue("@nome", adm.Nome);
command.Parameters.AddWithValue("@login", adm.Login);
command.Parameters.AddWithValue("@senha", adm.Senha);
command.Parameters.AddWithValue("@status", adm.Status);
try
{
i = command.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
Debug.WriteLine("Falha ao inserir dados: " + e);
}
}
}
return(i);
}
public String updateADM(String json)
{
JavaScriptSerializer js = new JavaScriptSerializer();
BeanADM obje = js.Deserialize <BeanADM>(json);
AdmDAO adm = new AdmDAO();
int i = 0;
i = adm.updateADM(obje);
return(js.Serialize(i));
}
public String admID(String json)
{
JavaScriptSerializer js = new JavaScriptSerializer();
BeanADM obje = js.Deserialize <BeanADM>(json);
AdmDAO adm = new AdmDAO();
List <BeanADM> list = new List <BeanADM>();
list = adm.selectIDADM(obje);
return(js.Serialize(list));
}
public String loginADM(String json)
{
JavaScriptSerializer js = new JavaScriptSerializer();
BeanADM obje = js.Deserialize <BeanADM>(json);
Boolean r = false;
AdmDAO adm = new AdmDAO();
r = adm.loginADM(obje.Login, obje.Senha);
return(js.Serialize(r));
}
public String admDel(String json)
{
int i = 0;
try
{
// Deserializando a string para Object
JavaScriptSerializer serializer = new JavaScriptSerializer();
BeanADM obje = serializer.Deserialize <BeanADM>(json);
AdmDAO adm = new AdmDAO();
i = adm.deleteADM(obje);
}
catch (WebException ex)
{
Debug.WriteLine("Erro: " + ex);
}
return(i.ToString());
}
public List <BeanADM> selectIDADM(BeanADM a)
{
List <BeanADM> list = new List <BeanADM>();
String sql = "SELECT DISTINCT * FROM SchoolManager.dbo.adm WHERE idadm = @id";
SqlConnection conn;
// BeanUsuario usu = new BeanUsuario();
using (conn = new Connection().abrirConexao())
{
using (SqlCommand command = new SqlCommand(sql, conn))
{
command.Parameters.AddWithValue("@id", a.Idadm);
try
{
SqlDataReader objDataReader = command.ExecuteReader();
if (objDataReader.HasRows)
{
while (objDataReader.Read())
{
BeanADM adm = new BeanADM();
adm.Idadm = int.Parse(objDataReader["idadm"].ToString());
adm.Nome = objDataReader["nome"].ToString();
adm.Login = objDataReader["login"].ToString();
adm.Senha = objDataReader["senha"].ToString();
adm.Status = Convert.ToBoolean(objDataReader["status"]);
list.Add(adm);
}
objDataReader.Close();
}
conn.Close();
}
catch (Exception e)
{
Debug.WriteLine("Erros ao selecionar todos usuarios: " + e);
}
}
}
return(list);
}
protected void listaUsuarios_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int i = e.RowIndex;
String idadm = ((Label)listaUsuarios.Rows[i].FindControl("Lid")).Text;
Debug.WriteLine("RowDeleting chamado Indice da Linha: " + i + "ID:" + idadm);
BeanADM u = new BeanADM();
u.Idadm = int.Parse(idadm);
JavaScriptSerializer serializer = new JavaScriptSerializer();
String result = ws.admDel(serializer.Serialize(u));
if (result == "0")
{
Session["msg"] = "Admin não foi excluido!";
Response.Redirect("cadastroadm.aspx");
}
else
{
Session["msg"] = " Admin excluído com sucesso!";
Response.Redirect("cadastroadm.aspx");
}
}
public int deleteADM(BeanADM adm)
{
String sql = "DELETE FROM SchoolManager.dbo.adm WHERE idadm = @pid";
SqlConnection conn;
int i = 0;
using (conn = new Connection().abrirConexao())
{
using (SqlCommand command = new SqlCommand(sql, conn))
{
command.Parameters.AddWithValue("@pid", adm.Idadm);
try
{
i = command.ExecuteNonQuery();
}
catch (Exception e)
{
Debug.WriteLine("Falha ao deletar dados: " + e);
}
conn.Close();
}
}
return(i);
}
