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));
}
