public IHttpActionResult Get(int companyId) { try { string sql = $"select w.Id, w.Description, w.ValueType, isnull(w.BillingRateType, 'Unknown')[BillingRateType], " + $"w.InclInHoursThisWeek, w.Time_Code_ID_OT, w.Time_Code_ID_DT, e.comp_code[Component], ReportTypeColumn from WS_EMP_Time_Code w " + $"join earn_code e on e.eg_code = w.eg_code and e.ec_code = w.ec_code"; DataTable table = SqlCommon.ExecuteDataAdapter(sql, WebCommon.GetTRConnectionAsync(companyId)); List <TimeCode> list = new List <TimeCode>(); table.Select().ToList().ForEach(r => list.Add(new TimeCode { MatchId = (int)r["Id"], CompanyId = companyId, Desc = $"{r["Description"]}", ValueType = ConvertEx.StringToEnum <EnumValueType>(r["ValueType"]), BillingType = ConvertEx.StringToEnum <EnumBillingRateType>(r["BillingRateType"]), OvertimeId = r.Field <int?>("Time_Code_ID_OT"), DoubleTimeId = r.Field <int?>("Time_Code_ID_DT"), IncludedInWeekCalc = (bool)r["InclInHoursThisWeek"], Component = ConvertEx.CharToEnum <EnumComponentType>(r["Component"]), ReportTypeColumn = Convert.ToString(r["ReportTypeColumn"]) })); return(Ok(list)); } catch (Exception e) { SqlCommon.ReportInfo(e.Message); return(BadRequest(e.Message)); } }
public IHttpActionResult Get() { try { string sql = $"select * from COMPANIES"; DataTable table = SqlCommon.ExecuteDataAdapter(sql, WebCommon.WebConnection); List <Company> list = new List <Company>(); table.Select().ToList().ForEach(r => list.Add(new Company { MatchId = (int)r["AutoID"], CompanyName = (string)r["Company_Name"], ShortName = ConvertEx.StrOrEmpty(r["companyShortName"]), Active = (bool)r["Active"], })); foreach (var com in list) { sql = @"select * from Company"; table = SqlCommon.ExecuteDataAdapter(sql, WebCommon.GetTRConnectionAsync(com.MatchId)); com.CompanyAddress1 = Convert.ToString(table.Rows[0]["ADD1"]); com.CompanyAddress2 = Convert.ToString(table.Rows[0]["ADD2"]); com.CompanyAddress3 = Convert.ToString(table.Rows[0]["ADD3"]); com.CompanyCity = Convert.ToString(table.Rows[0]["City"]); com.CompanyState = Convert.ToString(table.Rows[0]["State"]); com.CompanyZip = Convert.ToString(table.Rows[0]["Zip"]); com.CompanyPhone = Convert.ToString(table.Rows[0]["Phone"]); com.CompanyFax = Convert.ToString(table.Rows[0]["Fax"]); com.CompanyEmail = Convert.ToString(table.Rows[0]["Email"]); com.CompanyWeb = Convert.ToString(table.Rows[0]["WebPage"]); sql = "select isnull(case when rtrim(week_start) = '' then null else week_start end, 'U') as week_start from hr_cntl"; EnumDayInWeek day = ConvertEx.CharToEnum <EnumDayInWeek>(SqlCommon.ExecuteScalar(sql, WebCommon.GetTRConnectionAsync(com.MatchId))); com.WeekStart = ConvertEx.StringToEnum <DayOfWeek>(Enum.GetName(typeof(EnumDayInWeek), day)); sql = @"select use_cat_class from fa_setup"; table = SqlCommon.ExecuteDataAdapter(sql, WebCommon.GetTRConnectionAsync(com.MatchId)); com.EquipRateGroupType = (EnumGroupType)Convert.ToChar(table.Rows[0]["use_cat_class"]); sql = @"select lv1_active_gc, lv1_gencon_desc, lv2_active_gc, lv2_gencon_desc, lv3_active_gc, lv3_gencon_desc, lv4_active_gc, lv4_gencon_desc from proj_cntl"; table = SqlCommon.ExecuteDataAdapter(sql, WebCommon.GetTRConnectionAsync(com.MatchId)); com.MaxLevelCode = (table.Rows[0]["lv4_active_gc"] != DBNull.Value ? 4 : (table.Rows[0]["lv3_active_gc"] != DBNull.Value ? 3 : (table.Rows[0]["lv2_active_gc"] != DBNull.Value ? 2 : (table.Rows[0]["lv1_active_gc"] != DBNull.Value ? 1 : 0)))); com.Level1CodeDesc = Convert.ToString(table.Rows[0]["lv1_gencon_desc"]); com.Level2CodeDesc = Convert.ToString(table.Rows[0]["lv2_gencon_desc"]); com.Level3CodeDesc = Convert.ToString(table.Rows[0]["lv3_gencon_desc"]); com.Level4CodeDesc = Convert.ToString(table.Rows[0]["lv4_gencon_desc"]); } return(Ok(list)); } catch (Exception e) { SqlCommon.ReportInfo(e.Message); return(BadRequest(e.Message)); } }
public SyncStatus(DataRow row) { Id = (int)row["Id"]; CompanyId = ConvertEx.ToNullable <int>(row["CompanyId"]); SyncTable = (string)row["SyncTable"]; SyncName = (string)row["SyncName"]; DisplayName = (string)row["DisplayName"]; DoSync = (bool)row["DoSync"]; SyncType = ConvertEx.StringToEnum <EnumSyncType>(row["SyncType"]); Status = ConvertEx.StringToEnum <EnumTableSyncStatus>(row["Status"]); }
private void SetSubmitStatus(EnumSubmitStatus status) { DataRow row = gvPO.GetFocusedDataRow(); if (row != null && row[colStatus.FieldName] != DBNull.Value && ConvertEx.StringToEnum <EnumSubmitStatus>(row[colStatus.FieldName]) != status) { row[colStatus.FieldName] = Enum.GetName(typeof(EnumSubmitStatus), status); FieldPO.SqlUpdateStatus((int)row[colId.FieldName], status); btnSubmit.Enabled = (status == EnumSubmitStatus.Open); } }
private void SetSubmitStatus(EnumSubmitStatus status) { var row = gridView1.GetDataRow(gridView1.FocusedRowHandle); if (row != null && row.GetValue(colSubmitStatus) != DBNull.Value && ConvertEx.StringToEnum <EnumSubmitStatus>(row.GetValueString(colSubmitStatus)) != status) { row.SetValue(colSubmitStatus, GetEnumName(status)); LemHeader.SqlUpdateSubmitStatus(row.GetValue <int>(colId), status); btnSubmit.Enabled = (status == EnumSubmitStatus.Open); } }