private void btnSave_Click(object sender, EventArgs e)
{
#region [- Trim -]
txtCategoryName.Text = txtCategoryName.Text.Trim();
txtDescriptions.Text = txtDescriptions.Text.Trim();
#endregion
if (txtCategoryName.Text == "")
{
MessageBox.Show("Category Name Can Not Be Empty");
txtCategoryName.Focus();
}
else
{
Ref_Categories_Insert.Clear();
Ref_Category_Insert.CategoryName = txtCategoryName.Text;
Ref_Category_Insert.Descriptions = txtDescriptions.Text;
Ref_Categories_Insert.Add(Ref_Category_Insert);
Ref_CategoryViewModel.Save(Ref_Categories_Insert);
if (Init_Database_Exception() != 0)
{
Init_Database_SP_Message();
txtCategoryName.Text = "";
txtDescriptions.Text = "";
txtCategoryName.Focus();
dgvCategory.DataSource = Ref_CategoryViewModel.FillGrid();
Init_Database_Exception();
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
#region [- Trim -]
txtCategoryName.Text = txtCategoryName.Text.Trim();
txtDescriptions.Text = txtDescriptions.Text.Trim();
#endregion
Ref_Categories_Select.Clear();
Ref_Category_Select.CategoryName = txtCategoryName.Text;
Ref_Category_Select.Descriptions = txtDescriptions.Text;
Ref_Categories_Select.Add(Ref_Category_Select);
dgvCategory.DataSource = Ref_CategoryViewModel.Select(Ref_Categories_Select);
if (Init_Database_Exception() != 0)
{
if (dgvCategory.RowCount == 0)
{
MessageBox.Show("The Category List is Empty.");
}
txtCategoryName.Focus();
}
else
{
txtCategoryName.Focus();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
#region [- Trim -]
txtCategoryId.Text = txtCategoryId.Text.Trim();
txtCategoryName.Text = txtCategoryName.Text.Trim();
txtDescriptions.Text = txtDescriptions.Text.Trim();
#endregion
if (txtCategoryName.Text == "")
{
MessageBox.Show("Category Name Can Not Be Empty");
txtCategoryName.Focus();
}
else
{
Ref_Categories_Edit.Clear();
Ref_Category_Edit.CategoryId = System.Convert.ToInt32(txtCategoryId.Text);
Ref_Category_Edit.CategoryName = txtCategoryName.Text;
Ref_Category_Edit.Descriptions = txtDescriptions.Text;
Ref_Categories_Edit.Add(Ref_Category_Edit);
Ref_CategoryViewModel.Edit(Ref_Categories_Edit);
if (Init_Database_Exception() != 0)
{
Init_Database_SP_Message();
this.Close();
}
}
}
private void Category_Crud_Activated(object sender, EventArgs e)
{
if (dgvCategory.RowCount != 0)
{
dgvCategory.DataSource = Ref_CategoryViewModel.FillGrid();
//if (Model.Helper.ModelHelper.DatabaseExceptionHandeler() != null)
//{
// MessageBox.Show(Model.Helper.ModelHelper.DatabaseExceptionHandeler());
// Model.Helper.ModelHelper.DatabaseExceptionCleaner();
//}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvCategory.RowCount == 0)
{
MessageBox.Show("The Category List is Empty.");
txtCategoryName.Focus();
}
else
{
if (dgvCategory.SelectedRows.Count == 0)
{
MessageBox.Show("Please Selcet a Row.");
txtCategoryName.Focus();
}
else
{
Int32 selectedRowCount = dgvCategory.SelectedRows.Count;
Ref_Categories_Delete.Clear();
for (int i = 0; i < selectedRowCount; i++)
{
Ref_Category_Delete = new Model.Helper.SPHelper.Category.SpHelper_Category_Delete();
Ref_Category_Delete.CategoryId = (int)dgvCategory.SelectedRows[i].Cells[0].Value;
Ref_Categories_Delete.Add(Ref_Category_Delete);
}
Ref_CategoryViewModel.Delete(Ref_Categories_Delete);
if (Init_Database_Exception() != 0)
{
Init_Database_SP_Message();
dgvCategory.DataSource = Ref_CategoryViewModel.FillGrid();
Init_Database_Exception();
if (dgvCategory.RowCount == 0)
{
MessageBox.Show("The Category List is Empty.");
}
txtCategoryName.Focus();
}
else
{
txtCategoryName.Focus();
}
}
}
}
