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