public ActionResult Update(DevTest devTest) { using (var context = new MyDbContext()) { var userRecord = context.DevTest.Find(devTest.ID); userRecord.AffiliateName = devTest.AffiliateName; userRecord.CampaignName = devTest.CampaignName; userRecord.Clicks = devTest.Clicks; userRecord.Conversions = devTest.Conversions; userRecord.Date = DateTime.Now; userRecord.Impressions = devTest.Impressions; context.DevTest.Add(userRecord); context.Entry(userRecord).State = EntityState.Modified; context.SaveChanges(); } //Once the record is inserted , then notify all the subscribers (Clients) DevTestHub.NotifyCurrentUserInformationToAllClients(); return(RedirectToAction("Index")); }
public JsonResult DeleteData(int id) { string msg = ""; try { using (DevTestContext context = new DevTestContext()) { var data = context.DevTests.FirstOrDefault(d => d.ID == id); context.DevTests.Remove(data); context.SaveChanges(); msg = "Data Deleted Successfully.."; } DevTestHub.NotifyCurrentDevInformationToAllClients(); } catch (Exception cc) { msg = "Error Occur"; } var jsonresult = new { msg = msg }; return(Json(jsonresult)); }
public ActionResult Delete(DevTest devTest) { using (var context = new MyDbContext()) { var empRecord = context.DevTest.Find(devTest.ID); context.DevTest.Remove(empRecord); context.SaveChanges(); } //Once the record is inserted , then notify all the subscribers (Clients) DevTestHub.NotifyCurrentUserInformationToAllClients(); return(RedirectToAction("Index")); }
public ActionResult Insert(DevTest devTest) { if (ModelState.IsValid) { //Insert into Employee table using (var context = new MyDbContext()) { devTest.Date = DateTime.Now; context.DevTest.Add(devTest); context.SaveChanges(); } } //Once the record is inserted , then notify all the subscribers (Clients) DevTestHub.NotifyCurrentUserInformationToAllClients(); return(RedirectToAction("Index")); }
public JsonResult InsertData(DevTest model) { string msg = ""; try { using (DevTestContext context = new DevTestContext()) { if (model.ID > 0) { var data = context.DevTests.FirstOrDefault(d => d.ID == model.ID); data.Clicks = model.Clicks; data.AffiliateName = model.AffiliateName; data.CampaignName = model.CampaignName; data.Conversions = model.Conversions; data.Date = model.Date; data.Impressions = model.Impressions; } else { context.DevTests.Add(model); } context.SaveChanges(); msg = "Data Saved Successfully.."; } DevTestHub.NotifyCurrentDevInformationToAllClients(); } catch (Exception cc) { msg = "Error Occur"; } var jsonresult = new { msg = msg }; return(Json(jsonresult)); }