private void manager_record() { // Retrieve scientist's ID config.GetSingleResult("select ID from Scientist s, LoginInfo where s.ID = LoginInfo.ScientistID and LoginInfo.Username = '******' "); id = config.dt.Rows[0].Field <string>("ID"); // Get profile picture config.GetImage("select ProfilePic from Scientist where ID = '" + id + "' ", id, profilepicBox, "ProfilePic"); // Scientist information config.GetSingleResult("exec sp_ShowScientificInfo '" + id + "' "); sctidLabel.Text = config.dt.Rows[0].Field <string>("ID"); fnameLabel.Text = config.dt.Rows[0].Field <string>("Name"); fnameLabel2.Text = config.dt.Rows[0].Field <string>("Name"); sctposLabel.Text = config.dt.Rows[0].Field <string>("Position"); sctdepLabel.Text = config.dt.Rows[0].Field <string>("Department"); dobLabel.Text = config.dt.Rows[0].Field <DateTime>("DoB").ToString("dd/MM/yyyy"); genderLabel.Text = config.dt.Rows[0].Field <string>("Gender"); nationalityLabel.Text = config.dt.Rows[0].Field <string>("Nationality"); cardLabel.Text = config.dt.Rows[0].Field <long>("CreditCard").ToString(); addressLabel.Text = config.dt.Rows[0].Field <string>("Address"); phoneLabel.Text = config.dt.Rows[0].Field <string>("Phone"); emailLabel.Text = config.dt.Rows[0].Field <string>("Email"); // Login information config.GetSingleResult("exec sp_ShowLoginInfo '" + id + "' "); usnLabel.Text = config.dt.Rows[0].Field <string>("Username"); passLabel.Text = config.dt.Rows[0].Field <string>("Password"); roleLabel.Text = config.dt.Rows[0].Field <string>("Role"); }
private void login() { string username = usnTxtBox.Text; string password = passTxtBox.Text; query = "select * from LoginInfo where Username = N'" + username + "' and Password = N'" + password + "' "; config.GetSingleResult(query); config.GetRole(query); if (config.dt.Rows.Count > 0) { if (config.role == "manager") { MainPage_Manager a = new MainPage_Manager(usnTxtBox.Text); this.Hide(); a.ShowDialog(); this.Show(); } else if (config.role == "scientist") { MainPage_Scientist b = new MainPage_Scientist(usnTxtBox.Text); this.Hide(); b.ShowDialog(); this.Show(); } } else { MessageBox.Show("Account does not exist! Please contact administrator.", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void load_department_members() { config.Load_DTG("exec sp_ShowScientistInDep cmt123", cmtmemGridview); config.Load_DTG("exec sp_ShowScientistInDep ctl789", ctlmemGridview); config.Load_DTG("exec sp_ShowScientistInDep hmt567", hmtmemGridview); config.Load_DTG("exec sp_ShowScientistInDep mcb345", mcbmemGridview); config.GetSingleResult("exec sp_NumOfMemInDep cmt123"); numofmemLabel.Text = config.dt.Rows[0].Field <int>("Members").ToString(); config.GetSingleResult("exec sp_NumOfMemInDep ctl789"); numofmemLabel1.Text = config.dt.Rows[0].Field <int>("Members").ToString(); config.GetSingleResult("exec sp_NumOfMemInDep hmt567"); numofmemLabel2.Text = config.dt.Rows[0].Field <int>("Members").ToString(); config.GetSingleResult("exec sp_NumOfMemInDep mcb345"); numofmemLabel3.Text = config.dt.Rows[0].Field <int>("Members").ToString(); }
private void apparatusGridview_Click(object sender, EventArgs e) { selected_id = apparatusGridview.CurrentRow.Cells["ID"].Value.ToString(); config.GetSingleResult("select * from Equipment where ID = '" + selected_id + "' "); if (config.dt.Rows.Count > 0) { config.GetImage("select Image from Equipment where ID = '" + selected_id + "' ", selected_id, apparatuspicBox, "Image"); apparatusidLabel.Text = config.dt.Rows[0].Field <int>("ID").ToString(); apparatusnameLabel.Text = config.dt.Rows[0].Field <string>("Name"); apparatusdescriptTextbox.Text = config.dt.Rows[0].Field <string>("Description"); apparatusQuantity.Text = config.dt.Rows[0].Field <int>("Quantity").ToString(); } }
private void reportGridview_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { get_author = reportGridview.CurrentRow.Cells["Author"].Value.ToString(); dateTime = (DateTime)reportGridview.CurrentRow.Cells[0].Value; string r = dateTime.ToString("yyyy-MM-dd HH:mm:ss.fff"); config.GetSingleResult("select ReportFile from Report where ExpID = '" + exp_id + "' and Author = '" + get_author + "' and ReportTime = '" + r + "' "); byte[] bytes = config.dt.Rows[0].Field <byte[]>("ReportFile"); tmpFile = GetTempReportFilePathWithExtension("docx"); File.WriteAllBytes(tmpFile, bytes); functions.ImportReport(tmpFile, showreportRTextbox); }
private void load_current_selected_participant() { config.GetSingleResult("exec sp_ShowScientificInfo '" + cur + "'"); if (config.dt.Rows.Count > 0) { config.GetImage("select ProfilePic from Scientist where ID = '" + cur + "' ", cur, profilepicBox, "ProfilePic"); sctidLabel.Text = config.dt.Rows[0].Field <string>("ID"); fnameLabel.Text = config.dt.Rows[0].Field <string>("Name"); sctposLabel.Text = config.dt.Rows[0].Field <string>("Position"); sctdepLabel.Text = config.dt.Rows[0].Field <string>("Department"); genderLabel.Text = config.dt.Rows[0].Field <string>("Gender"); nationalityLabel.Text = config.dt.Rows[0].Field <string>("Nationality"); phoneLabel.Text = config.dt.Rows[0].Field <string>("Phone"); emailLabel.Text = config.dt.Rows[0].Field <string>("Email"); } }
private void scientistGridview_Click(object sender, EventArgs e) { selected_id = scientistGridview.CurrentRow.Cells["ID"].Value.ToString(); query = "select a.* from openquery([" + config.SERVERNAME + "], 'exec Laboratory.dbo.sp_ListOfScientist') as a where a.ID = '" + selected_id + "' "; config.GetSingleResult(query); if (config.dt.Rows.Count > 0) { config.GetImage("select ProfilePic from Scientist where ID = '" + selected_id + "' ", selected_id, profilepicBox, "ProfilePic"); sctidLabel.Text = config.dt.Rows[0].Field <string>("ID"); fnameLabel.Text = config.dt.Rows[0].Field <string>("Name"); sctposLabel.Text = config.dt.Rows[0].Field <string>("Position"); sctdepLabel.Text = config.dt.Rows[0].Field <string>("Department"); genderLabel.Text = config.dt.Rows[0].Field <string>("Gender"); nationalityLabel.Text = config.dt.Rows[0].Field <string>("Nationality"); phoneLabel.Text = config.dt.Rows[0].Field <string>("Phone"); emailLabel.Text = config.dt.Rows[0].Field <string>("Email"); } }