public FiderViewModel(MethodsEntities methodsEntities) { this.methodsEntities = methodsEntities; fiders = new ObservableCollection <FIDER>(methodsEntities.FIDER.OrderBy(p => p.F_TYPE)); persons = new ObservableCollection <PERSON>(methodsEntities.PERSON.OrderBy(p => p.PERSON_FIO)); units = new ObservableCollection <UNIT>(methodsEntities.UNIT.OrderBy(p => p.UNIT_VALUE)); }
public static void Merge() { using (var context = new MethodsEntities()) { context.Merge(); } }
public PersonViewModel(MethodsEntities methodsEntities) { this.methodsEntities = methodsEntities; data = new ObservableCollection <PERSON>(methodsEntities.PERSON.OrderBy(p => p.PERSON_FIO)); if (data != null && data.Count != 0) { selectedRow = data.FirstOrDefault(); } }
public EqTypeViewModel(MethodsEntities methodsEntities) { this.methodsEntities = methodsEntities; data = new ObservableCollection <EQUIPMENT_TYPE>(methodsEntities.EQUIPMENT_TYPE.OrderBy(p => p.EQT_NAME)); if (data != null && data.Count != 0) { selectedRow = data.FirstOrDefault(); } }
public ProducerViewModel(MethodsEntities methodsEntities) { this.methodsEntities = methodsEntities; data = new ObservableCollection <PRODUCER>(methodsEntities.PRODUCER); if (data != null && data.Count != 0) { selectedRow = data.FirstOrDefault(); } }
public MDTViewModel(MethodsEntities methodsEntities) { this.methodsEntities = methodsEntities; data = new ObservableCollection <MEASURING_DEVICE_TYPE>(methodsEntities.MEASURING_DEVICE_TYPE.OrderBy(p => p.MDT_NAME)); if (data != null && data.Count != 0) { selectedRow = data.FirstOrDefault(); } }
public OrganizationViewModel(MethodsEntities methodsEntities) { this.methodsEntities = methodsEntities; data = new ObservableCollection <ORGANIZATION>(methodsEntities.ORGANIZATION.OrderBy(p => p.ORG_NAME)); if (data != null && data.Count != 0) { selectedRow = data.FirstOrDefault(); } }
public UnitViewModel(MethodsEntities methodsEntities) { this.methodsEntities = methodsEntities; data = new ObservableCollection<UNIT>(methodsEntities.UNIT.OrderBy(p=>p.UNIT_VALUE)); if (data != null && data.Count != 0) { selectedRow = data.FirstOrDefault(); } }
public EquipmentViewModelNew(MethodsEntities methodsEntities, ARM arm_one) { this.arm_one = arm_one; this.methodsEntities = methodsEntities; this.arm_id = arm_one.ARM_ID; data = new ObservableCollection <EQUIPMENT>(methodsEntities.EQUIPMENT.Where(p => p.EQ_ARM_ID == arm_id)); EquipmentTypes = new ObservableCollection <EQUIPMENT_TYPE>(methodsEntities.EQUIPMENT_TYPE); equipmentNew = new EQUIPMENT(); isEnabled = false; }
public AntennaViewModel(MethodsEntities methodsEntities) { this.methodsEntities = methodsEntities; antennas = new ObservableCollection <ANTENNA>(methodsEntities.ANTENNA.OrderBy(p => p.ANT_TYPE)); if (selectedRow == null && antennas != null && antennas.Any()) { selectedRow = antennas[0]; } persons = new ObservableCollection <PERSON>(methodsEntities.PERSON.OrderBy(p => p.PERSON_FIO)); units = new ObservableCollection <UNIT>(methodsEntities.UNIT.OrderBy(p => p.UNIT_VALUE)); }
//static DatabaseOps() //{ // using (var context = new MethodsEntities()) // { // var connection = context.Database.Connection; // Server server = new Server(new ServerConnection(new SqlConnection(connection.ConnectionString))); // Database = server.Databases[connection.Database]; // } //} private static void currentDatabase() { using (var context = new MethodsEntities()) { var connection = context.Database.Connection; Server server = new Server(new ServerConnection(new SqlConnection(connection.ConnectionString))); _Database = server.Databases[connection.Database]; } }
public MdViewModel(MethodsEntities methodsEntities, ARM arm_one) { this.methodsEntities = methodsEntities; this.arm_id = arm_one.ARM_ID; mdTypes = new ObservableCollection <MEASURING_DEVICE_TYPE>(methodsEntities.MEASURING_DEVICE_TYPE); mdArm = new ObservableCollection <MEASURING_DEVICE>(); PrepareData(); CheckRightLeft(); isEnabled = false; }
public AnalyseResultsViewModel(MethodsEntities methodsEntities, ObservableCollection <ARM_TYPE> ArmTypes, int at_id) { this.methodsEntities = methodsEntities; this.ArmTypes = ArmTypes; RaisePropertyChanged(() => ArmTypes); DataForAnalyse = new ObservableCollection <ForScenario.DataForAnalyse>(); this.at_id = at_id; srPort = srDrive = srCarry = true; lsSosr = true; kategoria2 = true; kategoria1 = false; kategoria3 = false; }
public ReportWindowViewModel(MethodsEntities MethodsEntities, XtraReport xr, int anl_id) { this.methodsEntities = MethodsEntities; this.xr = xr; this.anl_id = anl_id; reportName = xr.GetType().Name; RaisePropertyChanged(() => reportData); //все строки таблицы для заданных отчёта и счёта RaisePropertyChanged(() => listLabel); //все метки из пред.коллекции if (listLabel.Any()) { selectedLabel = listLabel[0]; } }
public OrgAnalysis_1_ViewModel(MethodsEntities methodsEntities, string userName, int org_id, int anl_id, string invoice) { this.methodsEntities = methodsEntities; this.userName = userName; this.invoice = invoice; //подготовка к новому вводу TextOrganization = String.Empty; TextAnalysis = String.Empty; organization_new = new ORGANIZATION(); Persons = new ObservableCollection <PERSON>(methodsEntities.PERSON.OrderBy(p => p.PERSON_FIO)); Persons_M = new ObservableCollection <PERSON>(methodsEntities.PERSON.Where(p => p.PERSON_NOTE.Contains("М") || String.IsNullOrEmpty(p.PERSON_NOTE))); Persons_I = new ObservableCollection <PERSON>(methodsEntities.PERSON.Where(p => p.PERSON_NOTE.Contains("И") || String.IsNullOrEmpty(p.PERSON_NOTE))); Organizations = new ObservableCollection <ORGANIZATION>(methodsEntities.ORGANIZATION.OrderBy(p => p.ORG_NAME)); this.org_id = org_id; this.anl_id = anl_id; }
//public static List<MEASURING_DATA> BulkCopy(List<MEASURING_DATA> entities, string table = "MEASURING_DATA") public static List <MEASURING_DATA> BulkCopy(List <MEASURING_DATA> entities, string table) { var context = new MethodsEntities(); string connectionString = context.Database.Connection.ConnectionString; using (IDataReader reader = entities.GetDataReader()) using (SqlConnection connection = new SqlConnection(connectionString)) using (SqlBulkCopy bcp = new SqlBulkCopy(connection)) { connection.Open(); bcp.DestinationTableName = string.Format("[{0}]", table); bcp.ColumnMappings.Add("MDA_ID", "MDA_ID"); bcp.ColumnMappings.Add("MDA_MODE_ID", "MDA_MODE_ID"); bcp.ColumnMappings.Add("MDA_F", "MDA_F"); bcp.ColumnMappings.Add("MDA_F_UNIT_ID", "MDA_F_UNIT_ID"); bcp.ColumnMappings.Add("MDA_I", "MDA_I"); bcp.ColumnMappings.Add("MDA_ECN_VALUE_IZM", "MDA_ECN_VALUE_IZM"); bcp.ColumnMappings.Add("MDA_EN_VALUE_IZM", "MDA_EN_VALUE_IZM"); bcp.ColumnMappings.Add("MDA_U0CN_VALUE_IZM", "MDA_U0CN_VALUE_IZM"); bcp.ColumnMappings.Add("MDA_U0N_VALUE_IZM", "MDA_U0N_VALUE_IZM"); bcp.ColumnMappings.Add("MDA_UFCN_VALUE_IZM", "MDA_UFCN_VALUE_IZM"); bcp.ColumnMappings.Add("MDA_UFN_VALUE_IZM", "MDA_UFN_VALUE_IZM"); bcp.ColumnMappings.Add("MDA_ES_VALUE_IZM", "MDA_ES_VALUE_IZM"); bcp.ColumnMappings.Add("MDA_ECN_VALUE_IZM_DB", "MDA_ECN_VALUE_IZM_DB"); bcp.ColumnMappings.Add("MDA_EN_VALUE_IZM_DB", "MDA_EN_VALUE_IZM_DB"); bcp.ColumnMappings.Add("MDA_U0CN_VALUE_IZM_DB", "MDA_U0CN_VALUE_IZM_DB"); bcp.ColumnMappings.Add("MDA_U0N_VALUE_IZM_DB", "MDA_U0N_VALUE_IZM_DB"); bcp.ColumnMappings.Add("MDA_UFCN_VALUE_IZM_DB", "MDA_UFCN_VALUE_IZM_DB"); bcp.ColumnMappings.Add("MDA_UFN_VALUE_IZM_DB", "MDA_UFN_VALUE_IZM_DB"); bcp.ColumnMappings.Add("MDA_ES_VALUE_IZM_DB", "MDA_ES_VALUE_IZM_DB"); bcp.ColumnMappings.Add("MDA_ECN_VALUE_IZM_MKV", "MDA_ECN_VALUE_IZM_MKV"); bcp.ColumnMappings.Add("MDA_EN_VALUE_IZM_MKV", "MDA_EN_VALUE_IZM_MKV"); bcp.ColumnMappings.Add("MDA_U0CN_VALUE_IZM_MKV", "MDA_U0CN_VALUE_IZM_MKV"); bcp.ColumnMappings.Add("MDA_U0N_VALUE_IZM_MKV", "MDA_U0N_VALUE_IZM_MKV"); bcp.ColumnMappings.Add("MDA_UFCN_VALUE_IZM_MKV", "MDA_UFCN_VALUE_IZM_MKV"); bcp.ColumnMappings.Add("MDA_UFN_VALUE_IZM_MKV", "MDA_UFN_VALUE_IZM_MKV"); bcp.ColumnMappings.Add("MDA_ES_VALUE_IZM_MKV", "MDA_ES_VALUE_IZM_MKV"); bcp.ColumnMappings.Add("MDA_EGS_DB", "MDA_EGS_DB"); bcp.ColumnMappings.Add("MDA_EGS_MKV", "MDA_EGS_MKV"); bcp.ColumnMappings.Add("MDA_E", "MDA_E"); bcp.ColumnMappings.Add("MDA_UF", "MDA_UF"); bcp.ColumnMappings.Add("MDA_U0", "MDA_U0"); bcp.ColumnMappings.Add("MDA_EGS", "MDA_EGS"); bcp.ColumnMappings.Add("MDA_KP", "MDA_KP"); bcp.ColumnMappings.Add("MDA_KPS", "MDA_KPS"); bcp.ColumnMappings.Add("MDA_RBW", "MDA_RBW"); bcp.ColumnMappings.Add("MDA_RBW_UNIT_ID", "MDA_RBW_UNIT_ID"); bcp.ColumnMappings.Add("MDA_TYPE", "MDA_TYPE"); bcp.ColumnMappings.Add("MDA_KA", "MDA_KA"); bcp.ColumnMappings.Add("MDA_KF", "MDA_KF"); bcp.ColumnMappings.Add("MDA_K0", "MDA_K0"); bcp.ColumnMappings.Add("MDA_F_BEGIN", "MDA_F_BEGIN"); bcp.ColumnMappings.Add("MDA_F_END", "MDA_F_END"); bcp.ColumnMappings.Add("MDA_ECN_BEGIN", "MDA_ECN_BEGIN"); bcp.ColumnMappings.Add("MDA_EN_BEGIN", "MDA_EN_BEGIN"); bcp.ColumnMappings.Add("MDA_ECN_END", "MDA_ECN_END"); bcp.ColumnMappings.Add("MDA_EN_END", "MDA_EN_END"); bcp.ColumnMappings.Add("MDA_ANGLE", "MDA_ANGLE"); try { bcp.WriteToServer(reader); } catch (Exception e) { } } return(entities); }
public ARMMode_1_ViewModel(MethodsEntities methodsEntities, string userName) { this.methodsEntities = methodsEntities; this.userName = userName; //подготовка к новому вводу }