public static void UpdateCheck(ChecksModel check, int CheckID)
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
cnn.Execute("UPDATE checks SET StoreID = @StoreID, " +
"Date = @Date, " +
"PayType = @PayType, " +
"UserID = @UserID, " +
"SumQuantity = @SumQuantity, " +
"SumTotal = @SumTotal, " +
"SumTVA = @SumTVA, " +
"SumPay = @SumPay, " +
"SumRest = @SumRest, " +
"ClientID = @ClientID, " +
"Discount = @Discount, " +
"SumDiscount = @SumDiscount, " +
"DiscountType = @DiscountType, " +
"FPC = @FPC, " +
"StateID = @StateID " +
"WHERE CheckID = " + CheckID.ToString(), check);
}
}
public static List <ChecksModel> InsertCheck(ChecksModel check)
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
cnn.Execute("INSERT INTO checks (StoreID, " +
"Date, " +
"PayType, " +
"UserID, " +
"SumQuantity, " +
"SumTotal, " +
"SumTVA, " +
"SumPay, " +
"SumRest, " +
"ClientID, " +
"Discount, " +
"SumDiscount, " +
"DiscountType, " +
"FPC, " +
"StateID) " +
"VALUES (@StoreID, " +
"@Date, " +
"@PayType, " +
"@UserID, " +
"@SumQuantity, " +
"@SumTotal, " +
"@SumTVA, " +
"@SumPay, " +
"@SumRest, " +
"@ClientID, " +
"@Discount, " +
"@SumDiscount, " +
"@DiscountType, " +
"@FPC, " +
"@StateID);", check);
var output = cnn.Query <ChecksModel>("SELECT * FROM checks ORDER BY CheckID DESC LIMIT 1", new DynamicParameters());
return(output.ToList());
}
}
