public JsonResult IsCampaignExists(string Name)
{
using (MvcCRUDDBEntities db = new MvcCRUDDBEntities())
{
return(Json(!db.Campaigns.Any(x => x.Name == Name), JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetData()
{
using (MvcCRUDDBEntities db = new MvcCRUDDBEntities())
{
List <Campaign> campaignList = db.Campaigns.ToList <Campaign>();
return(Json(new { data = campaignList }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult InsertCustomer(Customer customer)
{
using (entities = new MvcCRUDDBEntities())
{
entities.Customers.Add(customer);
entities.SaveChanges();
}
return(Json(customer));
}
public ActionResult Delete(int id)
{
using (MvcCRUDDBEntities db = new MvcCRUDDBEntities())
{
Campaign campaign = db.Campaigns.Where(x => x.Id == id).FirstOrDefault <Campaign>();
db.Campaigns.Remove(campaign);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteCustomer(int customerId)
{
using (entities = new MvcCRUDDBEntities())
{
Customer customer = (from c in entities.Customers
where c.CustomerId == customerId
select c).FirstOrDefault();
entities.Customers.Remove(customer);
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult UpdateCustomer(Customer customer)
{
using (entities = new MvcCRUDDBEntities())
{
Customer updatedCustomer = (from c in entities.Customers
where c.CustomerId == customer.CustomerId
select c).FirstOrDefault();
updatedCustomer.Name = customer.Name;
updatedCustomer.Country = customer.Country;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult AddOrEdit(int id = 0)
{
using (MvcCRUDDBEntities db = new MvcCRUDDBEntities())
{
if (id == 0)
{
return(View(new Campaign()));
}
else
{
return(View(db.Campaigns.Where(x => x.Id == id).FirstOrDefault <Campaign>()));
}
}
}
public ActionResult AddOrEdit(Campaign campaign)
{
using (MvcCRUDDBEntities db = new MvcCRUDDBEntities())
{
if (campaign.Id == 0)
{
db.Campaigns.Add(campaign);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(campaign).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public JsonResult GetCustomers()
{
entities = new MvcCRUDDBEntities();
return(Json(entities.Customers));
}
