private void btnUpdate_Click(object sender, EventArgs e)
{
IncomeDetailManager income = new IncomeDetailManager();
income.TransactionID = Convert.ToInt32(lblTransactionID.Text);
income.LocationID = Convert.ToInt32(drpLocationList.SelectedValue);
income.Name = txtName.Text;
income.Date = Convert.ToDateTime(dateTime.Text);
income.Amount = Convert.ToInt32(txtAmount.Text);
income.Note = txtNote.Text;
bool res = income.UpdateIncome(income);
if (res)
{
MessageBox.Show("Record Updated Succesfully.!");
bindIncomeGrid();
pnlAddIncomeForm.Visible = false;
PnlIncomeGrid.Visible = true;
}
else
{
MessageBox.Show("Error.!");
}
}
private void IncomeDetailGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int TransactionID = 0;
if (e.ColumnIndex == 6)
{
txtName.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["Name"].Value.ToString();
drpLocationList.SelectedValue = Convert.ToInt32(IncomeDetailGrid.Rows[e.RowIndex].Cells["LocationID"].Value.ToString());
lblTransactionID.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["TransactionID"].Value.ToString();
txtAmount.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["Amount"].Value.ToString();
dateTime.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["Date"].Value.ToString();
txtNote.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["Note"].Value.ToString();
pnlAddIncomeForm.Visible = true;
PnlIncomeGrid.Visible = false;
btnAddNewIncome.Visible = false;
btnUpdate.Visible = true;
}
if (e.ColumnIndex == 7)
{
TransactionID = Convert.ToInt32(IncomeDetailGrid.Rows[e.RowIndex].Cells["TransactionID"].Value);
IncomeDetailManager cm = new IncomeDetailManager();
cm.DeleteIncome(TransactionID);
bindIncomeGrid();
pnlAddIncomeForm.Visible = false;
PnlIncomeGrid.Visible = true;
}
}
public void bindIncomeGrid()
{
IncomeDetailManager cl = new IncomeDetailManager();
DataSet ds = cl.ListIncomeDetails();
if (ds.Tables[0].Rows.Count > 0)
{
IncomeDetailGrid.AutoGenerateColumns = false;
IncomeDetailGrid.DataSource = null;
//Set Columns Count
IncomeDetailGrid.ColumnCount = 6;
//Add Columns
IncomeDetailGrid.Columns[0].Name = "TransactionID";
IncomeDetailGrid.Columns[0].HeaderText = "Transaction ID";
IncomeDetailGrid.Columns[0].DataPropertyName = "TransactionID";
IncomeDetailGrid.Columns[1].HeaderText = "Name";
IncomeDetailGrid.Columns[1].Name = "Name";
IncomeDetailGrid.Columns[1].DataPropertyName = "Name";
IncomeDetailGrid.Columns[2].Name = "LocationID";
IncomeDetailGrid.Columns[2].HeaderText = "Location";
IncomeDetailGrid.Columns[2].DataPropertyName = "LocationID";
IncomeDetailGrid.Columns[3].Name = "Date";
IncomeDetailGrid.Columns[3].HeaderText = "Date";
IncomeDetailGrid.Columns[3].DataPropertyName = "Date";
IncomeDetailGrid.Columns[4].Name = "Amount";
IncomeDetailGrid.Columns[4].HeaderText = "Amount";
IncomeDetailGrid.Columns[4].DataPropertyName = "Amount";
IncomeDetailGrid.Columns[5].Name = "Note";
IncomeDetailGrid.Columns[5].HeaderText = "Note";
IncomeDetailGrid.Columns[5].DataPropertyName = "Note";
IncomeDetailGrid.DataSource = ds.Tables[0];
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
IncomeDetailGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
IncomeDetailGrid.Columns.Add(Deletelink);
//DataGridViewButtonColumn db = new DataGridViewButtonColumn();
//db.Text = "Delete";
//IncomeDetailGrid.Columns.Insert(6, (DataGridViewColumn)db);
}
}
public bool UpdateIncome(IncomeDetailManager Income)
{
SqlParameter[] sp = new SqlParameter[6];
sp[0] = new SqlParameter("@TransactionID", Income.TransactionID);
sp[1] = new SqlParameter("@Name", Income.Name);
sp[2] = new SqlParameter("@LocationID", Income.LocationID);
sp[3] = new SqlParameter("@Date",Income.Date);
sp[4] = new SqlParameter("@Amount", Income.Amount);
sp[5] = new SqlParameter("@Note", Income.Note);
return datalayer.Execute_NonQuery("sp_UpdateIncome", CommandType.StoredProcedure, sp);
}
public bool AddIncome(IncomeDetailManager newIncome)
{
SqlParameter[] sp = new SqlParameter[6];
sp[0] = new SqlParameter("@Name", newIncome.Name);
sp[1] = new SqlParameter("@LocationID", newIncome.LocationID);
sp[2] = new SqlParameter("@Date", newIncome.Date);
sp[3] = new SqlParameter("@Amount", newIncome.Amount);
sp[4] = new SqlParameter("@Note", newIncome.Note);
sp[5] = new SqlParameter("@IsDeleted", false);
return datalayer.Execute_NonQuery("sp_AddIncome", CommandType.StoredProcedure, sp);
}
public bool AddIncome(IncomeDetailManager newIncome)
{
SqlParameter[] sp = new SqlParameter[6];
sp[0] = new SqlParameter("@Name", newIncome.Name);
sp[1] = new SqlParameter("@LocationID", newIncome.LocationID);
sp[2] = new SqlParameter("@Date", newIncome.Date);
sp[3] = new SqlParameter("@Amount", newIncome.Amount);
sp[4] = new SqlParameter("@Note", newIncome.Note);
sp[5] = new SqlParameter("@IsDeleted", false);
return datalayer.Execute_NonQuery("sp_AddIncome", CommandType.StoredProcedure, sp);
}
private void IncomeDetailGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int TransactionID = 0;
if (e.ColumnIndex == 6)
{
txtName.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["Name"].Value.ToString();
drpLocationList.SelectedValue = Convert.ToInt32(IncomeDetailGrid.Rows[e.RowIndex].Cells["LocationID"].Value.ToString());
lblTransactionID.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["TransactionID"].Value.ToString();
txtAmount.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["Amount"].Value.ToString();
dateTime.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["Date"].Value.ToString();
txtNote.Text = IncomeDetailGrid.Rows[e.RowIndex].Cells["Note"].Value.ToString();
pnlAddIncomeForm.Visible = true;
PnlIncomeGrid.Visible = false;
btnAddNewIncome.Visible = false;
btnUpdate.Visible = true;
}
if (e.ColumnIndex == 7)
{
TransactionID = Convert.ToInt32(IncomeDetailGrid.Rows[e.RowIndex].Cells["TransactionID"].Value);
IncomeDetailManager cm = new IncomeDetailManager();
cm.DeleteIncome(TransactionID);
bindIncomeGrid();
pnlAddIncomeForm.Visible = false;
PnlIncomeGrid.Visible = true;
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
IncomeDetailManager income = new IncomeDetailManager();
income.TransactionID = Convert.ToInt32(lblTransactionID.Text);
income.LocationID = Convert.ToInt32(drpLocationList.SelectedValue);
income.Name = txtName.Text;
income.Date = Convert.ToDateTime(dateTime.Text);
income.Amount = Convert.ToInt32(txtAmount.Text);
income.Note = txtNote.Text;
bool res = income.UpdateIncome(income);
if (res)
{
MessageBox.Show("Record Updated Succesfully.!");
bindIncomeGrid();
pnlAddIncomeForm.Visible = false;
PnlIncomeGrid.Visible = true;
}
else
{
MessageBox.Show("Error.!");
}
}
public void bindIncomeGrid()
{
IncomeDetailManager cl = new IncomeDetailManager();
DataSet ds = cl.ListIncomeDetails();
if (ds.Tables[0].Rows.Count > 0)
{
IncomeDetailGrid.AutoGenerateColumns = false;
IncomeDetailGrid.DataSource = null;
//Set Columns Count
IncomeDetailGrid.ColumnCount = 6;
//Add Columns
IncomeDetailGrid.Columns[0].Name = "TransactionID";
IncomeDetailGrid.Columns[0].HeaderText = "Transaction ID";
IncomeDetailGrid.Columns[0].DataPropertyName = "TransactionID";
IncomeDetailGrid.Columns[1].HeaderText = "Name";
IncomeDetailGrid.Columns[1].Name = "Name";
IncomeDetailGrid.Columns[1].DataPropertyName = "Name";
IncomeDetailGrid.Columns[2].Name = "LocationID";
IncomeDetailGrid.Columns[2].HeaderText = "Location";
IncomeDetailGrid.Columns[2].DataPropertyName = "LocationID";
IncomeDetailGrid.Columns[3].Name = "Date";
IncomeDetailGrid.Columns[3].HeaderText = "Date";
IncomeDetailGrid.Columns[3].DataPropertyName = "Date";
IncomeDetailGrid.Columns[4].Name = "Amount";
IncomeDetailGrid.Columns[4].HeaderText = "Amount";
IncomeDetailGrid.Columns[4].DataPropertyName = "Amount";
IncomeDetailGrid.Columns[5].Name = "Note";
IncomeDetailGrid.Columns[5].HeaderText = "Note";
IncomeDetailGrid.Columns[5].DataPropertyName = "Note";
IncomeDetailGrid.DataSource = ds.Tables[0];
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkForEditColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
IncomeDetailGrid.Columns.Add(Editlink);
DataGridViewLinkColumn Deletelink = new DataGridViewLinkColumn();
Deletelink.UseColumnTextForLinkValue = true;
Deletelink.HeaderText = "delete";
Deletelink.DataPropertyName = "lnkForDeleteColumn";
Deletelink.LinkBehavior = LinkBehavior.SystemDefault;
Deletelink.Text = "Delete";
IncomeDetailGrid.Columns.Add(Deletelink);
//DataGridViewButtonColumn db = new DataGridViewButtonColumn();
//db.Text = "Delete";
//IncomeDetailGrid.Columns.Insert(6, (DataGridViewColumn)db);
}
}
public bool UpdateIncome(IncomeDetailManager Income)
{
SqlParameter[] sp = new SqlParameter[6];
sp[0] = new SqlParameter("@TransactionID", Income.TransactionID);
sp[1] = new SqlParameter("@Name", Income.Name);
sp[2] = new SqlParameter("@LocationID", Income.LocationID);
sp[3] = new SqlParameter("@Date",Income.Date);
sp[4] = new SqlParameter("@Amount", Income.Amount);
sp[5] = new SqlParameter("@Note", Income.Note);
return datalayer.Execute_NonQuery("sp_UpdateIncome", CommandType.StoredProcedure, sp);
}
