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 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> 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);
}
}
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 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 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 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 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 ActionResult PreviewAd(AdvertismentDetails AdDetails)
{
return(View());
}
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));
}
