Example #1
0
        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;
            }
        }
Example #2
0
        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.!");
            }
        }
Example #3
0
 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));
 }
Example #4
0
 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);
 }
Example #6
0
        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);
            }
        }
Example #7
0
        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);
            }
        }
Example #8
0
        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;
            }
        }
Example #9
0
        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);
 }