private List <int> CreateCompoundIDList() { List <int> lstCompoundsOnReagentID = new List <int>(); DB_Operator dbo = new DB_Operator(); DataTable dt3 = dbo.GetTable("Compound_Data"); List <int> lstCompoundCodes = new List <int>(); List <string> lstCompoundNames = new List <string>(); for (int i = 0; i < dt3.Rows.Count; i++) { lstCompoundCodes.Add(Convert.ToInt32(dt3.Rows[i].ItemArray[0])); lstCompoundNames.Add(Convert.ToString(dt3.Rows[i].ItemArray[1])); } for (int i = 0; i < lstCompoundsOnReagent.Count; i++) { if (lstCompoundsOnReagent[i].Trim() == "") { lstCompoundsOnReagentID.Add(0000); } else { int index = lstCompoundNames.IndexOf(lstCompoundsOnReagent[i]); lstCompoundsOnReagentID.Add(lstCompoundCodes[index]); } } return(lstCompoundsOnReagentID); }
private void InsertData() { DB_Operator dbo = new DB_Operator(); List <int> lstCompoundsOnReagentID = CreateCompoundIDList(); dbo.InsertChemicalCompound(nameOftheChemicalCompound, lstColumnCodes, lstCompoundsOnReagentID, state, colorCode, ColorName, odor); }
private void btnRemoveOperation_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("Are you sure to remove the selected operation from the database?", "", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { int index = lstBoxOperations.SelectedIndex; DB_Operator dbo = new DB_Operator(); dbo.RemoveReagentOrOperation("Operation_Data", "Operation_Code", lstOperationCodes[index]); lstBoxOperations.Items.RemoveAt(index); lstOperationCodes.RemoveAt(index); } }
private void LoadControls() { DB_Operator dbo = new DB_Operator(); DataTable dt1 = dbo.GetTable("Reagent_Data"); DataTable dt2 = dbo.GetTable("Operation_Data"); DataTable dt3 = dbo.GetTable("Compound_Data"); foreach (DataRow dr in dt1.Rows) { lstColumnCodes.Add(dr.ItemArray[1] as string); lstColumnNames.Add(dr.ItemArray[2] as string); } foreach (DataRow dr in dt2.Rows) { lstColumnCodes.Add(dr.ItemArray[1] as string); lstColumnNames.Add(dr.ItemArray[2] as string); } Point lblPosition = new Point(40, 63); Point txtBoxPosition = new Point(237, 60); for (int i = 0; i < lstColumnCodes.Count; i++) { Label lblReagent = new Label(); lblReagent.Size = new System.Drawing.Size(194, 15); lblReagent.Name = "lblReagent_" + i.ToString(); lblReagent.Location = lblPosition; this.pnlChemicalCompound.Controls.Add(lblReagent); lblReagent.Text = lstColumnNames[i]; ComboBox cmbBoxCompound = new ComboBox(); cmbBoxCompound.Name = i.ToString(); cmbBoxCompound.Location = txtBoxPosition; this.pnlChemicalCompound.Controls.Add(cmbBoxCompound); for (int j = 0; j < dt3.Rows.Count; j++) { cmbBoxCompound.Items.Add(dt3.Rows[j].ItemArray[1]); } lblPosition.Y += 37; txtBoxPosition.Y += 37; } }
private void PerformFileOperation() { //Get the path of the application folder.. //string currentPath = Directory.GetCurrentDirectory(); ////define a path to create a new directory "temp"... string currentPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "University of Colombo\\Analytica Lab\\"); string filePath = Path.Combine(currentPath, "temp"); //if the temp folder already exists, delete it.. if (Directory.Exists(filePath)) { Directory.Delete(filePath, true); } //create temp directory.. Directory.CreateDirectory(filePath); //copy restoring datafiles into application folder.. File.Copy(txtBoxMdfLocation.Text, filePath + "\\Analytica_Lab.mdf"); File.Copy(txtBoxLdfLocation.Text, filePath + "\\Analytica_Lab_log.ldf"); //check whether the new database is compatible.. if not, delete new data files and rollback process.. bool isDatabaseCompatible = true; using (DB_Operator dbo = new DB_Operator()) { isDatabaseCompatible = dbo.TestDataBase(); } if (isDatabaseCompatible == true) { File.Delete(currentPath + "\\Analytica_Lab.mdf"); File.Delete(currentPath + "\\Analytica_Lab_log.ldf"); File.Copy(txtBoxMdfLocation.Text, currentPath + "\\Analytica_Lab.mdf"); File.Copy(txtBoxLdfLocation.Text, currentPath + "\\Analytica_Lab_log.ldf"); } }
private void ValidateInput() { if (this.txtBoxOperationName.Text.Trim() == null) { throw new Exception("Please insert a proper reagent name...!"); } else { if (isNewOperation == true) { bool isExisting = false; string operationCode = ""; do { operationCode = frmReagentWizard.GenerateCode(6); foreach (string s in lstOperationCodes) { if (s.Trim() == operationCode.Trim()) { isExisting = true; break; } } }while (isExisting == true); DB_Operator dbo = new DB_Operator(); dbo.InsertReagentOrOperation("Operation_Data", "Operation_Code", "Operation_Name", "Image_Link", "Op_" + operationCode, txtBoxOperationName.Text, "operation.png"); txtBoxOperationName.Clear(); grpBoxAddOperation.Hide(); this.Size = new Size(392, 300); } else { int index = lstBoxOperations.SelectedIndex; DB_Operator dbo = new DB_Operator(); dbo.UpdateReagentOrOperation("Operation_Data", "Operation_Code", "Operation_Name", lstOperationCodes[index], txtBoxOperationName.Text); txtBoxOperationName.Clear(); grpBoxAddOperation.Hide(); this.Size = new Size(392, 300); } } }
private void LoadOperationData() { if (lstBoxOperations.Items.Count != 0) { lstBoxOperations.Items.Clear(); lstOperationCodes.Clear(); lstImageLinks.Clear(); } lstBoxOperations.Refresh(); DB_Operator dbo = new DB_Operator(); DataTable dt = dbo.GetTable("Operation_Data"); for (int i = 0; i < dt.Rows.Count; i++) { lstBoxOperations.Items.Add(dt.Rows[i].ItemArray[2] as string); lstOperationCodes.Add(dt.Rows[i].ItemArray[1] as string); lstImageLinks.Add(dt.Rows[i].ItemArray[3] as string); } lstBoxOperations.Refresh(); }