public List <UserMaster> GetUserList() { List <UserMaster> list = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_UserMaster_GetAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { list = new List <UserMaster>(); foreach (DataRow row in table.Rows) { UserMaster _user = new UserMaster(); _user.ID = Convert.ToInt32(row["ID"]); _user.UserName = row["UserName"].ToString(); _user.Password = row["Password"].ToString(); _user.IsActive = Convert.ToBoolean(row["IsActive"]); _user.FirstName = row["FirstName"].ToString(); _user.LastName = row["LastName"].ToString(); _user.IsAdmin = Convert.ToBoolean(row["IsAdmin"]); _user.EmailId = row["EmailId"].ToString(); _user.CreatedDate = Convert.ToDateTime(row["CreatedDate"]); _user.ModifiedDate = Convert.ToDateTime(row["ModifiedDate"]); _user.LastLoginDatetime = Convert.ToDateTime(row["LastLoginDatetime"]); _user.LoginDatetime = Convert.ToDateTime(row["LoginDatetime"]); list.Add(_user); } } } return(list); }
public List <vwRuleEngine> GetRuleList() { List <vwRuleEngine> list = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_VwRuleEngine_GetAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { list = new List <vwRuleEngine>(); foreach (DataRow row in table.Rows) { vwRuleEngine _rule = new vwRuleEngine(); //_rule.ID = Convert.ToInt32(row["ID"]); _rule.RuleMastID = Convert.ToInt32(row["RuleMastID"]); //_rule.RuleDescID = Convert.ToString(row["RuleDescID"]); _rule.FolderPath = Convert.ToString(row["FolderPath"]); _rule.CreateDate = Convert.ToDateTime(row["CreateDate"]); _rule.ModifiedDate = Convert.ToDateTime(row["ModifiedDate"]); _rule.IsActive = Convert.ToBoolean(row["IsActive"]); _rule.RuleMastName = Convert.ToString(row["RuleMastName"]); list.Add(_rule); } } } return(list); }
public List <Employee> GetEmployeeList() { List <Employee> listEmployees = null; //Lets get the list of all employees in a datataable using (DataTable table = SqlDBHelper.ExecuteSelectCommand("GetEmployeeList", CommandType.StoredProcedure)) { //check if any record exist or not if (table.Rows.Count > 0) { //Lets go ahead and create the list of employees listEmployees = new List <Employee>(); //Now lets populate the employee details into the list of employees foreach (DataRow row in table.Rows) { Employee employee = new Employee(); employee.EmployeeID = Convert.ToInt32(row["EmployeeID"]); employee.LastName = row["LastName"].ToString(); employee.FirstName = row["FirstName"].ToString(); employee.Title = row["Title"].ToString(); employee.Address = row["Address"].ToString(); employee.City = row["City"].ToString(); employee.Region = row["Region"].ToString(); employee.PostalCode = row["PostalCode"].ToString(); employee.Country = row["Country"].ToString(); employee.Extension = row["Extension"].ToString(); listEmployees.Add(employee); } } } return(listEmployees); }
public List <APICallHistory> GetAPIHistoryList() { List <APICallHistory> list = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_APICallHistory_GetAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { list = new List <APICallHistory>(); foreach (DataRow row in table.Rows) { APICallHistory _history = new APICallHistory(); _history.ID = Convert.ToInt64(row["ID"]); _history.RunTime = Convert.ToDateTime(row["RunTime"]); _history.Comment = Convert.ToString(row["Comment"]); _history.Status = Convert.ToString(row["Status"]); _history.RunID = Convert.ToInt32(row["RunID"]); list.Add(_history); } } } return(list); }
public List <ServiceHistory> GetServiceHistoryStatusOfNRecords() { List <ServiceHistory> list = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_ServiceHistory_GetStatusOfNRecords", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { list = new List <ServiceHistory>(); foreach (DataRow row in table.Rows) { ServiceHistory _history = new ServiceHistory(); _history.ID = Convert.ToInt64(row["ID"]); _history.RunTime = Convert.ToDateTime(row["RunTime"]); _history.Comment = Convert.ToString(row["Comment"]); _history.Status = Convert.ToString(row["Status"]); _history.RunID = Convert.ToInt32(row["RunID"]); _history.NoOfFile = Convert.ToInt32(row["NoOfFile"]); list.Add(_history); } } } return(list); }
public List <RuleMast> GetRules() { List <RuleMast> list = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_RuleMast_GetAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { list = new List <RuleMast>(); foreach (DataRow row in table.Rows) { RuleMast _rule = new RuleMast(); _rule.ID = Convert.ToInt32(row["ID"]); _rule.RuleName = row["RuleName"].ToString(); _rule.IsActive = Convert.ToBoolean(row["IsActive"]); list.Add(_rule); } } } return(list); }
public List <Configuration> GetConfiguration() { List <Configuration> list = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_Configuration_GetAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { list = new List <Configuration>(); foreach (DataRow row in table.Rows) { Configuration _config = new Configuration(); _config.ID = Convert.ToInt32(row["ID"]); _config.ConfigurationKey = row["ConfigurationKey"].ToString(); _config.ConfigurationType = row["ConfigurationType"].ToString(); _config.ConfigurationValue = row["ConfigurationValue"].ToString(); _config.EntryDate = Convert.ToDateTime(row["EntryDate"]); _config.ModifiedDate = Convert.ToDateTime(row["ModifiedDate"]); _config.IsActive = Convert.ToBoolean(row["IsActive"]); _config.Comment = row["Comment"].ToString(); list.Add(_config); } } } return(list); }
public List <Course> GetCourseList() { List <Course> listCourse = null; //Lets get the list of all employees in a datataable using (DataTable table = SqlDBHelper.ExecuteSelectCommand("GetCourseList", CommandType.StoredProcedure)) { //check if any record exist or not if (table.Rows.Count > 0) { //Lets go ahead and create the list of employees listCourse = new List <Course>(); //Now lets populate the employee details into the list of employees foreach (DataRow row in table.Rows) { Course course = new Course(); course.courseID = Convert.ToInt32(row["courseID"]); course.courseCode = row["courseCode"].ToString(); course.courseName = row["courseName"].ToString(); course.semester = row["semester"].ToString(); course.year = row["year"].ToString(); course.enrollKey = row["enrollKey"].ToString(); listCourse.Add(course); } } } return(listCourse); }
public List <vwQuoteDetails> GetvwQuoteDetailsList() { List <vwQuoteDetails> list = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_vwQuoteDetails_GetAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { list = new List <vwQuoteDetails>(); foreach (DataRow row in table.Rows) { vwQuoteDetails _quote = new vwQuoteDetails(); _quote.ID = Convert.ToInt32(row["ID"]); _quote.Mailing_Address1 = Convert.ToString(row["Mailing_Address1"]); _quote.Mailing_Address2 = Convert.ToString(row["Mailing_Address2"]); _quote.ZipCode = Convert.ToInt32(row["ZipCode"]); _quote.City = Convert.ToString(row["City"]); _quote.ZipCode = Convert.ToInt32(row["Insured_State_ID"]); _quote.ZipCode = Convert.ToInt32(row["Home_State_ID"]); _quote.Is_new_business = Convert.ToBoolean(row["Is_new_business"]); _quote.Years_Without_Loss = Convert.ToInt32(row["Years_Without_Loss"]); _quote.Effective_Date = Convert.ToDateTime(row["Effective_Date"]); _quote.Expiration_Date = Convert.ToDateTime(row["Expiration_Date"]); _quote.LOB_GeneralLiability = Convert.ToBoolean(row["LOB_GeneralLiability"]); _quote.LOB_VacantBuildingGL = Convert.ToBoolean(row["LOB_VacantBuildingGL"]); _quote.LOB_Owners = Convert.ToBoolean(row["LOB_Owners"]); _quote.LOB_SpecialEvent = Convert.ToBoolean(row["LOB_SpecialEvent"]); _quote.LOB_Property = Convert.ToBoolean(row["LOB_Property"]); _quote.LOB_VacantBuildingProperty = Convert.ToBoolean(row["LOB_VacantBuildingProperty"]); _quote.LOB_BuilderRisk = Convert.ToBoolean(row["LOB_BuilderRisk"]); _quote.LOB_Crime = Convert.ToBoolean(row["LOB_Crime"]); _quote.LOB_InlandMarine = Convert.ToBoolean(row["LOB_InlandMarine"]); _quote.LOB_ContractorsEquipment = Convert.ToBoolean(row["LOB_ContractorsEquipment"]); _quote.LOB_MotorTruck = Convert.ToBoolean(row["LOB_MotorTruck"]); _quote.UserID = Convert.ToInt32(row["UserID"]); _quote.QuoteStatus = Convert.ToString(row["QuoteStatus"]); _quote.HomeStateName = Convert.ToString(row["HomeStateName"]); _quote.InsureStateName = Convert.ToString(row["InsureStateName"]); _quote.QuoteNo = Convert.ToString(row["QuoteNo"]); _quote.FullName = Convert.ToString(row["FullName"]); _quote.FirstName = Convert.ToString(row["FirstName"]); _quote.LastName = Convert.ToString(row["LastName"]); _quote.Insured_Name = Convert.ToString(row["Insured_Name"]); list.Add(_quote); } } return(list); } }
public List <VwRuleDesc> GetRuleList() { List <VwRuleDesc> list = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_VwRuleDesc_GetAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { list = new List <VwRuleDesc>(); foreach (DataRow row in table.Rows) { VwRuleDesc _rule = new VwRuleDesc(); _rule.ID = Convert.ToInt32(row["ID"]); _rule.RuleMastID = Convert.ToInt32(row["RuleMastID"]); _rule.RuleDescName = Convert.ToString(row["RuleDescName"]); _rule.SplitAs = Convert.ToString(row["SplitAs"]); _rule.Dictionary = Convert.ToString(row["Dictionary"]); _rule.OriginalDocumentName = Convert.ToString(row["OriginalDocumentName"]); _rule.ConvertedDocumentName = Convert.ToString(row["ConvertedDocumentName"]); _rule.EntryDate = Convert.ToDateTime(row["EntryDate"]); _rule.ModifiedDate = Convert.ToDateTime(row["ModifiedDate"]); _rule.IsActive = Convert.ToBoolean(row["IsActive"]); _rule.NeighbourhoodCount = Convert.ToInt32(row["NeighbourhoodCount"]); _rule.Expression1 = Convert.ToString(row["Expression1"]); _rule.Expression2 = Convert.ToString(row["Expression2"]); _rule.ContextWord = Convert.ToString(row["ContextWord"]); _rule.Operator = Convert.ToString(row["Operator"]); _rule.RuleName = Convert.ToString(row["RuleName"]); _rule.IsActiveRuleMast = Convert.ToBoolean(row["IsActiveRuleMast"]); _rule.FieldName = Convert.ToString(row["FieldName"]); _rule.FieldValue = Convert.ToString(row["FieldValue"]); _rule.UploadedFile = Convert.ToString(row["UploadedFile"]); _rule.IsIgnoreKeyword = Convert.ToBoolean(row["IsIgnoreKeyword"]); _rule.FieldPosition = Convert.ToString(row["FieldPosition"]); _rule.IsCheckSynonyms = Convert.ToBoolean(row["IsCheckSynonyms"]); _rule.Synonyms = Convert.ToString(row["Synonyms"]); _rule.ExpressionContext = Convert.ToString(row["ExpressionContext"]); list.Add(_rule); } } } return(list); }
public APIRuleApplicationSummary GetRunID() { APIRuleApplicationSummary _ruleSummary = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_APIRuleApplicationSummary_GetRunID", CommandType.StoredProcedure)) { //check if any record exist or not if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; _ruleSummary = new APIRuleApplicationSummary(); _ruleSummary.RunID = Convert.ToInt32(row["RunID"]); } } return(_ruleSummary); }
public List <StateMaster> GetStateList() { List <StateMaster> list = null; using (DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_StateMaster_GetAll", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { list = new List <StateMaster>(); foreach (DataRow row in table.Rows) { StateMaster _state = new StateMaster(); _state.ID = Convert.ToInt32(row["ID"]); _state.StateName = row["StateName"].ToString(); list.Add(_state); } } } return(list); }
public DataTable GetDateWiseData() { DataTable table = SqlDBHelper.ExecuteSelectCommand("proc_RuleApplicationSummary_GetDateWiseData", CommandType.StoredProcedure); return(table); }