private t_Channel_Configurations GetChannelConfiguration() { t_Channel_Configurations channelConfiguration = new t_Channel_Configurations(); channelConfiguration.ChannelId = cboChannels.Text; channelConfiguration.ChannelName = txtName.Text; channelConfiguration.Description = txtDescription.Text; channelConfiguration.ForwardFlow = rdoForward.Checked; channelConfiguration.LoggerId = txtLoggerID.Text; channelConfiguration.Pressure1 = rdoPressure1.Checked; channelConfiguration.Pressure2 = rdoPressure2.Checked; channelConfiguration.ReverseFlow = rdoReverse.Checked; channelConfiguration.Unit = cboUnits.Text; channelConfiguration.ChannelOther = rdoChannelOther.Checked; if (rdoIsShowLable.Checked == true) { channelConfiguration.DisplayOnLabel = true; } if (rdonotShowLable.Checked == true) { channelConfiguration.DisplayOnLabel = false; } channelConfiguration.t_Logger_Configurations = GetLoggerConfiguration(); return(channelConfiguration); }
public t_Channel_Configurations GetChannelConfigurationByType(string loggerId, string type) { t_Channel_Configurations config = new t_Channel_Configurations(); switch (type) { case "f": config = context.t_Channel_Configurations.Where(c => c.ForwardFlow != null && c.ForwardFlow == true && c.LoggerId == loggerId).FirstOrDefault(); break; case "r": config = context.t_Channel_Configurations.Where(c => c.ReverseFlow != null && c.ReverseFlow == true && c.LoggerId == loggerId).FirstOrDefault(); break; case "p1": config = context.t_Channel_Configurations.Where(c => c.Pressure1 != null && c.Pressure1 == true && c.LoggerId == loggerId).FirstOrDefault(); break; case "p2": config = context.t_Channel_Configurations.Where(c => c.Pressure2 != null && c.Pressure2 == true && c.LoggerId == loggerId).FirstOrDefault(); break; default: break; } return(config); }
public void DeleteChannelConfiguration(t_Channel_Configurations channelConfiguration) { try { channelConfigurationRepository.DeleteChannelConfiguration(channelConfiguration); } catch (Exception ex) { // throw ex; } }
public void UpdateChannelConfiguration(t_Channel_Configurations channelConfiguration, t_Channel_Configurations origChannelConfiguration) { try { channelConfigurationRepository.UpdateChannelConfiguration(channelConfiguration, origChannelConfiguration); } catch (Exception ex) { // throw ex; } }
private void SetValues(t_Channel_Configurations channelConfiguration) { cboChannels.Text = channelConfiguration.ChannelId; txtName.Text = channelConfiguration.ChannelName; cboUnits.SelectedValue = channelConfiguration.Unit; txtDescription.Text = channelConfiguration.Description; rdoForward.Checked = channelConfiguration.ForwardFlow ?? false; rdoPressure1.Checked = channelConfiguration.Pressure1 ?? false; rdoPressure2.Checked = channelConfiguration.Pressure2 ?? false; rdoReverse.Checked = channelConfiguration.ReverseFlow ?? false; rdoChannelOther.Checked = channelConfiguration.ChannelOther ?? false; if (channelConfiguration.DisplayOnLabel == true) { rdoIsShowLable.Checked = true; } else { rdonotShowLable.Checked = true; } }
public void InsertChannelConfiguration(t_Channel_Configurations channelConfiguration) { try { var loggerConfiguration = channelConfiguration.t_Logger_Configurations; var dbLoggerConfiguration = context.t_Logger_Configurations.SingleOrDefault(c => c.LoggerId == channelConfiguration.LoggerId); if (dbLoggerConfiguration != null) { dbLoggerConfiguration.SiteId = loggerConfiguration.SiteId; dbLoggerConfiguration.StartHour = loggerConfiguration.StartHour; dbLoggerConfiguration.TelephoneNumber = loggerConfiguration.TelephoneNumber; if (channelConfiguration.ForwardFlow == true) { dbLoggerConfiguration.ForwardFlow = 3; } if (channelConfiguration.Pressure1 == true) { dbLoggerConfiguration.Pressure1 = 1; } if (channelConfiguration.Pressure2 == true) { dbLoggerConfiguration.Pressure2 = 2; } if (channelConfiguration.ReverseFlow == true) { dbLoggerConfiguration.ReverseFlow = 4; } channelConfiguration.t_Logger_Configurations = null; } context.t_Channel_Configurations.Add(channelConfiguration); context.p_Create_Data_Table(channelConfiguration.ChannelId); context.SaveChanges(); } catch (Exception ex) { // throw ex; } }
public void DeleteChannelConfiguration(t_Channel_Configurations channelConfiguration) { try { var loggerConfiguration = context.t_Logger_Configurations.SingleOrDefault(c => c.LoggerId == channelConfiguration.LoggerId); //Clear if (channelConfiguration.ForwardFlow == true) { loggerConfiguration.ForwardFlow = null; } if (channelConfiguration.ReverseFlow == true) { loggerConfiguration.ReverseFlow = null; } if (channelConfiguration.Pressure1 == true) { loggerConfiguration.Pressure1 = null; } if (channelConfiguration.Pressure2 == true) { loggerConfiguration.Pressure2 = null; } context.t_Channel_Configurations.Attach(channelConfiguration); context.t_Channel_Configurations.Remove(channelConfiguration); context.p_Drop_Data_Table(channelConfiguration.ChannelId); context.SaveChanges(); } catch (Exception ex) { // throw ex; } }
public void UpdateChannelConfiguration(t_Channel_Configurations channelConfiguration, t_Channel_Configurations origChannelConfiguration) { try { context.t_Channel_Configurations.Attach(origChannelConfiguration); var dbLoggerConfiguration = origChannelConfiguration.t_Logger_Configurations; var loggerConfiguration = channelConfiguration.t_Logger_Configurations; if (origChannelConfiguration.Pressure1 == true) { dbLoggerConfiguration.Pressure1 = null; } if (origChannelConfiguration.Pressure2 == true) { dbLoggerConfiguration.Pressure2 = null; } if (origChannelConfiguration.ForwardFlow == true) { dbLoggerConfiguration.ForwardFlow = null; } if (origChannelConfiguration.ReverseFlow == true) { dbLoggerConfiguration.ReverseFlow = null; } origChannelConfiguration.ChannelId = channelConfiguration.ChannelId; origChannelConfiguration.ChannelName = channelConfiguration.ChannelName; origChannelConfiguration.Description = channelConfiguration.Description; origChannelConfiguration.ForwardFlow = channelConfiguration.ForwardFlow; origChannelConfiguration.LoggerId = channelConfiguration.LoggerId; origChannelConfiguration.Pressure1 = channelConfiguration.Pressure1; origChannelConfiguration.Pressure2 = channelConfiguration.Pressure2; origChannelConfiguration.ReverseFlow = channelConfiguration.ReverseFlow; origChannelConfiguration.Unit = channelConfiguration.Unit; origChannelConfiguration.DisplayOnLabel = channelConfiguration.DisplayOnLabel; origChannelConfiguration.ChannelOther = channelConfiguration.ChannelOther; dbLoggerConfiguration.SiteId = loggerConfiguration.SiteId; dbLoggerConfiguration.StartHour = loggerConfiguration.StartHour; dbLoggerConfiguration.TelephoneNumber = loggerConfiguration.TelephoneNumber; //Add if (channelConfiguration.ForwardFlow == true) { dbLoggerConfiguration.ForwardFlow = 3; } if (channelConfiguration.Pressure1 == true) { dbLoggerConfiguration.Pressure1 = 1; } if (channelConfiguration.Pressure2 == true) { dbLoggerConfiguration.Pressure2 = 2; } if (channelConfiguration.ReverseFlow == true) { dbLoggerConfiguration.ReverseFlow = 4; } context.SaveChanges(); } catch (Exception ex) { // throw ex; } }