public async Task <int> DeactProductTypeAsync(MstrProductType MstrProductType)
        {
            DynamicParameters para = new DynamicParameters();

            para.Add("AutoId", MstrProductType.AutoId);
            para.Add("IsActive", MstrProductType.IsActive);
            para.Add("UserId", MstrProductType.CreateUserId);
            para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output);

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

            return(para.Get <int>("Result"));
        }
        public async Task <int> SaveProductTypeAsync(MstrProductType MstrProductType)
        {
            DynamicParameters para = new DynamicParameters();

            para.Add("AutoId", MstrProductType.AutoId);
            para.Add("CategoryId", MstrProductType.CategoryId);
            para.Add("ProdTypeName", MstrProductType.ProdTypeName.Trim());
            para.Add("ProdTypeCode", MstrProductType.ProdTypeCode.Trim().ToUpper());
            para.Add("AutoArticle", MstrProductType.bAutoArticle);
            para.Add("UserId", MstrProductType.CreateUserId);
            para.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output);

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

            return(para.Get <int>("Result"));
        }