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);
}
}
}
public string UpdateEquipmentAssignment(EquipmentAssignment pEquipmentAssignment)
{
try
{
context.Entry(pEquipmentAssignment).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
context.SaveChanges();
return("success");
}
catch (Exception ex)
{
return("fail");
}
}
public string InsertEquipmentAssignment(EquipmentAssignment pEquipmentAssignment)
{
try
{
context.EquipmentAssignment.Add(pEquipmentAssignment);
context.SaveChanges();
return("success");
}
catch (Exception ex)
{
return("fail");
}
}
public static EquipmentView EquipmentToEquipmentAssignmentExtension(this EquipmentAssignment _equipment)
{
if (_equipment == null)
{
return(null);
}
EquipmentView ev = new EquipmentView()
{
AssignmentId = _equipment.AssignmentId
};
return(ev);
}
public static EquipmentAssignment EquipmentViewToEquipment(this EquipmentView _equipment)
{
if (_equipment == null)
{
return(null);
}
EquipmentAssignment ev = new EquipmentAssignment()
{
AssignmentId = _equipment.AssignmentId
};
return(ev);
}
public IActionResult Profile(EquipmentView pEquipmentAssignment)
{
XElement ele = GetAddress(pEquipmentAssignment.Address);
if (ele != null)
{
pEquipmentAssignment.Latitude = ele.Element("lat").FirstNode.ToString();
pEquipmentAssignment.Longitude = ele.Element("lng").FirstNode.ToString();
}
EquipmentAssignment pequipment = UserExtension.EquipmentViewToEquipment(pEquipmentAssignment);
string _result = lIAssignmentInterface.UpdateEquipmentAssignment(pequipment);
return(RedirectToAction("Index"));
}
public IActionResult Profile(string id)
{
EquipmentAssignment pUser = lIAssignmentInterface.getEquipmentAssignment(id);
List <SelectListItem> myList = new List <SelectListItem>()
{
new SelectListItem {
Value = "1", Text = "Ankle Unit"
},
new SelectListItem {
Value = "2", Text = "Knee Unit"
},
new SelectListItem {
Value = "3", Text = "Elbow Unit"
},
new SelectListItem {
Value = "4", Text = "Shoulder Unit"
},
};
ViewBag.equipment = myList;
List <User> _userPatientlist = lIUserRepository.getUserListByType(1);
var ObjList = _userPatientlist.Select(r => new SelectListItem
{
Value = r.UserId.ToString(),
Text = r.Name
});
ViewBag.Patient = new SelectList(ObjList, "Value", "Text");
ViewBag.Patient = ObjList;
List <User> _userTherapistlist = lIUserRepository.getUserListByType(2);
var ObjTherapistList = _userTherapistlist.Select(r => new SelectListItem
{
Value = r.UserId.ToString(),
Text = r.Name
});
ViewBag.Therapists = new SelectList(ObjList, "Value", "Text");
ViewBag.Therapists = ObjTherapistList;
EquipmentView pequipment = UserExtension.EquipmentToEquipmentAssignmentExtension(pUser);
return(View(pequipment));
}
public JsonResult Post([FromBody] EquipmentAPi pEquipmentAssignment)
{
ErrorResponse error = new ErrorResponse();
EquipmentAssignment lEquipmentAssignment;
var response = new Dictionary <string, object>();
string result = string.Empty;
try
{
logger.LogDebug("EquipmentAssignment Post Start");
if (!String.IsNullOrEmpty(pEquipmentAssignment.AssignmentId))
{
lEquipmentAssignment = lIEquipmentAssignmentRepository.getEquipmentAssignment(pEquipmentAssignment.AssignmentId);
if (lEquipmentAssignment == null)
{
lEquipmentAssignment = new EquipmentAssignment();
lEquipmentAssignment.AssignmentId = pEquipmentAssignment.AssignmentId;
lEquipmentAssignment.InstallerId = pEquipmentAssignment.InstallerId;
lEquipmentAssignment.PatientId = pEquipmentAssignment.PatientId;
lEquipmentAssignment.DateInstalled = pEquipmentAssignment.DateInstalled;
lEquipmentAssignment.DateRemoved = pEquipmentAssignment.DateRemoved;
lEquipmentAssignment.Limb = pEquipmentAssignment.Limb;
lEquipmentAssignment.Side = pEquipmentAssignment.Side;
lEquipmentAssignment.ExcerciseEnum = pEquipmentAssignment.ExcerciseEnum;
lEquipmentAssignment.ChairId = pEquipmentAssignment.ChairId;
lEquipmentAssignment.Boom1Id = pEquipmentAssignment.Boom1Id;
lEquipmentAssignment.Boom2Id = pEquipmentAssignment.Boom2Id;
lEquipmentAssignment.Boom3Id = pEquipmentAssignment.Boom3Id;
lEquipmentAssignment.CreatedDate = DateTime.UtcNow;
result = lIEquipmentAssignmentRepository.InsertEquipmentAssignment(lEquipmentAssignment);
}
else
{
lEquipmentAssignment.AssignmentId = pEquipmentAssignment.AssignmentId;
lEquipmentAssignment.InstallerId = pEquipmentAssignment.InstallerId;
lEquipmentAssignment.PatientId = pEquipmentAssignment.PatientId;
lEquipmentAssignment.DateInstalled = pEquipmentAssignment.DateInstalled;
lEquipmentAssignment.DateRemoved = pEquipmentAssignment.DateRemoved;
lEquipmentAssignment.Limb = pEquipmentAssignment.Limb;
lEquipmentAssignment.Side = pEquipmentAssignment.Side;
lEquipmentAssignment.ExcerciseEnum = pEquipmentAssignment.ExcerciseEnum;
lEquipmentAssignment.ChairId = pEquipmentAssignment.ChairId;
lEquipmentAssignment.Boom1Id = pEquipmentAssignment.Boom1Id;
lEquipmentAssignment.Boom2Id = pEquipmentAssignment.Boom2Id;
lEquipmentAssignment.Boom3Id = pEquipmentAssignment.Boom3Id;
lEquipmentAssignment.UpdatedDate = DateTime.UtcNow;
result = lIEquipmentAssignmentRepository.UpdateEquipmentAssignment(lEquipmentAssignment);
}
}
if (result == "success")
{
return(Json(new { Status = (int)HttpStatusCode.OK, result = "Equipment inserted successfully", TimeZone = DateTime.UtcNow.ToString("s") }));
}
else
{
return(Json(new { Status = (int)HttpStatusCode.InternalServerError, result = "Equipment not inserted", TimeZone = DateTime.UtcNow.ToString("s") }));
}
}
catch (Exception ex)
{
logger.LogDebug("Assignment Post Error: " + ex);
error.ErrorCode = HttpStatusCode.InternalServerError;
error.ErrorMessage = ex.ToString();
response.Add("ErrorResponse", error);
return(Json(new { Status = (int)HttpStatusCode.InternalServerError, result = "Equipment not inserted", TimeZone = DateTime.UtcNow.ToString("s") }));
}
}
