// //ДОБАВИТЬ // private void bClick_Add(object sender, EventArgs e) { if (tbName.Text != "") { if (NonRelapse.ExpositionsNR(tbName.Text)) { if (Validation.DataCheck(dateBegin.Value, dateEnd.Value)) { exposition = new Expositions { Name = tbName.Text, Address = tbAddress.Text, BeginData = dateBegin.Value, EndData = dateEnd.Value }; } else { DialogResult = DialogResult.None; MessageBox.Show("Даты введены некорректно!"); } } else { DialogResult = DialogResult.None; MessageBox.Show("Такая выставка уже существует."); } } else { DialogResult = DialogResult.None; MessageBox.Show("Название выставки не может быть пустым."); } }
// // Обновление списка картин на экспозиции // private void cbExposition_SelectionChangeCommitted(object sender, EventArgs e) { expos = (Expositions)cbExposition.SelectedItem; expToPics = db.ExpToPics.Where(c => c.IdExp == (int)cbExposition.SelectedValue).ToList(); dGVExpToPic.DataSource = expToPics; dGVExpToPic.Refresh(); }
// //Редактирование экспозиций // private void bEditExp_Click(object sender, EventArgs e) { int id = IdConverter(dGVExpositionList); if (id > 0) { Expositions exposition = db.Expositions.Find(id); FormExposition editForm = new FormExposition(exposition); DialogResult result = editForm.ShowDialog(this); switch (result) { case DialogResult.Cancel: return; case DialogResult.Abort: dbDelete.ExpositionDel(editForm.exposition, db); cbExposition_SelectionChangeCommitted(null, null); CbExposition_Refresh(); dGVExpositionList.Refresh(); break; case DialogResult.OK: dbEdit.ExpositionEdit(exposition, editForm.exposition, db); CbExposition_Refresh(); dGVExpositionList.Refresh(); break; default: Console.WriteLine("Ой-ой"); break; } } }
public FormPictureList(Expositions expositions) { this.expos = expositions; InitializeComponent(); db = new TableContext(); db.Pictures.Include("Status").Load(); dGVPictures.DataSource = db.Pictures.Local.ToBindingList(); }
//ДОБАВИТЬ Выставку public static bool ExpositionAdd(Expositions exp, TableContext tableContext) { try { tableContext.Expositions.Add(exp); tableContext.SaveChanges(); return(true); } catch (Exception) { MessageBox.Show("Потеряно соеденение с сервером."); return(false); } }
// //Удаление экспозиции через контекстное меню // private void tsmExpDel_Click(object sender, EventArgs e) { int id = IdConverter(dGVExpositionList); if (id > 0) { MessageBoxButtons msb = MessageBoxButtons.YesNo; String message = "Вы действительно хотите удалить экспозицию?"; String caption = "Удаление"; if (MessageBox.Show(message, caption, msb) == DialogResult.Yes) { Expositions expo = db.Expositions.Find(id); dbDelete.ExpositionDel(expo, db); } } }
//УДАЛИТЬ Выставку public static bool ExpositionDel(Expositions exposition, TableContext tableContext) { try { if (exposition != null) { tableContext.Expositions.Remove(exposition); tableContext.SaveChanges(); return(true); } return(false); } catch (Exception) { MessageBox.Show("Потеряно соеденение с сервером."); return(false); } }
public static bool ExpositionEdit(Expositions expEdit, Expositions expEditor, TableContext tableContext) { try { if (expEdit != expEditor) { expEdit = expEditor; } tableContext.Entry(expEdit).State = EntityState.Modified; tableContext.SaveChanges(); return(true); } catch (Exception) { MessageBox.Show("Потеряно соеденение с сервером."); return(false); } }
public FormExposition(Expositions exposition) { this.exposition = exposition; InitializeComponent(); if (exposition == null) { bAdd.Click += bClick_Add; bDel.Visible = false; this.Text = "Добавление выставки"; } else { tbName.Text = exposition.Name; tbAddress.Text = exposition.Address; dateBegin.Value = exposition.BeginData; dateEnd.Value = exposition.EndData; str = exposition.Name; bAdd.Click += bClick_Edit; this.Text = "Редактирование выставки"; bAdd.Text = "Изменить"; } }
// //Отчет по картинам на экспозиции // private void bExpToPic_Click(object sender, EventArgs e) { Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); // creating new WorkBook within Excel application Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); // creating new Excelsheet in workbook Microsoft.Office.Interop.Excel._Worksheet worksheet = null; // see the excel sheet behind the program // get the reference of first sheet. By default its name is Sheet1. // store its reference to worksheet worksheet = workbook.Sheets["Лист1"]; worksheet = workbook.ActiveSheet; // changing the name of active sheet worksheet.Name = "Отчет"; // storing header part in Excel int cell = 1; for (int i = 0; i < dGVExpToPic.Columns.Count; i++) { if (dGVExpToPic.Columns[i].Visible == true) { worksheet.Cells[1, cell] = dGVExpToPic.Columns[i].HeaderText; cell++; } } // storing Each row and column value to excel sheet for (int i = 0; i < dGVExpToPic.Rows.Count; i++) { for (int j = 0; j < dGVExpToPic.Columns.Count; j++) { if (dGVExpToPic.Columns[j].Visible == true) { worksheet.Cells[i + 2, j] = dGVExpToPic.Rows[i].Cells[j].Value.ToString(); } } } Excel.Range cellRange = (Excel.Range)worksheet.Cells[1, 1]; Excel.Range rowRange = cellRange.EntireRow; Excel.Range colRange = cellRange.EntireColumn; rowRange.Insert(Excel.XlInsertShiftDirection.xlShiftDown, false); colRange.Insert(Excel.XlInsertShiftDirection.xlShiftDown, false); Excel.Range excelCells = (Excel.Range)worksheet.get_Range("B1").Cells; excelCells.Merge(Type.Missing); Expositions ex1 = (Expositions)cbExposition.SelectedItem; worksheet.Cells[1, 2] = "Перечень картин на " + ex1.Name; Excel.Range range1 = worksheet.UsedRange; range1.Font.Name = "Times New Roman"; range1.Font.Size = 12; // выравниваем колонки, чтобы все данные были на виду range1.EntireColumn.AutoFit(); range1.EntireRow.AutoFit(); range1.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter; range1.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter; // Расставляем рамки со всех сторон range1.Borders.get_Item(Excel.XlBordersIndex.xlInsideHorizontal).LineStyle = Excel.XlLineStyle.xlContinuous; range1.Borders.get_Item(Excel.XlBordersIndex.xlInsideVertical).LineStyle = Excel.XlLineStyle.xlContinuous; //range1.BorderAround2(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlThick, Excel.XlColorIndex.xlColorIndexAutomatic); app.Visible = true; // save the application //workbook.SaveAs("C:\\Users\\Banana\\Desktop\\Report\\dbExportPicToExp.xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing); // Exit from the application //app.Quit(); }