public static bool EditPhoto(FrozenCritters.Models.Photos photo, int id)
{
string conString = WebConfigurationManager.ConnectionStrings["FrozenCrittersDb"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand editPhoto = new SqlCommand();
editPhoto.CommandText = "UPDATE Photos SET PhotosFile = @PhotosFile, PhotosName = @PhotosName, PhotosDescription = @PhotosDescription WHERE PhotosId = " + id;
editPhoto.Connection = con;
editPhoto.Parameters.AddWithValue("@PhotosFile", photo.PhotosFile);
editPhoto.Parameters.AddWithValue("@PhotosName", photo.PhotosName);
editPhoto.Parameters.AddWithValue("@PhotosDescription", photo.PhotosDescription);
try
{
con.Open();
int rows = editPhoto.ExecuteNonQuery();
if (rows == 1)
{
return(true);
}
else
{
return(false);
}
}
finally
{
con.Dispose();
}
}
public static bool AddPhotos(FrozenCritters.Models.Photos photo)
{
string conString = WebConfigurationManager.ConnectionStrings["FrozenCrittersDb"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand addPhoto = new SqlCommand();
addPhoto.CommandText = "INSERT INTO Photos (PhotosFile, PhotosName, PhotosDescription) VALUES(@PhotosFile, @PhotosName, @PhotosDescription)";
addPhoto.Connection = con;
addPhoto.Parameters.AddWithValue("@PhotosFile", photo.PhotosFile);
addPhoto.Parameters.AddWithValue("@PhotosName", photo.PhotosName);
addPhoto.Parameters.AddWithValue("@PhotosDescription", photo.PhotosDescription);
try
{
con.Open();
int rows = addPhoto.ExecuteNonQuery();
if (rows == 1)
{
return(true);
}
else
{
return(false);
}
}
finally
{
con.Dispose();
}
}
