public ActionResult ChangeAdStatus(int Adid, bool Value) { AdvertismentDetails obj = new AdvertismentDetails(); obj = _adminRepository.GetAdvertDetails(Adid); if (obj != null) { obj.Active = Value; } _adminRepository.UpdateAddStatus(obj); return Json(new { Message = " Advertisment Status Changed Successfully", Success = true }); }
public ActionResult PostAd(AdvertismentDetails advertisementDetails) { if (ModelState.IsValid) { try { advertisementDetails.PostedDate = DateTime.Now; var relPath = ConfigurationManager.AppSettings["DirAddImages"]; //"/Content/AdImages"; string guidstring = Guid.NewGuid().ToString(); string directory = Server.MapPath(relPath); string filePath = System.IO.Path.Combine(directory, guidstring + "_1" + "."); advertisementDetails.Image3 = ""; advertisementDetails.Image2 = ""; advertisementDetails.Image1 = ""; HttpPostedFileBase file = Request.Files["Image1"]; string filename = ""; if (file != null && file.ContentLength > 0) { filename = file.FileName; string[] strfile = filename.Split(".".ToCharArray()); int a = strfile.Length; filePath = filePath + strfile[a - 1]; if (System.IO.Directory.Exists(directory)) { file.SaveAs(filePath); advertisementDetails.Image1 = "/" + System.IO.Path.GetFileName(filePath); } } filePath = System.IO.Path.Combine(directory, guidstring + "_2" + "."); file = Request.Files["Image2"]; filename = ""; if (file != null && file.ContentLength > 0) { filename = file.FileName; string[] strfile = filename.Split(".".ToCharArray()); int a = strfile.Length; filePath = filePath + strfile[a - 1]; if (System.IO.Directory.Exists(directory)) { file.SaveAs(filePath); advertisementDetails.Image2 = "/" + System.IO.Path.GetFileName(filePath); } } filePath = System.IO.Path.Combine(directory, guidstring + "_3" + "."); file = Request.Files["Image3"]; filename = ""; if (file != null && file.ContentLength > 0) { filename = file.FileName; string[] strfile = filename.Split(".".ToCharArray()); int a = strfile.Length; filePath = filePath + strfile[a - 1]; if (System.IO.Directory.Exists(directory)) { file.SaveAs(filePath); advertisementDetails.Image3 = "/" + System.IO.Path.GetFileName(filePath); } } advertisementDetails.Title = HtmlRemoval.StripTagsCharArray(advertisementDetails.Title); advertisementDetails.Description = HtmlRemoval.StripTagsCharArray(advertisementDetails.Description); advertisementDetails.Location = HtmlRemoval.StripTagsCharArray(advertisementDetails.Location); _Repository.SaveAd(advertisementDetails); //send an Email to admin if (Boolean.Parse(ConfigurationManager.AppSettings["SendEmail"])) { //var mailMessage = new MailMessage(); //mailMessage.To = advertisementDetails.Email; //mailMessage.From = ConfigurationManager.AppSettings["FromEmail"]; //mailMessage.Subject= advertisementDetails.Title; //mailMessage.Body = advertisementDetails.Description; //SendEmail(mailMessage); AdvertismentDetails ad = _Repository.GetAdvertDetails(advertisementDetails.AdId); //http://beta.ninjalista.co.uk/details/Ag%C3%AAncias%20de%20viagem/agencias+de+viagem+teste+01/4 string link = "<a href='http://beta.ninjalista.co.uk/details/" + ad.Category.ToLower().Replace(" ", "-") + "/" + ad.SubCategory.ToLower().Replace(" ", "-") + "/" + ad.Title.ToLower().Replace(" ", "-") + "/" + advertisementDetails.AdId + "'>" + "http://beta.ninjalista.co.uk/details/" + ad.Category + "/" + ad.SubCategory + "/" + advertisementDetails.Title + "/" + advertisementDetails.AdId + "</a>"; MailMessage message = new MailMessage(); message.To.Add(advertisementDetails.Email); message.IsBodyHtml = true; message.Subject = "Anúncio postado: " + advertisementDetails.Title; message.Body = "Parabéns, o seu anúncio foi postado com sucesso, para visualiza-lo click no link abaixo: <br/>" + link + ". <br/><br/> Obrigado por usar o <a href='http://www.ninjalista.com'>Ninjalista.com</a>"; //+ advertisementDetails.Description; System.Net.Mail.SmtpClient smtp = new SmtpClient(); smtp.Send(message); } TempData["Title"] = "Anúncio postado!"; TempData["Body"] = "Parabéns, o seu anúncio foi postado!"; TempData["Body1"] = "<p>Um email de confirmação foi enviado para o seu email fornecido, e seu anúncio estara disponível em nosso site dentro de alguns minutos.</p>"; return RedirectToAction("Confirmation", "Home"); } catch (Exception ex) { TempData["error"] = ex.Message; return View("Index"); } } advertisementDetails.SubCategories = _Repository.GetAllSubCategories(); advertisementDetails.Categories = _Repository.GetAllCategory(); return View(advertisementDetails); }
public ActionResult PreviewAd(AdvertismentDetails AdDetails) { return View(); }
public ActionResult Details(string category, string title,int Id) { var details = new AdvertismentDetails(); details = _Repository.GetAdvertDetails(Id); if (details.AdId != 0) { details.Category = category; details.AdId = Id; details.link = (Request.UrlReferrer == null) ? "" : Request.UrlReferrer.AbsoluteUri; return View(details); } else { return RedirectToAction("PageNotFound", "Error"); } }
public ViewResult PostAd() { try { var advertisementDetails = new AdvertismentDetails(); advertisementDetails.Guid = Guid.NewGuid(); // advertisementDetails.SubCategories = _Repository.GetAllSubCategories(); advertisementDetails.Categories = _Repository.GetAllActiveCategory(); return View(advertisementDetails); } catch (Exception ex) { return View(); } //return View(); }
public void UpdateAddStatus(AdvertismentDetails advertismentdetails) { const string commandString = @"Update AdvertisementDetails SET Active = @Active WHERE ID=@AdId"; // const string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\kommanap\Gustin\Gustin\App_Data\Gustin.mdf;Integrated Security=True;User Instance=True"; try { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = new SqlCommand(commandString, connection); command.Parameters.Add("@AdId", advertismentdetails.AdId); command.Parameters.Add("@Active", advertismentdetails.Active); command.ExecuteNonQuery(); } } catch (Exception ex) { throw new Exception(ex.ToString()); } }
public void SaveAd(AdvertismentDetails advertismentDetails) { const string commandString = @"INSERT INTO AdvertisementDetails (SubCategoryId,Title,Description,Location,Email,PostedDate,CategoryId,Image1,Image2,Image3) VALUES (@subcategoryId,@title,@description,@location,@email,@postedDate,@categoryId,@Image1,@Image2,@Image3)"; // const string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\kommanap\Gustin\Gustin\App_Data\Gustin.mdf;Integrated Security=True;User Instance=True"; try { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = new SqlCommand(commandString, connection); command.Parameters.Add("@subcategoryId", advertismentDetails.SubCateogryId); command.Parameters.Add("@title", advertismentDetails.Title); command.Parameters.Add("@description", advertismentDetails.Description); command.Parameters.Add("@location", advertismentDetails.Location); command.Parameters.Add("@email", advertismentDetails.Email); command.Parameters.Add("@postedDate", DateTime.Now.Date); command.Parameters.Add("@categoryId", advertismentDetails.CateogryId); command.Parameters.Add("@Image1", advertismentDetails.Image1); command.Parameters.Add("@Image2", advertismentDetails.Image2); command.Parameters.Add("@Image3", advertismentDetails.Image3); command.ExecuteNonQuery(); } } catch (Exception ex) { throw new Exception(ex.ToString()); } }
public List<AdvertismentDetails> GetAllPostAds(int subCategory) { const string commandString = @"SELECT ID,Title,Location,PostedDate,Image1,Image2,Image3 FROM AdvertisementDetails where SubCategoryId=@SubCategoryId Order by Id Desc"; //const string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\kommanap\Gustin\Gustin\App_Data\Gustin.mdf;Integrated Security=True;User Instance=True"; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = GetCommand(commandString, connection, CommandType.Text); var advertisementDetails = new List<AdvertismentDetails>(); command.Parameters.Add("@subcategoryId", subCategory); { using (var reader = command.ExecuteReader()) { while (reader.Read()) { var details = new AdvertismentDetails(); details.AdId = (int)reader["ID"]; details.Title = (string)reader["Title"]; details.PostedDate = (DateTime)reader["PostedDate"]; details.Location=(string)reader["Location"]; details.Image1 = !(DBNull.Value.Equals(reader["Image1"]))?(string) reader["Image1"]:string.Empty; details.Image2 = !(DBNull.Value.Equals(reader["Image2"]))? (string)reader["Image2"]: string.Empty; details.Image2 = !(DBNull.Value.Equals(reader["Image3"]))?(string)reader["Image3"]:string.Empty; advertisementDetails.Add(details); } } } return advertisementDetails; } }
public AdvertismentDetails GetAdvertDetails(int id) { // const string commandString = // @"SELECT ID,Title,Location,PostedDate,Email,Description,Cat.CategoryName,Ad.Image1,Ad.Image2,Ad.Image3 //FROM AdvertisementDetails Ad Join Categories cat on Cat.CategoryId = Ad.CategoryId where Id = @id"; const string commandString = @"SELECT ID,Title,Location,PostedDate,Image1,Image2,Image3,Categories.CategoryName,SubCategories.SubCategoryName,AdvertisementDetails.Active,AdvertisementDetails.Description,AdvertisementDetails.Email FROM AdvertisementDetails,Categories,SubCategories where AdvertisementDetails.CategoryID=Categories.CategoryId AND AdvertisementDetails.SubCategoryID=SubCategories.SubCategoryId AND AdvertisementDetails.ID = @id"; //const string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\kommanap\Gustin\Gustin\App_Data\Gustin.mdf;Integrated Security=True;User Instance=True"; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = GetCommand(commandString, connection, CommandType.Text); var details = new AdvertismentDetails(); command.Parameters.Add("@id", id); { using (var reader = command.ExecuteReader()) { while (reader.Read()) { details.AdId = (int)reader["ID"]; details.Title = (string)reader["Title"]; details.PostedDate = (DateTime)reader["PostedDate"]; details.Location = (string)reader["Location"]; details.Description =(string)reader["Description"]; details.Email = (string)reader["Email"]; details.Category = (string)reader["CategoryName"]; details.SubCategory = (string)reader["SubCategoryName"]; details.Image1 = !(DBNull.Value.Equals(reader["Image1"])) ? (string)reader["Image1"] : string.Empty; details.Image2 = !(DBNull.Value.Equals(reader["Image2"])) ? (string)reader["Image2"] : string.Empty; details.Image3 = !(DBNull.Value.Equals(reader["Image3"])) ? (string)reader["Image3"] : string.Empty; details.Active = Convert.ToBoolean(reader["Active"]); } } } return details; } }
public List<AdvertismentDetails> GetSearchResults(string keyword) { string[] pram = keyword.Split(" ".ToCharArray()); string detail = ""; string or = ""; int cnt = 1; foreach (var item in pram) { detail = detail + " AD.Description like '%" + item + "%' OR AD.Title like '%" + item + "%' OR AD.Location like '%" + item + "%'"; //detail = detail + " AD.Description in ('" + item + "') OR AD.Title in ('" + item + "') OR AD.Location in ('" + item + "')"; if (cnt < pram.Length) { or = " OR "; detail = detail + or; } cnt++; } string commandString = @"SELECT ID,Title,Location,PostedDate,Image1,Image2,Image3 ,CategoryName,SubCategoryName FROM AdvertisementDetails AD INNER JOIN SubCategories SC ON AD.SubCategoryId = SC.SubCategoryId AND AD.SubCategoryId=SC.SubCategoryId And AD.Active=1 INNER JOIN Categories C ON C.CategoryId = AD.CategoryId WHERE " + detail + " Order by Id Desc"; //@"SELECT ID,Title,Location,PostedDate,Image1,Image2,Image3 FROM AdvertisementDetails where SubCategoryId=@SubCategoryId And Active=1 Order by Id Desc"; //const string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\kommanap\Gustin\Gustin\App_Data\Gustin.mdf;Integrated Security=True;User Instance=True"; using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = GetCommand(commandString, connection, CommandType.Text); var advertisementDetails = new List<AdvertismentDetails>(); //command.Parameters.Add("@subcategoryId", subCategory); { using (var reader = command.ExecuteReader()) { while (reader.Read()) { var details = new AdvertismentDetails(); details.AdId = (int)reader["ID"]; details.Title = (string)reader["Title"]; details.PostedDate = (DateTime)reader["PostedDate"]; details.Location = (string)reader["Location"]; details.SubCategory = (string)reader["SubCategoryName"]; details.Category = (string)reader["CategoryName"]; details.Image1 = !(DBNull.Value.Equals(reader["Image1"])) ? (string)reader["Image1"] : string.Empty; details.Image2 = !(DBNull.Value.Equals(reader["Image2"])) ? (string)reader["Image2"] : string.Empty; details.Image2 = !(DBNull.Value.Equals(reader["Image3"])) ? (string)reader["Image3"] : string.Empty; advertisementDetails.Add(details); } } } return advertisementDetails; } }