private void addToErrorsTime(int entryType, string message, TimeEntry entry)
{
entry.explanation = message;
entry.newEntryStatus = entryType;
correctedTimes.Add(entry);
}
public void processTimeEntries(string ID)
{
allTimes.Clear();
try
{
if (ds != null)
{
ds.Clear();
}
//go through each status individually
//due to the size and nature of the data, we will do them by EntryType (6, 7, 8, 9). We ignore all draft time (0-5)
String SQL = "SELECT t.EntryID, dbo.jfn_FormatClientCode(CliCode) as clicode,dbo.jfn_FormatMatterCode(MatCode) as matcode " +
" ,EntryDate ,e.empname as empName ,BillableFlag ,ActualHoursWork ,Amount, EntryStatus, " +
" tbd.tbdid, ut.utid, pb.PBFUTBatch, pb.PBFUTRecNbr, bt.BTID " +
" FROM TimeEntry t " +
" inner join matter m on m.matsysnbr = t.MatterSysNbr " +
" inner join client c on c.clisysnbr = ClientSysNbr " +
" inner join employee e on e.empsysnbr = t.TimekeeperSysNbr " +
" left outer join timeentrylink tel on tel.entryid = t.entryid " +
" left outer join timebatchdetail tbd on tel.tbdid = tbd.tbdid " +
" left outer join unbilledtime ut on ut.utid = tbd.tbdid " +
" left outer join PreBillFeeItem pb on pb.PBFUTBatch = ut.utbatch and pb.PBFUTRecNbr = ut.UTRecNbr " +
" left outer join billedtime bt on bt.btid = tbd.tbdid " +
" where t.entrystatus = " + ID;
ds = _jurisUtility.RecordsetFromSQL(SQL);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TimeEntry te = new TimeEntry();
te.amount = Convert.ToDecimal(dr["Amount"].ToString().Trim());
te.hours = Convert.ToDecimal(dr["ActualHoursWork"].ToString().Trim());
te.ClientNo = dr["clicode"].ToString().Trim();
te.MatterNo = dr["matcode"].ToString().Trim();
te.ID = Convert.ToInt32(dr["EntryID"].ToString().Trim());
te.Date = DateTime.Parse(dr["EntryDate"].ToString().Trim()).ToString("MM/dd/yyyy");
te.oldEntryStatus = Convert.ToInt32(dr["EntryStatus"].ToString().Trim());
if (!string.IsNullOrEmpty(dr["tbdid"].ToString().Trim()))
{
te.tbdid = Convert.ToInt32(dr["tbdid"].ToString().Trim());
}
if (!string.IsNullOrEmpty(dr["utid"].ToString().Trim()))
{
te.utid = Convert.ToInt32(dr["utid"].ToString().Trim());
}
if (!string.IsNullOrEmpty(dr["PBFUTBatch"].ToString().Trim()))
{
te.pbbatch = Convert.ToInt32(dr["PBFUTBatch"].ToString().Trim());
}
if (!string.IsNullOrEmpty(dr["PBFUTRecNbr"].ToString().Trim()))
{
te.pbrec = Convert.ToInt32(dr["PBFUTRecNbr"].ToString().Trim());
}
if (!string.IsNullOrEmpty(dr["BTID"].ToString().Trim()))
{
te.btid = Convert.ToInt32(dr["BTID"].ToString().Trim());
}
if (dr["BillableFlag"].ToString().Trim() == "Y")
{
te.isBillable = true;
}
else
{
te.isBillable = false;
}
te.Timekeeper = dr["empName"].ToString().Trim();
te.explanation = "";
te.ExpCode = "";
te.quantity = 1;
te.Summarize = false;
te.newEntryStatus = -1;
allTimes.Add(te);
}
ds.Clear();
}
catch (Exception ex1)
{
message = ex1.Message + "\r\n" + ex1.InnerException;
}
}
public void compareTimeEntries(TimeEntry tt)
{
//6 is recorded, 7 is unbilled, 8 is on prebill and 9 is billed
switch (tt.oldEntryStatus)
{
case 6:
{
//6 means they should be in tdb but NOT in unbilled or billedtime
if (tt.tbdid == 0)
{
addToErrorsTime(0, "Recorded time was not in TimeBatchDetail. Setting to Draft", tt);
}
else //it IS in tbd but it should NOT be in unbilled or billed time
{
//unbilledtime
if (tt.utid != 0)
{
//see if it is in prebillfeeitem
if (tt.pbrec != 0 && tt.pbbatch != 0) //it IS in unbilled AND prebill
{
addToErrorsTime(8, "Recorded time was on a PreBill. Setting to 'On PreBill'", tt);
}
else //it is NOT in PreBill but IS in unbilledTime
{
addToErrorsTime(7, "Recorded time was on in UnbilledTime. Setting to Posted", tt);
}
}
//billedtime
else if (tt.btid != 0) //it IS in billed so it needs to be 9
{
addToErrorsTime(9, "Recorded time was in BilledTime. Setting to Billed", tt);
}
}
break;
}
case 7:
{
//7 means they should be in unbilledtime AND TBD but NOT in prebillfeeitem or billedtime
if (tt.tbdid == 0)
{
addToErrorsTime(0, "Unbilled time was not in TimeBatchDetail. Setting to Draft", tt);
}
else //it IS in tbd but it needs to be in unbilledtime
{
//unbilledtime
if (tt.utid != 0) //if it IS
{
//see if it is in prebillfeeitem
if (tt.pbrec != 0 && tt.pbbatch != 0) //it IS in unbilled AND prebill
{
addToErrorsTime(8, "Unbilled time was on a PreBill. Setting to 'On PreBill'", tt);
}
// else it is NOT in PreBill so we do nothing because it is IN tbd and IN unbilledtime
}
else //it is in tbd but NOT unbilledtime so we see if it is in billedtime
{
//billedtime
if (tt.btid != 0) //it IS in billed so it needs to be 9
{
addToErrorsTime(9, "Recorded time was in BilledTime. Setting to Billed", tt);
}
else //not in billedtime, unbilledtime or prebill so it is a 6
{
addToErrorsTime(6, "Unbilled time was in TimeBatchDetail but NOT UnbilledTime. Setting to Recorded", tt);
}
}
}
break;
}
case 8:
{
//8 means they should be in tdb AND unbilledtime AND prebillfeeitem
if (tt.tbdid == 0)
{
addToErrorsTime(0, "Prebill time was not in TimeBatchDetail. Setting to Draft", tt);
}
else //it IS in tbd
{
//unbilledtime
if (tt.utid != 0) //if it IS
{
//see if it is not in prebillfeeitem
if (tt.pbrec == 0 && tt.pbbatch == 0) //it IS NOT in prebill
{
addToErrorsTime(7, "Prebill time was not on PreBill but WAS in UnbilledTime. Setting to Posted", tt);
}
//else do nothing because it is in all 3 tables
}
else //NOT in unbilledtime but it IS in tbd
{
//billedtime
if (tt.btid != 0) //it IS in billed so it needs to be 9
{
addToErrorsTime(9, "Prebill time was in BilledTime. Setting to Billed", tt);
}
else //not in unbilled, billed but IS in tbd
{
addToErrorsTime(6, "Prebill time was not in UnbilledTime but IS in TimeBatchDetail. Setting to Recorded", tt);
}
}
}
break;
}
case 9:
{
//9 means it SHOULD be in TBD and billedtime but NOT in unbilledTime or PreBillFeeItem
if (tt.tbdid == 0)
{
addToErrorsTime(0, "Billed time was not in TimeBatchDetail. Setting to Draft", tt);
}
else //it IS in tbd but it should NOT be in unbilled or billed time
{
//unbilledtime
if (tt.utid != 0) //if it IS
{
//see if it is in prebillfeeitem
if (tt.pbrec != 0 && tt.pbbatch != 0) //it IS in unbilled AND prebill
{
addToErrorsTime(8, "Billed time was on a PreBill. Setting to 'On PreBill'", tt);
}
else //it is NOT in PreBill
{
addToErrorsTime(7, "Billed time was in UnbilledTime. Setting to Posted", tt);
}
}
//billedtime
else if (tt.btid == 0) //it IS NOT in billed so it needs to be 0
{
addToErrorsTime(0, "Billed time was not in BilledTime. Setting to Draft", tt);
}
}
break;
}
} //end switch
}