private void addMeasureToBD(MeasureView msr) { using (SqlConnection sqlCon = new SqlConnection(AppSettings.GetConnectionString(typeof(Measure), application_cb.SelectedItem.ToString()))) { sqlCon.Open(); SqlCommand sqlCommand = DataManager.CreateCommand( @"INSERT INTO [dbo].[Measure]([MeasureID], [AccountID],[ChannelID],[BaseMeasureID],[SourceName],[DisplayName],[StringFormat],[AcquisitionNum],[IntegrityCheckRequired]) VALUES( @measureID:Int,@accountID:Int,@channelID:Int,@baseID:Int,@sourceName:Nvarchar,@displayName:Nvarchar,@stringFormat:Nvarchar,@acquisitionNum:Nvarchar,@check:Nvarchar)"); sqlCommand.Parameters["@measureID"].Value = getNewMeasureID(); sqlCommand.Parameters["@accountID"].Value = accounts_cb.SelectedValue; sqlCommand.Parameters["@channelID"].Value = msr.m.Channel == null ? "-1" : msr.m.Channel.ID.ToString(); sqlCommand.Parameters["@baseID"].Value = msr.m.BaseMeasureID; sqlCommand.Parameters["@sourceName"].Value = string.IsNullOrEmpty(msr.m.SourceName) ? DBNull.Value : (object)msr.m.SourceName; sqlCommand.Parameters["@displayName"].Value = msr.m.DisplayName; sqlCommand.Parameters["@stringFormat"].Value = string.IsNullOrEmpty(msr.m.StringFormat) ? DBNull.Value : (object)msr.m.StringFormat; sqlCommand.Parameters["@acquisitionNum"].Value = msr.m.AcquisitionNum == null ? DBNull.Value : (object)msr.m.AcquisitionNum; sqlCommand.Parameters["@check"].Value = string.IsNullOrEmpty(msr.IntegrityCheckRequired) ? DBNull.Value : (object)msr.IntegrityCheckRequired; sqlCommand.Connection = sqlCon; sqlCommand.ExecuteNonQuery(); } showMeasuresBtn_Click(null, null); }
void AddMeasureHandler(object sender, EventArgs e) { MeasureView msr = (MeasureView)e; if (msr.m.Account == null) { addMeasureToBD(msr); } else { editMeasureInDB(msr); } }
private void editMeasureInDB(MeasureView msr) { using (SqlConnection sqlCon = new SqlConnection(AppSettings.GetConnectionString(typeof(Measure), application_cb.SelectedItem.ToString()))) { bool includeStringFormat = !(msr.m.StringFormat.Equals("no change")); bool includeValidation = !(msr.IntegrityCheckRequired.Equals("no change")); string command = string.Format(@"UPDATE [dbo].[Measure] SET [SourceName] = @sourceName:Nvarchar, [DisplayName] = @displayName:Nvarchar, [AcquisitionNum] = @acquisitionNum:Nvarchar{0}{1} WHERE [MeasureID] = @measureID:Int and [AccountID] = @accountID:Int and [ChannelID] = @channelID:Int and [BaseMeasureID] = @baseID:Int", includeStringFormat ? ", [StringFormat] = @stringFormat:Nvarchar" : "", includeValidation ? ", [IntegrityCheckRequired] = @check:Nvarchar" : ""); sqlCon.Open(); SqlCommand sqlCommand = DataManager.CreateCommand(command); sqlCommand.Parameters["@measureID"].Value = msr.m.ID; sqlCommand.Parameters["@accountID"].Value = msr.m.Account.ID; sqlCommand.Parameters["@channelID"].Value = msr.m.Channel == null ? "-1" : msr.m.Channel.ID.ToString(); sqlCommand.Parameters["@baseID"].Value = msr.m.BaseMeasureID; sqlCommand.Parameters["@sourceName"].Value = string.IsNullOrEmpty(msr.m.SourceName) ? DBNull.Value : (object)msr.m.SourceName; sqlCommand.Parameters["@displayName"].Value = string.IsNullOrEmpty(msr.m.DisplayName) ? DBNull.Value : (object)msr.m.DisplayName; sqlCommand.Parameters["@acquisitionNum"].Value = msr.m.AcquisitionNum == null ? DBNull.Value : (object)msr.m.AcquisitionNum; if (includeValidation) { sqlCommand.Parameters["@check"].Value = string.IsNullOrEmpty(msr.IntegrityCheckRequired) ? DBNull.Value : (object)msr.IntegrityCheckRequired; } if (includeStringFormat) { sqlCommand.Parameters["@stringFormat"].Value = string.IsNullOrEmpty(msr.m.StringFormat) ? DBNull.Value : (object)msr.m.StringFormat; } sqlCommand.Connection = sqlCon; sqlCommand.ExecuteNonQuery(); } if (!string.IsNullOrEmpty(msr.oldMeasure.AcquisitionNum.ToString())) { deleteAcquisitionCPA(msr.oldMeasure); } setAcquisitionCPA(); showMeasuresBtn_Click(null, null); }