public void editIngredient() { AuntRosieEntities.Ingredient updateIngredient = new AuntRosieEntities.Ingredient(); updateIngredient.Name = txtNewIngredintName.Text; updateIngredient.StoringNote = txtstoringNote.Text; updateIngredient.Unit = cmbUnit.Text.Trim(); AuntRosieApplication.Classes.ListItem itm2 = new AuntRosieApplication.Classes.ListItem(); object obj2 = cmbName.Items[cmbName.SelectedIndex]; itm2 = (AuntRosieApplication.Classes.ListItem)obj2; updateIngredient.Id = (long)Convert.ToDouble(itm2.id); try { DBConnector conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; updateIngredient.Update(); MessageBox.Show("The Ingredient has been updated successfully", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message); // MessageBox.Show("Sorry! An internal error has happened", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnNewIngredintSave_Click(object sender, EventArgs e) { Ingredient newIngredient = new Ingredient(); if (IsValidIngredent()) { newIngredient.Name = txtNewIngredintName.Text.Trim(); newIngredient.Unit = cmbUnit.Text.Trim(); newIngredient.IngredientTypeId = (short)Convert.ToDouble(DBMethod.GetSelectedItemID(cmbNewtype)); newIngredient.StoringNote = txtstoringNote.Text; newIngredient.Unit = cmbUnit.Text.Trim(); DBConnector conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; newIngredient.Create(); pnlNewIngredint.Visible = false; pnlMain.Enabled = true; cmbType.Items.Clear(); Classes.DBMethod.FillCombBox(AuntRosieEntities.IngredientType.GetAllIngredintType (Classes.DBMethod.GetConnectionString()), cmbType); AuntRosieApplication.Classes.ListItem itm = new AuntRosieApplication.Classes.ListItem(); Object obj = cmbType.Items[cmbNewtype.SelectedIndex]; itm = (Classes.ListItem)obj; cmbType.SelectedItem = itm; cmbName.SelectedItem = cmbName.Items[cmbName.Items.Count - 1]; } }
private void newSupplier() { AuntRosieEntities.Supplier insertSupplier = new AuntRosieEntities.Supplier(); insertSupplier.Name = txtName.Text.Trim(); insertSupplier.ContactFirstName = txtSupplierFirstName.Text.Trim(); insertSupplier.ContactLasttName = txtSupplierLastName.Text.Trim(); insertSupplier.Phone = txtPhone.Text.Trim(); insertSupplier.Email = txtEmail.Text.Trim(); insertSupplier.City = txtCity.Text.Trim(); AuntRosieApplication.Classes.ListItem itm = new AuntRosieApplication.Classes.ListItem(); Object obj = cmbProvinces.Items[cmbProvinces.SelectedIndex]; itm = (AuntRosieApplication.Classes.ListItem)obj; insertSupplier.Province = itm.id; insertSupplier.Street = txtStreet.Text.Trim(); insertSupplier.PostalCode = txtPostalCode.Text.Trim(); try { DBConnector conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; insertSupplier.Create(); MessageBox.Show("The new supplier has been inserted successfully", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { //MessageBox.Show(ex.Message); MessageBox.Show("Sorry! An internal error has happened", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void FillCombBoxEvent(DataTable dt, ComboBox cmb) { if (dt != null) { foreach (DataRow row in dt.Rows) { AuntRosieApplication.Classes.ListItem itm = new AuntRosieApplication.Classes.ListItem(); itm.name = row[1].ToString() + "--ON " + DateTime.Parse(row[2].ToString()).ToLongDateString(); itm.id = row[0].ToString(); cmb.Items.Add((Object)itm); } } }
private void GetPaymentDate() { SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString()); // Create new SQL command SqlCommand command = new SqlCommand("SELECT DISTINCT PaymentDate AS Expr1 FROM [tblFullTimePayroll]", dbConnection); SqlDataAdapter adapter = new SqlDataAdapter(command); // Declare a DataTable object that will hold the return value DataTable dt = new DataTable(); // Try to connect to the database, and use the adapter to fill the table try { dbConnection.Open(); adapter.Fill(dt); if (dt.Rows.Count == 0) { MessageBox.Show("No previous payroll are registered", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); radNew.Checked = true; radExists.Checked = false; } else { cmbPaymentDate.Enabled = true; cmbPaymentDate.Focus(); } if (dt != null) { foreach (DataRow row in dt.Rows) { DateTime date = DateTime.Parse(row[0].ToString()); AuntRosieApplication.Classes.ListItem itm = new AuntRosieApplication.Classes.ListItem(); itm.name = date.Date.ToShortDateString(); itm.id = date.Date.ToShortDateString(); cmbPaymentDate.Items.Add((Object)itm); } } } catch (Exception ex) { } finally { dbConnection.Close(); } }
private void editEmployee() { AuntRosieEntities.Employee updateEmployee = new AuntRosieEntities.Employee(); updateEmployee.FirstName = txtFirstName.Text.Trim(); updateEmployee.LastName = txtLastName.Text.Trim(); updateEmployee.Phone = txtPhone.Text.Trim(); updateEmployee.Email = txtEmail.Text.Trim(); updateEmployee.City = txtCity.Text.Trim(); AuntRosieApplication.Classes.ListItem itm = new AuntRosieApplication.Classes.ListItem(); Object obj = cmbProvinces.Items[cmbProvinces.SelectedIndex]; itm = (AuntRosieApplication.Classes.ListItem)obj; updateEmployee.Province = itm.id; updateEmployee.Street = txtStreet.Text.Trim(); updateEmployee.PostalCode = txtPostalCode.Text.Trim(); AuntRosieApplication.Classes.ListItem itm2 = new AuntRosieApplication.Classes.ListItem(); object obj2 = cmbName.Items[cmbName.SelectedIndex]; itm2 = (AuntRosieApplication.Classes.ListItem)obj2; updateEmployee.Id = (long)Convert.ToDouble(itm2.id); if (EmpType == "F") { updateEmployee.Salary = Convert.ToDouble(txtsalary.Text.Trim()); updateEmployee.EmploymentDate = dtpEmploymentDate.Value.Date; } try { DBConnector conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; updateEmployee.Update(); MessageBox.Show("The Employee has been updated successfully", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message); //MessageBox.Show("Sorry! An internal error has happened", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmbSupplierName_SelectedIndexChanged(object sender, EventArgs e) { DBConnector conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; Supplier supplier = Supplier.Retrieve(DBMethod.GetSelectedItemID(cmbSupplierName)); txtName.Text = supplier.Name; txtSupplierFirstName.Text = supplier.ContactFirstName; txtSupplierLastName.Text = supplier.ContactLasttName; txtPhone.Text = supplier.Phone; txtEmail.Text = supplier.Email; txtCity.Text = supplier.City; AuntRosieApplication.Classes.ListItem itm2 = new AuntRosieApplication.Classes.ListItem(); itm2.id = supplier.Province; itm2.name = Classes.DBMethod.GetProvinceName(itm2.id); cmbProvinces.SelectedItem = itm2; cmbProvinces.Text = Classes.DBMethod.GetProvinceName(itm2.id); txtStreet.Text = supplier.Street; txtPostalCode.Text = supplier.PostalCode; }
private void cmbName_SelectedIndexChanged(object sender, EventArgs e) { try { DBConnector conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; Employee employee = Employee.Retrieve(DBMethod.GetSelectedItemID(cmbName)); txtFirstName.Text = employee.FirstName; txtLastName.Text = employee.LastName; txtPhone.Text = employee.Phone; txtEmail.Text = employee.Email; txtCity.Text = employee.City; AuntRosieApplication.Classes.ListItem itm2 = new AuntRosieApplication.Classes.ListItem(); itm2.id = employee.Province; itm2.name = Classes.DBMethod.GetProvinceName(itm2.id); cmbProvinces.SelectedItem = itm2; cmbProvinces.Text = Classes.DBMethod.GetProvinceName(itm2.id); txtStreet.Text = employee.Street; txtPostalCode.Text = employee.PostalCode; if (employee.Type == "F") { radFullTime.Checked = true; txtsalary.Text = employee.Salary.ToString(); dtpEmploymentDate.Value = employee.EmploymentDate.Date; } else { txtsalary.Text = ""; dtpEmploymentDate.Value = DateTime.Today.Date; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
public void deleteIngredient() { Ingredient deleteIngredient = new Ingredient(); AuntRosieApplication.Classes.ListItem itm2 = new AuntRosieApplication.Classes.ListItem(); object obj2 = cmbName.Items[cmbName.SelectedIndex]; itm2 = (AuntRosieApplication.Classes.ListItem)obj2; deleteIngredient.Id = (long)Convert.ToDouble(itm2.id); try { DBConnector conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; deleteIngredient.Delete(); MessageBox.Show("The Ingredient has been deleted successfully", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show("This ingredients could not be deleted", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }