public ReviewableData Add(ReviewableData reviewable, Guid userId) { Guid newId = Guid.NewGuid(); reviewable.id = newId; //newRD.id = newId; _reviewableRepository.Collection.Insert(reviewable); ReviewableData output = Get(newId, userId); if (System.Configuration.ConfigurationManager.AppSettings["UseLucene"] == "true") Search.IndexManager.threadproc_update(output); return output; }
protected void Button2_Click(object sender, EventArgs e) { SqlConnection conn = null; SqlDataReader dr = null; try { ReviewableRepository rr = new ReviewableRepository(); conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DataServices"].ConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand("Select * from [dbo].[Company]", conn); dr = cmd.ExecuteReader(); while (dr.Read()) { ReviewableData r = new ReviewableData(); r.name = dr.GetString(1); r.reviewableType = "business"; r.images = new string[0]; r.issuerCountryCode = "en_us"; r.issuerCountry = "United States"; r.createdDate = DateTime.UtcNow; rr.Add(r, Guid.Empty); } dr.Close(); IEnumerable<ReviewableData> bizs = rr.Get(); foreach (ReviewableData biz in bizs) { SqlDataReader dr2 = null; string query = @"SELECT top 1 i.uid, i.data, i.fileType, lkift.FileTypeName as imageTypeName, c.Name, 1 as Type, i.dateCreated FROM Image i INNER JOIN lk_Image_FileType lkift on lkift.id = i.fileType INNER JOIN Company_Image ci on i.uid = ci.ImageId INNER JOIN Company c on c.id = ci.CompanyId WHERE c.name = '" + biz.name + "' ORDER by i.dateCreated DESC"; SqlCommand cmd2 = new SqlCommand(query, conn); dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { ImageData l = new ImageData(); Guid newId = Guid.NewGuid(); l.id = newId; Object data = dr2.GetValue(1); l.data = (byte[])data; l.fileType = dr2.GetString(3); l.category = "company"; l.description = dr2.GetValue(4).ToString(); l.type = dr2.GetInt32(5); l.dateCreated = dr2.GetDateTime(6); //now add it to the db l = rr.AddImage(l, biz.id); } dr2.Close(); } } finally { if (conn != null) { conn.Close(); } } }
protected void Button3_Click(object sender, EventArgs e) { SqlConnection conn = null; SqlDataReader dr = null; try { ReviewableRepository pr = new ReviewableRepository(); conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DataServices"].ConnectionString); conn.Open(); SqlCommand cmd = new SqlCommand("GetProductsByName", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", ""); cmd.Parameters.AddWithValue("@userId", 1); dr = cmd.ExecuteReader(); while (dr.Read()) { ReviewableData prod = new ReviewableData(); prod.name = dr.GetString(1); if (dr.GetValue(2) != DBNull.Value) prod.description = dr.GetString(2); if (dr.GetValue(3) != DBNull.Value && dr.GetString(3).Trim().Length != 0) prod.outsideCode = dr.GetString(3); if (dr.GetValue(4) != DBNull.Value && dr.GetString(4).Trim() != "None") prod.outsideCodeType = dr.GetString(4).Trim(); if (dr.GetValue(5) != DBNull.Value) prod.issuerCountryCode = "en_us"; // dr.GetString(5); if (dr.GetValue(6) != DBNull.Value) prod.issuerCountry = dr.GetString(6); //if (dr.GetValue(7) != DBNull.Value) //prod.manufacturerid = dr.GetString(7); //if (dr.GetValue(8) != DBNull.Value) //prod.modelNum = dr.GetString(8); if (dr.GetValue(10) != DBNull.Value) { ReviewableData biz = pr.GetByName(dr.GetString(10), Guid.Empty).First(); prod.parentReviewableId = biz.id; prod.parentName = biz.name; } prod.reviewableType = "product"; prod.images = new string[0]; prod.createdDate = DateTime.UtcNow; pr.Add(prod, Guid.Empty); } dr.Close(); IEnumerable<ReviewableData> prods = pr.Get(); foreach (ReviewableData prod in prods) { SqlDataReader dr2 = null; string query = @"SELECT top 1 i.uid, i.data, i.fileType, lkift.FileTypeName as imageTypeName, p.Name, 2 as Type, i.dateCreated FROM Image i INNER JOIN lk_Image_FileType lkift on lkift.id = i.fileType INNER JOIN Product_Image pi on i.uid = pi.ImageId INNER JOIN Product p on p.id = pi.ProductId WHERE p.name = '" + prod.name + "' ORDER by i.dateCreated DESC"; SqlCommand cmd2 = new SqlCommand(query, conn); dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { ImageData l = new ImageData(); Guid newId = Guid.NewGuid(); //.GenerateNewId(); l.id = newId; Object data = dr2.GetValue(1); l.data = (byte[])data; l.fileType = dr2.GetString(3); l.category = "tile"; l.description = dr2.GetValue(4).ToString(); l.type = dr2.GetInt32(5); l.dateCreated = dr2.GetDateTime(6); pr.AddImage(l, prod.id); } dr2.Close(); } } finally { if (conn != null) { conn.Close(); } } }
public ReviewableData Update(ReviewableData reviewable, Guid userId, bool updateSearchIndex) { //newRd.images = imgIds.ToArray(); _reviewableRepository.Collection.Save(reviewable); ReviewableData output = Get(reviewable.id, userId); if (updateSearchIndex && System.Configuration.ConfigurationManager.AppSettings["UseLucene"] == "true") Search.IndexManager.threadproc_update(output); return output; }
private Reviewable PopulateData(ReviewableData reviewableData) { Reviewable reviewable = AutoMapper.Mapper.Map<ReviewableData, Reviewable>(reviewableData); return reviewable; }