//Update Recode
void iIncome.UpdateIncomeRecode(cIncome Income)
{
if (Income.IncomeID > 0)
{
SqlCommand cmd = new SqlCommand("UPDATE incomePayment SET incomeUnitName = @IUName, incomeType = @IncomeType, incomeAmount = @IncomeAmount, incomeDate = @IncomeDate, incomeDescription = @IncomeDescription WHERE incomeID = @IID", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@IUName", Income.incomeUnitName);
cmd.Parameters.AddWithValue("@IncomeType", Income.incomeType);
cmd.Parameters.AddWithValue("@IncomeAmount", Income.incomeAmount);
cmd.Parameters.AddWithValue("@IncomeDate", Income.incomeDate);
cmd.Parameters.AddWithValue("@IncomeDescription", Income.incomeDescription);
cmd.Parameters.AddWithValue("@IID", Income.IncomeID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
InUC.Hide();
SuccessfullMessageBox.ShowDialog("A New Expenses Recode is Update Successfully", "Successfully Inserted");
InUC.Show();
}
else
{
// InUC.Hide();
ErrorDialogBox.ShowDialog("Please Select a Expenses Recode to Update", "Error");
// InUC.Show();
}
}
private void btnIncomeInsert_Click(object sender, EventArgs e)
{
if (IsEmpty() && IsValid())
{
cIncome cIn = new cIncome(dropIncomeUnitName.Text, dropIncomeType.Text, txtIncomeAmount.Text, txtIncomeDate.Text, txtIncomeDescription.Text);
iIncome iIn = new IncomeImpl();
iIn.InsertIncomeRecode(cIn);
ReadRecode();
ResetIncomeRecode();
}
}
//Insert Recode
void iIncome.InsertIncomeRecode(cIncome Income)
{
SqlCommand cmd = new SqlCommand("INSERT INTO incomePayment VALUES (@IUName, @IncomeType, @IncomeAmount, @IncomeDate, @IncomeDescription)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@IUName", Income.incomeUnitName);
cmd.Parameters.AddWithValue("@IncomeType", Income.incomeType);
cmd.Parameters.AddWithValue("@IncomeAmount", Income.incomeAmount);
cmd.Parameters.AddWithValue("@IncomeDate", Income.incomeDate);
cmd.Parameters.AddWithValue("@IncomeDescription", Income.incomeDescription);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
InUC.Hide();
SuccessfullMessageBox.ShowDialog("A New Expenses Recode is Insert Successfully", "Successfully Inserted");
InUC.Show();
}
//Delete Recode
void iIncome.DeleteIncomeRecode(cIncome Income)
{
if (Income.IncomeID > 0)
{
SqlCommand cmd = new SqlCommand("DELETE FROM incomePayment WHERE incomeID = @IID", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@IID", Income.IncomeID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
InUC.Hide();
SuccessfullMessageBox.ShowDialog("Expenses Recode is Delete Successfully", "Successfully Deleted");
InUC.Show();
}
else
{
InUC.Hide();
ErrorDialogBox.ShowDialog("Please Select a Expenses Recode to Delete", "Error");
InUC.Show();
}
}