public List <Modelo.Img> Select(string id)
{
Modelo.Img aImage;
List <Modelo.Img> aListImages = new List <Modelo.Img>();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Area_Img ai inner join Img i on i.id = ai.id_Img where ai.id_Area = 1";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
aImage = new Modelo.Img(dr["img_Url"].ToString());
aListImages.Add(aImage);
}
}
dr.Close();
conn.Close();
return(aListImages);
}
public List <Modelo.Img> SelectAll()
{
Modelo.Img aImage;
List <Modelo.Img> aListImages = new List <Modelo.Img>();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from img_Area";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
aImage = new Modelo.Img(
dr["img_Url"].ToString());
aListImages.Add(aImage);
}
}
dr.Close();
conn.Close();
return(aListImages);
}
public void Update(Modelo.Img obj)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("UPDATE img_Area SET img_Url = @img_Url WHERE id = @id", conn);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.ExecuteNonQuery();
}
public void Delete(Modelo.Img obj)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("DELETE FROM img_Area WHERE id = @id", conn);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.ExecuteNonQuery();
}
public bool Insert(Modelo.Img obj)
{
try
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("INSERT INTO img_Area VALUES(@img_Url, @id_Area)", conn);
cmd.Parameters.AddWithValue("@img_Url", obj.imgUrl);
cmd.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
public bool InsertAreaImg(string url, int idArea)
{
try {
Modelo.Img mimg = new Modelo.Img(url);
SqlConnection conn = new SqlConnection(connectionstring);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"Insert into Img (img_Url) values (@url)
Select max(id) as id from Img";
cmd.Parameters.AddWithValue("@url", url);
SqlDataReader dr = cmd.ExecuteReader();
int id = 0;
if (dr.HasRows)
{
int i = 0;
while (dr.Read())
{
if (i > 0)
{
break;
}
id = Alternadores.AlternadorI(dr["id"].ToString());
i++;
}
}
dr.Close();
SqlCommand ncmd = conn.CreateCommand();
if (id > 0)
{
ncmd.CommandText = "Insert into Area_Img (id_Area,id_Img) values (@idA,@idI)"; ncmd.Parameters.AddWithValue("@idA", Identity()); ncmd.Parameters.AddWithValue("@idI", id);
ncmd.ExecuteNonQuery();
}
else
{
throw new Exception();
}
return(true);
}
catch {
return(false);
}
}
