public async Task <int> Update(FarmerBuyingCalendar farmerBuyingCalendar)
        {
            var cmd = QueriesCreatingHelper.CreateQueryUpdate(farmerBuyingCalendar);
            var rs  = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);

            return(rs == 0 ? -1 : 0);
        }
        public async Task <int> Add(FarmerBuyingCalendar farmerBuyingCalendar)
        {
            var cmd = QueriesCreatingHelper.CreateQueryInsert(farmerBuyingCalendar);

            cmd += ";SELECT LAST_INSERT_ID();";
            return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
        }