public MainForm()
{
InitializeComponent();
dc = new PROVIDER_DBDataContext();
tabMainChanged();
}
public Form6()
{
InitializeComponent();
dc = new PROVIDER_DBDataContext();
fillCoverageAreas();
idSelectCovArea = -1;
}
public event EventHandler <EventArgs> AddTransactionClicked; //событие для наблюдателя
public Form2(int idAgr)
{
InitializeComponent();
dc = new PROVIDER_DBDataContext();
idAgreement = idAgr;
fillTransactions();
transaction_date.Enabled = false;
}
public void NewCovArea(string District, string Street, int Num_house)
{
PROVIDER_DBDataContext dc = new PROVIDER_DBDataContext();
var CovArea = new coverage_areas()
{
district = District,
street = Street,
num_house = Num_house
};
dc.coverage_areas.InsertOnSubmit(CovArea); // добавление в БД
dc.SubmitChanges(); // выполняет соответствующие команды
// для внесения изменений базы данных
}
public void DelCovArea(int idCovArea)
{
PROVIDER_DBDataContext dc = new PROVIDER_DBDataContext();
coverage_areas ca = (from c in dc.coverage_areas
where (c.coverage_area_id == idCovArea)
select c).Single <coverage_areas>();
/*dc.OrderDetails.DeleteAllOnSubmit(
* cust.Orders.SelectMany(o => o.OrderDetails));
*
* dc.Orders.DeleteAllOnSubmit(cust.Orders);*/
dc.coverage_areas.DeleteOnSubmit(ca);
dc.SubmitChanges(); //Добавление в БД
}
public Form1()
{
InitializeComponent();
f3 = new Form3();
f4 = new Form4();
f5 = new Form5();
f3.Show();
f4.Show();
f5.Show();
dc = new PROVIDER_DBDataContext();
fillAgreements();
agreementOk.Visible = false;
agreementCancel.Visible = false;
}
public void NewTransaction(int Id_agreement, string Operation_type,
int Transaction_amount, DateTime Transaction_date)
{
PROVIDER_DBDataContext dc = new PROVIDER_DBDataContext();
var Trans = new transactions()
{
id_agreement = Id_agreement,
operation_type = Operation_type,
transaction_amount = Transaction_amount,
transaction_date = Transaction_date
};
dc.transactions.InsertOnSubmit(Trans); // добавление в БД
dc.SubmitChanges(); // выполняет соответствующие команды
// для внесения изменений базы данных
}
public Form4()
{
InitializeComponent();
dc = new PROVIDER_DBDataContext();
fillCoWorkers();
}
public Form5()
{
InitializeComponent();
dc = new PROVIDER_DBDataContext();
fillRates();
}
public Form3()
{
InitializeComponent();
dc = new PROVIDER_DBDataContext();
fillUsers();
}
