public ActionResult AddTest(int?test_id, tblTest Obj)
{
string username = "";
HttpCookie cookie = HttpContext.Request.Cookies["AdminCookies"];
if (cookie != null)
{
username = Convert.ToString(cookie.Values["UserName"]);
}
try
{
// TODO: Add insert logic here
if (test_id != null)
{
Obj.ID = Convert.ToInt32(test_id);
new TestDAL().UpdateTest(Obj);
TempData["AlertTask"] = "Test updated successfully";
}
else
{
test_id = new TestDAL().AddTest(Obj);
TempData["AlertTask"] = "Test added successfully";
}
return(Redirect("/tests"));
}
catch
{
return(View());
}
}
public static tblTest Reload(this tblTest item, DbContext c)
{
c.Configuration.AutoDetectChangesEnabled = false;
c.Entry(item).Reload();
c.Configuration.AutoDetectChangesEnabled = true;
return(item);
}
public bool Delete(tblTest entity)
{
_context.tblTests.Attach(entity as tblTest);
_context.tblTests.Remove(entity as tblTest);
return(true);
}
public bool Update(tblTest entity)
{
_context.tblTests.Attach(entity as tblTest);
_context.Entry(entity as tblTest).State = EntityState.Modified;
return(true);
}
public ActionResult AddTest(int?test_id)
{
var model = new tblTest();
var cat = new TestDAL().GetCategories().ToList();
ViewBag.TestCat = cat;
if (test_id != null)
{
model = new TestDAL().GetTest(Convert.ToInt32(test_id));
}
return(View(model));
}
public ActionResult InsertData(tblTest objDD)
{
try
{
var msg = _iDR.InsertData(objDD);
return(Json(new { Result = msg }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public static PracticeFrameworkViewModel From(tblTest tblTestModel)
{
if (tblTestModel == null)
{
return(null);
}
return(new PracticeFrameworkViewModel
{
id = tblTestModel.Id,
description = tblTestModel.Description
});
}
public int Delete(int id)
{
var modelToDelete = _db.tblTests.Find(id);
var practiceModel = new tblTest();
if (modelToDelete != null)
{
practiceModel = _db.tblTests.Remove(modelToDelete);
}
_db.SaveChanges();
return(practiceModel.Id);
}
public string InsertData(tblTest objTest)
{
try
{
using (var db = new vsaTestEntities())
{
db.tblTests.Add(objTest);
db.SaveChanges();
}
return("success");
}
catch (Exception ex)
{
return("error");
}
}
public string DeleteData(int Id)
{
try
{
using (var db = new vsaTestEntities())
{
tblTest test = db.tblTests.Find(Id);
db.tblTests.Remove(test);
db.SaveChanges();
}
return("success");
}
catch (Exception ex)
{
return("error");
}
}
public List <tblTest> getDataByDates(clsData objGD)
{
List <tblTest> lstTest = new List <tblTest>();
tblTest objTest = new tblTest();
try
{
using (var db = new vsaTestEntities())
{
if (objGD.DueDate != null)
{
var data = db.spGetDataByDates(null, null, Convert.ToDateTime(objGD.DueDate));
DateTime dd = data.FirstOrDefault().ReceivedDate;
objTest.ReceivedDate = data.FirstOrDefault().ReceivedDate;
objTest.SentDate = data.FirstOrDefault().SentDate;
objTest.DueDate = data.FirstOrDefault().DueDate;
objTest.Name = data.FirstOrDefault().Name;
objTest.Description = data.FirstOrDefault().Description;
objTest.ClaimsAdministrator = data.FirstOrDefault().ClaimsAdministrator;
objTest.Employer = data.FirstOrDefault().Employer;
objTest.Request = data.FirstOrDefault().Request;
}
else if (objGD.SentDate != null && objGD.ReceiveDate != null)
{
var data = db.spGetDataByDates(Convert.ToDateTime(objGD.ReceiveDate), Convert.ToDateTime(objGD.SentDate), null);
objTest.ReceivedDate = data.FirstOrDefault().ReceivedDate;
objTest.SentDate = data.FirstOrDefault().SentDate;
objTest.DueDate = data.FirstOrDefault().DueDate;
objTest.Name = data.FirstOrDefault().Name;
objTest.Description = data.FirstOrDefault().Description;
objTest.ClaimsAdministrator = data.FirstOrDefault().ClaimsAdministrator;
objTest.Employer = data.FirstOrDefault().Employer;
objTest.Request = data.FirstOrDefault().Request;
}
lstTest.Add(objTest);
return(lstTest);
}
}
catch (Exception)
{
return(lstTest);
}
}
public bool Add(tblTest entity)
{
_context.tblTests.Add(entity as tblTest);
return(true);
}
