public Aluno_MedTV_Transacao Buscar(Aluno_MedTV aluno_medtv, string code, int status)
{
try
{
Aluno_MedTV_Transacao aluno_medtv_transacao = null;
DBSession session = new DBSession();
Query query = session.CreateQuery("select isnull(aluno_MedTV_Transacao_id, 0) as aluno_MedTV_Transacao_id, isnull(aluno_MedTV_id, 0) as aluno_MedTV_id, isnull(status, 0) as status, isnull(code, '') as code, isnull(data, '01/01/1900') as data, isnull(msg, '') as msg FROM Aluno_MedTV_Transacao WHERE aluno_medtv_id = @aluno_medtv_id AND code = @code and status = @status");
query.SetParameter("aluno_medtv_id", aluno_medtv.aluno_MedTV_id)
.SetParameter("code", code)
.SetParameter("status", status);
IDataReader reader = query.ExecuteQuery();
if (reader.Read())
{
aluno_medtv_transacao = new Aluno_MedTV_Transacao(Convert.ToInt32(reader["aluno_MedTV_transacao_id"]), aluno_medtv, Convert.ToInt32(reader["status"]), Convert.ToString(reader["code"]), Convert.ToString(reader["msg"]), Convert.ToDateTime(reader["data"]));
}
reader.Close();
session.Close();
return(aluno_medtv_transacao);
}
catch (Exception error)
{
throw error;
}
}
public int SalvarRetornar(Aluno_MedTV_Transacao variavel)
{
try
{
Salvar(variavel);
return(Buscar(variavel.aluno_medTV_id, variavel.code, variavel.status).aluno_MedTV_Transacao_id);
}
catch (Exception error)
{
throw error;
}
}
public void Excluir(Aluno_MedTV_Transacao variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("DELETE FROM aluno_MedTV_Transacao WHERE aluno_MedTV_Transacao_id = @aluno_MedTV_Transacao_id;");
query.SetParameter("aluno_MedTV_Transacao_id", variavel.aluno_MedTV_Transacao_id);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void Alterar(Aluno_MedTV_Transacao variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("UPDATE Aluno_MedTV_Transacao SET code = @code, status = @status, msg = @msg, data = @data WHERE aluno_MedTV_Transacao_id = @aluno_MedTV_Transacao_id");
query.SetParameter("aluno_MedTV_Transacao_id", variavel.aluno_MedTV_Transacao_id)
.SetParameter("code", variavel.code)
.SetParameter("status", variavel.status)
.SetParameter("msg", variavel.msg)
.SetParameter("data", variavel.data);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public void Salvar(Aluno_MedTV_Transacao variavel)
{
try
{
DBSession session = new DBSession();
Query query = session.CreateQuery("INSERT INTO aluno_MedTV_Transacao (aluno_medtv_id, status, code, msg, data) VALUES (@aluno_medtv_id, @status, @code, @msg, @data) ");
query.SetParameter("aluno_medtv_id", variavel.aluno_medTV_id.aluno_MedTV_id)
.SetParameter("status", variavel.status)
.SetParameter("data", variavel.data)
.SetParameter("code", variavel.code)
.SetParameter("msg", variavel.msg);
query.ExecuteUpdate();
session.Close();
}
catch (Exception error)
{
throw error;
}
}
public Aluno_MedTV TratarRetorno(Transaction transaction)
{
Aluno_MedTV am = new Aluno_MedTVDB().Buscar(Convert.ToInt32(transaction.Reference));
int status = transaction.TransactionStatus;
//if (transaction.TransactionStatus == Uol.PagSeguro.Enums.TransactionStatus.Initiated)
// status = 0;
//if (transaction.TransactionStatus == Uol.PagSeguro.Enums.TransactionStatus.WaitingPayment)
// status = 1;
//if (transaction.TransactionStatus == Uol.PagSeguro.Enums.TransactionStatus.InAnalysis)
// status = 2;
//if (transaction.TransactionStatus == Uol.PagSeguro.Enums.TransactionStatus.Paid)
// status = 3;
//if (transaction.TransactionStatus == Uol.PagSeguro.Enums.TransactionStatus.Available)
// status = 4;
//if (transaction.TransactionStatus == Uol.PagSeguro.Enums.TransactionStatus.InDispute)
// status = 5;
//if (transaction.TransactionStatus == Uol.PagSeguro.Enums.TransactionStatus.Refunded)
// status = 6;
//if (transaction.TransactionStatus == Uol.PagSeguro.Enums.TransactionStatus.Cancelled)
// status = 7;
Aluno_MedTV_Transacao amt = new Aluno_MedTV_TransacaoDB().Buscar(am, transaction.Code, status);
if (amt == null)
{
amt = new Aluno_MedTV_Transacao()
{
aluno_medTV_id = am,
code = transaction.Code,
data = DateTime.Now,
status = status
};
amt.Salvar();
}
if (am != null)
{
am.aluno = new AlunoDB().Buscar(am.aluno.codigo);
//salva o code no Aluno_MedTV
//msg do status
amt.msg = TransacaoMsg(status);
//3 Paga
if (transaction.TransactionStatus == 3)
{
//se não estiver ativo, ativa o usuário
if (!am.ativo)
{
am.Ativar();
}
}
//4 Disponivel
if (transaction.TransactionStatus == 4)
{
LancaEntrada(am.aluno, amt.data);
}
//5 Em disputa
if (transaction.TransactionStatus == 5)
{
//se estiver ativo, desativa o usuário
if (am.ativo)
{
am.Desativar();
}
new Envio_emailDB().Salvar(new Envio_email()
{
data = DateTime.Now,
assunto = "MedTV alterações de pagamento",
texto = "Alterações no pagamento.<BR>Aluno: " + am.aluno.nome + "(" + am.aluno.cpf + ")<BR>Msg: " + amt.msg,
para = emailNotificacaoPagamento
});
}
amt.data = DateTime.Now;
amt.Alterar();
}
return(am);
}
