public bool Update(ComicsImg comicsImg)
{
bool retVal = false;
try
{
using (IDbConnection dbConnect = Database.CreateOpenConnection())
{
using (IDbCommand command =
Database.CreateStoredProcCommand(ComicsImgSP.UpdateComicsImgs.ToString(), dbConnect))
{
command.Parameters.Add(Database.CreateParameter("@IdImg", comicsImg.IdImg));
command.Parameters.Add(Database.CreateParameter("@JobID", comicsImg.JobId));
command.Parameters.Add(Database.CreateParameter("@ComicId", comicsImg.ComicId));
command.Parameters.Add(Database.CreateParameter("@ImgUrl", comicsImg.ImgUrl));
command.Parameters.Add(Database.CreateParameter("@imagePath", comicsImg.ImagePath));
command.Parameters.Add(Database.CreateParameter("@ComicUrl", comicsImg.ComicUrl));
command.Parameters.Add(Database.CreateParameter("@forDate", comicsImg.ForDate));
command.Parameters.Add(Database.CreateParameter("@Visited", comicsImg.Visited));
retVal = (command.ExecuteNonQuery() > 0);
}
dbConnect.Close();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(retVal);
}
public List <ComicsImg> Select(int?idImg, int?comicId, DateTime?forDate)
{
//Create a list to store the result
List <ComicsImg> list = new List <ComicsImg>();
try
{
using (IDbConnection dbConnect = Database.CreateOpenConnection())
{
using (IDbCommand command =
Database.CreateStoredProcCommand(ComicsImgSP.SelectComicsImgs.ToString(), dbConnect))
{
command.Parameters.Add(Database.CreateParameter("IdImg", idImg));
command.Parameters.Add(Database.CreateParameter("ComicId", comicId));
command.Parameters.Add(Database.CreateParameter("forDate", forDate));
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ComicsImg comicsImg = new ComicsImg
{
IdImg = Convert.ToInt32(reader["IdImg"].ToString()),
JobId = Guid.Parse(reader["JobID"].ToString()),
ComicId = Convert.ToInt32(reader["ComicId"].ToString()),
ImgUrl = reader["ImgUrl"].ToString(),
ImagePath = reader["imagePath"].ToString(),
ComicUrl = reader["ComicUrl"].ToString(),
ForDate = Convert.ToDateTime(reader["forDate"].ToString()),
Visited = Convert.ToDateTime(reader["Visited"].ToString())
};
list.Add(comicsImg);
}
}
}
dbConnect.Close();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(list);
}
public bool CheckImageUrl(string imageUrl)
{
List <ComicsImg> list = new List <ComicsImg>();
try
{
using (IDbConnection dbConnect = Database.CreateOpenConnection())
{
using (IDbCommand command =
Database.CreateStoredProcCommand(ComicsImgSP.GetImageUrl.ToString(), dbConnect))
{
command.Parameters.Add(Database.CreateParameter("ImgU", imageUrl));
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ComicsImg comicsImg = new ComicsImg
{
IdImg = Convert.ToInt32(reader["IdImg"].ToString()),
JobId = Guid.Parse(reader["JobID"].ToString()),
ComicId = Convert.ToInt32(reader["ComicId"].ToString()),
ImgUrl = reader["ImgUrl"].ToString(),
ImagePath = reader["imagePath"].ToString(),
ComicUrl = reader["ComicUrl"].ToString(),
ForDate = Convert.ToDateTime(reader["forDate"].ToString()),
Visited = Convert.ToDateTime(reader["Visited"].ToString())
};
list.Add(comicsImg);
}
}
}
dbConnect.Close();
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
return(list.Count > 0);
}
