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