public bool AddNewCategory(CategoryManager newCategory)
{
SqlParameter[] sp = new SqlParameter[5];
sp[0] = new SqlParameter("@CategoryName", newCategory.CategoryName);
sp[1] = new SqlParameter("@CategoryDescription", newCategory.CategoryDescription);
sp[2] = new SqlParameter("@CategoryTypeID", newCategory.CategoryTypeID);
sp[3] = new SqlParameter("@CategoryType", newCategory.CategoryType);
sp[4] = new SqlParameter("@IsDeleted", false);
return datalayer.Execute_NonQuery("sp_AddCaegory", CommandType.StoredProcedure, sp);
}
public void bindCategory()
{
CategoryManager cs = new CategoryManager();
DataSet ds = cs.listAllCategory();
if (ds.Tables[0].Rows.Count > 0)
{
CategoryGrid.AutoGenerateColumns = false;
CategoryGrid.DataSource = null;
//Set Columns Count
CategoryGrid.ColumnCount = 4;
//Add Columns
CategoryGrid.Columns[0].Name = "Id";
CategoryGrid.Columns[0].HeaderText = "Id";
CategoryGrid.Columns[0].DataPropertyName = "CategoryID";
CategoryGrid.Columns[1].HeaderText = "Category Name";
CategoryGrid.Columns[1].Name = "CategoryName";
CategoryGrid.Columns[1].DataPropertyName = "CategoryName";
CategoryGrid.Columns[2].Name = "Description";
CategoryGrid.Columns[2].HeaderText = "Category Description";
CategoryGrid.Columns[2].DataPropertyName = "CategoryDesc";
CategoryGrid.Columns[3].Name = "CategoryType";
CategoryGrid.Columns[3].HeaderText = "Category Type";
CategoryGrid.Columns[3].DataPropertyName = "CategoryType";
CategoryGrid.DataSource = ds.Tables[0];
//Buttons
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
CategoryGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
CategoryGrid.Columns.Add(Deletelink);
//DataGridViewButtonColumn db = new DataGridViewButtonColumn();
//db.Text = "Delete";
//CategoryGrid.Columns.Insert(4, (DataGridViewColumn)db);
}
}
public void bindExpenseCateGory()
{
CategoryManager cs = new CategoryManager();
DataSet ds = cs.listAllCategory(1);
if (ds.Tables[0].Rows.Count > 0)
{
drpCategoryList.DisplayMember = "CategoryName";
drpCategoryList.ValueMember = "CategoryID";
drpCategoryList.DataSource = ds.Tables[0];
}
else
{
//drpLocation.Items.Add()
}
}
private void btnAddNewExpenseCategory_Click(object sender, EventArgs e)
{
string categoryName = txtExpenseCategoryName.Text;
string categoryDesc = txtExpenseCategoryDescription.Text;
int catTypeID = drpCategoryType.SelectedIndex;
string catType = drpCategoryType.SelectedItem.ToString();
CategoryManager cs = new CategoryManager(categoryName, categoryDesc, catTypeID, catType);
bool res = cs.AddNewCategory(cs);
if (res)
{
MessageBox.Show("Record Inserted Succesfully.!");
bindCategory();
pnlExpenseCategoryGrid.Visible = true;
pnlExpenseCategoryForm.Visible = false;
}
else
{
MessageBox.Show("Error.!");
}
}
private void CategoryGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int category_id = 0;
if (e.ColumnIndex == 4)
{
txtExpenseCategoryName.Text = CategoryGrid.Rows[e.RowIndex].Cells["CategoryName"].Value.ToString();
txtExpenseCategoryDescription.Text = CategoryGrid.Rows[e.RowIndex].Cells["Description"].Value.ToString();
lblExpenseID.Text = CategoryGrid.Rows[e.RowIndex].Cells["Id"].Value.ToString();
if (CategoryGrid.Rows[e.RowIndex].Cells["CategoryType"].Value.ToString() == "Expense")
{
drpCategoryType.SelectedIndex = 1;
}
else if (CategoryGrid.Rows[e.RowIndex].Cells["CategoryType"].Value.ToString() == "Income")
{
drpCategoryType.SelectedIndex= 2;
}
pnlExpenseCategoryForm.Visible = true;
pnlExpenseCategoryGrid.Visible = false;
btnPnlExpenseCategory.Visible = false;
btnUpdate.Visible = true;
btnCancel.Visible = true;
}
if (e.ColumnIndex == 5)
{
category_id = Convert.ToInt32(CategoryGrid.Rows[e.RowIndex].Cells["Id"].Value);
CategoryManager cat_manager = new CategoryManager();
cat_manager.DeleteCategory(category_id);
bindCategory();
pnlExpenseCategoryForm.Visible = false;
pnlExpenseCategoryGrid.Visible = true;
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int category_id = Convert.ToInt32(lblExpenseID.Text);
string categoryName = txtExpenseCategoryName.Text;
string categoryDesc = txtExpenseCategoryDescription.Text;
int catTypeID = drpCategoryType.SelectedIndex;
string catType = drpCategoryType.SelectedItem.ToString();
CategoryManager cm = new CategoryManager(category_id,categoryName,categoryDesc,catTypeID,catType);
if (!string.IsNullOrEmpty(categoryName))
{
try
{
cm.UpdateCategoryWithType(cm);
MessageBox.Show("Category Updated Succesfully.!");
bindCategory();
pnlExpenseCategoryGrid.Visible = true;
pnlExpenseCategoryForm.Visible = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Enter Category Name");
}
}
public void UpdateCategoryWithType(CategoryManager category)
{
SqlParameter[] sp = new SqlParameter[5];
sp[0] = new SqlParameter("@CategoryID", category.CategoryID);
sp[1] = new SqlParameter("@CategoryName", category.CategoryName);
sp[2] = new SqlParameter("@CategoryDescription", category.CategoryDescription);
sp[3] = new SqlParameter("@CategoryTypeID", category.CategoryTypeID);
sp[4] = new SqlParameter("@CategoryType", category.CategoryType);
datalayer.Execute_NonQuery("sp_UpdateCategoryWithCategoryType", CommandType.StoredProcedure, sp);
}
