public static void Delete(Entities.AMuestrear AMuestrear)
{
if (AMuestrear != null)
{
SyntexLocal.Delete <Entities.AMuestrear>(AMuestrear.ID_ANIMAL.ToString());
}
else
{
SyntexLocal.Delete <Entities.AMuestrear>(string.Empty);
}
}
public static List <Entities.AMuestrear> SelectAllAMuestrear()
{
var conn = GetConnection();
try
{
var aMuestearLst = new List <Entities.AMuestrear>();
SqlCommand command = new SqlCommand("SELECT ID_ANIMAL,ID_CATEGORIA,ID_ETAPA_PRODUCCION,FECHA_TACTO,GESTACION FROM A_MUESTREAR", conn);
command.CommandType = CommandType.Text;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var aMuestear = new Entities.AMuestrear();
aMuestear.ID_ANIMAL = Convert.ToInt32(reader["ID_ANIMAL"].ToString());
aMuestear.ID_CATEGORIA = Convert.ToInt32(reader["ID_CATEGORIA"].ToString());
aMuestear.ID_ETAPA_PRODUCCION = Convert.ToInt32(reader["ID_ETAPA_PRODUCCION"].ToString());
aMuestear.FECHA_TACTO = Convert.ToDateTime(reader["FECHA_TACTO"].ToString());
aMuestear.GESTACION = Convert.ToInt32(reader["GESTACION"].ToString());
aMuestearLst.Add(aMuestear);
}
}
return(aMuestearLst);
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
public static void Update(Entities.AMuestrear AMuestrear)
{
SyntexLocal.Update(AMuestrear);
}
public static List <Entities.AMuestrear> Select(Entities.AMuestrear AMuestrear)
{
return(SyntexLocal.Select <Entities.AMuestrear>());
}
public static void Insert(Entities.AMuestrear AMuestrear)
{
SyntexLocal.Insert(AMuestrear);
}
public static void Delete(Entities.AMuestrear AMuestrear)
{
Data.AMuestrear.Delete(AMuestrear);
}
public static void Update(Entities.AMuestrear AMuestrear)
{
Data.AMuestrear.Update(AMuestrear);
}
public static List <Entities.AMuestrear> Select(Entities.AMuestrear AMuestrear)
{
return(Data.AMuestrear.Select(AMuestrear));
}
public static void Insert(Entities.AMuestrear AMuestrear)
{
Data.AMuestrear.Insert(AMuestrear);
}
