private void FillGrid(string value)
{
dgvGeneralList.Rows.Clear();
DataTable dt = new DataTable();
string sql = "";
if (value == "")
{
sql = "SELECT * FROM General";
}
else
{
sql = string.Format(@"SELECT * FROM General WHERE gen_Name LIKE '%{0}%' ", value);
}
dt = DataAccessLayer.Retreiving(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
DataGridViewRow addRow = new DataGridViewRow();
addRow.CreateCells(dgvGeneralList);
addRow.Cells[0].Value = row[0].ToString();
addRow.Cells[1].Value = row[2].ToString();
addRow.Cells[2].Value = CommonCodeClass.GetCategoryName(row[1].ToString());
addRow.Cells[3].Value = row[3].ToString();
addRow.Cells[4].Value = row[4].ToString();
dgvGeneralList.Rows.Add(addRow);
}
}
}
private void FillCmbCategoryList()
{
cmbCategoryList.Items.Clear();
cmbCategoryList.Items.Add("Select Category");
if (CommonCodeClass.GetAllCategory().Rows.Count > 0)
{
foreach (DataRow item in CommonCodeClass.GetAllCategory().Rows)
{
cmbCategoryList.Items.Add(item[0]);
}
}
cmbCategoryList.SelectedIndex = 0;
}
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();
}
