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; }