internal Personnel SchemaPersonnelVersPersonnel(TablePersonnel schemaPersonnel) { return(new Personnel( TablePersonnel.stringToRole[schemaPersonnel.Role], schemaPersonnel.Nom, schemaPersonnel.Tel, schemaPersonnel.Mobile, schemaPersonnel.Mail)); }
public void InitializeView() { try { TablePersonnel.Rows.Clear(); TablePersonnel.Refresh(); TablePersonnel.RowTemplate.Height = 30; TablePersonnel.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; TablePersonnel.ColumnHeadersDefaultCellStyle.Font = new Font("Roboto", 12F, FontStyle.Regular); // fetch all userid ex 1 2 3 4 1 2 List <int> fakeId = new List <int>(); List <int> realId = new List <int>(); var fetchId = SqlUtils.ExecuteQueryReader("select userid from assigned_personnel", false); while (fetchId.Read()) { fakeId.Add(Convert.ToInt32(fetchId["userid"].ToString())); } foreach (int item in fakeId) { if (realId.Contains(item) == false) { realId.Add(item); } } foreach (int userid in realId) { string fullname = ""; string username = ""; var fetchData = SqlUtils.ExecuteQueryReader("select given_name + ' ' + last_name as fullname,username from personnel where userid=" + userid, false); while (fetchData.Read()) { fullname = fetchData["fullname"].ToString(); username = fetchData["username"].ToString(); } string eventname = ""; var reader = SqlUtils.ExecuteQueryReader("select eventid from assigned_personnel where userid=" + userid, false); while (reader.Read()) { var rd = SqlUtils.ExecuteQueryReader("select event_name from custom_event where eventid=" + reader["eventid"].ToString() + " and event_open=1", false); while (rd.Read()) { eventname += rd["event_name"].ToString() + ", "; } } TablePersonnel.Rows.Add(); TablePersonnel.Rows[TablePersonnel.Rows.Count - 1].DefaultCellStyle.BackColor = Color.FromArgb(240, 240, 240); TablePersonnel.Rows[TablePersonnel.Rows.Count - 1].DefaultCellStyle.Font = new Font("Roboto", 9F, FontStyle.Regular); TablePersonnel.Rows[TablePersonnel.RowCount - 1].Cells[0].Value = username; TablePersonnel.Rows[TablePersonnel.RowCount - 1].Cells[1].Value = fullname; TablePersonnel.Rows[TablePersonnel.RowCount - 1].Cells[2].Value = eventname.Substring(0, eventname.Trim().Length - 1); } } catch (Exception ex) { MessageBox.Show(ex.Message); } // extract to unique 1 2 3 4 // select userinfo where userid = 1 // eid = select eventid from assigned_personnel where userid=id; // select event_name from custom_event where eventid=eid; //var r = SqlUtils.ExecuteQueryReader("select * from assigned_personnel",false); //while (r.Read()) //{ // string fullname = ""; // string eventname = ""; // string uname = ""; // // fetch in // SqlDataReader rd = SqlUtils.ExecuteQueryReader(" select given_name + ' ' + last_name as fullname,username from personnel where userid=" + r["userid"].ToString(), false); // while (rd.Read()) // { // fullname = rd["fullname"].ToString(); // uname = rd["username"].ToString(); // } // rd = SqlUtils.ExecuteQueryReader("select event_name from custom_event where eventid="+r["eventid"].ToString() ,false); // while (rd.Read()) // { // eventname = rd["event_name"].ToString(); // } // TablePersonnel.Rows.Add(); // TablePersonnel.Rows[TablePersonnel.Rows.Count - 1].DefaultCellStyle.BackColor = Color.FromArgb(240, 240, 240); // TablePersonnel.Rows[TablePersonnel.Rows.Count - 1].DefaultCellStyle.Font = new Font("Roboto", 9F, FontStyle.Regular); // TablePersonnel.Rows[TablePersonnel.RowCount - 1].Cells[0].Value = uname; // TablePersonnel.Rows[TablePersonnel.RowCount - 1].Cells[1].Value = fullname; // TablePersonnel.Rows[TablePersonnel.RowCount - 1].Cells[2].Value = eventname; //} }