public ActionResult GetTestSuiteById(int id)
{
ValidationMapper <TestSuite, Models.TestSuites> mapperObj = new ValidationMapper <TestSuite, Models.TestSuites>();
var dalObj = new DALRepository();
var tstSuite = dalObj.GetTestSuiteById(id);
var testSuite = new Models.TestSuites();
if (tstSuite != null)
{
testSuite = mapperObj.Translate(tstSuite);
return(Json(testSuite, JsonRequestBehavior.AllowGet));
}
return(null);
}
public JsonResult DeleteTestSuite(Models.TestSuites testSuite)
{
int result = 0; bool status = false;
try
{
ValidationMapper <TestSuite, Models.TestSuites> mapperObj = new ValidationMapper <TestSuite, Models.TestSuites>();
var dalObj = new DALRepository();
result = dalObj.DeleteTestsuite(testSuite.TestSuiteId);
if (result == 1)
{
status = true;
}
return(Json(new { success = status }));
}
catch
{
return(Json(new { success = status }));
}
}
public JsonResult UpdateTestSuite(Models.TestSuites testSuite)
{
int result = 0; bool status = false;
try
{
ValidationMapper <Models.TestSuites, TestSuite> mapperObj = new ValidationMapper <Models.TestSuites, TestSuite>();
var dalObj = new DALRepository();
result = dalObj.UpdatedTestSuite(mapperObj.Translate(testSuite));
if (result == 1)
{
status = true;
}
return(Json(new { success = status }));
}
catch
{
return(Json(new { success = status }));
}
}
public JsonResult jqueryGettestsuites(int?page, int?limit, string sortBy, string direction, Models.TestSuites testsuit)
{
ValidationMapper <TestSuite, Models.TestSuites> mapperObj = new ValidationMapper <TestSuite, Models.TestSuites>();
var dalObj = new DALRepository();
var testSuiteList = dalObj.GetTestSuites();
var query = testSuiteList.Select(p => new Models.TestSuites
{
TestSuiteId = p.TestSuiteId,
TestSuite1 = p.TestSuite1,
TestSuiteDescription = p.TestSuiteDescription,
TestSuiteOwner = p.TestSuiteOwner,
CreatedBy = p.CreatedBy,
CreatedDate = p.CreatedDate,
IsActive = p.IsActive,
});
if (!string.IsNullOrWhiteSpace(testsuit.TestSuite1))
{
query = query.Where(q => q.TestSuite1.Contains(testsuit.TestSuite1));
}
if (testsuit.IsActive)
{
query = query.Where(q => q.IsActive.Equals(testsuit.IsActive));
}
if (!string.IsNullOrEmpty(sortBy) && !string.IsNullOrEmpty(direction))
{
if (direction.Trim().ToLower() == "asc")
{
switch (sortBy.Trim().ToLower())
{
case "testsuite1":
query = query.OrderBy(q => q.TestSuite1);
break;
case "createddate":
query = query.OrderBy(q => q.CreatedDate);
break;
case "testsuiteid":
query = query.OrderBy(q => q.TestSuiteId);
break;
}
}
else
{
switch (sortBy.Trim().ToLower())
{
case "testsuite1":
query = query.OrderByDescending(q => q.TestSuite1);
break;
case "createddate":
query = query.OrderByDescending(q => q.CreatedDate);
break;
case "testsuiteid":
query = query.OrderByDescending(q => q.TestSuiteId);
break;
}
}
}
else
{
query = query.OrderBy(q => q.TestSuiteId);
}
var records = new List <Models.TestSuites>();
var total = records.Count();
total = query.Count();
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
records = query.Skip(start).Take(limit.Value).ToList();
}
else
{
records = query.ToList();
}
return(this.Json(new { records, total }, JsonRequestBehavior.AllowGet));
//if (testSuiteList.Any())
//{
// foreach (var ts in testSuiteList)
// {
// records.Add(mapperObj.Translate(ts));
// }
//}
//return this.Json(new { records, total }, JsonRequestBehavior.AllowGet);
}
