private void button2_Click(object sender, EventArgs e)
{
//string yourtext = "18.02. 2003";
//string tlFio = yourtext;
//string[] b = tlFio.Split(new char[] { ' ', '.', ',' }, StringSplitOptions.RemoveEmptyEntries);
//string o = b[0] + "." + b[1] + "." + b[2];
////string text = yourtext.Replace(" ", ".");
//DateTime d = Convert.ToDateTime(o);
////DateTime.TryParseExact(yourtext, "0:MM/dd/yy H:mm:ss zzz", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out d);
//this.Hide();
//Form2 rr = new Form2();
//rr.Show();
//foreach (DataGridViewRow Row in dataGridView1.Rows)
//{
// listBox1.Items.Add(Row.AccessibilityObject.Value);
// //foreach (DataGridViewCell Cell in dataGridView1.Cell)
// //{
// //}
//}
////dataGridView1.Rows[1].Cells[1].Value
///
var someList = new List <string>();
DataTable dataTable = new DataTable();
List <Person> persons = new List <Person>();
if (dataGridView1.Rows.Count > 0 && dataGridView1.Columns.Count > 0) // Разобраться почему не проходит условие по дате и фио так как вставляеться данные рандомные
{
for (int i = 0; i < dataGridView1.Columns.Count && someList.Count != dataGridView1.Columns.Count; i++)
{
dataTable.Columns.Add();
string it = dataGridView1.Columns[i].HeaderText;
//someList.Add(it.Trim('a', 'r', 'n', 't').Replace("\r", " ").Replace("\a", "").Replace("\t", ""));
someList.Add(it);
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string[] row = new string[dataGridView1.Columns.Count];
for (int j = 0; j < dataGridView1.Columns.Count; j++)
{
string tt = Convert.ToString(dataGridView1[j, i].Value);
row[j] = tt.Trim('a', 'r', 'n', 't').Replace("\r", " ").Replace("\a", "").Replace("\t", "").Replace("\v", " ");
}
string tlFio = row[1];
string[] b = tlFio.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string o = b[0] + " " + b[1] + " " + b[2];
if (dataGridView2.Rows.Count > 0 && dataGridView2.Columns.Count > 0)
{
for (int r = 0; r < dataGridView2.Rows.Count; r++)
{
string[] row2 = new string[dataGridView2.Columns.Count];
for (int h = 0; h < dataGridView2.Columns.Count; h++)
{
string tt = Convert.ToString(dataGridView2[h, r].Value);
row2[h] = tt.Trim('a', 'r', 'n', 't').Replace("\r", " ").Replace("\a", "").Replace("\t", "");
}
string rlFio = row2[1];
string[] c = tlFio.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string q = c[0] + " " + c[1] + " " + c[2];
if (o == q && row[2] == row2[2])
{
if (string.IsNullOrEmpty(row[6]) || row[6] == " ")
{
row[6] = row2[3];
Person person = new Person
{
FIO = row[1],
DateBirdhsday = Convert.ToDateTime(row[2])
};
persons.Add(person);
}
}
}
}
dataTable.Rows.Add(row);
}
}
if (persons.Count > 0)
{
foreach (Person p in persons)
{
listBox1.Items.Add("ФИО " + p.FIO + " Дата рождения " + p.DateBirdhsday);
}
}
dataGridView3.DataSource = dataTable;
for (int i = 0; i < someList.Count; i++)
{
dataGridView3.Columns[i].HeaderText = someList[i];
}
if (dataGridView3.Rows.Count > 0 && dataGridView3.Columns.Count > 0)
{
for (int i = 0; i < dataGridView3.Rows.Count; i++)
{
string[] row = new string[dataGridView3.Columns.Count];
for (int j = 0; j < dataGridView3.Columns.Count; j++)
{
string tt = Convert.ToString(dataGridView3[j, i].Value);
row[j] = tt.Trim('a', 'r', 'n', 't').Replace("\r", " ").Replace("\a", "").Replace("\t", "").Replace("\v", " ");
}
List <NekorektData> nekorektDatas = new List <NekorektData>();
if (string.IsNullOrEmpty(row[6]) || row[6] == " ")
{
NekorektData nekorektData = new NekorektData
{
FIO = row[1],
DateBirdhsday = Convert.ToDateTime(row[2])
};
nekorektDatas.Add(nekorektData);
}
if (nekorektDatas.Count > 0)
{
foreach (NekorektData l in nekorektDatas)
{
listBox2.Items.Add("ФИО " + l.FIO + " Дата рождения " + l.DateBirdhsday);
}
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
var someList = new List <string>();
DataTable dataTable = new DataTable();
List <Person> persons = new List <Person>();
List <NekorektData> nekorektDatas = new List <NekorektData>();
foreach (DataGridViewRow row2 in dataGridView1.Rows)
{
string searchValue = row2.Cells[1].Value.ToString();
string tr = row2.Cells[6].Value.ToString();
try
{
string tlFio = searchValue;
string[] c = tlFio.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string q = c[0] + " " + c[1] + " " + c[2];
DateTime d = Convert.ToDateTime(row2.Cells[2].Value.ToString());
dataGridView2.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
foreach (DataGridViewRow row in dataGridView2.Rows)
{
string rr = row.Cells[1].Value.ToString();
string tlFio2 = rr;
string[] r = tlFio2.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string p = r[0] + " " + r[1] + " " + r[2];
DateTime t = Convert.ToDateTime(row.Cells[2].Value.ToString());
if (p.Equals(q) && t == d)
{
if (string.IsNullOrEmpty(tr) || tr == " ")
{
row2.Cells[6].Value = row.Cells[3].Value.ToString();
Person person = new Person
{
FIO = searchValue,
DateBirdhsday = d
};
persons.Add(person);
}
}
}
}
catch
{
}
}
foreach (DataGridViewRow row22 in dataGridView1.Rows)
{
string searchValue = row22.Cells[1].Value.ToString();
string tr = row22.Cells[6].Value.ToString();
DateTime d = Convert.ToDateTime(row22.Cells[2].Value.ToString());
if (string.IsNullOrEmpty(tr) || tr == " ")
{
NekorektData nekorektData = new NekorektData
{
FIO = searchValue,
DateBirdhsday = d
};
nekorektDatas.Add(nekorektData);
}
for (int i = 0; i < dataGridView1.Columns.Count && someList.Count != dataGridView1.Columns.Count; i++)
{
dataTable.Columns.Add();
string it = dataGridView1.Columns[i].HeaderText;
//someList.Add(it.Trim('a', 'r', 'n', 't').Replace("\r", " ").Replace("\a", "").Replace("\t", ""));
someList.Add(it);
}
string[] rrt = new string[someList.Count];
for (int r = 0; r < someList.Count; r++)
{
rrt[r] = row22.Cells[r].Value.ToString();
}
dataTable.Rows.Add(rrt);
}
if (nekorektDatas.Count > 0)
{
foreach (NekorektData l in nekorektDatas)
{
listBox2.Items.Add("ФИО " + l.FIO + " Дата рождения " + l.DateBirdhsday);
}
}
if (persons.Count > 0)
{
foreach (Person p in persons)
{
listBox1.Items.Add("ФИО " + p.FIO + " Дата рождения " + p.DateBirdhsday);
}
}
dataGridView3.DataSource = dataTable;
for (int i = 0; i < someList.Count; i++)
{
dataGridView3.Columns[i].HeaderText = someList[i];
}
}
private void button1_Click(object sender, EventArgs e)
{
using (TexnikymBDEntities db = new TexnikymBDEntities())
{
var Shablons = db.ШаблонГруппы;
var Student = db.Студенты2;
foreach (ШаблонГруппы tl in Shablons)
{
List <Person> persons = new List <Person>();
string tlFio = tl.ФИО;
string[] b = tlFio.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string o = b[0] + " " + b[1] + " " + b[2];
foreach (Студенты2 ii in Student)
{
string iiFio = ii.ФИО;
string[] c = iiFio.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
string y = c[0] + " " + c[1] + " " + c[2];
if (o == y && tl.ДатаРождения == ii.ДатаРождения)
{
if (string.IsNullOrEmpty(tl.Паспорт) || tl.Паспорт == " ")
{
tl.Паспорт = ii.ПаспортныеДанные;
Person person = new Person
{
FIO = ii.ФИО,
DateBirdhsday = ii.ДатаРождения
};
persons.Add(person);
}
}
}
if (persons.Count > 0)
{
foreach (Person p in persons)
{
listBox1.Items.Add("ФИО " + p.FIO + " Дата рождения " + p.DateBirdhsday);
}
}
}
foreach (ШаблонГруппы tl in Shablons)
{
List <NekorektData> nekorektDatas = new List <NekorektData>();
if (string.IsNullOrEmpty(tl.Паспорт) || tl.Паспорт == " ")
{
NekorektData nekorektData = new NekorektData
{
FIO = tl.ФИО,
DateBirdhsday = tl.ДатаРождения
};
nekorektDatas.Add(nekorektData);
}
if (nekorektDatas.Count > 0)
{
foreach (NekorektData l in nekorektDatas)
{
listBox2.Items.Add("ФИО " + l.FIO + " Дата рождения " + l.DateBirdhsday);
}
}
}
db.SaveChanges();
db.ШаблонГруппы.Load();
dataGridView3.DataSource = db.ШаблонГруппы.Local.ToBindingList();
}
}
