public WeightRecord GetOldestWeightRecord(int UserID) { string command = "EXECUTE dbo.OldestWeightForUserID @UserID"; WeightRecord result = null; using (var conn = new SqlConnection(connString)) { result = conn.QueryFirstOrDefault <WeightRecord>(command, new { UserID }); } return(result); }
public object UpdateWeightRecord(WeightRecord weightRecord) { int result = weightData.UpdateWeightRecord(weightRecord); if (result == 1) { return(new { Success = true, Message = "User updated" }); } else { return(new { Success = false, Message = "Something went wrong, user did not update" }); } }
public bool WeightRecordExistsforDate(WeightRecord weightRec) { string command = "EXECUTE dbo.SelectRecordByUserIDAndDate @UserID, @WeightInDate"; WeightRecord result = null; using (var conn = new SqlConnection(connString)) { result = conn.QueryFirstOrDefault <WeightRecord>(command, weightRec); } return(result != null); }
public WeightRecord AddWeightRecord(WeightRecord weightRecord) { string command = "EXECUTE dbo.AddWeightRecord @UserID, @WeightInDate, @CurrentWeight"; WeightRecord result = null; using (var conn = new SqlConnection(connString)) { result = conn.QueryFirstOrDefault <WeightRecord>(command, weightRecord); } return(result); }
public int UpdateWeightRecord(WeightRecord weightRecord) { string command = "EXECUTE dbo.UpdateExistingWeightRecord @UserID, @WeightInDate, @CurrentWeight"; int result; using (var conn = new SqlConnection(connString)) { result = conn.Execute(command, weightRecord); } return(result); }
public WeightSpan(WeightRecord record1, WeightRecord record2) { if (record1.MeasuredAt < record2.MeasuredAt) { From = record1.MeasuredAt; To = record2.MeasuredAt; Change = record2.Value - record1.Value; } else { From = record2.MeasuredAt; To = record1.MeasuredAt; Change = record1.Value - record2.Value; } }
public void NumberOfRecordsShouldIncreaseWhenIAddRecord() { var userName = "******"; var service = new PerfectLifeWebServiceClient(); var records1 = service.GetRecords(userName).Result.Count; var record = new WeightRecord(userName, 80); var result = service.AddRecord(record); Assert.Equal(HttpStatusCode.OK, result.Result); var records2 = service.GetRecords(userName).Result.Count; Assert.Equal(records1 + 1, records2); }
/// <summary> /// 双击皮重记录,显示历史皮重 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void pzDataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e) { Point aP = e.GetPosition(pzDataGrid); IInputElement obj = pzDataGrid.InputHitTest(aP); DependencyObject target = obj as DependencyObject; while (target != null) { if (target is DataGridRow) { WeightRecord sp = pzDataGrid.SelectedItem as WeightRecord; ShowHistoryTare(sp); break; } target = VisualTreeHelper.GetParent(target); } }
/// <summary> /// 查看录像 /// </summary> /// <param name="wm">称量记录</param> /// <param name="showType">查看类型(0:净重;1:皮重;2:毛重)</param> public ShowVideoTapeView(WeightRecord wm, int showType) { InitializeComponent(); if (showType == 0) { FormNameTextBlock.Text = "净重记录_查看录像"; } else if (showType == 1) { FormNameTextBlock.Text = "皮重记录_查看录像"; } else if (showType == 2) { FormNameTextBlock.Text = "毛重记录_查看录像"; } weightModel = wm; LoadDefaultTime(); this.showType = showType; }
public ActionResult Create(WeightRecord r2) { WeightRecord r = new WeightRecord(); try { r.UserName = User.Identity.Name; UpdateModel(r); int newId = weightRecords.Add(r); return(RedirectToAction("Details", new { id = newId })); } catch { ModelState.AddRuleViolations(r.GetRuleViolations()); return(View(r)); } }
public Task <int> RemoveWeightAsync(WeightRecord weightRecord) => Connection.DeleteAsync(weightRecord);
public Task <int> UpdateWeightRecordAsync(WeightRecord weightRecord) => Connection.UpdateAsync(weightRecord);
public Task <int> InsertWeightRecordAsync(WeightRecord weightRecord) => Connection.InsertAsync(weightRecord);