public async Task <int> DeleteProdDefinitionAsync(ProdDefinitionDto prodDefDto)
        {
            DynamicParameters para = new DynamicParameters();

            para.Add("PdDetailId", prodDefDto.AutoId);
            para.Add("PdHeaderId", prodDefDto.PDHeaderId);
            para.Add("UserId", prodDefDto.CreateUserId);
            para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output);

            var result = await DbConnection.ExecuteAsync("spMstrProductDefinitionDelete", para
                                                         , commandType : CommandType.StoredProcedure);

            return(para.Get <int>("Result"));
        }
        public async Task <ReturnDto> SaveProdDefinitionAsync(ProdDefinitionDto prodDefinitionDto)
        {
            DynamicParameters para = new DynamicParameters();

            para.Add("PdHeaderId", prodDefinitionDto.PDHeaderId);
            para.Add("ProcessId", prodDefinitionDto.ProcessId);
            para.Add("Name", prodDefinitionDto.PDName.Trim().ToUpper());
            para.Add("ReceiveSiteId", prodDefinitionDto.ReceiveSiteId);
            para.Add("DispatchSiteId", prodDefinitionDto.DispatchSiteId);
            para.Add("UserId", prodDefinitionDto.CreateUserId);
            //para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output);

            var result = await DbConnection.QueryFirstOrDefaultAsync <ReturnDto>("spMstrProductDefinitionSave", para
                                                                                 , commandType : CommandType.StoredProcedure);

            return(result);
        }