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