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); }