public static int UpdateCake(CakeModel cake) { cake.CakeName2 = ConvertToUnSign(cake.CakeName); using (IDbConnection connection = new SQLiteConnection(LoadConnectionString())) { int cakeId = connection.ExecuteScalar <int>("UPDATE cake SET cakeCode = @CakeCode, cakeName = @CakeName, cakeName2 = @CakeName2, cakeCat = @CakeCat, cakePrice = @CakePrice, cakeDesc = @CakeDesc, cakeImage = @CakeImage, cakeQuantity = @CakeQuantity WHERE cakeId = @CakeId; SELECT last_insert_rowid()", cake); return(cakeId); } }
public static int SaveCake(CakeModel cake) { cake.CakeName2 = ConvertToUnSign(cake.CakeName); using (IDbConnection connection = new SQLiteConnection(LoadConnectionString())) { int cakeId = connection.ExecuteScalar <int>("INSERT INTO cake(cakeCode, cakeName, cakeName2, cakeCat, cakePrice, cakeDesc, cakeImage, cakeQuantity) VALUES(@CakeCode, @CakeName, @CakeName2, @CakeCat, @CakePrice, @CakeDesc, @CakeImage, @CakeQuantity); SELECT last_insert_rowid()", cake); return(cakeId); } }