void menuClick(object sender, System.EventArgs e) { string condition = dataGridView1["Product", dataGridView1.SelectedRows[0].Index].Value.ToString(); if (((System.Windows.Forms.MenuItem)sender).Text == "Удалить") { new DBAdapter().DeleteFromDB(condition); try { DataFromDB = DataFromDB.AsEnumerable().Where(x => x.Field <string>("Product") != condition).Select(x => x).CopyToDataTable <DataRow>(); } catch { DataFromDB.Rows.Clear(); } finally { RefreshDataGridView(DataFromDB); } } else { new DBAdapter().UpdateInDB(((System.Windows.Forms.MenuItem)sender).Text, condition); try { int cond = System.Convert.ToInt32(dataGridView1["Key", dataGridView1.SelectedRows[0].Index].Value.ToString()); var row = DataFromDB.AsEnumerable().SingleOrDefault(r => r.Field <int>("Key") == cond); var rowIndex = DataFromDB.Rows.IndexOf(row); DataFromDB.Rows[rowIndex].SetField("Status", ((System.Windows.Forms.MenuItem)sender).Text); DataFromDB.Rows[rowIndex].SetField("StatusChange", System.DateTime.Now); } catch { } finally { RefreshDataGridView(DataFromDB); } } refreshLabel(); }
public DataSource(DataType dataType) { IDataFactory factory; switch (dataType) { case DataType.File: factory = new DataFromFile(); _data = factory.CreateData(); break; case DataType.DB: factory = new DataFromDB(); _data = factory.CreateData(); break; } }
static void Main(string[] args) { WriterToHistorical writerToHistorical = new WriterToHistorical(); WriterToDumpingBaffer writerToDumpingBaffer = new WriterToDumpingBaffer(); Database database = new Database(); DataFromDB data = new DataFromDB(); DatabaseDB databaseDB = new DatabaseDB(); while (true) { Console.WriteLine("Odaberite 1 ili 2"); Console.WriteLine("1. Slanje preko Dumping Buffer-a"); Console.WriteLine("2. Slanje direktno na Historical"); int broj = Int32.Parse(Console.ReadLine()); // database.Create(); switch (broj) { case 1: writerToDumpingBaffer.SetDataToDumpingBuffer(); data.PackAddData(); database.WriteToDatabase(); // databaseDB.WriteToDatabase(); break; case 2: writerToHistorical.SettingValues(); database.WriteToDatabase(); break; default: Console.WriteLine("Izaberite opciju 1 ili 2!"); break; } } }