public void Delete(int Id)
{
tbl_Opportunity opportunity = db.tbl_Opportunity.Find(Id);
db.tbl_Opportunity.Remove(opportunity);
Save();
}
public void Update(tbl_Opportunity opportunity)
{
db.Entry(opportunity).State = EntityState.Modified;
db.Configuration.ValidateOnSaveEnabled = false;
Save();
db.Configuration.ValidateOnSaveEnabled = true;
}
public ActionResult Create([Bind(Include = "Oppor_Id,Oppor_Name,Oppor_Description,Oppor_Dateofevent,Oppor_ImageThumbnailUrl," +
"Oppor_ImageUrl,Oppor_Streetaddress,Oppor_Streetaddress2,Oppor_City,Oppor_State,Oppor_Zip,Oppor_County,Oppor_Eldersource," +
"Oppor_Eldersourceinstitute,Oppor_RequiresBackgroundCheck,Oppor_IsFeatured,Oppor_CreatedOn," +
"UserId,Role")] tbl_Opportunity opportunity, OpportunityViewModel opportunityVM)
{
if (ModelState.IsValid)
{
foreach (var item in db.OPPOR_HAS_CATEGORY)
{
if (item.Oppor_Id == opportunity.Oppor_Id)
{
db.Entry(item).State = System.Data.Entity.EntityState.Deleted;
}
}
foreach (var item in opportunityVM.Categories)
{
if (item.Checked)
{
db.OPPOR_HAS_CATEGORY.Add(new OPPOR_HAS_CATEGORY()
{
Oppor_Id = opportunity.Oppor_Id, Category_Id = item.Id
});
}
}
db.tbl_Opportunity.Add(opportunity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(opportunity));
}
// GET: /Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Opportunity opportunity = db.tbl_Opportunity.Find(id);
if (opportunity == null)
{
return(HttpNotFound());
}
var Results = from b in db.tbl_Category
select new
{
b.Category_Id,
b.CategoryName,
Checked = ((from ab in db.OPPOR_HAS_CATEGORY
where (ab.Oppor_Id == id) & (ab.Category_Id == b.Category_Id)
select ab).Count() > 0)
};
var MyViewModel = new OpportunityViewModel();
MyViewModel.Oppor_Id = id.Value;
MyViewModel.Oppor_Name = opportunity.Oppor_Name;
MyViewModel.Oppor_Description = opportunity.Oppor_Description;
MyViewModel.Oppor_Dateofevent = opportunity.Oppor_Dateofevent;
MyViewModel.ImageData = opportunity.ImageData;
MyViewModel.ImageMimeType = opportunity.ImageMimeType;
MyViewModel.Oppor_Streetaddress = opportunity.Oppor_Streetaddress;
MyViewModel.Oppor_Streetaddress2 = opportunity.Oppor_Streetaddress2;
MyViewModel.Oppor_City = opportunity.Oppor_City;
MyViewModel.Oppor_State = opportunity.Oppor_State;
MyViewModel.Oppor_Zip = opportunity.Oppor_Zip;
MyViewModel.Oppor_County = opportunity.Oppor_County;
MyViewModel.Oppor_Eldersource = opportunity.Oppor_Eldersource;
MyViewModel.Oppor_Eldersourceinstitute = opportunity.Oppor_Eldersourceinstitute;
MyViewModel.Oppor_RequiresBackgroundCheck = opportunity.Oppor_RequiresBackgroundCheck;
MyViewModel.Oppor_IsFeatured = opportunity.Oppor_IsFeatured;
MyViewModel.Oppor_CreatedOn = opportunity.Oppor_CreatedOn;
MyViewModel.UserId = opportunity.UserId;
MyViewModel.Role = opportunity.Role;
var MyCheckBoxList = new List <CheckBoxViewModel>();
foreach (var item in Results)
{
MyCheckBoxList.Add(new CheckBoxViewModel {
Id = item.Category_Id, Name = item.CategoryName, Checked = item.Checked
});
}
MyViewModel.Categories = MyCheckBoxList;
return(View(MyViewModel));
}
public ActionResult DeleteConfirmed(int id)
{
tbl_Opportunity tbl_Opportunity = db.tbl_Opportunity.Find(id);
db.tbl_Opportunity.Remove(tbl_Opportunity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ViewResult Details(int?Oppor_Id)
{
tbl_Opportunity opportunity = db.tbl_Opportunity.FirstOrDefault(o => o.Oppor_Id == Oppor_Id);
if (opportunity == null)
{
return(View("~/Views/Error/Error.cshtml"));
}
return(View(opportunity));
}
public void RemoveLine(Basket basket2, tbl_Opportunity opportunity)
{
var basketLine = db.BasketLines.FirstOrDefault(b => b.BasketID == BasketID &&
b.Oppor_Id == opportunity.Oppor_Id);
if (basketLine != null)
{
db.BasketLines.Remove(basketLine);
}
db.SaveChanges();
}
public ActionResult RemoveLine(Basket basket2, int?Oppor_Id)
{
if (Oppor_Id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Opportunity addedItem = db.tbl_Opportunity.Find(Oppor_Id);
Basket basket = Basket.GetBasket(this.HttpContext);
basket.RemoveLine(basket, addedItem);
return(RedirectToAction("Index"));
}
public FileContentResult GetImage(int Oppor_Id)
{
tbl_Opportunity oppor = db.tbl_Opportunity
.FirstOrDefault(o => o.Oppor_Id == Oppor_Id);
if (oppor != null)
{
return(File(oppor.ImageData, oppor.ImageMimeType));
}
else
{
return(null);
}
}
// GET: Admin/tbl_Opportunity/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Opportunity tbl_Opportunity = db.tbl_Opportunity.Find(id);
if (tbl_Opportunity == null)
{
return(HttpNotFound());
}
return(View(tbl_Opportunity));
}
// GET: Admin/tbl_Opportunity/Create
public ActionResult Create()
{
//tbl_Opportunity opportunity = db.tbl_Opportunity.Find(id);
tbl_Opportunity opportunity = new tbl_Opportunity();
var Results = from b in db.tbl_Category
select new
{
b.Category_Id,
b.CategoryName,
};
var MyViewModel = new OpportunityViewModel();
MyViewModel.Oppor_Id = opportunity.Oppor_Id;
MyViewModel.Oppor_Name = opportunity.Oppor_Name;
MyViewModel.Oppor_Description = opportunity.Oppor_Description;
MyViewModel.Oppor_Dateofevent = opportunity.Oppor_Dateofevent;
MyViewModel.ImageData = opportunity.ImageData;
MyViewModel.ImageMimeType = opportunity.ImageMimeType;
MyViewModel.Oppor_Streetaddress = opportunity.Oppor_Streetaddress;
MyViewModel.Oppor_Streetaddress2 = opportunity.Oppor_Streetaddress2;
MyViewModel.Oppor_City = opportunity.Oppor_City;
MyViewModel.Oppor_State = opportunity.Oppor_State;
MyViewModel.Oppor_Zip = opportunity.Oppor_Zip;
MyViewModel.Oppor_County = opportunity.Oppor_County;
MyViewModel.Oppor_Eldersource = opportunity.Oppor_Eldersource;
MyViewModel.Oppor_Eldersourceinstitute = opportunity.Oppor_Eldersourceinstitute;
MyViewModel.Oppor_RequiresBackgroundCheck = opportunity.Oppor_RequiresBackgroundCheck;
MyViewModel.Oppor_IsFeatured = opportunity.Oppor_IsFeatured;
MyViewModel.Oppor_CreatedOn = opportunity.Oppor_CreatedOn;
MyViewModel.UserId = opportunity.UserId;
MyViewModel.Role = opportunity.Role;
var MyCheckBoxList = new List <CheckBoxViewModel>();
foreach (var item in Results)
{
MyCheckBoxList.Add(new CheckBoxViewModel {
Id = item.Category_Id, Name = item.CategoryName, Checked = false
});
}
MyViewModel.Categories = MyCheckBoxList;
return(View(MyViewModel));
}
public void AddToBasket(Basket basket2, tbl_Opportunity opportunity)
{
var basketLine = db.BasketLines.FirstOrDefault(b => b.BasketID == BasketID &&
b.Oppor_Id == opportunity.Oppor_Id);
if (basketLine == null)
{
basketLine = new BasketLine
{
Oppor_Id = opportunity.Oppor_Id,
BasketID = BasketID,
Quantity = 1,
DateCreated = DateTime.Now
};
db.BasketLines.Add(basketLine);
}
else
{
basketLine.Quantity++;/*= quantity;*/
}
db.SaveChanges();
}
public void Update(tbl_Opportunity url)
{
objDb.Update(url);
}
public void Insert(tbl_Opportunity url)
{
objDb.Insert(url);
}
public void Insert(tbl_Opportunity opportunity)
{
db.tbl_Opportunity.Add(opportunity);
Save();
}
