private void ExtractPaddies() { var nameIndex = 0; var codeIndex = 0; foreach (DataGridViewColumn column in NamesGrid.Columns) { if (!column.HeaderText.Equals("DPName", StringComparison.InvariantCultureIgnoreCase)) { continue; } nameIndex = column.DisplayIndex; break; } foreach (DataGridViewColumn column in NamesGrid.Columns) { if (!column.HeaderText.Equals("BranchCode", StringComparison.InvariantCultureIgnoreCase)) { continue; } codeIndex = column.DisplayIndex; break; } foreach (DataGridViewRow row in NamesGrid.Rows) { try { var value = row.Cells[nameIndex].Value; if (value != null) { var paddie = new Paddie { Name = value.ToString(), BranchCode = row.Cells[codeIndex]?.Value?.ToString() }; if (paddies.All(o => o.Name != paddie.Name)) { paddies.Add(paddie); } } } catch (Exception exception) { Console.WriteLine(exception); } } using (var context = new DalexDbContext()) { context.Paddies.AddRange(paddies); context.SaveChanges(); //MessageBox.Show(@"Success"); } }
private void ExtractBranches() { int branchIndex = 0; int codeIndex = 0; foreach (DataGridViewColumn column in NamesGrid.Columns) { if (!column.HeaderText.Equals("Branch", StringComparison.InvariantCultureIgnoreCase)) { continue; } branchIndex = column.DisplayIndex; break; } foreach (DataGridViewColumn column in NamesGrid.Columns) { if (!column.HeaderText.Equals("BranchCode", StringComparison.InvariantCultureIgnoreCase)) { continue; } codeIndex = column.DisplayIndex; break; } foreach (DataGridViewRow row in NamesGrid.Rows) { try { var value = row.Cells[branchIndex].Value; if (value != null) { var branch = new Branch { Name = value.ToString(), Code = row.Cells[codeIndex].Value?.ToString() }; if (branches.All(o => o.Code != branch.Code)) { branches.Add(branch); } } } catch (Exception exception) { Console.WriteLine(exception); } } using (var context = new DalexDbContext()) { context.Branches.AddRange(branches); context.SaveChanges(); //MessageBox.Show(@"Success"); } }
private static int GetPaddiesId(string value) { using (var context = new DalexDbContext()) { var paddie = context.Paddies.FirstOrDefault(o => o.Name == value); if (paddie?.Id != null) { return((int)paddie?.Id); } } return(0); }
private void ExtractTickets() { var nameIndex = 0; var branchNameIndex = 0; var phoneIndex = 0; foreach (DataGridViewColumn column in AttendantGrid.Columns) { if (!column.HeaderText.Equals("Name", StringComparison.InvariantCultureIgnoreCase)) { continue; } nameIndex = column.DisplayIndex; break; } foreach (DataGridViewColumn column in AttendantGrid.Columns) { if (!column.HeaderText.Equals("BranchName", StringComparison.InvariantCultureIgnoreCase)) { continue; } branchNameIndex = column.DisplayIndex; break; } foreach (DataGridViewColumn column in AttendantGrid.Columns) { if (!column.HeaderText.Equals("Number", StringComparison.InvariantCultureIgnoreCase)) { continue; } phoneIndex = column.DisplayIndex; break; } foreach (DataGridViewRow row in AttendantGrid.Rows) { try { var value = row.Cells[nameIndex].Value.ToString(); if (!string.IsNullOrWhiteSpace(value)) { var ticket = new Attendant { Phone = row.Cells[phoneIndex]?.Value?.ToString(), Name = row.Cells[branchNameIndex]?.Value?.ToString(), BranchName = row.Cells[phoneIndex]?.Value?.ToString() }; if (_attendants.All(o => o.Phone != ticket.Phone)) { _attendants.Add(ticket); } } } catch (Exception exception) { Console.WriteLine(exception); } } using (var context = new DalexDbContext()) { context.Attendants.AddRange(_attendants); context.SaveChanges(); //MessageBox.Show(@"Success"); } }
private void ExtractTickets() { var nameIndex = 0; var codeIndex = 0; var ticketIndex = 0; foreach (DataGridViewColumn column in NamesGrid.Columns) { if (!column.HeaderText.Equals("DPName", StringComparison.InvariantCultureIgnoreCase)) { continue; } nameIndex = column.DisplayIndex; break; } foreach (DataGridViewColumn column in NamesGrid.Columns) { if (!column.HeaderText.Equals("BranchCode", StringComparison.InvariantCultureIgnoreCase)) { continue; } codeIndex = column.DisplayIndex; break; } foreach (DataGridViewColumn column in NamesGrid.Columns) { if (!column.HeaderText.Equals("TicketNo", StringComparison.InvariantCultureIgnoreCase)) { continue; } ticketIndex = column.DisplayIndex; break; } foreach (DataGridViewRow row in NamesGrid.Rows) { try { var value = row.Cells[nameIndex].Value.ToString(); if (!string.IsNullOrWhiteSpace(value)) { var ticket = new Ticket { PaddieId = GetPaddiesId(value), BranchCode = row.Cells[codeIndex]?.Value?.ToString(), Number = row.Cells[ticketIndex]?.Value?.ToString() }; if (tickets.All(o => o.Number != ticket.Number)) { tickets.Add(ticket); } } } catch (Exception exception) { Console.WriteLine(exception); } } using (var context = new DalexDbContext()) { context.Tickets.AddRange(tickets); context.SaveChanges(); //MessageBox.Show(@"Success"); } }