internal static bool DeleteExpense(Income data)
{
bool retData = false;
using (SqlConnection con = new SqlConnection(_ConnectionString))
{
SqlCommand cmd = new SqlCommand("dbo.ExpenseDelete", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter idParam = cmd.Parameters.Add("@ID", SqlDbType.Int);
idParam.Value = data.ID;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
retData = true;
}
return retData;
}
private static Income readIncome(SqlDataReader reader)
{
Income retData = new Income((int)reader["ID"])
{
Value = Convert.ToSingle(reader["Value"]),
AccountID = (int)reader["AccountID"],
Date = (DateTime)reader["IncomeDate"],
CategoryID = (int)reader["IncomeCategoryID"],
Description = (string)reader["IncomeDescription"]
};
return retData;
}
internal static Income SaveIncome(Income data)
{
using (SqlConnection con = new SqlConnection(_ConnectionString))
{
SqlCommand cmd = new SqlCommand("dbo.IncomeSave", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter idParam = cmd.Parameters.Add("@ID", SqlDbType.Int);
idParam.Value = data.ID;
SqlParameter descParam = cmd.Parameters.Add("@IncomeDescription", SqlDbType.VarChar, 240);
descParam.Value = data.Description;
SqlParameter categoryParam = cmd.Parameters.Add("@IncomeCategoryID", SqlDbType.Int);
categoryParam.Value = data.CategoryID;
SqlParameter accParam = cmd.Parameters.Add("@AccountID", SqlDbType.Int);
accParam.Value = data.AccountID;
SqlParameter dtParam = cmd.Parameters.Add("@IncomeDate", SqlDbType.DateTime);
dtParam.Value = data.Date;
SqlParameter valParam = cmd.Parameters.Add("@Value", SqlDbType.Float);
valParam.Value = data.Value;
con.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
data = readIncome(reader);
}
reader.Close();
}
return data;
}
