public int insertHistorico(BeanHistorico his)
{
int i = 0;
String sql = "INSERT INTO SchoolManager.dbo.historico(idaluno_fk,msg,dt_hora) VALUES(@idaluno_fk,@msg,@data);";
using (conn = new Connection().abrirConexao())
{
using (SqlCommand command = new SqlCommand(sql, conn))
{
command.Parameters.AddWithValue("@idaluno_fk", his.Aluno.Idaluno);
command.Parameters.AddWithValue("@msg", his.Msg);
command.Parameters.AddWithValue("@data", DateTime.Now);
try
{
i = command.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
Debug.WriteLine("Falha ao inserir dados: " + e);
}
}
}
return(i);
}
protected void enviar_Click(object sender, EventArgs e)
{
/*lb_msg.Text = "Relatório enviado com sucesso!";
* tb_nome.Text = "";
* msgtb.Text = "";*/
//Response.Redirect("relatorio.aspx");
Utils utils = new Utils();
String rel = "";
String json = "";
BeanAluno ba = new BeanAluno();
BeanHistorico bh = new BeanHistorico();
if (id.Text == "")
{
ba.Idaluno = int.Parse(tb_nome.Text);
bh.Aluno = ba;
bh.Msg = msgtb.Text;
json = new JavaScriptSerializer().Serialize(bh);
rel = ws.historicoIn(json);
if (rel.Equals("\"0\""))
{
Session["msgBD"] = "Problema ao enviar relatório";
Response.Redirect("relatorio.aspx");
}
else if (rel.Equals("\"1\""))
{
Session["msgBD"] = "Relatório enviado com sucesso!";
Response.Redirect("relatorio.aspx");
}
else if (rel.Equals("\"2\""))
{
Session["msgBD"] = "Erro";
Response.Redirect("c.aspx");
}
else
{
Session["msgBD"] = "Eduardo falo que Isac mangou de mim!" + rel;
Response.Redirect("relatorio.aspx");
}
}
}
public String historicoDel(String json)
{
int i = 0;
try
{
// Deserializando a string para Object
JavaScriptSerializer serializer = new JavaScriptSerializer();
BeanHistorico obje = serializer.Deserialize <BeanHistorico>(json);
HistoricoDAO his = new HistoricoDAO();
i = his.deleteHistorico(obje);
}
catch (WebException ex)
{
Debug.WriteLine("Erro: " + ex);
}
return(i.ToString());
}
public List <BeanHistorico> selectAll()
{
List <BeanHistorico> list = new List <BeanHistorico>();
String sql = "SELECT DISTINCT * FROM SchoolManager.dbo.historico ORDER BY idhistorico DESC";
SqlConnection conn;
// BeanUsuario usu = new BeanUsuario();
using (conn = new Connection().abrirConexao())
{
using (SqlCommand command = new SqlCommand(sql, conn))
{
try
{
SqlDataReader objDataReader = command.ExecuteReader();
if (objDataReader.HasRows)
{
while (objDataReader.Read())
{
BeanHistorico his = new BeanHistorico();
BeanAluno al = new BeanAluno();
his.Idhistorico = int.Parse(objDataReader["idhistorico"].ToString());
al.Idaluno = int.Parse(objDataReader["idaluno_fk"].ToString());
his.Aluno = al;
his.Msg = objDataReader["msg"].ToString();
list.Add(his);
}
objDataReader.Close();
}
conn.Close();
}
catch (Exception e)
{
Debug.WriteLine("Erros ao selecionar todos usuarios: " + e);
}
}
}
return(list);
}
public int deleteHistorico(BeanHistorico his)
{
String sql = "DELETE FROM SchoolManager.dbo.adm WHERE idhistorico = @pid";
SqlConnection conn;
int i = 0;
using (conn = new Connection().abrirConexao())
{
using (SqlCommand command = new SqlCommand(sql, conn))
{
command.Parameters.AddWithValue("@pid", his.Idhistorico);
try
{
i = command.ExecuteNonQuery();
}
catch (Exception e)
{
Debug.WriteLine("Falha ao deletar dados: " + e);
}
conn.Close();
}
}
return(i);
}
