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") })); } }