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(int companyId) { try { string sql = "select eqi_num, eqi_code, eqi_desc1, eqi_class, eqi_cat, isnull(own_type,'U') own_type from Equip_ID"; DataTable table = SqlCommon.ExecuteDataAdapter(sql, WebCommon.GetTRConnectionAsync(companyId)); List <Equipment> list = new List <Equipment>(); table.Select().ToList().ForEach(r => list.Add(new Equipment { EqpNum = (string)r["eqi_num"], CompanyId = companyId, AssetCode = (string)r["eqi_code"], Desc = (string)r["eqi_desc1"], ClassCode = (string)r["eqi_class"], CategoryCode = (string)r["eqi_cat"], OwnerType = ConvertEx.CharToEnum <EnumOwnerType>(r["own_type"]) })); 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)); } }
private void gvDetail_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { if (gvDetail.IsNewItemRow(e.RowHandle)) { int poId = (int)gvPO.GetFocusedDataRow()[colId.FieldName]; DataRowView row = e.Row as DataRowView; row[colDetailId.FieldName] = FieldPODetail.SqlInsert(poId, (int)row[colDetailPOLine.FieldName], (string)row[colDetailDescription.FieldName], ConvertEx.ToNullable <int>(row[colDetailLevel1Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel2Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel3Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel4Code.FieldName]), ConvertEx.CharToEnum <EnumComponentType>(row[colDetailComponent.FieldName]), (bool)row[colDetailBillable.FieldName], (decimal)row[colDetailAmount.FieldName]); SetSubmitStatus(EnumSubmitStatus.Open); } }
public LemHeader(DataRow row) { Id = (int)row["Id"]; MatchId = (int)row["MatchId"]; CompanyId = (int)row["CompanyId"]; LogDate = Convert.ToDateTime(row["LogDate"]); LogStatus = ConvertEx.CharToEnum <EnumLogStatus>(row["LogStatus"]); SubmitStatus = ConvertEx.CharToEnum <EnumSubmitStatus>(row["SubmitStatus"]); ProjectId = (int)row["ProjectId"]; LemNum = Convert.ToString(row["LemNum"]); CreatorId = Convert.ToInt32(row["CreatorId"]); Description = Convert.ToString(row["LEM_Desc"]); ApprovalComments = Convert.ToString(row["ApprovalComments"]); EmailData = ConvertEx.ToNullableObj <byte[]>(row["EmailData"]); }
public FieldPODetail(DataRow row) { Id = Convert.ToInt32(row["Id"]); CompanyId = Convert.ToInt32(row["CompanyId"]); POId = Convert.ToInt32(row["POId"]); LineNum = Convert.ToInt16(row["LineNum"]); Description = Convert.ToString(row["Description"]); Level1Id = ConvertEx.ToNullable <int>(row["Level1Code"]); Level2Id = ConvertEx.ToNullable <int>(row["Level2Code"]); Level3Id = ConvertEx.ToNullable <int>(row["Level3Code"]); Level4Id = ConvertEx.ToNullable <int>(row["Level4Code"]); Component = ConvertEx.CharToEnum <EnumComponentType>(row["Component"]); Billable = Convert.ToBoolean(row["Billable"]); Amount = Convert.ToDecimal(row["Amount"]); }
public FieldPO(DataRow row) { Id = Convert.ToInt32(row["Id"]); MatchId = Convert.ToInt32(row["MatchId"]); CompanyId = Convert.ToInt32(row["CompanyId"]); PODate = Convert.ToDateTime(row["PODate"]); PONum = Convert.ToString(row["PONum"]); SupplierCode = Convert.ToString(row["SupplierCode"]); ProjectId = Convert.ToInt32(row["ProjectId"]); Billable = Convert.ToBoolean(row["Billable"]); POAmount = Convert.ToDecimal(row["POAmount"]); SubmitStatus = ConvertEx.CharToEnum <EnumSubmitStatus>(row["FieldPOStatus"]); CreatorId = Convert.ToInt32(row["CreatorId"]); }
void RefreshBillRate(DataRow row) { var equip = Equipment.GetEquipment(Convert.ToString(row[colEqpNum.FieldName])); if (equip != null && row[colBillCycle.FieldName] != DBNull.Value) { EnumBillCycle cycle = ConvertEx.CharToEnum <EnumBillCycle>(row[colBillCycle.FieldName]); var list = equip.GetBillRateList(_headerRecord.ProjectId); row[colBillRate.FieldName] = (object)list.SingleOrDefault(x => x.BillCycle == cycle)?.BillRate ?? DBNull.Value; } else { row[colBillRate.FieldName] = DBNull.Value; } RefreshBillAmount(row); }
public EquipTimeEntry(DataRow row) { Id = (int)row["Id"]; MatchId = (int)row["MatchId"]; CompanyId = (int)row["CompanyId"]; HeaderId = (int)row["LogHeaderId"]; EqpNum = (string)row["EqpNum"]; EmpNum = ConvertEx.ToNullable <int>(row["EmpNum"]); ChangeOrderId = ConvertEx.ToNullable <int>(row["ChangeOrderId"]); Level1Id = ConvertEx.ToNullable <int>(row["Level1Id"]); Level2Id = ConvertEx.ToNullable <int>(row["Level2Id"]); Level3Id = ConvertEx.ToNullable <int>(row["Level3Id"]); Level4Id = ConvertEx.ToNullable <int>(row["Level4Id"]); Billable = (bool)row["Billable"]; Quantity = Convert.ToDecimal(row["Quantity"]); BillCycle = ConvertEx.CharToEnum <EnumBillCycle>(row["BillCycle"]); BillAmount = ConvertEx.ValueOrZero <decimal>(row["BillAmount"]); }
public IHttpActionResult Get(int contactId, int companyId) { try { using (SqlConnection sqlcon = new SqlConnection(WebCommon.WebConnection)) { sqlcon.Open(); string sSQL = @"WS_FLEM_Defaults_Get"; using (SqlCommand cmd = new SqlCommand(sSQL, sqlcon)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@contactId", contactId)); cmd.Parameters.Add(new SqlParameter("@CompanyId", companyId)); DataTable table = new DataTable(); table.Load(cmd.ExecuteReader()); List <DefaultEarning> list = table.Select().Select(r => new DefaultEarning { CompanyId = companyId, ProjectId = Convert.ToInt32(r["pri_id"]), Level1Id = ConvertEx.ToNullable <int>(r["lv1id"]), Level2Id = ConvertEx.ToNullable <int>(r["lv2id"]), Level3Id = ConvertEx.ToNullable <int>(r["lv3id"]), Level4Id = ConvertEx.ToNullable <int>(r["lv4id"]), EarningType = ConvertEx.CharToEnum <EnumEarningType>(r["type"]) }).ToList(); return(Ok(list)); } } } catch (Exception e) { SqlCommon.ReportInfo(e.Message); return(BadRequest(e.Message)); } }
private void gvDetail_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DataRow row = gvDetail.GetDataRow(e.RowHandle); if (e.Column == colDetailLevel1Code) { row[colDetailLevel2Code.FieldName] = DBNull.Value; row[colDetailLevel3Code.FieldName] = DBNull.Value; row[colDetailLevel4Code.FieldName] = DBNull.Value; } else if (e.Column == colDetailLevel2Code) { row[colDetailLevel3Code.FieldName] = DBNull.Value; row[colDetailLevel4Code.FieldName] = DBNull.Value; } else if (e.Column == colDetailLevel3Code) { row[colDetailLevel4Code.FieldName] = DBNull.Value; } else if (e.Column == colDetailAmount) { UpdatePOAmount(); } if (!gvDetail.IsNewItemRow(e.RowHandle)) { if (new GridColumn[] { colDetailDescription, colDetailLevel1Code, colDetailLevel2Code, colDetailLevel3Code, colDetailLevel4Code, colDetailComponent, colDetailBillable, colDetailAmount }.Contains(e.Column)) { FieldPODetail.SqlUpdate((int)row[colDetailId.FieldName], (string)row[colDetailDescription.FieldName], ConvertEx.ToNullable <int>(row[colDetailLevel1Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel2Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel3Code.FieldName]), ConvertEx.ToNullable <int>(row[colDetailLevel4Code.FieldName]), ConvertEx.CharToEnum <EnumComponentType>(row[colDetailComponent.FieldName]), (bool)row[colDetailBillable.FieldName], (decimal)row[colDetailAmount.FieldName]); SetSubmitStatus(EnumSubmitStatus.Open); } } }
private void gvEquipment_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { if (gvEquipment.IsNewItemRow(e.RowHandle)) { DataRowView row = e.Row as DataRowView; row[colId.FieldName] = EquipTimeEntry.SqlInsert(_headerRecord.Id, (string)row[colEqpNum.FieldName], ConvertEx.ToNullable <int>(row[colEmpNum.FieldName]), ConvertEx.ToNullable <int>(row[colChangeOrder.FieldName]), ConvertEx.ToNullable <int>(row[colLevel1Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel2Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel3Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel4Code.FieldName]), (bool)row[colBillable.FieldName], ConvertEx.ToNullable <decimal>(row[colQuantity.FieldName]) ?? 0, ConvertEx.CharToEnum <EnumBillCycle>(row[colBillCycle.FieldName]), ConvertEx.ToNullable <decimal>(row[colBillAmount.FieldName])); LemHeader.SqlUpdateSubmitStatus(_headerRecord.Id, EnumSubmitStatus.Open); } }
private void gvEquipment_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DataRow row = gvEquipment.GetDataRow(e.RowHandle); if (e.Column == colEqpNum || e.Column == colAssetDescription) { string eqtNum = Convert.ToString(row[e.Column.FieldName]); row[colEqpNum.FieldName] = eqtNum; row[colAssetDescription.FieldName] = eqtNum; var equip = Equipment.GetEquipment(eqtNum); row[colEquipmentClass.FieldName] = EquipmentClass.GetEquipmentClass(equip.ClassCode)?.DisplayName ?? ""; Employee employee = (equip.OwnerType == EnumOwnerType.Employee) ? EquipmentAssignment.GetEmployee(equip.EqpNum, _headerRecord.LogDate) : null; row[colEmpNum.FieldName] = (object)employee?.EmpNum ?? DBNull.Value; row[colEmployeeName.FieldName] = employee?.DisplayName ?? ""; RefreshBillRate(row); } else if (e.Column == colLevel1Code) { row[colLevel2Code.FieldName] = DBNull.Value; row[colLevel3Code.FieldName] = DBNull.Value; row[colLevel4Code.FieldName] = DBNull.Value; } else if (e.Column == colLevel2Code) { row[colLevel3Code.FieldName] = DBNull.Value; row[colLevel4Code.FieldName] = DBNull.Value; } else if (e.Column == colLevel3Code) { row[colLevel4Code.FieldName] = DBNull.Value; } else if (e.Column == colBillCycle) { RefreshBillRate(row); } else if (e.Column == colQuantity) { RefreshBillAmount(row); } if (!gvEquipment.IsNewItemRow(e.RowHandle)) { if (new GridColumn[] { colEqpNum, colAssetDescription, colChangeOrder, colLevel1Code, colLevel2Code, colLevel3Code, colLevel4Code, colBillable, colQuantity, colBillCycle }.Contains(e.Column)) { EquipTimeEntry.SqlUpdate((int)row[colId.FieldName], (string)row[colEqpNum.FieldName], ConvertEx.ToNullable <int>(row[colEmpNum.FieldName]), ConvertEx.ToNullable <int>(row[colChangeOrder.FieldName]), ConvertEx.ToNullable <int>(row[colLevel1Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel2Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel3Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel4Code.FieldName]), (bool)row[colBillable.FieldName], ConvertEx.ToNullable <decimal>(row[colQuantity.FieldName]) ?? 0, ConvertEx.CharToEnum <EnumBillCycle>(row[colBillCycle.FieldName]), ConvertEx.ToNullable <decimal>(row[colBillAmount.FieldName])); LemHeader.SqlUpdateSubmitStatus(_headerRecord.Id, EnumSubmitStatus.Open); } } }