/* * SELECT[name] * ,[amount] * ,[pay_type] * ,[day_of_month] * ,[seed_date] * ,[day_of_week] * ,[pay_interval] * FROM[dbo].[bills] */ public int AddBill(BillDto bill) { if (bill.interval == 'm') { var sql = "INSERT INTO [dbo].[Bills]([name],[amount],[pay_type],[day_of_month])" + "VALUES(@name, @amount, @pay_type, @day_of_month)"; var newBill = new { name = bill.name, amount = bill.amount, pay_type = "m", day_of_month = bill.dayofmonth }; return(DapperUtils.InsertItem(sql, newBill)); } if (bill.interval == 'b') { var sql = "INSERT INTO [dbo].[Bills]([name],[amount],[pay_type],[seed_date],[day_of_week],[pay_interval])" + "VALUES(@name, @pay_type, @seed_date, @day_of_week, @pay_interval)"; var newBill = new { name = bill.name, amount = bill.amount, pay_type = "w", seed_date = bill.seedpayday, day_of_week = bill.dayofweek, pay_interval = "b" }; return(DapperUtils.InsertItem(sql, newBill)); } return(0); }
public int DeleteBill(string Name) { var sql = "DELETE FROM [dbo].[Bills] WHERE [name] = @key"; return(DapperUtils.DeleteItem(sql, Name)); }