public int InsertTEST(TEST_EL T) { using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena)) { con.Open(); using (SqlCommand com = new SqlCommand("spInsertTEST", con)) { com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@iIdGestorCapacitacion", SqlDbType.Int).Value = T.iIdGestorCapacitacion; com.Parameters.Add("@vDescricionTest", SqlDbType.VarChar).Value = T.vDescricionTest; com.Parameters.Add("@dFechaTest", SqlDbType.Date).Value = T.dFechaTest; com.Parameters.Add("@iEstadoTest", SqlDbType.Int).Value = T.iEstadoTest; com.Parameters.Add("@iUsuarioCrea", SqlDbType.Int).Value = T.iUsuarioCrea; return(com.ExecuteNonQuery()); } } }
public List <TEST_EL> GetAllTEST(TEST_EL T) { using (SqlConnection con = new SqlConnection(ConexionUtil.Cadena)) { con.Open(); using (SqlCommand com = new SqlCommand("spGet_TEST", con)) { com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@iIdTest", SqlDbType.Int).Value = T.iIdTest; List <TEST_EL> list = new List <TEST_EL>(); using (IDataReader dataReader = com.ExecuteReader()) { while (dataReader.Read()) { TEST_EL obj = new TEST_EL(); if (dataReader["iIdTest"] != DBNull.Value) { obj.iIdTest = (int)dataReader["iIdTest"]; } if (dataReader["iIdGestorCapacitacion"] != DBNull.Value) { obj.iIdGestorCapacitacion = (int)dataReader["iIdGestorCapacitacion"]; } if (dataReader["vDescricionTest"] != DBNull.Value) { obj.vDescricionTest = (string)dataReader["vDescricionTest"]; } if (dataReader["dFechaTest"] != DBNull.Value) { obj.dFechaTest = (DateTime)dataReader["dFechaTest"]; } if (dataReader["iEstadoTest"] != DBNull.Value) { obj.iEstadoTest = (int)dataReader["iEstadoTest"]; } if (dataReader["iUsuarioCrea"] != DBNull.Value) { obj.iUsuarioCrea = (int)dataReader["iUsuarioCrea"]; } if (dataReader["dFechaCrea"] != DBNull.Value) { obj.dFechaCrea = (DateTime)dataReader["dFechaCrea"]; } if (dataReader["iUsuarioMod"] != DBNull.Value) { obj.iUsuarioMod = (int)dataReader["iUsuarioMod"]; } if (dataReader["dFechaMod"] != DBNull.Value) { obj.dFechaMod = (DateTime)dataReader["dFechaMod"]; } list.Add(obj); } } return(list); } } }
public int UpdateTEST(TEST_EL T) { return(TEST_DA.Accion.UpdateTEST(T)); }
public int InsertTEST(TEST_EL T) { return(TEST_DA.Accion.InsertTEST(T)); }
//================================================================ // TEST ================================================== public List <TEST_EL> GetAllTEST(TEST_EL T) { return(TEST_DA.Accion.GetAllTEST(T)); }
public int Put(int id, TEST_EL value) { return(TEST_DA.Accion.UpdateTEST(value)); }
public int POST(TEST_EL value) { return(TEST_DA.Accion.InsertTEST(value)); }