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 static void SqlUpdate(int id, string eqpNum, int?empNum, int?changeOrderId, int?level1Id, int?level2Id, int?level3Id, int?level4Id, bool billable, decimal quantity, EnumBillCycle billCycle, decimal?billAmount)
{
string sql = $"update EquipTimeEntry set EqpNum={eqpNum}, EmpNum={StrEx.ValueOrNull(empNum)}, Billable='{billable}', ChangeOrderId={StrEx.ValueOrNull(changeOrderId)}, " +
$"Level1Id={StrEx.ValueOrNull(level1Id)}, Level2Id={StrEx.ValueOrNull(level2Id)}, Level3Id={StrEx.ValueOrNull(level3Id)}, Level4Id={StrEx.ValueOrNull(level4Id)}, " +
$"Quantity={quantity}, BillCycle='{(char)billCycle}', BillAmount={StrEx.ValueOrNull(billAmount)}, SyncStatus='{EnumRecordSyncStatus.NoSubmit}' where Id={id} ";
MobileCommon.ExecuteNonQuery(sql);
}
public static int SqlInsert(int headerId, string eqpNum, int?empNum, int?changeOrderId, int?level1Id, int?level2Id, int?level3Id, int?level4Id, bool billable, decimal quantity, EnumBillCycle billCycle, decimal?billAmount)
{
string sql = $"insert EquipTimeEntry(MatchId, CompanyId, LogHeaderId, EqpNum, EmpNum, changeOrderId, Level1Id, Level2Id, Level3Id, Level4Id, Billable, Quantity, BillCycle, BillAmount, SyncStatus, Deleted) " +
$"values(-1, {Company.CurrentId}, {headerId}, {eqpNum}, {StrEx.ValueOrNull(empNum)}, {StrEx.ValueOrNull(changeOrderId)}, {StrEx.ValueOrNull(level1Id)}, {StrEx.ValueOrNull(level2Id)}, {StrEx.ValueOrNull(level3Id)}, {StrEx.ValueOrNull(level4Id)}," +
$" '{billable}', {quantity}, '{(char)billCycle}', {StrEx.ValueOrNull(billAmount)}, '{EnumRecordSyncStatus.NoSubmit}', 0); " +
$"Select CAST(SCOPE_IDENTITY() AS INT);";
return(Convert.ToInt32(MobileCommon.ExecuteScalar(sql)));
}
