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;
}
}
}
