//
//ДОБАВИТЬ
//
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();
}
