public List <TestBenchModel> GetTestBenchList()
{
IEnumerable <TestBenchModel> priorityList = null;
try
{
using (LT_SERVER_DBEntities entity = new LT_SERVER_DBEntities())
{
var t = (from t1 in entity.TestBenchDetails
select new TestBenchModel
{
ID = t1.ID,
TestBenchID = t1.TestBenchID,
TestBenchName = t1.TestBenchName,
DBName = t1.DBName,
DBPassword = t1.DBPassword,
DBUser = t1.DBUser,
PortNo = t1.PortNo,
IPAddress = t1.IPAddress
}).ToList();
priorityList = t.ToList();
}
}
catch (Exception ex)
{
LoggingService service = new LoggingService("TestBenchService/GetTestBenchList", ex.Message, System.DateTime.Now);
service.LogError();
}
return(priorityList.ToList());
}
public DataTable GetTestBenchTable(int id)
{
try
{
using (LT_SERVER_DBEntities entity = new LT_SERVER_DBEntities())
{
TestBenchDetail _testBenchDetails = GetTestBenchInfo(id, entity);
string ip = _testBenchDetails.IPAddress;
string port = _testBenchDetails.PortNo.ToString();
string dbname = _testBenchDetails.DBName;
string user = _testBenchDetails.DBUser;
string pass = _testBenchDetails.DBPassword;
string source = ip + ", " + port;
con = new Connection(source, dbname, user, pass);
_query = "SELECT DISTINCT * FROM information_schema.tables;";
con.SqlQuery(_query);
dt = con.QueryEx();
con.closeConnection();
}
//SaveTableDetails(_testBenchDetails.TestBenchID, dt);
}
catch (Exception epx)
{
//LogLibrary.WriteErrorLog("Error in getData Function in From Table Class" + epx);
Debug.WriteLine(epx);
}
return(dt);
}
public List <PriorityModel> GetPriorityList()
{
IEnumerable <PriorityModel> priorityList = null;
try
{
using (LT_SERVER_DBEntities entity = new LT_SERVER_DBEntities())
{
var t = (from t1 in entity.Priorities
select new PriorityModel
{
PriorityName = t1.PriorityName,
ID = t1.ID,
Frequency = t1.Frequency
}).ToList();
priorityList = t.ToList();
}
}
catch (Exception ex)
{
LoggingService service = new LoggingService("TestBenchService/GetPriorityList", ex.Message, System.DateTime.Now);
service.LogError();
}
return(priorityList.ToList());
}
public List <WebJobLogModel> GetWebJobLog()
{
IEnumerable <WebJobLogModel> priorityList = null;
try
{
using (LT_SERVER_DBEntities entity = new LT_SERVER_DBEntities())
{
var t = (from t1 in entity.tblWebJobLogs
select new WebJobLogModel
{
ID = t1.ID,
TestBenchID = t1.TestBenchID,
TableName = t1.TableName,
StartDateTime = t1.StartDateTime,
EndDateTime = t1.EndDateTime,
Status = t1.Status
}).OrderByDescending(z => z.ID).ToList();
priorityList = t.ToList();
}
}
catch (Exception ex)
{
LoggingService service = new LoggingService("TestBenchService/GetPriorityList", ex.Message, System.DateTime.Now);
service.LogError();
}
return(priorityList.ToList());
}
public void InsertLog(tblErrorLog log)
{
using (LT_SERVER_DBEntities entity = new LT_SERVER_DBEntities())
{
entity.tblErrorLogs.Add(log);
entity.SaveChanges();
}
}
public List <tblErrorLog> GetErrorLog()
{
List <tblErrorLog> log = null;
using (LT_SERVER_DBEntities entity = new LT_SERVER_DBEntities())
{
log = entity.tblErrorLogs.ToList();
}
return(log);
}
public void GetTablePriorityRecords2(int priorityID)
{
try
{
using (LT_SERVER_DBEntities entity = new LT_SERVER_DBEntities())
{
List <TablePriority> list = entity.TablePriorities.Where(x => x.PriorityID == priorityID).ToList <TablePriority>();
GetTableData(list);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public TestBenchDetail GetTestBenchInfo(int ID, LT_SERVER_DBEntities entity)
{
TestBenchDetail priorityList = null;
try
{
priorityList = entity.TestBenchDetails.Where(x => x.ID == ID).FirstOrDefault();
}
catch (Exception ex)
{
LoggingService service = new LoggingService("TestBenchService/GetTestBenchInfo", ex.Message, System.DateTime.Now);
service.LogError();
}
return(priorityList);
}
public int GetTestBenchCount()
{
int count = 0;
try
{
using (LT_SERVER_DBEntities entity = new LT_SERVER_DBEntities())
{
count = entity.TestBenchDetails.Count();
}
}
catch (Exception ex)
{
LoggingService service = new LoggingService("TestBenchService/GetTestBenchCount", ex.Message, System.DateTime.Now);
service.LogError();
}
return(count);
}
public void GetPriorityList()
{
try
{
List <PriorityModel> list = null;
using (LT_SERVER_DBEntities entity = new LT_SERVER_DBEntities())
{
list = (from t1 in entity.Priorities
select new PriorityModel
{
ID = t1.ID,
Frequency = t1.Frequency,
PriorityName = t1.PriorityName
}).ToList();
}
//Console.WriteLine("Method Called !!!");
CreateRecurringJob(list);
}
catch (Exception ex)
{
LoggingService service2 = new LoggingService("CreatePriorityJob/GetPriorityList", ex.InnerException.Message, System.DateTime.Now);
service2.LogError();
}
}
