private void btnUpdate_Click(object sender, EventArgs e) { ep.Clear(); if (cmbCategoryList.SelectedIndex == 0) { ep.SetError(cmbCategoryList, "Please Select Category Name"); cmbCategoryList.Focus(); return; } if (txtGeneralName.Text.Trim().Length == 0) { ep.SetError(txtGeneralName, "Please Enter General Name"); txtGeneralName.Focus(); txtGeneralName.SelectAll(); return; } if (txtUserFOr.Text.Trim().Length == 0) { ep.SetError(txtUserFOr, "Please Enter Using Detail of Product"); txtUserFOr.Focus(); txtUserFOr.SelectAll(); return; } string sql = string.Format(@"UPDATE General SET categoryID = '{0}', gen_Name='{1}', usefor='{2}', description='{3}' WHERE gen_ID = '{4}'", CommonCodeClass.GetCategoryID(cmbCategoryList.Text.Trim()), txtGeneralName.Text, txtUserFOr.Text, txtDescription.Text, updateGeneralID); DataAccessLayer.Execute(sql); MessageBox.Show("General Product Successfully Updated..."); btnCancel_Click(sender, e); }
private void btnSave_Click(object sender, EventArgs e) { ep.Clear(); if (cmbCategoryList.SelectedIndex == 0) { ep.SetError(cmbCategoryList, "Please Select Category Name"); cmbCategoryList.Focus(); return; } if (txtGeneralName.Text.Trim().Length == 0) { ep.SetError(txtGeneralName, "Please Enter General Name"); txtGeneralName.Focus(); txtGeneralName.SelectAll(); return; } if (txtUserFOr.Text.Trim().Length == 0) { ep.SetError(txtUserFOr, "Please Enter Using Detail of Product"); txtUserFOr.Focus(); txtUserFOr.SelectAll(); return; } string sql = string.Format(@"INSERT INTO General (categoryID, gen_Name, usefor, description) VALUES ('{0}', '{1}', '{2}', '{3}')", CommonCodeClass.GetCategoryID(cmbCategoryList.Text.Trim()), txtGeneralName.Text, txtUserFOr.Text, txtDescription.Text); DataAccessLayer.Execute(sql); MessageBox.Show("General Product Successfully Added..."); FillGrid(""); ClearForm(); }