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; }