/// <summary>
/// Закрыть форму
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnConfirm_Click(object sender, EventArgs e)
{
using (var db = new dbContext())
{
//При закрытии формы мы сохраняем наши параметры
foreach (var item in modelVisible)
{
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//При закрытии формы мы сохраняем наши параметры
foreach (var item in modelUnVisible)
{
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
this.DialogResult = DialogResult.OK;
this.Close();
}
/// <summary>
/// Очередность и видимость колонок
/// </summary>
public void ReloadColumnView()
{
this.Columns.Clear();
using (var db = new dbContext())
{
var t = from e in db.TColumn
where e.FrameId.Id == FrameId &&
e.UserId.UserName == UserName &&
e.ComponentGuid.ToString() == ComponentGuid
orderby e.Position
select e;
foreach (var item in t)
{
Columns.Add(new DataGridViewTextBoxColumn { Name = item.ColumnName,
HeaderText = item.DisplayName,
Width = item.ColumnWidth,
Visible = item.IsVisible });
}
}
}
/// <summary>
/// До загрузки формы
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void EditColumnWindow_Load(object sender, EventArgs e)
{
using (var db = new dbContext())
{
var t = from el in db.TColumn
where el.UserId.UserName == userName &&
el.FrameId.Id == frameId &&
el.ComponentGuid.ToString() == componentGuid
select el;
modelVisible = t.Where(a => a.IsVisible).OrderBy(a => a.Position).ToList();
modelUnVisible = t.Where(a => !a.IsVisible).OrderBy(a => a.Position).ToList();
ResetListBox();
}
}