Esempio n. 1
0
 private void UpdateBillRate(DataRow row)
 {
     foreach (var timecode in TimeCode.SubList(TimeCode.EnumValueType.Hours))
     {
         decimal?billRate = ProjectWorkClass.GetBillRate(_headerRecord.ProjectId, timecode.MatchId, (string)row[colWorkClass.FieldName]);
         row[BillRateI(timecode)] = (object)billRate ?? DBNull.Value;
         if (row[colId.FieldName] != DBNull.Value)
         {
             LabourTimeDetail.SqlUpdateBillRate((int)row[colId.FieldName], timecode.MatchId, billRate);
         }
     }
 }
Esempio n. 2
0
        private void CalcOvertime(DataRow row, string colName)
        {
            var sqlUpdate = new Action <int, decimal>((timeCodeId, val) =>
            {
                if (row[colId.FieldName] != DBNull.Value)
                {
                    if (TimeCode.GetTimeCode(timeCodeId).ValueType == EnumValueType.Hours)
                    {
                        LabourTimeDetail.SqlUpdateHours((int)row[colId.FieldName], timeCodeId, val);
                    }
                    else
                    {
                        LabourTimeDetail.SqlUpdateAmount((int)row[colId.FieldName], timeCodeId, val);
                    }
                }
            });

            bool handled = false;

            if ((bool)row[colManual.FieldName] == false)
            {
                var ot = OvertimeLimit.GetOvertime(_headerRecord.ProjectId, (int)row[colEmpNum.FieldName]);

                var regTimeCode = TimeCode.GetTimeCodeList(EnumBillingRateType.Regular).SingleOrDefault(x => colName == EnterHoursI(x));
                if (regTimeCode != null && regTimeCode.OvertimeId != null && ot != null)
                {
                    int?    currId    = ConvertEx.ToNullable <int>(row[colId.FieldName]);
                    decimal dayHours  = LabourTimeEntry.GetDayHours(_headerRecord.ProjectId, (int)row[colEmpNum.FieldName], _headerRecord.LogDate, currId);
                    decimal weekHours = LabourTimeEntry.GetWeekHours(_headerRecord.ProjectId, (int)row[colEmpNum.FieldName], _headerRecord.LogDate, currId);

                    dayHours  += ConvertEx.ToNullable <decimal>(row[colName]) ?? 0;
                    weekHours += ConvertEx.ToNullable <decimal>(row[colName]) ?? 0;

                    decimal overHours = ot.Calc(dayHours, weekHours);

                    row[EnterHoursI(regTimeCode.OvertimeId.Value)] = overHours;
                    sqlUpdate(regTimeCode.OvertimeId.Value, overHours);
                    dayHours -= overHours;

                    row[colName] = dayHours;
                    sqlUpdate(regTimeCode.MatchId, dayHours);
                    handled = true;
                }
            }

            if (!handled)
            {
                sqlUpdate(int.Parse(colName.Replace(strEnterHours, "")), ConvertEx.ToNullable <decimal>(row[colName]) ?? 0);
            }
        }
Esempio n. 3
0
        private void gvLabour_RowUpdated(object sender, RowObjectEventArgs e)
        {
            if (gvLabour.IsNewItemRow(e.RowHandle))
            {
                DataRowView row = e.Row as DataRowView;
                row[colId.FieldName] = LabourTimeEntry.SqlInsert(_headerRecord.Id, (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], (bool)row[colManual.FieldName], (string)row[colWorkClass.FieldName], ConvertEx.ToNullable <decimal>(row[colIncludedHours.FieldName]),
                                                                 ConvertEx.ToNullable <decimal>(row[colTotalHours.FieldName]), ConvertEx.ToNullable <decimal>(row[colBillAmount.FieldName]));

                foreach (var timeCode in TimeCode.SubList(EnumValueType.Hours))
                {
                    LabourTimeDetail.SqlInsert((int)row[colId.FieldName], timeCode.MatchId, ConvertEx.ToNullable <decimal>(row[BillRateI(timeCode)]), ConvertEx.ToNullable <decimal>(row[EnterHoursI(timeCode)]), null);
                }

                foreach (var timeCode in TimeCode.SubList(EnumValueType.Dollars))
                {
                    LabourTimeDetail.SqlInsert((int)row[colId.FieldName], timeCode.MatchId, null, null, ConvertEx.ToNullable <decimal>(row[EnterAmountI(timeCode)]));
                }

                LemHeader.SqlUpdateSubmitStatus(_headerRecord.Id, EnumSubmitStatus.Open);
            }
        }