public int UpdateTGeneral(TGeneral_EL ent)
{
using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("Sp_Upd_TGeneral", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@co_tabla", SqlDbType.Int).Value = ent.co_tabla;
cmd.Parameters.Add("@co_codigo", SqlDbType.Int).Value = ent.co_codigo;
cmd.Parameters.Add("@de_tabla", SqlDbType.VarChar, 100).Value = ent.de_tabla;
//cmd.Parameters.Add("@ti_tabla", SqlDbType.Char, 1).Value = ent.ti_tabla;
//cmd.Parameters.Add("@fg_tabla", SqlDbType.Char, 1).Value = ent.fg_tabla;
cmd.Parameters.Add("@st_tabla", SqlDbType.Char, 1).Value = ent.st_tabla;
cmd.Parameters.Add("@mo_valor1", SqlDbType.Decimal).Value = ent.mo_valor1;
cmd.Parameters.Add("@mo_valor2", SqlDbType.Decimal).Value = ent.mo_valor2;
cmd.Parameters.Add("@mo_valor3", SqlDbType.Decimal).Value = ent.mo_valor3;
cmd.Parameters.Add("@tx_valor1", SqlDbType.Char, 30).Value = ent.tx_valor1;
cmd.Parameters.Add("@tx_valor2", SqlDbType.Char, 30).Value = ent.tx_valor2;
cmd.Parameters.Add("@tx_valor3", SqlDbType.Char, 30).Value = ent.tx_valor3;
cmd.Parameters.Add("@co_usuario_modificacion", SqlDbType.Char, 20).Value = ent.co_usuario_modificacion;
return(cmd.ExecuteNonQuery());
}
}
}
public JsonResult Del_TGeneral(TGeneral_EL Datos)
{
try
{
string postdata = JsonConvert.SerializeObject(Datos);
var data = JsonConvert.DeserializeObject <int>(Utilitario.Accion.Conect_WEBAPI("TGeneral/Delete", "POST", postdata, "0"));
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(e.Message, JsonRequestBehavior.AllowGet));
}
}
public List <TGeneral_EL> GetAllTGeneral(TGeneral_EL ent)
{
using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("Sp_Sel_TGeneral", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@co_tabla", SqlDbType.Int).Value = ent.co_tabla;
cmd.Parameters.Add("@co_codigo", SqlDbType.Int).Value = ent.co_codigo;
//List<CAPACITACION_EL> list = new List<CAPACITACION_EL>();
List <TGeneral_EL> obj = new List <TGeneral_EL>();
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
TGeneral_EL tg = new TGeneral_EL();
tg.co_codigo = Convert.ToInt32(dr["co_codigo"].ToString());
tg.de_tabla = dr["de_tabla"].ToString();
tg.co_tabla = Convert.ToInt32(dr["co_tabla"].ToString());
tg.de_padre = dr["de_padre"].ToString();
//tg.ti_tabla = dr["ti_tabla"].ToString();
//tg.fg_tabla = dr["fg_tabla"].ToString();
tg.mo_valor1 = string.IsNullOrEmpty(dr["mo_valor1"].ToString()) ? 0 : Convert.ToDecimal(dr["mo_valor1"].ToString());
tg.mo_valor2 = string.IsNullOrEmpty(dr["mo_valor2"].ToString()) ? 0 : Convert.ToDecimal(dr["mo_valor2"].ToString());
tg.mo_valor3 = string.IsNullOrEmpty(dr["mo_valor3"].ToString()) ? 0 : Convert.ToDecimal(dr["mo_valor3"].ToString());
tg.tx_valor1 = dr["tx_valor1"].ToString();
tg.tx_valor2 = dr["tx_valor2"].ToString();
tg.tx_valor3 = dr["tx_valor3"].ToString();
tg.st_tabla = dr["st_tabla"].ToString();
if (dr["st_tabla"].ToString() == "1")
{
tg.st_tabla = "SI";
}
else
{
tg.st_tabla = "NO";
}
obj.Add(tg);
}
}
return(obj);
}
}
}
public int DeleteTGeneral(TGeneral_EL ent)
{
using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("Sp_Del_TGeneral", con))
{
cmd.CommandType = CommandType.StoredProcedure;
//Inicio Parámetros
cmd.Parameters.Add("@co_tabla", SqlDbType.Int).Value = ent.co_tabla;
cmd.Parameters.Add("@co_codigo", SqlDbType.Int).Value = ent.co_codigo;
cmd.Parameters.Add("@co_usuario_eliminacion", SqlDbType.Char, 20).Value = ent.co_usuario_eliminacion;
return(cmd.ExecuteNonQuery());
}
}
}
public List <TGeneral_EL> Sel_ComboTGeneral()
{
using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("Sp_Sel_ComboTGeneral", con))
{
cmd.CommandType = CommandType.StoredProcedure;
using (IDataReader dr = cmd.ExecuteReader())
{
List <TGeneral_EL> lista = new List <TGeneral_EL>();
while (dr.Read())
{
TGeneral_EL ar = new TGeneral_EL();
ar.co_codigo = Convert.ToInt32(dr["co_codigo"].ToString());
ar.de_tabla = dr["de_tabla"].ToString();
lista.Add(ar);
}
return(lista);
}
}
}
}
public int Delete(TGeneral_EL val)
{
return(TGeneral_DA.Accion.DeleteTGeneral(val));
}
public int Put(int id, TGeneral_EL value)
{
return(TGeneral_DA.Accion.UpdateTGeneral(value));
}
public int POST(TGeneral_EL value)
{
return(TGeneral_DA.Accion.InsertTGeneral(value));
}
public IEnumerable <TGeneral_EL> Lista(TGeneral_EL val)
{
return(TGeneral_DA.Accion.GetAllTGeneral(val));
}
