public ActionResult Delete(int id, OfferVM ovm)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Offer o = OService.GetById(id);
//OfferVM ovm = new OfferVM()
//{
// OfferId = o.OfferId,
// Offer_Title = o.Offer_Title,
// Offer_description = o.Offer_description,
// Offre_Duration = o.Offre_Duration,
// Offre_Salary = o.Offre_Salary,
// Offer_Contract_Type = (ContractTypeVM)o.Offer_Contract_Type,
// Offer_Level_Of_Expertise = (OfferLevelVM)o.Offer_Level_Of_Expertise,
// Offer_DatePublished = o.Offer_DatePublished,
// Vues = o.Vues,
// CompanyId = o.CompanyId
//};
if (o == null)
{
return(HttpNotFound());
}
OService.Delete(o);
OService.Commit();
return(RedirectToAction("Index"));
}
// GET: Offer/Details/5
public ActionResult Details(int id)
{
IEnumerable <Company> companies = CService.GetMany().ToList();
ViewBag.data = companies;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Offer o = OService.GetById(id);
OfferVM ovm = new OfferVM()
{
OfferId = o.OfferId,
Offer_Title = o.Offer_Title,
Offer_description = o.Offer_description,
Offre_Duration = o.Offre_Duration,
Offre_Salary = o.Offre_Salary,
Offer_Contract_Type = (ContractTypeVM)o.Offer_Contract_Type,
Offer_Level_Of_Expertise = (OfferLevelVM)o.Offer_Level_Of_Expertise,
Offer_DatePublished = o.Offer_DatePublished,
Vues = o.Vues,
CompanyId = o.CompanyId
};
o.Vues = o.Vues + 1;
OService.Update(o);
OService.Commit();
if (o == null)
{
return(HttpNotFound());
}
return(View(ovm));
}
// GET: Offer/Delete/5
public ActionResult Delete(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Offer o = OService.GetById(id);
OfferVM ovm = new OfferVM()
{
OfferId = o.OfferId,
Offer_Title = o.Offer_Title,
Offer_description = o.Offer_description,
Offre_Duration = o.Offre_Duration,
Offre_Salary = o.Offre_Salary,
Offer_Contract_Type = (ContractTypeVM)o.Offer_Contract_Type,
Offer_Level_Of_Expertise = (OfferLevelVM)o.Offer_Level_Of_Expertise,
Offer_DatePublished = o.Offer_DatePublished,
Vues = o.Vues,
CompanyId = o.CompanyId
};
if (o == null)
{
return(HttpNotFound());
}
return(View(ovm));
}
public IActionResult Create()
{
var viewModel = new OfferVM();
viewModel.Id = 0;
//viewModel.ClientId = _sessionHelper.CPMUser.ClientId;
viewModel.ClientId = 2;
viewModel.IsNew = true;
//viewModel.WebUserType = (int)_sessionHelper.CPMUser.WebUserType;
viewModel.WebUserType = (int)Business.Common.Enums.WebUserType.Customer;
return(View("Create", viewModel));
}
public ActionResult Detail(int id)
{
try
{
BusinessManager businessManager = BusinessManager.Instance;
Offer offer = businessManager.GetOfferById(id);
OfferVM offerVM = new OfferVM(offer);
return(View(offerVM));
}
catch (Exception e)
{
return(RedirectToRoute("Error"));
}
}
public IActionResult EditOffer(int id)
{
Offer offer = offerRepo.GetOfferByID(id);
OfferVM offerVM = new OfferVM
{
Id = offer.Id,
Name = offer.Name,
Price = offer.Price,
Desc = offer.Desc,
photo = offer.photo
};
return(View(offerVM));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Offer = (await _offerService.GetDetails(id.GetValueOrDefault())).Data;
if (Offer == null)
{
return(NotFound());
}
return(Page());
}
public ActionResult Create(OfferVM ovm)
{
Offer newoffer = new Offer()
{
OfferId = ovm.OfferId,
Offer_Title = ovm.Offer_Title,
Offer_description = ovm.Offer_description,
Offre_Duration = ovm.Offre_Duration,
Offre_Salary = ovm.Offre_Salary,
Offer_Contract_Type = (ContractType)ovm.Offer_Contract_Type,
Offer_Level_Of_Expertise = (OfferLevel)ovm.Offer_Level_Of_Expertise,
Offer_DatePublished = DateTime.Now,
Vues = 0,
CompanyId = ovm.CompanyId
};
OService.Add(newoffer);
OService.Commit();
return(RedirectToAction("Index"));
}
public void Update(OfferVM updatedOffer)
{
//add image folders
string uploadsFolder = Path.Combine(hostingEnvironment.WebRootPath, "Uploads");
Offer OldOffer = db.Offers.Find(updatedOffer.Id);
OldOffer.Name = updatedOffer.Name;
OldOffer.Price = updatedOffer.Price;
OldOffer.Desc = updatedOffer.Desc;
if (updatedOffer.img != null)
{
//add image one
string uniqFileNameOne = Guid.NewGuid().ToString() + "_" + Path.GetFileName(updatedOffer.img.FileName);
string filePathOne = Path.Combine(uploadsFolder, uniqFileNameOne);
updatedOffer.img.CopyTo(new FileStream(filePathOne, FileMode.Create));
OldOffer.photo = uniqFileNameOne;
}
db.SaveChanges();
}
public ActionResult Edit(int id, OfferVM ovm)
{
if (ModelState.IsValid)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Offer o = OService.GetById(id);
o.Offer_description = ovm.Offer_description;
o.Offre_Duration = ovm.Offre_Duration;
o.Offre_Salary = ovm.Offre_Salary;
o.Offer_Contract_Type = (ContractType)ovm.Offer_Contract_Type;
o.Offer_Level_Of_Expertise = (OfferLevel)ovm.Offer_Level_Of_Expertise;
o.CompanyId = ovm.CompanyId;
if (o == null)
{
return(HttpNotFound());
}
// Service.UpdateCompany(c);
OService.Update(o);
OService.Commit();
return(RedirectToAction("Index"));
}
// TODO: Add delete logic here
return(View(ovm));
}
public void AddOffer(OfferVM offer)
{
//add image folders
string uploadsFolder = Path.Combine(hostingEnvironment.WebRootPath, "Uploads");
//add image one
string uniqFileNameOne = Guid.NewGuid().ToString() + "_" + Path.GetFileName(offer.img.FileName);
string filePathOne = Path.Combine(uploadsFolder, uniqFileNameOne);
offer.img.CopyTo(new FileStream(filePathOne, FileMode.Create));
Offer newOffer = new Offer
{
Name = offer.Name,
Price = offer.Price,
Desc = offer.Desc,
photo = uniqFileNameOne
};
db.Offers.Add(newOffer);
db.SaveChanges();
}
public IHttpActionResult GetOfferProductsAndPackages(int OfferId, int StoreId)
{
try
{
#region InlineQueries
var productsQuery = @"SELECT
COALESCE(t2.Product_Id, t1.Product_Id) AS Id,
COALESCE(t2.Product_Id, t1.Product_Id) AS Product_Id,
COALESCE(t2.Name, t1.Name) AS Name,
COALESCE(t2.Price, t1.Price) AS Price,
COALESCE(t2.StoreName, t1.StoreName) AS StoreName,
COALESCE(t2.CategoryName, t1.CategoryName) AS CategoryName,
COALESCE(t2.ImageUrl, t1.ImageUrl) AS Image,
COALESCE(t2.OfferProductId, 0) AS OfferProductId,
COALESCE(t2.Offer_Id, 0) AS Offer_Id,
COALESCE(t2.IsChecked, CAST(0 AS bit)) AS IsChecked
FROM (SELECT
Products.Id AS Product_Id,
Products.Name AS Name,
Products.Price AS Price,
Stores.BusinessName AS StoreName,
Categories.Name AS CategoryName,
Products.Image AS ImageUrl,
1 AS Qty,
0 AS OfferProductId,
0 AS Package_Id,
CAST(1 AS bit) AS IsChecked
FROM Products
JOIN Categories
ON Products.Category_Id = Categories.Id
JOIN Stores
ON Products.Store_Id = Stores.Id
WHERE
Stores.Id = " + StoreId + @"
AND Products.IsDeleted = 0
AND Categories.IsDeleted = 0
AND Stores.IsDeleted = 0) t1
LEFT JOIN (SELECT
Products.Id AS Product_Id,
Products.Name AS Name,
Offer_Products.DiscountedPrice AS Price,
Stores.BusinessName AS StoreName,
Categories.Name AS CategoryName,
Products.Image AS ImageUrl,
Offer_Products.Id AS OfferProductId,
Offer_Products.Offer_Id,
CAST(1 AS bit) AS IsChecked
FROM Offers
JOIN Offer_Products
ON Offer_Products.Offer_Id = Offers.Id
JOIN Products
ON Products.Id = Offer_Products.Product_Id
JOIN Stores
ON Stores.Id = Products.Store_Id
JOIN Categories
ON Categories.Id = Products.Category_Id
WHERE Offers.Id = " + OfferId + @"
AND Offers.IsDeleted = 0
And Offer_Products.IsDeleted = 0
AND Products.IsDeleted = 0
AND Categories.IsDeleted = 0) t2
ON t1.Product_Id = t2.Product_Id
order by IsChecked desc
";
var packageQuery = @"SELECT
COALESCE(t2.Package_Id, t1.Package_Id) AS Id,
COALESCE(t2.Package_Id, t1.Package_Id) AS Package_Id,
COALESCE(t2.Name, t1.Name) AS Name,
COALESCE(t2.Price, t1.Price) AS Price,
COALESCE(t2.StoreName, t1.StoreName) AS StoreName,
COALESCE(t2.ImageUrl, t1.ImageUrl) AS ImageUrl,
COALESCE(t2.OfferPackageId, 0) AS OfferPackageId,
COALESCE(t2.Offer_Id, 0) AS Offer_Id,
COALESCE(t2.IsChecked, CAST(0 AS bit)) AS IsChecked
FROM (SELECT
Packages.Id AS Package_Id,
Packages.Name AS Name,
Packages.Price AS Price,
Stores.BusinessName AS StoreName,
Packages.ImageUrl AS ImageUrl,
0 AS OfferPackageId,
CAST(1 AS bit) AS IsChecked
FROM Packages
JOIN Stores
ON Packages.Store_Id = Stores.Id
WHERE Stores.Id = " + StoreId + @"
AND Stores.IsDeleted = 0) t1
LEFT JOIN (SELECT
Packages.Id AS Package_Id,
Packages.Name AS Name,
Offer_Packages.DiscountedPrice AS Price,
Stores.BusinessName AS StoreName,
Packages.ImageUrl AS ImageUrl,
Offer_Packages.Id AS OfferPackageId,
Offer_Packages.Offer_Id,
CAST(1 AS bit) AS IsChecked
FROM Offers
JOIN Offer_Packages
ON Offer_Packages.Offer_Id = Offers.Id
JOIN Packages
ON Packages.id = Offer_Packages.Package_Id
JOIN Stores
ON Stores.Id = Offers.Store_Id
WHERE Offers.Id = " + OfferId + @"
AND Offers.IsDeleted = 0
And Offer_Packages.IsDeleted = 0
) t2
ON t1.Package_Id = t2.Package_Id
ORDER BY IsChecked DESC
";
#endregion
using (DunkeyContext ctx = new DunkeyContext())
{
OfferVM model = new OfferVM
{
Packages = ctx.Database.SqlQuery <SearchPackageViewModel>(packageQuery).ToList(),
Products = ctx.Database.SqlQuery <SearchProductViewModel>(productsQuery).ToList()
};
CustomResponse <OfferVM> response = new CustomResponse <OfferVM>
{
Message = "Success",
StatusCode = (int)HttpStatusCode.OK,
Result = model
};
return(Ok(response));
}
}
catch (Exception ex)
{
return(StatusCode(DunkeyDelivery.Utility.LogError(ex)));
}
}
public IActionResult EditOffer(OfferVM UpdatedOffer)
{
offerRepo.Update(UpdatedOffer);
return(RedirectToAction("AllOffers", "Offers"));
}
public IActionResult AddOffer(OfferVM offer)
{
offerRepo.AddOffer(offer);
return(View());
}
