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