public Local_Result Managment_Local(Local _Local, int Action)
{
P_Local dao = new P_Local();
Local_Result ar = dao.Managment_Local(_Local, Action);
return(ar);
}
public String Managment_Local(Local_S _Local)
{
B_Local b_Local = new B_Local();
Local_Result a = b_Local.Managment_Local(new Local(_Local.LocalId, _Local.Lc_nombre, _Local.LC_Descripcion, _Local.Lc_Direccion, _Local.Lc_Aforo, _Local.Lc_Estado), _Local.Action);
var jsonSerialiser = new JavaScriptSerializer();
var json = jsonSerialiser.Serialize(a);
return(json);
}
public Local_Result Managment_Local(Local _Local, int Action)
{
Local_Result resu = new Local_Result();
using (SqlConnection connection = new SqlConnection(cadena))
{
try
{
String id = "";
connection.Open();
SqlCommand command = new SqlCommand("VR_Managment_Local", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@LocalId", SqlDbType.Int).Value = _Local.LocalId;
command.Parameters.Add("@Lc_nombre", SqlDbType.VarChar).Value = _Local.Lc_nombre;
command.Parameters.Add("@Lc_Descripcion", SqlDbType.VarChar).Value = _Local.LC_Descripcion;
command.Parameters.Add("@Lc_Direccion", SqlDbType.VarChar).Value = _Local.Lc_Direccion;
command.Parameters.Add("@Lc_Aforo", SqlDbType.Int).Value = _Local.Lc_Aforo;
command.Parameters.Add("@Lc_Estado", SqlDbType.Int).Value = _Local.Lc_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);
}
