public FormSCL() { InitializeComponent(); context = new SclContext(); dateLabel = new ToolStripLabel(); timeLabel = new ToolStripLabel(); statusStrip1.Items.Add(dateLabel); statusStrip1.Items.Add(timeLabel); InitializeCategories(); InitializeRegions(); comboBoxRegion.SelectedIndex = -1; comboBoxCategory.SelectedIndex = -1; comboBoxOrgCategory.SelectedIndex = -1; comboBoxOrgRegion.SelectedIndex = -1; dataGridViewCustomers.AutoGenerateColumns = false; //ToolStripMenuItem contextMenuStripDataGridView.Items.AddRange(new[] { SaveToDocument, ChangeStatusCustomer }); dataGridViewCustomers.ContextMenuStrip = contextMenuStripDataGridView; SaveToDocument.Click += SaveToDocument_Click; ChangeStatusCustomer.Click += ChangeStatusCustomer_Click; //Get 1 sec Timer for a clock timer = new Timer() { Interval = 1000 }; timer.Tick += timer_Tick; timer.Start(); }
private void ChangeStatusCustomer_Click(object sender, EventArgs e) { string custId = dataGridViewCustomers.CurrentRow.Cells[0].Value.ToString(); int cuID = System.Convert.ToInt32(custId); using (SclContext context = new SclContext()) { Customer cust = context.Customers.FirstOrDefault(p => p.CustomerId.Equals(cuID)); if (cust.UserStatus.Equals("Не діє")) { cust.UserStatus = "Діє"; } else if (cust.UserStatus.Equals("Діє")) { cust.UserStatus = "Не діє"; } else { MessageBox.Show("Статус користувача має не допустиме значення"); } context.SaveChanges(); } }
private void buttonFormFindOrgRC_Click(object sender, EventArgs e) { using (SclContext db = new SclContext()) { var org = db.Organizations.Where(p => p.OrgName.Contains(textBoxNameOrganizationFormFindOrgRC.Text)); dataGridViewFindOrgRc.DataSource = org.ToList(); } }
private void SaveToDocument_Click(object sender, EventArgs e) { string custId = dataGridViewCustomers.CurrentRow.Cells[0].Value.ToString(); int cuID = System.Convert.ToInt32(custId); using (SclContext db = new SclContext()) { var getCust = db.Customers.Where(cust => cust.CustomerId.Equals(cuID)).ToList(); // MessageBox.Show(getCust[0].Phone.ToString()); MessageBox.Show("Приложение требует ексель"); var excelApp = new Excel.Application(); excelApp.Workbooks.Add(); Excel._Worksheet workSheet = (Excel.Worksheet)excelApp.ActiveSheet; excelApp.Visible = true; workSheet.Cells[1, "A"] = "Назва організації"; workSheet.Cells[1, "B"] = "ПІБ"; workSheet.Cells[1, "C"] = "Посада"; workSheet.Cells[1, "D"] = "Логін"; workSheet.Cells[1, "E"] = "Пароль"; var OrgName = context.Organizations.Where(p => p.OrgShortName.Equals(dataGridViewCustomers.CurrentRow.Cells[6].Value)); //workSheet.Cells[2, "A"] = OrgName.ToString();//.Value.ToString(); workSheet.Cells[2, "B"] = "" + dataGridViewCustomers.CurrentRow.Cells[1].Value.ToString() + " " + dataGridViewCustomers.CurrentRow.Cells[2].Value.ToString() + " " + dataGridViewCustomers.CurrentRow.Cells[3].Value.ToString(); workSheet.Cells[2, "C"] = dataGridViewCustomers.CurrentRow.Cells[7].Value.ToString(); workSheet.Cells[2, "D"] = dataGridViewCustomers.CurrentRow.Cells[10].Value.ToString(); SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "Excel files 2003(*.xls)|*.xls|Excel files 2007(*.xlsx)|*.xlsx| All files(*.*)|*.*"; saveFileDialog.DefaultExt = ".xlsx"; saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory); saveFileDialog.Title = "Введіть назву та виберіть шлях для збереження файлу"; saveFileDialog.OverwritePrompt = true; try { if (saveFileDialog.ShowDialog() == DialogResult.Cancel) { return; } excelApp.ActiveWorkbook.SaveCopyAs(saveFileDialog.FileName); } catch (Exception ex) { MessageBox.Show("Виникла помилка:" + ex.ToString()); } excelApp.ActiveWorkbook.Close(false); excelApp.Quit(); } }
public FormAddOrganization(SclContext context) { this.context = context; InitializeComponent(); comboBoxNewOrgStatus.SelectedIndex = 0; comboBoxNewOrgRegion.SelectedIndex = -1; comboBoxNewOrgCategory.SelectedIndex = -1; InitializeCategories(); InitializeRegions(); }
public FormChangeOrganization(SclContext context, Organization organization = null) { this.context = context; InitializeComponent(); InitializeCategories(); InitializeRegions(); //comboBoxNewOrgStatus.SelectedIndex = 0; //comboBoxNewOrgRegion.SelectedIndex = -1; //comboBoxNewOrgCategory.SelectedIndex = -1; this.organization = organization ?? new Organization(); InitializeForm(); }
//private MyOrganization myOrgTakeInfo = new MyOrganization(); public FormChangeCustomer(SclContext context, Customer customer = null) { this.context = context; InitializeComponent(); InitializeCategories(); InitializeRegions(); InitializeCities(); groupBoxLoginFormChangeCustomer.Enabled = false; this.customer = customer ?? new Customer(); login = new Login(); InitializeForm(); }
//private MyOrganization myOrgTakeInfo = new MyOrganization(); public FormAddCustomer(SclContext context, Customer customer = null) { this.context = context; InitializeComponent(); InitializeCategories(); InitializeRegions(); InitializeCities(); //comboBoxNewCategory.SelectedIndex = -1; //comboBoxNewCustRegion.SelectedIndex = -1; //comboBoxNewCustCode.SelectedIndex = -1; this.customer = customer ?? new Customer(); login = new Login(); }