public bool Insert(Publisher publisher)
{
using (SqlConnection con = new SqlConnection(constring))
{
con.Open();
string sql = "insert into publisher "
+ "(id, name, description, enabled, date_last_updated) "
+ "values (@id, @name, @description, @enabled, @date_last_updated)";
SqlCommand command = new SqlCommand(sql, con);
command.Parameters.AddWithValue("@id", publisher.id);
command.Parameters.AddWithValue("@name", TruncateString(publisher.name, 100));
command.Parameters.AddWithValue("@description", TruncateString(publisher.description, 1000));
command.Parameters.AddWithValue("@enabled", publisher.enabled);
if (publisher.dateLastUpdated == DateTime.MinValue)
{
publisher.dateLastUpdated = new DateTime(1900, 1, 1);
}
command.Parameters.AddWithValue("@date_last_updated", publisher.dateLastUpdated);
int result = command.ExecuteNonQuery();
if (result == 1)
{
return true;
}
else
{
return false;
}
}
}
public bool Save(Publisher publisher)
{
if (PublisherExists(publisher.id))
{
return Update(publisher);
}
return Insert(publisher);
}
public Publisher GetPublisher(string ComicVinePublisherRequestXMLResponse)
{
var publisher = new Publisher();
var xDoc = XDocument.Parse(ComicVinePublisherRequestXMLResponse);
publisher.id = ParseHelper.ParseInt((string)xDoc.Descendants("id").Where(p => p.Parent.Name.LocalName == "results").FirstOrDefault() ?? "0");
publisher.name = (string)xDoc.Descendants("name").Where(p => p.Parent.Name.LocalName == "results").FirstOrDefault() ?? "";
publisher.description = (string)xDoc.Descendants("description").Where(p => p.Parent.Name.LocalName == "results").FirstOrDefault() ?? "";
publisher.dateLastUpdated = ParseHelper.ParseDateTime((string)xDoc.Descendants("date_last_updated").Where(p => p.Parent.Name.LocalName == "results").FirstOrDefault() ?? "");
publisher.enabled = true;
return publisher;
}
public bool Save(Publisher publisher)
{
return repository.Save(publisher);
}
public void CanSavePublisher()
{
Publisher publisher = new Publisher
{
id = -7,
name = "Cheetum Comics",
description = "Steelers"
};
repository.Save(publisher);
Publisher savedPublisher = repository.GetPublisher(-7);
Assert.IsTrue(savedPublisher.id == -7);
Assert.IsTrue(savedPublisher.name == "Cheetum Comics");
}
public bool Save(Publisher publisher)
{
publishers.Add(publisher);
return true;
}
private List<Publisher> FillPublishers(DataSet ds)
{
List<Publisher> publishers = new List<Publisher>();
foreach (DataRow row in ds.Tables[0].Rows)
{
Publisher publisher = new Publisher();
publisher.id = ParseHelper.ParseInt(row["id"].ToString());
publisher.name = row["name"].ToString();
publisher.description = row["description"].ToString();
publisher.enabled = ParseHelper.ParseBool(row["enabled"].ToString());
publisher.dateLastUpdated = ParseHelper.ParseDateTime(row["date_last_updated"].ToString());
publishers.Add(publisher);
}
return publishers;
}
private Publisher FillPublisher(DataSet ds)
{
Publisher publisher = new Publisher();
if (ds.Tables[0].Rows.Count != 0)
{
publisher.id = ParseHelper.ParseInt(ds.Tables[0].Rows[0]["id"].ToString());
publisher.name = ds.Tables[0].Rows[0]["name"].ToString();
publisher.description = ds.Tables[0].Rows[0]["description"].ToString();
publisher.enabled = ParseHelper.ParseBool(ds.Tables[0].Rows[0]["enabled"].ToString());
publisher.dateLastUpdated = ParseHelper.ParseDateTime(ds.Tables[0].Rows[0]["date_last_updated"].ToString());
}
return publisher;
}
