public Form2(int personId, string fromWhere)
{
_personId = personId;
InitializeComponent();
_context = new MineContext();
_fromWhereOpened = fromWhere;
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex].Name == "ZamowieniaNazwa")
{
// button clicked - do some logic
var personId = (int)dataGridView1["PersonId", e.RowIndex].Value;
var childForm = new Form2(personId, FromWhereConsts.ODEBRANIE);
childForm.ShowDialog();
}
if (e.ColumnIndex >= 0 && dataGridView1.Columns[e.ColumnIndex].Name == "UsunCol")
{
// button clicked - do some logic
var personId = (int)dataGridView1["PersonId", e.RowIndex].Value;
DialogResult dialogResult = MessageBox.Show("Czy jesteś pewien, że chcesz usunąć klienta?", "Usuń", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new MineContext())
{
var person = ctx.Persons.First(x => x.PersonId == personId);
var zakupy = ctx.Binocles.Where(x => x.Person_PersonId == personId);
ctx.Binocles.RemoveRange(zakupy);
ctx.Persons.Remove(person);
ctx.SaveChanges();
Search();
}
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
}
private async void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Columns[e.ColumnIndex].Name == "ZamowieniaNazwa")
{
// button clicked - do some logic
var personId = (int)dataGridView1["PersonId", e.RowIndex].Value;
var childForm = new Form2(personId, FromWhereConsts.ZBALANSOWANI);
childForm.ShowDialog();
}
if (e.ColumnIndex >= 0 && dataGridView1.Columns[e.ColumnIndex].Name == "UsunCol")
{
// button clicked - do some logic
var personId = (int)dataGridView1["PersonId", e.RowIndex].Value;
var dialogResult = MessageBox.Show("Czy jesteś pewien, że chcesz usunąć klienta?", "Usuń", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
//cascade delete?
using (var ctx = new MineContext())
{
var person = ctx.Persons.First(x => x.PersonId == personId);
var zakupy = ctx.Binocles.Where(x => x.Person_PersonId == personId);
//TODO: Czy nie brakuje usuwania doplat?
ctx.Binocles.RemoveRange(zakupy);
ctx.Persons.Remove(person);
ctx.SaveChanges();
}
await Search();
}
}
}
public Form3(int binocleId, int personId)
{
_binocleId = binocleId;
_personId = personId;
InitializeComponent();
_context = new MineContext();
_person = _context.Persons.First(x => x.PersonId == _personId);
_priceHelper = new PriceHelper();
_mapper = new Mapper();
comboBox5.DataSource = Enum.GetValues(typeof(FormaPlatnosci));
}
private void Search()
{
var personList = new List <Person>();
var lokalizacje = LokalizacjaHelper.DajDozwoloneLokalizacje(_lokalizacja);
using (var ctx = new MineContext())
{
personList = ctx.Persons.Include(x => x.Binocles).Include(y => y.Binocles.Select(z => z.Doplaty)).Where(x => lokalizacje.Contains(x.Lokalizacja)).ToList();
}
//TODO: refactor above query???
//https://stackoverflow.com/questions/7259567/linq-to-entities-does-not-recognize-the-method/7259649
var doWyswietlenia = personList.Where(x => x.Binocles.Any(y => _priceHelper.CzyZbalansowany(y))).ToList(); //zmienić jak w Nieodebrane...czyli przenieść logikę do pobrania wyżej zamiast pobierać wszystkich ludzi
dataGridView1.DataSource = doWyswietlenia;
dataGridView1.Columns["Binocles"].Visible = false;
dataGridView1.Columns["PersonId"].Visible = false;
dataGridView1.RowHeadersVisible = true;
dataGridView1.RowHeadersWidth = 60;
dataGridView1.Columns["FirstName"].HeaderText = "Imię";
dataGridView1.Columns["LastName"].HeaderText = "Nazwisko";
dataGridView1.Columns["Address"].HeaderText = "Adres";
dataGridView1.Columns["Address"].Width = 240;
dataGridView1.Columns["BirthDate"].HeaderText = "Data urodzenia";
dataGridView1.Columns["Lokalizacja"].Width = 75;
if (!dataGridView1.Columns.Contains("ZamowieniaNazwa"))
{
DataGridViewButtonColumn col = new DataGridViewButtonColumn();
col.UseColumnTextForButtonValue = true;
col.Text = "Zamówienia";
col.Name = "ZamowieniaNazwa";
col.HeaderText = "Zamówienia";
dataGridView1.Columns.Add(col);
}
if (!dataGridView1.Columns.Contains("UsunCol"))
{
DataGridViewButtonColumn col = new DataGridViewButtonColumn();
col.UseColumnTextForButtonValue = true;
col.Visible = true;
col.Text = "Usuń";
col.Name = "UsunCol";
dataGridView1.Columns.Add(col);
}
dataGridView1.Columns["UsunCol"].Visible = true;
dataGridView1.Columns["UsunCol"].HeaderText = "Usuń";
SetRowNumber(dataGridView1);
}
private void Search()
{
var personList = new List <Person>();
var lokalizacje = LokalizacjaHelper.DajDozwoloneLokalizacje(_lokalizacja);
using (var ctx = new MineContext())
{
personList = ctx.Persons.Include(x => x.Binocles).Where(x => lokalizacje.Contains(x.Lokalizacja) && x.Binocles.Any(y => !(y.IsDataOdbioru || y.BuyDate <= _dataOdbioru))).ToList();
}
//https://stackoverflow.com/questions/7259567/linq-to-entities-does-not-recognize-the-method/7259649
//var doWyswietlenia = personList.Where(x => x.Binocles.Any(y => !_orderHelper.CzyOdebrany(y))).ToList();
dataGridView1.DataSource = personList;
dataGridView1.Columns["Binocles"].Visible = false;
dataGridView1.Columns["PersonId"].Visible = false;
dataGridView1.RowHeadersVisible = true;
dataGridView1.RowHeadersWidth = 60;
dataGridView1.Columns["FirstName"].HeaderText = "Imię";
dataGridView1.Columns["LastName"].HeaderText = "Nazwisko";
dataGridView1.Columns["Address"].HeaderText = "Adres";
dataGridView1.Columns["Address"].Width = 240;
dataGridView1.Columns["BirthDate"].HeaderText = "Data urodzenia";
dataGridView1.Columns["Lokalizacja"].Width = 75;
if (!dataGridView1.Columns.Contains("ZamowieniaNazwa"))
{
DataGridViewButtonColumn col = new DataGridViewButtonColumn();
col.UseColumnTextForButtonValue = true;
col.Text = "Zamówienia";
col.Name = "ZamowieniaNazwa";
col.HeaderText = "Zamówienia";
dataGridView1.Columns.Add(col);
}
if (!dataGridView1.Columns.Contains("UsunCol"))
{
DataGridViewButtonColumn col = new DataGridViewButtonColumn();
col.UseColumnTextForButtonValue = true;
col.Visible = true;
col.Text = "Usuń";
col.Name = "UsunCol";
dataGridView1.Columns.Add(col);
}
dataGridView1.Columns["UsunCol"].Visible = true;
dataGridView1.Columns["UsunCol"].HeaderText = "Usuń";
SetRowNumber(dataGridView1);
}
public void Generate(Binocle okularyy, Person osoba)
{
var okulary = new Binocle();
using (var context = new MineContext())
{
okulary = context.Binocles.Include(x => x.Doplaty).First(x => x.BinocleId == okularyy.BinocleId);
_czySaDoplaty = okulary.Doplaty.Any(x => x.Binocle_BinocleId == okulary.BinocleId);
}
var DEST = ConfigurationManager.AppSettings["PdfFolder"].ToString() + osoba.LastName + "_" + osoba.FirstName + "_" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".pdf";
FileInfo file = new FileInfo(DEST);
file.Directory.Create();
CreatePdf(DEST, okulary, osoba);
System.Diagnostics.Process.Start(DEST);
}
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex < 0)
{
return;
}
var personId = (int)dataGridView1["PersonId", e.RowIndex].Value;
DialogResult dialogResult = MessageBox.Show("Zapisać zmiany?", "Zapisz", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var ctx = new MineContext())
{
var person = ctx.Persons.First(x => x.PersonId == personId);
person.Address = (string)dataGridView1["Address", e.RowIndex].Value;
person.FirstName = (string)dataGridView1["FirstName", e.RowIndex].Value;
person.LastName = (string)dataGridView1["LastName", e.RowIndex].Value;
person.BirthDate = (DateTime)dataGridView1["BirthDate", e.RowIndex].Value;
person.Lokalizacja = (Lokalizacja)dataGridView1["Lokalizacja", e.RowIndex].Value;
ctx.SaveChanges();
Search();
}
}
else if (dialogResult == DialogResult.No)
{
using (var ctx = new MineContext())
{
var person = ctx.Persons.First(x => x.PersonId == personId);
dataGridView1["Address", e.RowIndex].Value = person.Address;
dataGridView1["FirstName", e.RowIndex].Value = person.FirstName;
dataGridView1["LastName", e.RowIndex].Value = person.LastName;
dataGridView1["BirthDate", e.RowIndex].Value = person.BirthDate;
dataGridView1["Lokalizacja", e.RowIndex].Value = person.Lokalizacja;
ctx.SaveChanges();
//Search();
}
}
}
private MineContext getContext()
{
return(_context ?? (_context = new MineContext()));
}
void Awake()
{
//Instantiate the context, passing it this instance.
context = new MineContext(this);
}
