public bool Actualizar(BE.MetaSala beMetaSala) { try { string sp = "SpTbMetaSalaActualizar"; int rowsAffected = 0; using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal)) { cnn.Open(); SqlCommand cmd = new SqlCommand(sp, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IDMETASALA", beMetaSala.IdMetaSala)); cmd.Parameters.Add(new SqlParameter("@IDSALA", beMetaSala.Sala.IdSala)); cmd.Parameters.Add(new SqlParameter("@ANHO", beMetaSala.Anho)); cmd.Parameters.Add(new SqlParameter("@MES", beMetaSala.Mes)); cmd.Parameters.Add(new SqlParameter("@CANTIDADPERSONAL", beMetaSala.CantidadPersonal)); cmd.Parameters.Add(new SqlParameter("@MONTOPERSONAL", beMetaSala.MontoPersonal)); cmd.Parameters.Add(new SqlParameter("@MONTOGRUPAL", beMetaSala.MontoGrupal)); cmd.Parameters.Add(new SqlParameter("@CUMPLIDO", beMetaSala.Cumplido)); rowsAffected = cmd.ExecuteNonQuery(); cnn.Close(); } return(rowsAffected > 0 ? true : false); } catch (Exception ex) { throw ex; } }
private BE.UI.MetaSala BeToUi(BE.MetaSala beMetaSala) { var uiMetaSala = new BE.UI.MetaSala(); uiMetaSala.Id = beMetaSala.IdMetaSala; uiMetaSala.SalaId = beMetaSala.Sala.IdSala; uiMetaSala.SalaNombre = beMetaSala.Sala.Nombre; uiMetaSala.Anho = beMetaSala.Anho; uiMetaSala.Mes = beMetaSala.Mes; uiMetaSala.CantidadPersonal = beMetaSala.CantidadPersonal; uiMetaSala.MontoPersonal = beMetaSala.MontoPersonal; uiMetaSala.MontoGrupal = beMetaSala.MontoGrupal; uiMetaSala.Cumplido = beMetaSala.Cumplido; return(uiMetaSala); }
public BE.MetaSala Obtener(int idSala, int anho, int mes) { BE.MetaSala beMetaSala = null; try { string sp = "SpTbMetaSalaObtener"; using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal)) { cnn.Open(); SqlCommand cmd = new SqlCommand(sp, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IDSALA", idSala)); cmd.Parameters.Add(new SqlParameter("@ANHO", anho)); cmd.Parameters.Add(new SqlParameter("@MES", mes)); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { beMetaSala = new BE.MetaSala(); beMetaSala.IdMetaSala = reader["IdMetaSala"] == DBNull.Value ? 0 : int.Parse(reader["IdMetaSala"].ToString()); beMetaSala.Anho = reader["Anho"] == DBNull.Value ? 0 : int.Parse(reader["Anho"].ToString()); beMetaSala.Mes = reader["Mes"] == DBNull.Value ? 0 : int.Parse(reader["Mes"].ToString()); beMetaSala.CantidadPersonal = reader["CantidadPersonal"] == DBNull.Value ? 0 : int.Parse(reader["CantidadPersonal"].ToString()); beMetaSala.MontoPersonal = reader["MontoPersonal"] == DBNull.Value ? 0.0 : double.Parse(reader["MontoPersonal"].ToString()); beMetaSala.MontoGrupal = reader["MontoGrupal"] == DBNull.Value ? 0.0 : double.Parse(reader["MontoGrupal"].ToString()); beMetaSala.Cumplido = reader["Cumplido"] == DBNull.Value ? false : bool.Parse(reader["Cumplido"].ToString()); beMetaSala.Sala = new BE.Sala() { IdSala = reader["IdSala"] == DBNull.Value ? 0 : int.Parse(reader["IdSala"].ToString()) }; } cnn.Close(); } return(beMetaSala); } catch (Exception ex) { throw ex; } }
public List <BE.MetaSala> Listar() { var lstMetaSala = new List <BE.MetaSala>(); try { string sp = "SpTbMetaSalaListar"; using (SqlConnection cnn = new SqlConnection(ConnectionManager.ConexionLocal)) { cnn.Open(); SqlCommand cmd = new SqlCommand(sp, cnn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var beMetaSala = new BE.MetaSala(); beMetaSala.IdMetaSala = reader["IdMetaSala"] == DBNull.Value ? 0 : int.Parse(reader["IdMetaSala"].ToString()); beMetaSala.Anho = reader["Anho"] == DBNull.Value ? 0 : int.Parse(reader["Anho"].ToString()); beMetaSala.Mes = reader["Mes"] == DBNull.Value ? 0 : int.Parse(reader["Mes"].ToString()); beMetaSala.CantidadPersonal = reader["CantidadPersonal"] == DBNull.Value ? 0 : int.Parse(reader["CantidadPersonal"].ToString()); beMetaSala.MontoPersonal = reader["MontoPersonal"] == DBNull.Value ? 0.0 : double.Parse(reader["MontoPersonal"].ToString()); beMetaSala.MontoGrupal = reader["MontoGrupal"] == DBNull.Value ? 0.0 : double.Parse(reader["MontoGrupal"].ToString()); beMetaSala.Cumplido = reader["Cumplido"] == DBNull.Value ? false : bool.Parse(reader["Cumplido"].ToString()); beMetaSala.Sala = new BE.Sala() { IdSala = reader["IdSala"] == DBNull.Value ? 0 : int.Parse(reader["IdSala"].ToString()) }; lstMetaSala.Add(beMetaSala); } cnn.Close(); } return(lstMetaSala); } catch (Exception ex) { throw ex; } }
private BE.MetaSala UiToBe(BE.UI.MetaSala uiMetaSala) { var beMetaSala = new BE.MetaSala(); beMetaSala.IdMetaSala = uiMetaSala.Id; beMetaSala.Anho = uiMetaSala.Anho; beMetaSala.Mes = uiMetaSala.Mes; beMetaSala.CantidadPersonal = uiMetaSala.CantidadPersonal; beMetaSala.MontoPersonal = uiMetaSala.MontoPersonal; beMetaSala.MontoGrupal = uiMetaSala.MontoGrupal; beMetaSala.Cumplido = uiMetaSala.Cumplido; beMetaSala.Sala = new BE.Sala() { IdSala = uiMetaSala.SalaId, Nombre = uiMetaSala.SalaNombre }; return(beMetaSala); }