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);
}
}
}
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);
}
}
public void LoadFromTemplate()
{
if (EquipTimeEntry.CopyDataFromTemplate(_headerRecord.ProjectId, _headerRecord.LogDate, _headerRecord.Id))
{
SetCurrent(_headerRecord);
LemHeader.SqlUpdateSubmitStatus(_headerRecord.Id, EnumSubmitStatus.Open);
}
else
{
GuiCommon.ShowMessage("The template data is not available.");
}
}
private void gvEquipment_RowDeleting(object sender, DevExpress.Data.RowDeletingEventArgs e)
{
if (GuiCommon.ShowMessage("Delete Record?", "Confirmation", PopupType.Yes_No) == PopupResult.No)
{
e.Cancel = true;
}
else
{
DataRow row = gvEquipment.GetDataRow(e.RowHandle);
EquipTimeEntry.DeleteEntry((int)row[colId.FieldName]);
LemHeader.SqlUpdateSubmitStatus(_headerRecord.Id, EnumSubmitStatus.Open);
}
}
public IHttpActionResult Post(int syncId, [FromBody] EquipTimeEntry entry)
{
try
{
using (SqlConnection sqlcon = new SqlConnection(WebCommon.WebConnection))
{
sqlcon.Open();
string sSQL = @"WS_FLEM_EquipTimeEntry_PostPut";
SqlCommand cmd = new SqlCommand(sSQL, sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paraMatchId;
cmd.Parameters.Add(new SqlParameter("@SyncId", syncId));
cmd.Parameters.Add(new SqlParameter("@CompanyId", entry.CompanyId));
cmd.Parameters.Add(paraMatchId = new SqlParameter("@MatchId", entry.MatchId)
{
Direction = ParameterDirection.InputOutput
});
cmd.Parameters.Add(new SqlParameter("@HeaderMatchId", entry.HeaderId));
cmd.Parameters.Add(new SqlParameter("@EqpNum", entry.EqpNum));
cmd.Parameters.Add(new SqlParameter("@Level1Id", (object)entry.Level1Id ?? DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Level2Id", (object)entry.Level2Id ?? DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Level3Id", (object)entry.Level3Id ?? DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Level4Id", (object)entry.Level4Id ?? DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Billable", entry.Billable));
cmd.Parameters.Add(new SqlParameter("@Quantity", entry.Quantity));
cmd.Parameters.Add(new SqlParameter("@BillCycle", (char)entry.BillCycle));
cmd.Parameters.Add(new SqlParameter("@BillAmount", (object)entry.BillAmount ?? DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@EstId", (object)entry.ChangeOrderId ?? DBNull.Value));
cmd.ExecuteNonQuery();
return(Ok(paraMatchId.Value));
}
}
catch (Exception e)
{
SqlCommon.ReportInfo(e.Message);
return(BadRequest(e.Message));
}
}
public void SetCurrent(LemHeader header)
{
_headerRecord = header;
SetEnabled(_headerRecord.CheckEditable());
var changeOrderList = ChangeOrder.ListForProject(_headerRecord.ProjectId).Select(cs => new { EstimateId = cs.EstimateId, DisplayName = cs.DisplayName }).Distinct().ToList();
luChangeOrder.DataSource = changeOrderList;
tableEquipEntry.Clear();
EquipTimeEntry.GetEquipEntryList(header.Id).ToList().ForEach(x =>
{
var equip = Equipment.GetEquipment(x.EqpNum);
double?billRate = null;
if (equip != null)
{
var list = equip.GetBillRateList(_headerRecord.ProjectId);
billRate = (double?)list.SingleOrDefault(c => c.BillCycle == x.BillCycle)?.BillRate;
}
tableEquipEntry.Rows.Add(
x.Id,
x.EqpNum,
x.EqpNum,
EquipmentClass.GetEquipmentClass(equip.ClassCode)?.DisplayName ?? "",
x.EmpNum,
x.EmpNum != null ? Employee.GetEmployee(x.EmpNum.Value).DisplayName : "",
x.ChangeOrderId,
x.Level1Id,
x.Level2Id,
x.Level3Id,
x.Level4Id,
x.Billable,
x.Quantity,
(char)x.BillCycle,
billRate,
x.BillAmount);
});
tableEquipEntry.AcceptChanges();
}