public int updateAd(int id, AdViewModel model)
{
Database s = new Database();
model = extractData(model);
s.updateAd(id, model.Title, model.Description, model.Category, model.Color,
DateTime.Parse(model.Date).ToString("dd-MM-yyyy"), model.ImageName, model.Organization, model.Reward, model.Type, model.City);
return(0);
}
public AdViewModel extractData(AdViewModel model)
{
if (model.Organization == null)
{
model.Organization = "-";
}
if (model.Reward.ToString() == "0")
{
model.Reward = 0;
}
return(model);
}
public AdViewModel getAd(int id)
{
Database s = new Database();
if (s.getAd(id).Tables["myTable"].Rows.Count > 0)
{
AdViewModel ad = createData(s.getAd(id).Tables["myTable"].Rows[0]);
return(ad);
}
else
{
return(null);
}
}
public List <AdViewModel> getSimilarAds(int id, string type)
{
Database db = new Database();
AdViewModel model = getAd(id);
Similarity s = new Similarity();
s.currentAd = model;
int response = s.getAllAds(type);
if (response == -1)
{
return(null);
}
else
{
return(s.getMatches());
}
}
public AdViewModel createData(DataRow r)
{
AdViewModel ad = new AdViewModel();
ad.Title = r["Title"].ToString();
ad.Description = r["description"].ToString();
ad.ImageName = r["ImageName"].ToString();
ad.Reward = int.Parse(r["Reward"].ToString());
ad.City = r["City"].ToString();
ad.Date = r["date"].ToString();
ad.Id = int.Parse(r["id"].ToString());
ad.Location = "{lat:" + r["locationlat"].ToString() + ", lng:" + r["locationlong"].ToString() + "}";
ad.Type = r["type"].ToString();
ad.PostedBy = r["postedby"].ToString();
ad.Category = r["category"].ToString();
ad.Color = r["color"].ToString();
ad.Organization = r["org"].ToString();
return(ad);
}
public bool Blocked(string email, AdViewModel ad)
{
if (ad.Organization == "-")
{
return(false);
}
Database s = new Database();
DataTable dt = s.getOrganizationID(ad.Organization, ad.City).Tables["myTable"];
int orgID = int.Parse(dt.Rows[0]["id"].ToString());
dt = s.checkBlocked(email, orgID).Tables["myTable"];
if (dt.Rows.Count > 0 && dt.Rows[0] != null)
{
return(true);
}
else
{
return(false);
}
}
public int insertNewAd(AdViewModel model, string postedby)
{
Database s = new Database();
model = extractData(model);
string latlng = model.Location.Trim('(', ')');
string[] trimmed = latlng.Split(',');
string lat = trimmed[0];
string lng = trimmed[1].Remove(0, 1);
if (model.Organization != null)
{
model.Organization = s.getOrganizationID(model.Organization, model.City).Tables["myTable"].Rows[0]["id"].ToString();
}
int response = s.insertNewAd(model.Title, model.Description, model.Category, model.Color,
DateTime.Parse(model.Date).ToString("dd-MM-yyyy"),
lat, lng, model.ImageName, model.Organization,
model.Reward, model.Type, model.City, postedby);
return(response);
}
public List <AdViewModel> getAds(AdViewModel model, string type)
{
Database s = new Database();
DataTable dt = s.getAds(model.Id, model.Category, model.Date,
model.Organization, type, model.City).Tables["myTable"];
if (dt.Rows.Count > 0)
{
List <AdViewModel> list = new List <AdViewModel>();
foreach (DataRow r in dt.Rows)
{
AdViewModel ad = createData(r);
list.Add(ad);
}
return(list);
}
else
{
return(null);
}
}
public List <AdViewModel> getAllAds(string type, string organization, string category, string color, string city, string q)
{
Database s = new Database();
List <AdViewModel> ads;
DataTable dt = s.getAllAds(type, organization, category, color, city, q).Tables["myTable"];
if (dt != null)
{
ads = new List <AdViewModel>();
foreach (DataRow r in dt.Rows)
{
AdViewModel ad = createData(r);
ads.Add(ad);
}
return(ads);
}
else
{
return(null);
}
}
public List <AdViewModel> getAllAds(string type)
{
Database s = new Database();
List <AdViewModel> ads;
DataTable dt = s.getAllAds(type).Tables["myTable"];
if (dt != null)
{
ads = new List <AdViewModel>();
foreach (DataRow r in dt.Rows)
{
AdViewModel ad = createData(r);
ads.Add(ad);
}
return(ads);
}
else
{
return(null);
}
}
