private void addIngBnt_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(ingredientName.Text) || string.IsNullOrEmpty(ingredientCost.Text)) { throw new MissingValueException(); } else if (ingredientCdH.Value == decimal.Zero && ingredientCdM.Value == decimal.Zero && ingredientCdS.Value == decimal.Zero) { throw new MissingValueException(); } else { int intValue = 0; if (!int.TryParse(ingredientCost.Text, out intValue) || !int.TryParse(ingredientCdH.Value.ToString(), out intValue) || !int.TryParse(ingredientCdM.Value.ToString(), out intValue) || !int.TryParse(ingredientCdS.Value.ToString(), out intValue)) { throw new InvalidValueException(); } else { dblib db = new dblib(); db.addNewIngredient(ingredientName.Text, ingredientCost.Text, ingredientCdH.Value.ToString(), ingredientCdM.Value.ToString(), ingredientCdS.Value.ToString()); MessageBox.Show("New ingredient added"); this.DialogResult = DialogResult.OK; } } } catch (MissingValueException) { MessageBox.Show("Missing value(s)"); } catch (InvalidValueException) { MessageBox.Show("Invalidate value(s)"); } catch (SqlException) { } }
private void loadScriptBnt_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(cookwareScriptPath.Text)) { using (StreamReader file = new StreamReader(cookwareScriptPath.Text)) { string line; while ((line = file.ReadLine()) != null) { dblib db = new dblib(); db.addNewCookware(line.Trim()); } } MessageBox.Show("Cookware script loaded"); } if (!string.IsNullOrEmpty(ingredientScriptPath.Text)) { using (StreamReader file = new StreamReader(ingredientScriptPath.Text)) { string line; while ((line = file.ReadLine()) != null) { string[] separator = { ", " }; string[] values = line.Split(separator, StringSplitOptions.None); string[] times = values[2].Split(':'); dblib db = new dblib(); db.addNewIngredient(values[0].Trim(), values[1].Trim(), times[0].Trim(), times[1].Trim(), times[2].Trim()); } } MessageBox.Show("Ingredient script loaded"); } if (!string.IsNullOrEmpty(recipeScriptPath.Text)) { using (StreamReader file = new StreamReader(recipeScriptPath.Text)) { string line; while ((line = file.ReadLine()) != null) { string[] separator = { ", " }; string[] values = line.Split(separator, StringSplitOptions.None); string[] times = values[3].Split(':'); dblib db = new dblib(); string cookwareId = db.findCookwareId(values[4]); List <string> ingIds = new List <string>(); List <string> ingAmounts = new List <string>(); for (int i = 5; i < values.Length; i++) { ingIds.Add(db.findIngredientId(values[i])); i++; ingAmounts.Add(values[i]); } string[] ingredientNames = ingIds.ToArray(); string[] ingredientAmounts = ingAmounts.ToArray(); db.addNewRecipe(values[0].Trim(), values[1].Trim(), values[2].Trim(), times[0].Trim(), times[1].Trim(), times[2].Trim(), cookwareId, ingredientNames, ingredientAmounts); } } MessageBox.Show("Recipe script loaded"); } this.DialogResult = DialogResult.OK; } catch (SqlException) { } catch (FileNotFoundException) { MessageBox.Show("Cannot find the script file"); } }