public Participante_Result Managment_Participante(Participante _Participante, int Action)
{
P_Participante dao = new P_Participante();
Participante_Result ar = dao.Managment_Participante(_Participante, Action);
return(ar);
}
public String Managment_Participante(Participante_S_C _Participante)
{
B_Participante b_Participante = new B_Participante();
Participante_Result a = b_Participante.Managment_Participante(new Participante(_Participante.ParticipanteId, _Participante.TrabajadorId, _Participante.ProgramaId, _Participante.Estado), _Participante.Action);
var jsonSerialiser = new JavaScriptSerializer();
var json = jsonSerialiser.Serialize(a);
return(json);
}
public Participante_Result Managment_Participante(Participante _Participante, int Action)
{
Participante_Result resu = new Participante_Result();
using (SqlConnection connection = new SqlConnection(cadena))
{
try
{
String id = "";
connection.Open();
SqlCommand command = new SqlCommand("VR_Managment_Participante", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ParticipanteId", SqlDbType.Int).Value = _Participante.ParticipanteId;
command.Parameters.Add("@TrabajadorId", SqlDbType.Int).Value = _Participante.TrabajadorId;
command.Parameters.Add("@ProgramaId", SqlDbType.Int).Value = _Participante.@ProgramaId;
command.Parameters.Add("@Estado", SqlDbType.Int).Value = _Participante.@Estado;
command.Parameters.Add("@Action", SqlDbType.Int).Value = Action;
SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleResult);
if (reader.HasRows)
{
if (reader.Read())
{
id = reader.GetValue(0).ToString();
}
}
reader.Close();
connection.Close();
resu.Result = 1;
resu.Message = id;
}
catch (Exception e)
{
connection.Close();
resu.Result = 0;
resu.Message = e.Message;
}
}
return(resu);
}