public bool Delete(string empresaid, tb_cm_equivalencia BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCmequivalencia_DELETE", cnx)) { { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Equiv_id", SqlDbType.Char, 2).Value = BE.Equiv_id; } try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public List<tb_cm_equivalencia> Get_all(string empresaid, tb_cm_equivalencia BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCmequivalencia_SEARCH", cnx)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@descripcion", BE.Equiv_name); List<tb_cm_equivalencia> list = new List<tb_cm_equivalencia>(); try { cnx.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { tb_cm_equivalencia be = new tb_cm_equivalencia(); be.Equiv_id = Convert.ToInt32(dr["Equiv_id"]); be.Equiv_name = Convert.ToString(dr["Equiv_name"]); be.Unmed1 = Convert.ToString(dr["unmed1"]); be.Unmed2 = Convert.ToString(dr["unmed2"]); be.Equivalencia = Convert.ToDecimal(dr["equivalencia"]); be.descripcion1 = Convert.ToString(dr["descripcion1"]); be.descripcion2 = Convert.ToString(dr["descripcion2"]); list.Add(be); } return list; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public bool Update(string empresaid, tb_cm_equivalencia BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCmequivalencia_UPDATE", cnx)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@equiv_id", SqlDbType.Int).Value = BE.Equiv_id; cmd.Parameters.Add("@equiv_name", SqlDbType.VarChar, 50).Value = BE.Equiv_name; cmd.Parameters.Add("@unmed1", SqlDbType.Char, 2).Value = BE.Unmed1; cmd.Parameters.Add("@unmed2", SqlDbType.Char, 2).Value = BE.Unmed2; cmd.Parameters.Add("@equivalencia", SqlDbType.Decimal, 10).Value = BE.Equivalencia; try { cnx.Open(); if (cmd.ExecuteNonQuery() > 0) { return true; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public List<tb_cm_equivalencia> Get_equivalencia(string empresaid, tb_cm_equivalencia BE) { using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid))) { using (SqlCommand cmd = new SqlCommand("gspTbCmequivalencia_SEARCH", cnx)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Equiv_id", SqlDbType.Decimal,10).Value = BE.Equiv_id; List<tb_cm_equivalencia> list = new List<tb_cm_equivalencia>().ToList(); try { cnx.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { tb_cm_equivalencia be = new tb_cm_equivalencia(); be.Equivalencia = Convert.ToInt32(dr["equivalencia"]); Int32 a = Convert.ToInt32(dr["equivalencia"]); list.Add(be); // return BE; } return list; } } catch (Exception ex) { throw new Exception(ex.Message); } } } }
public bool Update(string empresaid, tb_cm_equivalencia BE) { return tablaDA.Update(empresaid, BE); }
public bool Insert(string empresaid, tb_cm_equivalencia BE) { return tablaDA.Insert(empresaid, BE); }
public List<tb_cm_equivalencia> Get_xcodigo(string empresaid, tb_cm_equivalencia BE) { return tablaDA.Get_xcodigo(empresaid, BE).ToList(); }