// PUT api/Temp/5
public async Task<IHttpActionResult> PutAd(int id, Ad ad)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != ad.Id)
{
return BadRequest();
}
db.Entry(ad).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AdExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
public ActionResult CreateMobileAccessoriesAd()
{
if (Request.IsAuthenticated)
{
Ad ad = new Ad();
return View(ad);
}
return RedirectToAction("Register", "Account");
}
// GET: /Jobs/Create
public ActionResult Create()
{
if (Request.IsAuthenticated)
{
Ad ad = new Ad();
return View(ad);
}
return RedirectToAction("Index", "Home");
}
public async Task<IHttpActionResult> PostAd(Ad ad)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
db.Ads.Add(ad);
await db.SaveChangesAsync();
return CreatedAtRoute("DefaultApi", new { id = ad.Id }, ad);
}
public ActionResult Create(string category, string subcategory = null)
{
if (Request.IsAuthenticated)
{
if (checkCategory(category, subcategory))
{
ViewBag.category = category;
ViewBag.subcategory = subcategory;
Ad ad = new Ad();
return View(ad);
}
return HttpNotFound();
}
return RedirectToAction("Register", "Account");
}
public void MyAdLocation(string city, string popularPlace, string exectLocation,ref Ad ad,string SaveOrUpdate)
{
AdsLocation loc = new AdsLocation();
if (city != null)
{
var citydb = db.Cities.FirstOrDefault(x => x.cityName.Equals(city, StringComparison.OrdinalIgnoreCase));
if (citydb == null)
{
City cit = new City();
cit.cityName = city;
cit.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
cit.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
cit.addedOn = DateTime.UtcNow;
db.Cities.Add(cit);
db.SaveChanges();
loc.cityId = cit.Id;
if (popularPlace != null)
{
popularPlace pop = new popularPlace();
pop.cityId = cit.Id;
pop.name = popularPlace;
pop.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
pop.addedOn = DateTime.UtcNow;
db.popularPlaces.Add(pop);
db.SaveChanges();
loc.popularPlaceId = pop.Id;
}
}
else
{
loc.cityId = citydb.Id;
if (popularPlace != null)
{
var ppp = db.popularPlaces.FirstOrDefault(x => x.City.cityName.Equals(city, StringComparison.OrdinalIgnoreCase) && x.name.Equals(popularPlace, StringComparison.OrdinalIgnoreCase));
if (ppp == null)
{
popularPlace pop = new popularPlace();
pop.cityId = citydb.Id;
pop.name = popularPlace;
pop.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
pop.addedOn = DateTime.UtcNow;
db.popularPlaces.Add(pop);
db.SaveChanges();
loc.popularPlaceId = pop.Id;
}
else
{
loc.popularPlaceId = ppp.Id;
}
}
}
loc.exectLocation = exectLocation;
loc.Id = ad.Id;
if (SaveOrUpdate == "Save")
{
ad.AdsLocation = loc;
// db.AdsLocations.Add(loc);
}
else if (SaveOrUpdate == "Update")
{
db.Entry(loc).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public void MyAd(ref Ad ad,string SaveOrUpdate,string cateogry = null,string subcategory = null)
{
ad.status = "a";
var type = System.Web.HttpContext.Current.Request["type"];
var isbiding = System.Web.HttpContext.Current.Request["bidingAllowed"];
var condition = System.Web.HttpContext.Current.Request["condition"];
var pp = System.Web.HttpContext.Current.Request["price"];
string[] prices = pp.Split(','); //exception: object reference not set to instance of object
if (type == "sell")
{
ad.type = true;
}
else
{
ad.type = false;
}
if (isbiding == "fixedPrice")
{
pp = prices[0];
var nn = System.Web.HttpContext.Current.Request["isNegotiable"];
if (nn == "on")
{
ad.isnegotiable = "y";
}
else
{
ad.isnegotiable = "n";
}
}
else if (isbiding == "allowBiding")
{
pp = prices[1];
ad.isnegotiable = "b";
}
if (condition == "new")
{
ad.condition = "n";
}
else if (condition == "unboxed")
{
ad.condition = "b";
}
else
{
ad.condition = "u";
}
if (pp != null && pp != "")
{
ad.price = int.Parse(pp);
}
ad.description = System.Web.HttpUtility.HtmlEncode(ad.description);
ad.postedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (SaveOrUpdate == "Save")
{
ad.category = cateogry;
ad.subcategory = subcategory;
ad.time = DateTime.UtcNow;
}
else if (SaveOrUpdate == "Update")
{
ad.time =DateTime.Parse(System.Web.HttpContext.Current.Request["time"]);
if (ad.category == null)
{
ad.category = System.Web.HttpContext.Current.Request["category"];
}
if (ad.subcategory == null)
{
ad.subcategory = System.Web.HttpContext.Current.Request["subcategory"];
}
}
}
public int SaveLaptopBrandModel(Ad ad)
{
ad.status = "a";
var company = Request["brand"];
var model = Request["model"];
if (company != null && company != "")
{
company = company.Trim();
model = model.Trim();
}
if (true) //company != null
{
var allBrands = (db.LaptopBrands.Select(x => x.brand)).AsEnumerable(); //getBrands
bool isNewBrand = true;
foreach (var brand in allBrands)
{
if (brand == company)
{
isNewBrand = false;
}
}
if (isNewBrand)
{
LaptopBrand mob = new LaptopBrand();
mob.brand = company;
mob.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
mob.time = DateTime.UtcNow;
if (company == null || company == "")
{
mob.status = "a";
}
else
{
mob.status = "p";
}
db.LaptopBrands.Add(mob);
db.SaveChanges();
LaptopModel mod = new LaptopModel();
mod.model = model;
mod.brandId = mob.Id;
mod.time = DateTime.UtcNow;
if (model == null || model == "")
{
mod.status = "a";
}
else
{
mod.status = "p";
}
mod.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
db.LaptopModels.Add(mod);
db.SaveChanges();
ad.status = "p";
}
else
{
var allModels = db.LaptopModels.Where(x => x.LaptopBrand.brand == company).Select(x => x.model);
bool isNewModel = true;
foreach (var myModel in allModels)
{
if (myModel == model)
{
isNewModel = false;
}
}
if (isNewModel)
{
ad.status = "p";
var brandId = db.LaptopBrands.FirstOrDefault(x => x.brand.Equals(company));
LaptopModel mod = new LaptopModel();
mod.brandId = brandId.Id;
mod.model = model;
if (model == null || model == "")
{
mod.status = "a";
}
else
{
mod.status = "p";
}
mod.addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
mod.time = DateTime.UtcNow;
db.LaptopModels.Add(mod);
try
{
db.SaveChanges();
}
catch (Exception e)
{
string s = e.ToString();
}
}
}
var laptopModel = db.LaptopModels.FirstOrDefault(x => x.LaptopBrand.brand == company && x.model == model);
return laptopModel.Id;
}
}
public void ReplaceAdImages(ref Ad ad, FileName[] filenames)
{
string newFileName = "";
int count = 1;
var id = ad.Id;
var imaa = db.AdImages.Where(x => x.adId.Equals(id)).Count();
count = imaa + 1;
for (int i = 1; i < filenames.Length; i++)
{
IAmazonS3 client;
try
{
using (client = new AmazonS3Client(Amazon.RegionEndpoint.USEast1))
{
GetObjectRequest request = new GetObjectRequest
{
BucketName = _bucketName,
Key = _folderName + filenames[i].fileName
};
using (GetObjectResponse response = client.GetObject(request))
{
string filename = filenames[i].fileName;
if (!System.IO.File.Exists(filename))
{
string extension = System.IO.Path.GetExtension(filenames[i].fileName);
newFileName = ad.Id.ToString() + "_" + count + extension;
client = new AmazonS3Client(Amazon.RegionEndpoint.USEast1);
CopyObjectRequest request1 = new CopyObjectRequest()
{
SourceBucket = _bucketName,
SourceKey = _folderName + filename,
DestinationBucket = _bucketName,
CannedACL = S3CannedACL.PublicRead,//PERMISSION TO FILE PUBLIC ACCESIBLE
DestinationKey = _folderName + newFileName
};
CopyObjectResponse response1 = client.CopyObject(request1);
AdImage image = new AdImage();
image.imageExtension = extension;
image.adId = ad.Id;
db.AdImages.Add(image);
db.SaveChanges();
count++;
DeleteObjectRequest deleteObjectRequest =
new DeleteObjectRequest
{
BucketName = _bucketName,
Key = _folderName + filenames[i].fileName
};
AmazonS3Config config = new AmazonS3Config();
config.ServiceURL = "https://s3.amazonaws.com/";
using (client = Amazon.AWSClientFactory.CreateAmazonS3Client(
_awsAccessKey, _awsSecretKey, config))
{
client.DeleteObject(deleteObjectRequest);
}
}
}
}
}
catch (Exception e)
{
}
}
}
public void SaveTags(string s,ref Ad ad,string addOrUpdate = "add")
{
if(addOrUpdate == "update")
{
var adid = ad.Id;
var adtags = db.AdTags.Where(x => x.adId.Equals(adid)).ToList();
foreach (var cc in adtags)
{
db.AdTags.Remove(cc);
}
db.SaveChanges();
}
string[] values = s.Split(',');
Inspinia_MVC5_SeedProject.Models.Tag[] tags = new Inspinia_MVC5_SeedProject.Models.Tag[values.Length];
AdTag[] qt = new AdTag[values.Length];
for (int i = 0; i < values.Length; i++)
{
values[i] = values[i].Trim();
string ss = values[i];
if (ss != "")
{
var data = db.Tags.FirstOrDefault(x => x.name.Equals(ss, StringComparison.OrdinalIgnoreCase));
tags[i] = new Inspinia_MVC5_SeedProject.Models.Tag();
if (data != null)
{
tags[i].Id = data.Id;
}
else
{
tags[i].name = values[i];
tags[i].time = DateTime.UtcNow;
tags[i].createdBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
db.Tags.Add(tags[i]);
}
}
else
{
tags[i] = null;
}
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
string sb = e.ToString();
}
for (int i = 0; i < values.Length; i++)
{
if (tags[i] != null)
{
qt[i] = new AdTag();
qt[i].adId = ad.Id;
qt[i].tagId = tags[i].Id;
db.AdTags.Add(qt[i]);
}
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
string sb = e.ToString();
}
}
// GET: /RealEstate/Create
public ActionResult Create()
{
Ad ad = new Ad();
return View(ad);
}
public async Task<object> SaveSkills(string s,Ad ad, bool update = false)
{
if (update)
{
var adid = ad.Id;
var adtags = db.JobSkills.Where(x => x.adId.Equals(adid)).ToList();
foreach (var cc in adtags)
{
db.JobSkills.Remove(cc);
}
await db.SaveChangesAsync();
}
if(s == "" || s == null)
{
return true;
}
string[] values = s.Split(',');
Skill[] tags = new Skill[values.Length];
JobSkill[] qt = new JobSkill[values.Length];
for (int i = 0; i < values.Length; i++)
{
values[i] = values[i].Trim();
string ss = values[i];
if (ss != "")
{
var data = db.Skills.FirstOrDefault(x => x.name.Equals(ss, StringComparison.OrdinalIgnoreCase));
tags[i] = new Skill();
if (data != null)
{
tags[i].Id = data.Id;
}
else
{
tags[i].name = values[i];
tags[i].time = DateTime.UtcNow;
tags[i].addedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
db.Skills.Add(tags[i]);
}
}
else
{
tags[i] = null;
}
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
string sb = e.ToString();
}
for (int i = 0; i < values.Length; i++)
{
if (tags[i] != null)
{
qt[i] = new JobSkill();
qt[i].adId = ad.Id;
qt[i].tagId = tags[i].Id;
db.JobSkills.Add(qt[i]);
}
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
string sb = e.ToString();
}
return true;
}
public async Task<bool> SaveAd(Ad ad,bool update = false)
{
JobAd jobAd = new JobAd();
if(update){
// jobAd =await db.JobAds.FindAsync(ad.Id);
jobAd.adId = ad.Id;
}
//else{
// jobAd = new JobAd();
//}
ad.status = "a";
ad.category = "Jobs";
var seats = System.Web.HttpContext.Current.Request["seats"];
if ( seats != null && seats != "")
{
jobAd.seats = int.Parse(seats);
}
jobAd.qualification = System.Web.HttpContext.Current.Request["qualification"];
jobAd.exprience = System.Web.HttpContext.Current.Request["exprience"];
if(System.Web.HttpContext.Current.Request["salary"] != null && System.Web.HttpContext.Current.Request["salary"] != "")
{
ad.price = int.Parse(System.Web.HttpContext.Current.Request["salary"]);
}
ad.isnegotiable = System.Web.HttpContext.Current.Request["gender"];
var skills = System.Web.HttpContext.Current.Request["skills"];
jobAd.careerLevel = System.Web.HttpContext.Current.Request["careerLevel"];
var lastDateToApply = System.Web.HttpContext.Current.Request["lastDateToApply"];
if (lastDateToApply != null && lastDateToApply != "")
{
jobAd.lastDateToApply = DateTime.Parse(lastDateToApply);
}
ad.condition = System.Web.HttpContext.Current.Request["shift"];
jobAd.salaryType = System.Web.HttpContext.Current.Request["salaryType"];
ad.description = System.Web.HttpUtility.HtmlEncode(ad.description);
ad.postedBy = System.Web.HttpContext.Current.User.Identity.GetUserId();
if (!update)
{
jobAd.category1 = System.Web.HttpContext.Current.Request["category"];
ad.subcategory = System.Web.HttpContext.Current.Request["subcategory"];
ad.time = DateTime.UtcNow;
db.Ads.Add(ad);
await db.SaveChangesAsync();
jobAd.adId = ad.Id;
db.JobAds.Add(jobAd);
await db.SaveChangesAsync();
}
else if (update)
{
ad.time = DateTime.Parse(System.Web.HttpContext.Current.Request["time"]);
jobAd.category1 = System.Web.HttpContext.Current.Request["category"];
ad.subcategory = System.Web.HttpContext.Current.Request["subcategory"];
db.Entry(ad).State = EntityState.Modified;
await db.SaveChangesAsync();
db.Entry(jobAd).State = EntityState.Modified;
await db.SaveChangesAsync();
}
return true;
}
// GET: /Electronics/Create
public ActionResult Create()
{
ViewBag.postedBy = new SelectList(db.AspNetUsers, "Id", "Email");
Ad ad = new Ad();
return View(ad);
}
public async Task<bool> saveBikeAd(Ad ad, bool update = false)
{
// ad.category = "Vehicles";
// ad.subcategory = "Cars";
BikeAd mobileAd = new BikeAd();
if (Request["year"] != "" && Request["year"] != null)
{
mobileAd.year = short.Parse(Request["year"]);
}
if (Request["kmDriven"] != null && Request["kmDriven"] != "")
{
mobileAd.kmDriven = int.Parse(Request["kmDriven"]);
}
mobileAd.adId = ad.Id;
if (Request["noOfOwners"] != null && Request["noOfOwners"] != "")
{
mobileAd.noOfOwners = short.Parse(Request["noOfOwners"]);
}
if (Request["registeredCity"] != null && Request["registeredCity"] != "")
{
var city = Request["registeredCity"];
mobileAd.registeredCity = await SaveCity(city);
}
mobileAd.bikeModel = SaveBikesBrandModel(ref ad);
if (update)
{
db.Entry(mobileAd).State = EntityState.Modified;
}
else
{
db.BikeAds.Add(mobileAd);
}
try
{
await db.SaveChangesAsync();
}
catch (DbEntityValidationException e)
{
string s = e.ToString();
List<string> errorMessages = new List<string>();
foreach (DbEntityValidationResult validationResult in e.EntityValidationErrors)
{
string entityName = validationResult.Entry.Entity.GetType().Name;
foreach (DbValidationError error in validationResult.ValidationErrors)
{
errorMessages.Add(entityName + "." + error.PropertyName + ": " + error.ErrorMessage);
}
}
}
return true;
}
