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