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 IEnumerable <tblTest> getData()
{
List <tblTest> lstObj = new List <tblTest>();
try
{
using (var db = new vsaTestEntities())
{
var data = db.tblTests.ToList();
return(data);
}
}
catch (Exception)
{
return(lstObj);
}
}
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);
}
}
