private void btnDelete_Click(object sender, EventArgs e) { try { using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString())) { string sql = $@"DELETE FROM EquipmentType WHERE EquipmentTypeID = {_mainFormEquipmentType.EquipmentTypeID}"; cnn.Execute(sql); } } catch (Exception ex) { throw ex; } }
private void btnAdd_Click(object sender, EventArgs e) { try { using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString())) { string sql = $@"DELETE FROM EquipmentType WHERE EquipmentTypeID = {_mainFormEquipmentType.EquipmentTypeID}"; cnn.Execute(sql); sql = $@"INSERT INTO [dbo].[EquipmentType] (EquipmentName,X_,Y_) VALUES (@EquipmentName,@X_,@Y_)"; cnn.Execute(sql, _mainFormEquipmentType); } } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { try { using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString())) { string sql = $@"DELETE FROM Equipment WHERE EquipmentID = {_mainFormEquipment.EquipmentID}"; int deleted = cnn.Execute(sql); //INSERT INTO [dbo].[Equipment] (EquipmentID ,EquipmentTypeID,UnitID,Latitude,Longitude,XOffset,YOffset,IsDatum,Tag) VALUES (@EquipmentID ,@EquipmentTypeID2,@UnitID2,@Latitude,@Longitude,@XOffset,@YOffset,@IsDatum,@Tag) sql = $@"INSERT INTO [dbo].[Equipment] (EquipmentTypeID,UnitID,Latitude,Longitude,XOffset,YOffset,IsDatum,Tag) " + $@"VALUES (@EquipmentTypeID,@UnitID,@Latitude,@Longitude,@XOffset,@YOffset,@IsDatum,@Tag)"; if (deleted > 0) { cnn.Execute(sql, _mainFormEquipment); } } } catch (Exception ex) { throw ex; } }
private void frmEquipment_Load(object sender, EventArgs e) { #region Binding equipmentBindingSource.DataSource = _mainFormEquipment; equipmentBindingSource.ResetBindings(true); #endregion if (firstLoad) { #region loadAllUnits using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString())) { var p = new DynamicParameters(); p.Add("@tblName", "Unit"); string sql = "[dbo].[SelectTable]"; _AllUnins = cnn.Query <Unit>(sql, p, commandType: CommandType.StoredProcedure).ToList(); } #endregion #region loadAllEquipmentType using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString())) { var p = new DynamicParameters(); p.Add("@tblName", "EquipmentType"); string sql = "[dbo].[SelectTable]"; _AllEquipmentTypes = cnn.Query <EquipmentType>(sql, p, commandType: CommandType.StoredProcedure).ToList(); } #endregion #region loadAllEquipment using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString())) { var p = new DynamicParameters(); p.Add("@tblName", "Equipment"); string sql = "[dbo].[SelectTable]"; _AllEquipments = cnn.Query <Equipment>(sql, p, commandType: CommandType.StoredProcedure).ToList(); } #endregion #region comboBoxes_Binding unitNameComboBox.DataSource = _AllUnins.OrderBy(x => x.UnitName).Select(x => x.UnitName).ToList(); equipmentNameComboBox.DataSource = _AllEquipmentTypes.OrderBy(x => x.EquipmentName).Select(x => x.EquipmentName).ToList(); unitNameComboBox.Text = (_AllUnins.Where(x => x.UnitID == _mainFormEquipment.UnitID).FirstOrDefault()) .UnitName; equipmentNameComboBox.Text = (_AllEquipmentTypes.Where(x => x.EquipmentTypeID == _mainFormEquipment.EquipmentTypeID).FirstOrDefault()) .EquipmentName; this.unitNameComboBox.SelectedIndexChanged += new EventHandler(this.unitNameComboBox_SelectedIndexChanged); this.equipmentNameComboBox.SelectedIndexChanged += new EventHandler(this.equipmentNameComboBox_SelectedIndexChanged); #endregion firstLoad = false; } isDatums1 = isDatums(); if (isDatums1.Count() > 0) { isValidUintArea1.top = isDatums1.Min(x => x.YOffset).Value; isValidUintArea1.bottom = isDatums1.Max(x => x.YOffset).Value; isValidUintArea1.left = isDatums1.Min(x => x.XOffset).Value; isValidUintArea1.right = isDatums1.Max(x => x.XOffset).Value; if (_mainFormEquipment.IsDatum != true) { if (!isValidUintArea1.isValid) { _mainFormEquipment.IsDatum = true; } else { _mainFormEquipment.IsDatum = false; _mainFormEquipment.XPercent = (double)(_mainFormEquipment.XOffset - isValidUintArea1.left) / (double)(isValidUintArea1.right - isValidUintArea1.left) * 100; _mainFormEquipment.YPercent = (double)(_mainFormEquipment.YOffset - isValidUintArea1.top) / (double)(isValidUintArea1.bottom - isValidUintArea1.top) * 100; isValidUintArea1.topLongitude = isDatums1.FirstOrDefault(c => c.YOffset == isValidUintArea1.top).Longitude; isValidUintArea1.bottomLongitude = isDatums1.FirstOrDefault(c => c.YOffset == isValidUintArea1.bottom).Longitude; isValidUintArea1.lefLatitudet = isDatums1.FirstOrDefault(c => c.XOffset == isValidUintArea1.left).Latitude; isValidUintArea1.rightLatitude = isDatums1.FirstOrDefault(c => c.XOffset == isValidUintArea1.right).Latitude; _mainFormEquipment.Longitude = CalculateLL(convertToDigit(isValidUintArea1.topLongitude), convertToDigit(isValidUintArea1.bottomLongitude), _mainFormEquipment.YPercent).ToString(); _mainFormEquipment.Latitude = CalculateLL(convertToDigit(isValidUintArea1.lefLatitudet), convertToDigit(isValidUintArea1.rightLatitude), _mainFormEquipment.XPercent).ToString(); } } } if (_mainFormEquipment.Unit.UnitName != "") { unitNameComboBox.Text = _mainFormEquipment.Unit.UnitName; } if (_mainFormEquipment.EquipmentType.EquipmentName != "") { equipmentNameComboBox.Text = _mainFormEquipment.EquipmentType.EquipmentName; } }