private void ExpenseGrid_CellContentClick(object sender, DataGridViewCellEventArgs e) { int TransactionID = 0; if (e.ColumnIndex == 8) { drpClientList.SelectedValue = Convert.ToInt32(ExpenseGrid.Rows[e.RowIndex].Cells["ClientID"].Value.ToString()); drpLocationList.SelectedValue = Convert.ToInt32(ExpenseGrid.Rows[e.RowIndex].Cells["LocationID"].Value.ToString()); drpCategoryList.SelectedValue = Convert.ToInt32(ExpenseGrid.Rows[e.RowIndex].Cells["CategoryID"].Value.ToString()); lblTransactionID.Text = ExpenseGrid.Rows[e.RowIndex].Cells["TransactionID"].Value.ToString(); txtPayTo.Text = ExpenseGrid.Rows[e.RowIndex].Cells["PayTo"].Value.ToString(); txtAmount.Text = ExpenseGrid.Rows[e.RowIndex].Cells["Amount"].Value.ToString(); txtNote.Text = ExpenseGrid.Rows[e.RowIndex].Cells["Note"].Value.ToString(); dateTime.Text = ExpenseGrid.Rows[e.RowIndex].Cells["Date"].Value.ToString(); pnlExpenseForm.Visible = true; pnlExpenseGrid.Visible = false; btnSaveExpenseDetail.Visible = false; btnUpdate.Visible = true; } if (e.ColumnIndex == 9) { TransactionID = Convert.ToInt32(ExpenseGrid.Rows[e.RowIndex].Cells["TransactionID"].Value); ExpenseDetailManager cm = new ExpenseDetailManager(); cm.DeleteExpense(TransactionID); bindExpenseGrid(); pnlExpenseForm.Visible = false; pnlExpenseGrid.Visible = true; } }
private void btnSaveExpenseDetail_Click(object sender, EventArgs e) { ExpenseDetailManager newExpense = new ExpenseDetailManager(); newExpense.LocationID = Convert.ToInt32(drpLocationList.SelectedValue); newExpense.ClientID = Convert.ToInt32(drpClientList.SelectedValue); newExpense.CategoryID = Convert.ToInt32(drpCategoryList.SelectedValue); newExpense.PayTo = txtPayTo.Text; newExpense.Amount = Convert.ToInt32(txtAmount.Text); newExpense.Date = Convert.ToDateTime(dateTime.Text); newExpense.Note = txtNote.Text; bool restult = newExpense.AddExpense(newExpense); if (restult) { MessageBox.Show("Record Inserted Succesfully.!"); bindExpenseGrid(); pnlExpenseGrid.Visible = true; pnlExpenseForm.Visible = false; } else { MessageBox.Show("Error.!"); } }
public bool UpdateExpense(ExpenseDetailManager expense) { SqlParameter[] sp = new SqlParameter[7]; sp[0] = new SqlParameter("@TransactionID", expense.TransactionID); sp[1] = new SqlParameter("@ClientID", expense.ClientID); sp[2] = new SqlParameter("@CategoryID", expense.CategoryID); sp[3] = new SqlParameter("@payTo", expense.PayTo); sp[4] = new SqlParameter("@Date", expense.Date); sp[5] = new SqlParameter("@Amount", expense.Amount); sp[6] = new SqlParameter("@Note", expense.Note); return(datalayer.Execute_NonQuery("sp_UpdateExpense", CommandType.StoredProcedure, sp)); }
public bool AddExpense(ExpenseDetailManager newExpense) { SqlParameter[] sp = new SqlParameter[8]; sp[0] = new SqlParameter("@LocationID", newExpense.LocationID); sp[1] = new SqlParameter("@ClientID", newExpense.ClientID); sp[2] = new SqlParameter("@CategoryID", newExpense.CategoryID); sp[3] = new SqlParameter("@payTo", newExpense.PayTo); sp[4] = new SqlParameter("@Date", newExpense.Date); sp[5] = new SqlParameter("@Amount", newExpense.Amount); sp[6] = new SqlParameter("@Note", newExpense.Note); sp[7] = new SqlParameter("@IsDeleted", false); return(datalayer.Execute_NonQuery("sp_AddExpense", CommandType.StoredProcedure, sp)); }
public bool AddExpense(ExpenseDetailManager newExpense) { SqlParameter[] sp = new SqlParameter[8]; sp[0] = new SqlParameter("@LocationID", newExpense.LocationID); sp[1] = new SqlParameter("@ClientID", newExpense.ClientID); sp[2] = new SqlParameter("@CategoryID", newExpense.CategoryID); sp[3] = new SqlParameter("@payTo", newExpense.PayTo); sp[4] = new SqlParameter("@Date", newExpense.Date); sp[5] = new SqlParameter("@Amount", newExpense.Amount); sp[6] = new SqlParameter("@Note", newExpense.Note); sp[7] = new SqlParameter("@IsDeleted", false); return datalayer.Execute_NonQuery("sp_AddExpense", CommandType.StoredProcedure, sp); }
public void bindExpenseGrid() { ExpenseDetailManager cl = new ExpenseDetailManager(); DataSet ds = cl.ListExpenseDetails(); if (ds.Tables[0].Rows.Count > 0) { ExpenseGrid.AutoGenerateColumns = false; ExpenseGrid.DataSource = null; //Set Columns Count ExpenseGrid.ColumnCount = 8; //Add Columns ExpenseGrid.Columns[0].Name = "TransactionID"; ExpenseGrid.Columns[0].HeaderText = "Transaction ID"; ExpenseGrid.Columns[0].DataPropertyName = "TransactionID"; ExpenseGrid.Columns[1].HeaderText = "Location ID"; ExpenseGrid.Columns[1].Name = "LocationID"; ExpenseGrid.Columns[1].DataPropertyName = "LocationID"; ExpenseGrid.Columns[2].Name = "ClientID"; ExpenseGrid.Columns[2].HeaderText = "Client ID"; ExpenseGrid.Columns[2].DataPropertyName = "ClientID"; ExpenseGrid.Columns[3].Name = "CategoryID"; ExpenseGrid.Columns[3].HeaderText = "Category ID"; ExpenseGrid.Columns[3].DataPropertyName = "CategoryID"; ExpenseGrid.Columns[4].Name = "PayTo"; ExpenseGrid.Columns[4].HeaderText = "Pay To"; ExpenseGrid.Columns[4].DataPropertyName = "PayTo"; ExpenseGrid.Columns[5].Name = "Date"; ExpenseGrid.Columns[5].HeaderText = "Date"; ExpenseGrid.Columns[5].DataPropertyName = "Date"; ExpenseGrid.Columns[6].Name = "Amount"; ExpenseGrid.Columns[6].HeaderText = "Amount"; ExpenseGrid.Columns[6].DataPropertyName = "Amount"; ExpenseGrid.Columns[7].Name = "Note"; ExpenseGrid.Columns[7].HeaderText = "Note"; ExpenseGrid.Columns[7].DataPropertyName = "Note"; ExpenseGrid.DataSource = ds.Tables[0]; DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn(); Editlink.UseColumnTextForLinkValue = true; Editlink.HeaderText = "Edit"; Editlink.DataPropertyName = "lnkForEditColumn"; Editlink.LinkBehavior = LinkBehavior.SystemDefault; Editlink.Text = "Edit"; ExpenseGrid.Columns.Add(Editlink); DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn(); Deletelink.UseColumnTextForLinkValue = true; Deletelink.HeaderText = "delete"; Deletelink.DataPropertyName = "lnkForDeleteColumn"; Deletelink.LinkBehavior = LinkBehavior.SystemDefault; Deletelink.Text = "Delete"; ExpenseGrid.Columns.Add(Deletelink); //DataGridViewButtonColumn db = new DataGridViewButtonColumn(); //db.Text = "Delete"; //ExpenseGrid.Columns.Insert(8, (DataGridViewColumn)db); } }
private void btnUpdate_Click(object sender, EventArgs e) { ExpenseDetailManager newExpense = new ExpenseDetailManager(); newExpense.TransactionID = Convert.ToInt32(lblTransactionID.Text); newExpense.LocationID = Convert.ToInt32(drpLocationList.SelectedValue); newExpense.ClientID = Convert.ToInt32(drpClientList.SelectedValue); newExpense.CategoryID = Convert.ToInt32(drpCategoryList.SelectedValue); newExpense.PayTo = txtPayTo.Text; newExpense.Date = Convert.ToDateTime(dateTime.Text); newExpense.Amount = Convert.ToInt32(txtAmount.Text); newExpense.Note = txtNote.Text; bool restult = newExpense.UpdateExpense(newExpense); if (restult) { MessageBox.Show("Record Updated Succesfully.!"); bindExpenseGrid(); pnlExpenseForm.Visible = false; pnlExpenseGrid.Visible = true; btnUpdate.Visible = false; } else { MessageBox.Show("Error.!"); } }
public bool UpdateExpense(ExpenseDetailManager expense) { SqlParameter[] sp = new SqlParameter[7]; sp[0] = new SqlParameter("@TransactionID", expense.TransactionID); sp[1] = new SqlParameter("@ClientID", expense.ClientID); sp[2] = new SqlParameter("@CategoryID", expense.CategoryID); sp[3] = new SqlParameter("@payTo", expense.PayTo); sp[4] = new SqlParameter("@Date", expense.Date); sp[5] = new SqlParameter("@Amount", expense.Amount); sp[6] = new SqlParameter("@Note", expense.Note); return datalayer.Execute_NonQuery("sp_UpdateExpense", CommandType.StoredProcedure, sp); }