public IHttpActionResult GetDepartmentsByBranchCode(string branch_code) { var depts_ = new List <DepartmentModel>(); if (branch_code.Equals("001")) { AppraisalDbEntities appcnxn = new AppraisalDbEntities(); depts_ = (from a in appcnxn.zib_appraisal_dept_structure where a.groupcode.Equals("001") orderby a.deptname ascending select new DepartmentModel { dept_code = a.deptcode, dept_name = a.deptname, unit_code = a.unitcode, unit_name = a.unitname }).ToList(); return(Ok(depts_)); } depts_.Add(new DepartmentModel { Id = 0, dept_code = "OPNS", dept_name = "OPERATIONS", unit_code = "OPNS", unit_name = "OPERATIONS" }); depts_.Add(new DepartmentModel { Id = 1, dept_code = "MKTG", dept_name = "MARKETING", unit_code = "OPNS", unit_name = "OPERATIONS" }); return(Ok(depts_)); }
internal static zib_workflow_xceed_definitions getXceedDefinition(StaffADProfile staffADProfile) { AppraisalDbEntities conn = new AppraisalDbEntities(); var entry = (from d in conn.zib_workflow_xceed_definitions where (d.ad_org_id.Equals(staffADProfile.org_id)) select d ).First(); return(entry); }
internal static Tuple <int, string, int> getXceedConnector(StaffADProfile staffADProfile) { AppraisalDbEntities conn = new AppraisalDbEntities(); var entry = (from d in conn.zib_workflow_xceed_definitions where (d.ad_org_id.Equals(staffADProfile.org_id)) select new { conn_name = d.conn_name, org_id = d.org_id, ad_org_id = d.ad_org_id }).First(); string connString = System.Configuration.ConfigurationManager.ConnectionStrings[entry.conn_name].ConnectionString; return(Tuple.Create(entry.org_id, connString, entry.ad_org_id)); }
static public List <CustomerSearchEntryModel> getSearchRequestEntry(string workflowid) { try { AppraisalDbEntities workflowcnxn = new AppraisalDbEntities(); var entries = (from w in workflowcnxn.zib_customersearch_entries where w.workflowid.Equals(workflowid) select new CustomerSearchEntryModel { StaffName = w.name, AccountNumber = w.account_no, AccountName = w.account_name, RegistrationNumber = w.registration_no, StaffNumber = w.employee_number, RequestStageId = w.requeststageid, RequestStage = w.requeststage, DateSubmitted = w.createdate, LastEditDate = w.lasteditdate, RequestStatus = w.status, EmailAddress = w.email, EmployeeNumber = w.employee_number, StaffGrade = w.grade, org_id = w.org_id, Ranking = w.ranking, Phone = w.phone, ad_org_id = w.ad_org_id, supergroupcode = w.supergroupcode, supergroupname = w.supergroupname, GroupName = w.groupname, GroupCode = w.groupcode, DeptCode = w.deptcode, DeptName = w.deptname, UnitName = w.unitname, UnitCode = w.unitcode, FeeAmount = w.feeAmount, Comments = w.comments, EntryPoint = w.entrypoint, }).ToList(); return(entries); } catch (Exception ex) { return(null); } return(null); }